How to Add SAGE Categories to DC Products in Bulk

  • Updated

Add SAGE Categories using DC's Attribute importer/exporter!

  1. Export your product attributes
  2. Update column CE (sage_categories) in the exported spreadsheet on the Product Data sheet
  3. Upload your updated attributes file to DC for import

1. Export your product attributes

  1. Select Products in the left menu

  2. Click Bulk Product Manager

  3. On the Bulk Product Manager page, find the Export Product Data section & click Customize Export

  4. Ensure that the "Send to" email address is correct

  5. Under the Prepare your export file section, select DistributorCentral data (if its not already selected)five.png

  6. Then select Product Attributes in "Data type included in export" dropdownsix.png

  7. Click Begin Export
  8. You'll receive an email from with a link to download your Attribute Spreadsheet

  9. Open the downloaded Spreadsheet to begin making alterations to your Product Attributes

2. Update column CE (sage_categories) in the spreadsheet 

Add SAGE's predefined categories to a cell in column CE

SAGE's predefined category limit is 2 per product 

  1. Find the product that you need to update in the left product details section and move to the column CE in red to the far right.

  2. With the Categories cell selected, click the drop-down menu found to the right of the cell

  3. Select the category you'd like to add & repeat until all predefined attribute values needed are added to this attribute cell

  4. When you're done, save your updated spreadshee

3. Upload your SAGE Categories to DC's Attribute importer

  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 Attributes in the Update Type dropdownD-four.png

  5. Click Select file

  6. Find and upload your Product Attributes Spreadsheet

  7. Click Save in the bottom right corner of the Product Data Spreadsheet Upload

The import will run automatically and your SAGE categories will be applied to your products. "Complete" will appear under the Status column in the Imports table to the right of your Attributes import. 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request