Audience: Suppliers

Note: Not every retail trading partner on the Dsco platform uses Advanced Catalog, which is different from the Catalog templates that are used to provide item/product data to your retail partner. For more information about uploading default Dsco Catalog/Inventory templates using the Inventory page, see Creating or Updating Inventory

Advanced Catalog makes it easy for you to upload catalog items 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 items to the 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.

Depending on your configuration, upload your products to the Dsco platform using one of the following options:

Uploading products using the Catalogs page

Step 1: Click the Dashboard icon and select Workflows > Catalogs.

Step 2: On the Catalogs page, navigate to the desired category and subcategory.

Step 3: Download the category's template spreadsheet by clicking the three-dot menu for the desired catalog/category and select Download Template Spreadsheet.

Step 4: Fill out the Excel spreadsheet with your items, including sku (Dsco required) and any other attributes required by your retailer (highlighted in green).

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.).

Tip: Adding images to your products? Check out the Adding images to your products section below for some helpful tips.

Step 5: Upload the completed spreadsheet by clicking the same three-dot menu for the desired catalog/category and select Upload Spreadsheet.

Step 6: In the pop-up window, click the box and navigate to the location of the file or drag the file into the box. Click Upload.

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

Uploading products using the Products page

Step 1: Click the Dashboard icon and select Workflows > Products.

Step 2: The Products page is displayed with a list of your products. Click the Actions button in the top corner and select Load Products.

Step 3: In the Load Products window, click the drop-down to select or search for a category and/or subcategory. 

Step 4: Click Download Template.

Step 5: Fill out the Excel spreadsheet with your items, including sku (Dsco required) and any other attributes required by your retailer (highlighted in green).

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.).

Tip: Adding images to your products? Check out the Adding images to your products section below for some helpful tips.

Step 6: When you're ready to upload the spreadsheet, return to the Products page, click the Actions button, and select Load Products.

Step 7: In the Load Products window, click the drop-down to select or search for a category and/or subcategory.

Step 8: Click Upload.

Step 9: In the pop-window, click the box and navigate to the location of the file or drag the file into the box.

Step 10: Click Upload.

Step 11: A pop-up is displayed when your catalog file has been uploaded successfully. If you receive an error message related to syntax errors, make sure you're uploading the correct file and upload the file again. 

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

Adding images to your products

If your retailer accepts or requires images in your catalog data, here are some guidelines for image URLs:

  • If you choose to upload your images via a spreadsheet, every item must include at least one image URL. If there are any blank rows in the "image_reference" columns, the Dsco platform will remove that image from the item. Make sure that either all rows are complete in the "image_reference" columns, or completely remove the "image_reference" columns from the spreadsheet. 
  • You must use HTTPS. Here's an example: https://www.dropbox.com/s/85dxl67o4xinmlj/FW5033-MFW5223-M1.jpg.
  • You must not include spaces in the image title or anywhere in the URL. Using dashes or underscores is recommended instead.
  • Images 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:
    • Dropbox   
    • Imgur    
    • Flickr  
    • Google Photos
  • If you're using Dropbox to host your images, valid image URLs should look like this: https://www.dropbox.com/s/85dxl67o4xinmlj/FW5033-MFW5223-M1.jpg?dl=1
  • 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 the 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.

Important: Dropbox will automatically create a link with a dl=0 extension, which will result in an image error. The dl=0 value must be changed to dl=1

If you have additional questions about image hosting, don't hesitate to reach out to the Technical Support team at support@dsco.io.

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

Comments

0 comments

Please sign in to leave a comment.