Please read fully: This project is for 2 site and 2 issues in a single bundle
Site 1. is getting the following error when adding products:
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '5-1' for key 'UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID'
Site 2: You will need to change your host file to see this site as it is not live yet. Getting the error message that "No Shipper is Avaiable" however USPS with a username and password has been install.
Again, this is for 2 different sites.
5 freelancers are bidding on average $78 for this job
I can solve your this two error in your two site. am i can get your both site address? I am expert in magento and i can start your project right now. waiting for your reply for more discuss.