Import & export layout
Shopify product CSV columns and import rules
Shopify product import/export CSV (current column names).
The Shopify products layout has 32 columns; the required column is Title.
Shopify imports and exports products as a CSV where one row is one variant, not one product. The first row for a product carries the shared details (title, description, vendor, type, tags) and every following row with the same URL handle adds a variant or an extra image. That's why the URL handle matters so much: it is the key that ties rows together, and if two unrelated products share a handle, Shopify merges them.
Shopify renamed many columns in its current template (for example Body (HTML) became Description and Variant Price became Price). Older exports and many third-party apps still use the legacy names, which Fileshape treats as a separate source layout and converts to the current one.
Import rules to know
- Only Title is required for a new product, but a missing URL handle makes it impossible to add variants later in the same file.
- Published on online store and Gift card take TRUE or FALSE, not yes/no.
- Weight value is in grams regardless of the display unit you choose.
- Images are downloaded from their URLs during import, so the URLs must be publicly reachable. Product CSVs can be at most 15 MB.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| Title | Yes | Women's Snowboard | |
| URL handle | womens-snowboard | Required when adding variants | |
| Description | |||
| Vendor | |||
| Product category | |||
| Type | |||
| Tags | |||
| Collection | |||
| Published on online store | TRUE | ||
| Status | active | ||
| SKU | |||
| Barcodes | |||
| Option1 name | |||
| Option1 value | |||
| Price | 49.00 | ||
| Compare-at price | |||
| Cost per item | |||
| Charge tax | |||
| Inventory tracker | |||
| Inventory quantity | |||
| Continue selling when out of stock | |||
| Weight value (grams) | |||
| Weight unit for display | |||
| Requires shipping | |||
| Fulfillment service | |||
| Product image URL | |||
| Image position | |||
| Image alt text | |||
| Variant image URL | |||
| Gift card | |||
| SEO title | |||
| SEO description |