How do I update product-level shipping prices via CSV file?

Aside from updating product-level shipping prices per destination manually on Merchant Dashboard (see detailed guide here), you can also do so via CSV file. This article walks you through this process.

Create a CSV file

1. Create a spreadsheet for your shipping feed. At the bottom of this article, you may download a template you can use to fill in with your products and shipping prices per destination. (The file name is Wish Edit Shipping Feed Template.xlsx.)

Please be sure to enter the Parent Unique Id and the shipping price for each destination you intend to ship to. (Note that it's not necessary to include all destinations in your CSV file, just the ones you intend to set or update shipping prices for.)

You may also designate the specific warehouse (Primary or Secondary) of the relevant product; simply add the "Warehouse Name" column next to the Parent Unique Id column. (See template example attached below.)

2. Once you are done creating your feed, now it's time to save it as a CSV file. If you are using Excel, you can click on File > Save As and then select 'Comma Separated Values (CSV)' as your format. If you are using Google Drive, you can do this by clicking on File > Download as > Comma Separated Values.  

Upload CSV file and map attributes

3. Go to the Products > Add/Edit Products with CSV page and upload your CSV file here, map the columns from your CSV to the corresponding Wish attributes. Click "Submit" to complete. Learn more about the general process of adding or editing products via CSV here.

Confirm and check upload status

4. You will receive an immediate confirmation when your CSV feed is accepted. It may take up to 24 hours to finish processing.

5. To check on the status of the CSV upload, you may visit the Products > Product CSV File Status page and select 'View full report' for this particular job uploaded.