Changing Product Information in Bulk

You might have the need to update several products with new product data or information. Rather than editing the products individually, you have the option of updating them on a .csv file and uploading them all at once. For more information on adding products to Connect, see this article: Adding Products

Steps to Edit Products in Bulk

1. Navigate to the Products page by clicking the Products in the left navigation bar. 

2. Click the button to export a .csv file of your products

3. Open the .csv and edit any product information you need to. Delete irrelevant columns you are not updating, keeping the following columns at minimum -- Supplier ID, Product ID, Product Name, Community, Product Type. (very important- You must delete any image attributes as well prior to re-importing). Save the .csv file. 

Please note: If you are editing products on behalf of your suppliers, you cannot modify any Default attributes, including Type or Display Name. 

4. On the Products page, click the  button to begin the bulk upload/import process

5. Select the community you wish to upload the .csv to, select supplier and/or product type if relevant, then select the file you want to upload. 

6. Click Save.  You will be taken to the upload history page, where you can check for any errors in the upload. Tip - Test an import of a few rows of data first if you are trying to update a large number of products at once to troubleshoot prior to completing your import, or consider testing in Sandbox environment!

Details on Editing Products in Bulk

1. Navigate to the Products page by clicking Products in the left navigation bar. 

2. Click the button to export a .csv file of your documents. Be sure to select the Export to .csv option

3. Open the .csv and edit any product information* you need to. Save the .csv

*Please note the following:

• We recommend deleting any irrelevant columns you are not updating.

• Make sure these columns remain in your .csv in addition to any fields you are modifying -- Supplier ID, Product ID, Product Name, Community, Product Type. 

• If you are editing products on behalf of your suppliers, you cannot modify any Default attributes, including Type or Display Name. 

• If you have product image attributes in your file, please delete these columns before you import.

• You will also need to ensure that you have filled out all required field details.

• You can review the export for products or the online form for more information regarding field types and acceptable values. 

4. On the Products page, click the  button to begin the bulk upload/import process

5. Select the community you wish to upload the .csv to, and if applicable, the supplier and product type, then select the file you want to upload.

6. Click Save.  You will be taken to the upload history page, where you can check for any errors in the upload. 

Tip - Test an import of a few rows of data first if you are trying to update a large number of products at once to troubleshoot prior to completing your import, or consider testing in Sandbox environment!