Merchants can add products, edit products, edit shipping, and add variations via CSV in Merchant Dashboard. Taking these actions via CSV allows merchants to efficiently make changes in bulk to their products.
See below for a step-by-step walkthrough of the product CSV upload experience:
1. First, navigate to Products > Add/Edit Products with CSV. On this page, select the type of action to take by clicking the “Action type” dropdown. These actions include Add products, Edit products, Edit shipping, and Add variations.
2. Next, download a CSV template to fill out with product information by clicking “Download CSV template”. Merchants may also download an example CSV to see what a pre-filled template looks like by clicking “Download example CSV”.
If merchants have existing products that they wish to edit, click “Download all products”. This may take up to 24 hours to process depending on how many products merchants currently have. Merchants will receive an email once their product CSV is processed and ready to download.
3. Prepare a CSV file with a row for each Parent SKU (to group variations) or SKU (for each variation) by downloading either a CSV template (recommended for adding products) or all existing products (recommended for editing products).
Certain product attributes are required for different actions - please click “List of product attributes” to expand a table listing the actions and corresponding required product attributes. To expand a list of additional optional attributes, click “View more optional attributes” at the bottom of the table.
Please see this article for more information on required and optional product attributes, including attributes that have recently been renamed.
4. Upload the formatted CSV file when ready. If any column headers do not match listed Wish attributes, merchants may manually map them together under the Column mapping section. If all column headers and Wish attributes match 1:1, merchants will see the message “All columns have been mapped.” Click the “Submit” button in the top right to proceed.
5. After submitting, merchants will land on a job details page indicating the progress of their product CSV upload. Merchants may hit the “Cancel” button on this page to stop an upload if desired. When the upload is complete and ready for review, merchants will receive an email.
6. Merchants may navigate to the Product CSV File Status page from here by clicking the “Return to Product CSV File Status” link in the header. Merchants may also access this page by navigating to Products > Product CSV File Status.
On this page, merchants may view the status of all present and past product CSV uploads. The “Status” column here will display either In Progress, Complete, or Cancelled, reflecting the status of the product CSV upload. Please note it may take 12 hours for products to appear on Wish.