CSV import file format for products, categories, price books and variations
Key Takeaway
In a product import, category columns add categories to a product but don't remove the ones it already has. A change to the Product Type of an existing product is ignored, and no error appears. Category descriptions and URL slugs need a separate category import, which you run from the catalog's Categories tab.
You can load product data into a B2B Commerce store with a CSV file. Each column heading tells the import what the column holds: product fields, categories, entitlement policies, prices, media or variation details. Each row represents a unique product and its variations. A separate category import file handles category paths, descriptions and URL slugs. Some columns only add data, and some values can't change after a product exists. Knowing these rules tells you what an import will actually do.
Product file basics
Save the import file in UTF-8 format so that special characters are encoded properly.
Each store starts with a default catalog named after the store, for example MyStore Catalog. That catalog holds one default category, Products. Each store also gets a default price book and a default strikethrough price book, for example MyStore Price Book and MyStore Strikethrough Price Book. During an import, you choose the catalog, category and price books for the products.