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.

Not all retailer trading partners use advanced catalog services, which is different from the 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 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 catalog/inventory templates using the Inventory page, see Creating or Updating Inventory.

Step 1: Click the navigation icon 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. 

Looking to add new products and start with a blank template? See Uploading new products for more information.

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.


  • Adding images to your products? Be sure every product includes at least one image URL. Make sure that either all rows are complete in the "image_reference" columns or completely remove the "image_reference" columns from the spreadsheet. Remove all unused columns from the spreadsheet. See Working with product images for advanced catalog services.
  • Looking to remove unwanted or incorrect values from the image attributes? Simply enter a text string "null” in an existing image attribute field to delete values. When you reupload your SKUs, the unwanted image(s) will no longer appear.

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: A pop-up is displayed when your catalog file has been uploaded successfully. If you receive an error notification, make sure you're uploading the correct file and upload the file again. Learn more about troubleshooting common errors for advanced catalog services.

Step 9: To see if your products have met your retailer's catalog requirements, go to the Catalog Exceptions page to view content and image errors. 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.