I am trying to set up Shipping in Google Merchant Center to improve my Merchant Performance. The Shipping metric rating is Fair. and I want to improve it. The problem is that I dropship all of 20,000 products, and I source goods from multiple vendors. During product selection the shopping cart on my site shows market rates based on item weight (dimensional or regular) and delivery ZIP code. How can I set up shipping in my Google Merchant Account to reflect what my customers will see? Must I set up an advanced table or something?
Unless you have fixed shipping costs it will be impossible to know the cost for each shopper. Typically, the shipping will depend on the shopper's address, where the product is being shipped from, and the number of products in the cart.