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 the 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:

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 the platform’s minimum system requirements and your retailer’s catalog requirements.

Adding an image to a product

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 > Replaced Image details.

Step 3: On the Product Details page, click Add Media.

Step 4: On the Manage Media window, select the Media Name, click the arrow to browse to the image, then click Save.

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, select the Retailer for which you want to add products, then select the Category and subcategory. 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 the platform'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 content and/or image attributes? Simply enter a text string "null” in an existing image or content 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 the Retailer for which you want to add products, then 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: While your product data is reviewed to ensure it meets both CommerceHub’s minimum system requirements and your retailer’s catalog requirements, a Products Processing prompt appears at the top of the page.

Step 9: Click Products Processing to see the progress of your upload:

Step 10: If your catalog was uploaded successfully, a pop-up is displayed.

  • 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.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.