· DataEase · Documentation · 3 min read
Variants
Product variants are the different versions of a product (size S, color Red, 32 GB, and so on).
With DataEase you can export all variants, change prices, stock, barcodes, metafields, and then import the file back to Shopify in minutes.
Shopify manual for variants.
Table of Contents
1. Export
- New Export → CSV / Excel → Variants
- Pick the filters you need (see list below).
- Select the columns (or choose All).
- Run and download.
- If your description metafields are huge, choose CSV (Excel cells max 32 767 chars).
Full export how-to: export-data.
2. Import
- Edit the export file or copy our demo sheet.
- Use
itemCommand(CREATE,UPDATE,MERGE,DELETE,IGNORE) on each variant row. - Make sure you have at least
variantIdorskuorbarcodeto match the variant. - Save as CSV or XLSX → New Import in DataEase → upload → map columns → run.
Detailed steps: import-data.
3. Field list
Legend
• Import field – can be sent back to Shopify.
• No flag – export-only (read-only).
Variant columns
variantId
Unique identifier for the variant. Import field
itemCommand
Action for this variant row (CREATE, UPDATE, etc.). Import field
sku
Stock-keeping unit (SKU). Import field
barcode
Barcode / UPC / EAN. Import field
displayName
Auto-built name (Product title + Variant title). Export only
inventoryQuantity
Total on-hand stock across all locations. Import field
sellableOnlineQuantity
Stock available for online store. Import field
availableForSale
true if purchasable. Import field
variantImage
Featured image URL for the variant. Import field
position
Variant sort order (1 = first). Import field
price
Selling price (shop currency). Import field
compareAtPrice
“Compare at” price (cross-out). Import field
taxable
Charge tax? (true / false). Import field
taxCode
US tax code string. Import field
inventoryPolicy
CONTINUE or DENY when out of stock. Import field
variantMetafields
Dynamic metafield columns like variant metafield custom.color. See /metafields. Import field
weight
Weight numeric value. Import field
weightUnit
GRAMS, KILOGRAMS, OUNCES, or POUNDS. Import field
requiresShipping
true if physical item. Import field
requiresComponents
true if variant can only be sold as part of a bundle. Import field
cost
Unit cost (requires permission). Import field
countryCodeOfOrigin
ISO-2 origin country. Import field
harmonizedSystemCode
HS (tariff) code (6-13 digits). Import field
provinceCodeOfOrigin
Origin province ISO-2. Import field
tracked
Track inventory? (true/false). Import field
quantities
Dynamic location columns location: Warehouse A, etc. Adjust stock or use “+5” / “-3”. Import field
fixedPrices
Dynamic market price columns price / Canada, compare at price / EU. Import field
variantCreatedAt
Variant creation time. Export only
variantUpdatedAt
Last variant update time. Export only
4. Filter list
Use these filters before exporting to limit which variants you get:
Barcode
Variant barcode matches text.
CategoryId
Product taxonomy ID equals value.
CreatedAt
Variant creation date range.
Handle
Product handle contains / equals text.
Id
Product ID equals list.
InventoryTotal
Stock level greater / less than number.
Price
Variant price range.
ProductType
Product type equals text.
Sku
SKU matches value.
Status
Product status (ACTIVE, DRAFT, ARCHIVED).
Tag
Product has tag.
Title
Product title contains text.
UpdatedAt
Variant last updated date range.
VariantId
Variant ID equals list.
VariantTitle
Variant title contains text.
Vendor
Vendor equals text.
Need more help? Our support team replies within 24 hours.