PLEASE NOTE: Vendor SKU is the unique identifier for products; any information attached to the Vendor SKU will be created for that SKU. Once created, the Vendor SKU cannot be changed.


Option 1: Update Full Catalog


If you have a large catalog and multiple updates to make to your product fields (such as changing “Shipping Cost” or “Category ID”) the bulk upload tool can be used. Downloading your catalog and re-uploading with changes allows for several changes to be made at once. (Note: All Product IDs must remain the same in the update files or new products will be created).


1. Click on the button marked “Full Catalog” under the "Export" section in order to download your catalog file.



2. Once it has downloaded, open the downloaded .csv file in Excel.

3. Create changes to any product field(s) except for SKU. SKU is the unique identifier for products and if this field is changed, a new product will be created.




4. When you're ready to re-upload your file, be sure to first save it in the original .csv format.

5. Click on the “.CSV” button under the "Upload" section to choose the file from your computer.



6. Once the file has completed, it will have a red cloud icon or green cloud icon. If a red cloud icon is present, your file has errors and needs to be revised. Any products not in the error file have been successfully uploaded. See How to fix a bulk upload error file if your file has errors.



 

7. When products have been uploaded, the "Status" column will show a green cloud icon. Your file was accepted and your products have been updated.



Option 2: Update Cost & Inventory


If you would only like to update the cost and/or inventory of your products, you can use the “Update Cost & Inventory” function. This feature works similarly to the “Export Full Catalog” button but only exports the Vendor SKU, Product/Product Group Title, Product Identifier, Product Identifier Type, Unit Price and Quantity fields.


1. Click on the button marked “Cost & Inventory” under the "Export" section in order to download your catalog file.



2. Open the downloaded .csv file in Excel.

3. Create changes to any product field(s) except for SKU. SKU is the unique identifier for products and if this field is changed, a new product will be created.








4. Save your file in the original .csv format.

5. Click on the “.CSV” button under the "Upload" section to choose the file from your computer.



 

6. Once the file has completed, it will have a red cloud icon or green cloud icon. If a red cloud icon is present, your file has errors and needs to be revised. Any products not in the error file have been successfully uploaded. See How to fix a bulk upload error file if your file has errors.



 

7. When products have been uploaded, the "Status" column will show a green cloud icon. Your file was accepted and your products have been updated.



Additional Bulk Upload Resources 


For more info on Bulk Upload page functionality, the Bulk Upload template and Gateway bulk tools, see the list of additional resources below. 


If you're experiencing issues with our bulk upload tools, you can submit a helpdesk ticket, and select “Bulk Upload/Updates” under Ticket Reason for further assistance. You do not need to be logged into your Helpdesk account to submit a support ticket. 


Vendor Helpdesk: Bulk Upload Resources 


Bulk Upload: Creating Products

Field Requirements & Limits

Bulk Upload Template Tabs

How To Fix a Bulk Upload Error File

Bulk Upload: Fixing File Errors

Bulk Upload: How do I fix a gtin or duplicate universal ID error in my upload file?

How to add or update inventory