General
ID
Description | Example Value |
Shopify's unique catalog identifier |
|
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.
Command
Description | Example Value |
Import action |
|
MERGE: Update existing catalog or create if not found
DELETE: Remove the catalog from your store
NEW: Create catalog only (fails if catalog exists)
REPLACE: Delete existing catalog and create new one
IGNORE: Skip this catalog row during import
Title
Description | Example Value |
Name of the catalog |
|
The main catalog title displayed throughout your store administration.
Type
Description | Example Value |
Type of catalog context |
|
MARKET: Catalogs specific to certain markets or regions
APP: Catalogs specific to certain apps installed in the store
COMPANY_LOCATION: Catalogs specific to company locations for B2B customers
Type Values
Description | Example Value |
Specific values for the catalog type |
|
Comma-separated list of specific identifiers that this catalog applies to:
For MARKET type: Market handles (e.g.,
us,ca,uk)For APP type: App handles
For COMPANY_LOCATION type: Company location names
Status
Description | Example Value |
Current status |
|
ACTIVE: The catalog is currently active and available
DRAFT: The catalog is in draft mode and not yet published
Top Row
Description | Example Value |
Whether this is the first row for this catalog |
|
TRUE: This is the first row for this catalog object
FALSE: This is a continuation row for the same catalog
Used internally for grouping multiple rows together into a single catalog.
Row
Description | Example Value |
Row number in the spreadsheet |
|
Sequential number identifying the position of this row in the import spreadsheet.
Price List
Price List: ID
Description | Example Value |
Unique identifier for the price list |
|
The Shopify ID of the price list associated with this catalog.
Price List: Name
Description | Example Value |
Name of the price list |
|
Descriptive name for the price list used within this catalog.
Price List: Currency
Description | Example Value |
Currency code for the price list |
|
Three-letter ISO currency code (e.g., USD, EUR, CAD) for all prices in this price list.
Price List: Fixed Prices Count
Description | Example Value |
Number of fixed prices in the price list - Export only |
|
Total count of product variants with fixed prices defined in this price list. This field is export-only and cannot be imported.
Price List: Adjustment Type
Description | Example Value |
Type of price adjustment |
|
PERCENTAGE_DECREASE: Reduce prices by a percentage
PERCENTAGE_INCREASE: Increase prices by a percentage
FIXED_AMOUNT_DECREASE: Reduce prices by a fixed amount
FIXED_AMOUNT_INCREASE: Increase prices by a fixed amount
Price List: Adjustment Value
Description | Example Value |
Value of the price adjustment |
|
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.
Price List: Compare At Mode
Description | Example Value |
How compare-at prices are handled |
|
ADJUSTED: Compare-at prices are adjusted according to the price list rules
NULL_OUT: Compare-at prices are set to null/empty
Publication
Publication: ID
Description | Example Value |
Unique identifier for the publication |
|
The Shopify ID of the publication associated with this catalog.
Publication: Name
Description | Example Value |
Name of the publication |
|
Descriptive name for the publication channel used within this catalog.
Publication: Autopublish
Description | Example Value |
Whether products are automatically published |
|
TRUE: Products added to this catalog are automatically published to the publication channel
FALSE: Products must be manually published to the publication channel
Products
Product: Command
Description | Example Value |
Action to perform on the product |
|
MERGE: Add product to catalog or update if already present
DELETE: Remove product from catalog
Product: Handle
Description | Example Value |
Handle of the product to add/remove |
|
The URL-friendly identifier of the product to include in or remove from this catalog.
Fixed Prices
Price: Command
Description | Example Value |
Action to perform on the price |
|
MERGE: Add or update fixed price for the variant
DELETE: Remove fixed price for the variant
Price: Variant ID
Description | Example Value |
Unique identifier for the product variant |
|
The Shopify ID of the product variant to set a fixed price for within this catalog.
Price: Variant SKU
Description | Example Value |
SKU of the product variant |
|
The stock keeping unit (SKU) of the product variant. Can be used as an alternative to Variant ID for identifying the variant.
Price: Amount
Description | Example Value |
Fixed price amount for the variant |
|
The specific price to charge for this variant within this catalog context, in the currency specified by the price list.
Price: Compare At Amount
Description | Example Value |
Compare-at price for the variant |
|
The "was" or "compare at" price to display alongside the fixed price, typically used to show savings or discounts.