Search code examples
salesforcedemandwaresalesforce-commerce-cloud

SFCC - Help exporting all Products from Salesforce Commerce Cloud (Demandware) to XML or CSV

We are attempting to migrate a store from SFCC to Shopify, but we are having trouble exporting the products from Salesforce Commerce Cloud (previously Demandware).

I've reviewed quite a bit of documentation from SFCC, but I'm not finding a simple product export. I wonder if I might be misunderstanding their terminology.

I found this cheatsheet: https://documentation.b2c.commercecloud.salesforce.com/DOC2/index.jsp?topic=%2Fcom.demandware.dochelp%2FImportExport%2FImportExportObjectCheatsheet.html&resultof=%22%70%72%6f%64%75%63%74%22%20%22%65%78%70%6f%72%74%22%20

It pointed me toward "Catalog Object Import/Export" https://documentation.b2c.commercecloud.salesforce.com/DOC2/index.jsp?topic=%2Fcom.demandware.dochelp%2FImportExport%2FCatalogObjectImportExport.html

When I attempt to export my products, I am missing many product attributes from the export, like custom attributes. How can I get this data too?

Solution

  • Please refer to the sfcc catalog schema from B2C Commerce import and export schemas:

    The schema will explain to you the structure of the catalog. The catalog can have assigned products or catalog can own them. In SFCC we usually have a master catalog that owns products. Owning means that in the catalog you have product definition and all related data about the product, except images.

    Hence what you need to do is to ask your client to export for your master catalog of the site you wish to migrate. Such activity doesn't require coding or some job creation in SFCC. You can make it from Business Manager following this pass:

    • Merchant Tools > Products and Catalogs > Import & Export > Catalog Export - Step 1: Select Catalog

    Catalog Export

    Note that products in Commerce Cloud have an inheritance model for attributes. Products that have multiple size or color options (or other options) will use a Master -> Variant relationship. Variants will inherit values for attributes from the Master product if their own attributes are empty. For example, you will often see a product's name attribute defined only for the Master product.