To update existing products in bulk, navigate to Inventory, then click the Bulk Manage button and select Update Existing Products.
You will see the following screen:
Choose if you want to upload an existing spreadsheet into QuickBooks Commerce or if you want to download a spreadsheet allowing you to edit its contents to update your products.
If you choose the No I need to download a list of my products option to download your product list for editing, you'll be presented with the attribute selection screen.
From here, select the attributes you would like added to your CSV file. Check the box if you would like to update price lists for your products at the same time. Be sure to add Price List and Sales Channel options if needed.
You can find more information on each attribute in this article.
Once done, click the Build a Product Sheet button, then when displayed, click the Download Product Sheet button to download the CSV file. If you'd like to select other attributes or start over, select the Re-build Product Sheet option.
-
Once you have edited the required data in the downloaded CSV file, you'll need to upload the product sheet.
To upload your edited product sheet, select the Upload filled CSV button that's displayed after downloading the file in the previous step:
Alternatively, you can start the process again and select the Yes I have a spreadsheet with updated product data ready to upload option. Either way, you'll be presented with the following screen:
You can click the Choose File option and select your file or drag the file into the green box. Then click the Upload button.
Review and Confirm the changes. If you encounter errors when uploading the spreadsheet, refer to this handy guide to resolve them.
Your products and price lists have now been updated.
