Audience: Suppliers

Advanced catalog services makes it easy for you to update your existing catalog products via spreadsheet upload that's specific to your retail trading partner's requirements. 

Retailers frequently change their categories and requirements. To ensure data accuracy and compliance, be sure to select each catalog/subcategory and download the latest template spreadsheet before you upload your products to CommerceHub's Dsco platform. This will help make sure your data is compliant with your retailer's requirements while reducing any errors you might receive when the Dsco platform validates your data.

Looking to transmit catalog data via API or SFTP? See Integrating with the platform for more information on how to get validation and exception messages via API or SFTP.

Not all retailer trading partners use advanced catalog services, which is different from the basic catalog templates you use to provide item data to your retail partner. Advanced catalog templates on the Products page are created by the retailer and reflect the retailer’s unique requirements for each product category. The basic catalog/inventory templates found on the Inventory Upload File page are not specific to a category and does not reflect any retailer rules or requirements. For more information about uploading basic catalog/inventory templates using the Inventory page, see Creating or Updating Inventory.

There are two ways to edit your products:

• Manually editing products one at a time in the Dsco portal
• Editing multiple products at a time via flat-file formats or API

Editing products in the Dsco portal

Step 1: Click the navigation menu and select Workflows > Products. The Products page is displayed with a list of your products.

Step 2: Click the SKU link to see the product details.

Step 3: On the details page, click Edit Attributes at the top of the page. 

Step 4: On the edit attributes page, you can:

• Update the desired attributes.
• Add or remove locales. Click the + and - buttons next to the desired attributes, select a locale from the drop-down, and enter a description.
• Add a Partner SKU mapping for the item. Scroll down to the Partner SKU Mappings section and assign the appropriate partner SKU for your trading partner.

Step 5: When finished, click Save.

A status message is displayed at the top of the page. Your product data is reviewed to ensure it meets both CommerceHub’s minimum system requirements and your retailer’s catalog requirements.

Editing multiple products at a time

Step 1: Click the navigation menu and select Workflows > Products. The Products page is displayed with a list of your products. 

Step 2: Click Add Products at the top of the page. 

Step 3: In the Add Products window, click the drop-down to select a category/subcategory, and then click Populated Template to download a spreadsheet that’s pre-populated with existing product data. 

Step 4: Fill out the Excel spreadsheet with your products. Here's some additional information about the spreadsheet:

• Green attributes are required by your retailer.
• Blue attributes are recommended by your retailer.
• Grey/White attributes are optional and can be used if you'd like to store additional information about the product. If you provide data for these fields, the data will be validated to meet CommerceHub's system requirements. See Dsco Data Schema for more information about field definitions and requirements.

Step 5: When you're ready to upload the spreadsheet, return to the Products page and click Add Products.

Step 6: In the Add Products window, click the drop-down to select a category/ subcategory and click Continue to Upload.

Step 7: In the Add Products window, click the box and navigate to the location of the file or drag the file into the box. Click Upload.

Step 8: Your product data is reviewed to ensure it meets both CommerceHub’s minimum system requirements and your retailer’s catalog requirements.

• If your catalog was uploaded successfully, a pop-up is displayed.
• If your products do not meet minimum system requirements, an error notification (red box) is displayed. Click Download Error Report to view and download a CSV file that lists all products with an error. The file will display only one error per product. You’ll need to correct the errors in your file and re-upload your file to the system. See Troubleshooting common errors for advanced catalog services for more information.
• If your products do not meet your retailer’s catalog requirements, a notification for compliance errors  and/or category errors is displayed.