Redirect store - product catalog fields

We can accept product catalog data in whatever format the brand can provide. This is often a “catalog export” function within the brand's eCommerce system or maybe a link to your Google Shopping or other Affiliate Marketing product feeds.

Required setup data for each product

Note: We do not need separate SKU-level details (colors/sizes/etc.). This information is generally provided in spreadsheet format, with one product per row. Your Customer Success partner can provide a template to help as needed.

1. Store catalog file

• For each product that is in the store, the following data is required:
  • Product code
    • Unique code/ID for the product (this is the parent ID to a set of SKUs).
    • Used to match for the ExpertVoice Recommendation Display,  ideally this matches the value that will be passed into the EAS display code.
  • Product name
    • Name that will be displayed for the product
  • Product description
    • Long description of the product (may contain HTML)
  • MSRP price
  • Product images
    • Image name (when images are sent as a batch) or URL to download the image
  • SKU
    • Unique code/ID for one product variant (colors/sizes)
• Optional data for each product:
  • Technical description/specs
    • May contain HTML
  • Additional product images
    • List of file names for the product images
    • When providing a batch of image files, match file names exactly; case-sensitive
    • Supports up to 9 images per product.

2.  Collection of image files that are referenced in the above store spreadsheet 

• Generally provided via FTP or website so they can be downloaded in bulk. Names are case-sensitive and should match exactly. A brand may also offer a list of URLs.
  

How to export product catalog data:

• Shopify:
  • https://help.shopify.com/en/manual/products/import-export/export-products
  • We can also integrate directly with the brand's Shopify API, and pull down the catalog data directly.
• Magento 2:
  • https://experienceleague.adobe.com/docs/commerce-admin/systems/data-transfer/data-export.html?lang=en
• Salesforce Commerce Cloud (Demandware):
  • https://documentation.b2c.commercecloud.salesforce.com/DOC1/topic/com.demandware.dochelp/content/b2c_commerce/topics/catalogs/b2c_export_a_catalog_as_csv.html
• WooCommerce:
  • https://docs.woocommerce.com/document/product-csv-importer-exporter/#section-8
• Big Commerce:
  • V2: https://support.bigcommerce.com/s/article/Importing-Exporting-Products#product-export
  • V3: https://support.bigcommerce.com/s/article/V3-Import-Export?language=en_US#export
• NetSuite SuiteCommerce:
  •  Looks to require a plugin to do catalog exports. Most brands using NetSuite have a Google Shopping feed they can share.
• SAP Hybris:
  • https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/8bd9a45d86691014b71aa404248b7ee5.html
• Wix:
  • https://support.wix.com/en/article/wix-stores-exporting-products
• Squarespace:
  • https://support.squarespace.com/hc/en-us/articles/360000694948-Exporting-products-to-a-csv
• HCL Commerce (IBM WebSphere):
  • https://help.hcltechsw.com/commerce/8.0.0/admin/tasks/tpncatalogexport.html