Skip to content
fileshape

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

ColumnRequiredExampleNotes
TitleYesWomen's Snowboard
URL handlewomens-snowboardRequired when adding variants
Description
Vendor
Product category
Type
Tags
Collection
Published on online storeTRUE
Statusactive
SKU
Barcodes
Option1 name
Option1 value
Price49.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

Guides