The Advanced Catalog feature is where you can view, download, and upload the catalog requirements for your retail trading partner. CommerceHub's Dsco platform makes it easy to see how your retail partner categorizes their items, and the download tool allows you to quickly obtain a template to upload your own items.
Note: The Advanced Catalog feature is different from the Catalog templates that are used to provide item data to your retail partner. For more information about uploading default Dsco Catalog/Inventory templates using the Inventory page, see Creating or Updating Inventory.
Important: To ensure data accuracy and compliance, be sure to download the latest template spreadsheet before you upload your items to the Dsco portal. This will help make sure your data is compliant with your retailer's requirements while reducing any errors you might receive when the Dsco portal validates your data.
Not every retail trading partner on the Dsco platform uses the Advanced Catalog feature.
Step 1: Click the Navigation icon, select WORKFLOWS, and then CATALOGS. There, you will see what catalogs have been created and activated by your trading partner.
Tip: You can also access the Catalogs page directly by going to https://app.dsco.io/catalogs.
Step 2: Select the category you would like to work on in the left-hand Catalogs column. The category will expand to as many subcategories as your retailer has created.
Step 3: Once you have selected the lowest subcategory, the Attributes column will populate with attribute fields specific to that category.
Guide to Attribute Indicators:
- Green = Required. Your retailer requires your items to include this attribute on upload.
- Blue = Recommended. Your retailer does not require this attribute for the item to load, but it is recommended.
- Grey = Optional.
Step 1: Select the "three dot" menu on the side of the catalog you would like to download and select Download Template Spreadsheet. This will download an .xlsx spreadsheet with the required attributes needed to upload your item(s) to Dsco.
Step 2: Fill out the Excel spreadsheet with your items, including sku (Dsco required) and any other attributes required by your trading partner (highlighted in green).
Note that column color highlights correspond with the attribute indicators shown above.
The template also includes columns with additional attributes Dsco supports but are not required by your retailer. Some suppliers may want to use these Dsco attributes for their own systems (e.g. "upc", "partner_sku", etc.).
Step 3: Once the spreadsheet is filled with your items for that category, you can upload it back to Dsco through the same "three dot" menu.
Tips for adding images
If your retail partner accepts or requires images in your catalog data, here are some guidelines for image URLs:
- Must use HTTPS
- Must not have spaces in the image title or anywhere in the URL. Using dashes or underscores is recommended instead.
- Must be hosted in a public repository/site. If you aren't sure how to host images online or do not have an internal hosting site that's public, you can use one of the following services:
- Google Photos
- If you're using Dropbox, valid image URLs should look like this: https://www.dropbox.com/s/85dxl67o4xinmlj/FW5033-MFW5223-M1.jpg?dl=1
If you have additional questions about image hosting, don't hesitate to reach out to our support team at email@example.com.
After you upload your catalog, Dsco will immediately validate your items to ensure they meet your retailer's catalog requirements. If there are any errors, Dsco will:
- Display a dialog box with a summary (shown below) and give you the option to (a) retry uploading a corrected file or (b) skip the row with the error and continue validating.
- Display errors (including image errors) on your Exceptions page, where you can also view and take action to resolve. For more information, see Exceptions Page.
Note: If images are rejected by the AC upload tool, you can visit the URL provided in the file to confirm the image will render in their browser (you must not be logged in to your image hosting site). When viewing images, there should not be additional navigational links/buttons on the page; only the image should show in the browser window.
Be sure to select each catalog and sub-catalog to ensure you are providing all of your available inventory to your retail trading partner.