How to Update Related Products in Bulk

1. Export a spreadsheet of your DC products

1. Select Products in the left menu
   
   
   
2. Click Product Data File Manager
   
   
   
3. On the Product Data File Manager page, find the Export Product Data section to the right
   
   
   
4. Ensure that the "Send to" email address is correct
   
   
   
5. Then select Product Data in "Data type included in export" dropdown
   
   
6. Click Begin Export
   
   
   
7. Click Download Spreadsheet in the email you receive from info@distributorcentral.com to download the file

2. Update the product information in the spreadsheet you just exported from DC

1. Open the DC product spreadsheet that was exported and downloaded to your computer
   
   
2. With the spreadsheet open the spreadsheet & update the Related Products
   (add product numbers separated by commas or remove products numbers to remove related products)
   
   • Companion Sell -  Update column BE
   • Substitute - Update column BF
   • Common Grouping - Update column BG 
     
     
3. Save the updated file to your computer
   
   
4. Next, you'll upload the back into DC for import

3. Upload the updated file back into DC for import

1. Select Products in the left menu
   
   
   
2. Click Product Data File Manager
   
   
   
3. On the Product Data File Manager page, click Upload Import Spreadsheet to right
   The Product Data Spreadsheet Upload box will open
   
   
   
4. Choose Product Data in the Update Type dropdown
   
   
5. Next, choose the fields you've made changes to in the spreadsheet under Fields to Update
   
   
6. Enter comments as needed
   
   
7. Click Select file
   
   
8. Find and upload your Product Data Spreadsheet
   
   
9. Click Save in the bottom right corning of the Product Data Spreadsheet Upload
   

Once uploaded the DC Data Team will run your updates. In the meantime you can refer to the Imports table to track the progress of your import.