Download sample spreadsheets to see the structure for importing catalog data. The samples reference demo products and a demo company location, so replace the handles, SKUs, and Type Values with ones that exist on your store before importing.

The ID field is used to identify existing catalogs for updates. When creating new catalogs, this field can be left empty and Shopify will generate a unique ID automatically.

The main catalog title displayed throughout your store administration.

Comma-separated list of specific identifiers that this catalog applies to:

Used internally for grouping multiple rows together into a single catalog.

Sequential number identifying the position of this row in the import spreadsheet.

The Shopify ID of the price list associated with this catalog.

Descriptive name for the price list used within this catalog.

Three-letter ISO currency code (e.g., USD, EUR, CAD) for all prices in this price list.

Total count of product variants with fixed prices defined in this price list. This field is export-only and cannot be imported.

When creating a new price list, Shopify requires an adjustment. If you only set fixed prices and leave the adjustment columns blank, Altera creates the price list with a neutral 0% adjustment, so your fixed prices apply as-is.

The percentage or fixed amount value for the price adjustment. For percentage adjustments, use whole numbers (e.g., 10 for 10%). For fixed amounts, use decimal values in the price list currency.

The Shopify ID of the publication associated with this catalog.

Descriptive name for the publication channel used within this catalog.

If the row also has a value in the Product: Variant ID or Product: Variant SKU column, the command applies to that single variant instead of the whole product. MERGE includes the variant in the catalog and DELETE excludes it while the rest of the product stays available.

The URL-friendly identifier of the product to include in or remove from this catalog. On variant rows the handle is optional, because the variant ID or SKU already identifies the product.

When this column has a value, the row's Product: Command applies to just this variant's availability in the catalog instead of the whole product. Exports list each excluded variant as a row with a DELETE command, so re-importing an export unchanged makes no changes, and changing a DELETE to MERGE re-includes that variant.

If MERGE variant rows reference a product that is not in the catalog yet, the product is added to the catalog with only the listed variants included. A whole-product MERGE row takes precedence: if the same file also adds the product itself, the product is included with all of its variants, and any DELETE variant rows then exclude specific variants. To include only some variants of a new product, either list just the wanted variants as MERGE rows without a whole-product row, or add the whole-product row plus DELETE rows for the variants to exclude.

A whole-product DELETE row also takes precedence: if the same file removes the product from the catalog, variant rows for that product are skipped with a warning instead of re-adding it.

Works the same way as Product: Variant ID but identifies the variant by its SKU. If both columns have a value, the ID is used. If your store has duplicate SKUs, add the Product: Handle column to the row so the variant is matched within the right product, or use the ID instead.

The Shopify ID of the product variant to set a fixed price for within this catalog.

The stock keeping unit (SKU) of the product variant. Can be used as an alternative to Variant ID for identifying the variant.

The specific price to charge for this variant within this catalog context, in the currency specified by the price list.

The "was" or "compare at" price to display alongside the fixed price, typically used to show savings or discounts.

You can use these filters to limit which catalogs are exported:

Set type to COMPANY_LOCATION to export only B2B catalogs. The id filter accepts a comma-separated list to export a specific set of catalogs in one job.