Skip to content
DataEase
Try for free

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

Section titled “Table of Contents”
  1. Export
  2. Import
  3. Field list
  4. Filter list

1. Export

Section titled “1. Export ”
  1. New Export → CSV / Excel → Variants
  2. Pick the filters you need (see list below).
  3. Select the columns (or choose All).
  4. Run and download.
  5. If your description metafields are huge, choose CSV (Excel cells max 32 767 chars).

Full export how-to: export-data.

2. Import

Section titled “2. Import ”
  1. Edit the export file or copy our demo sheet.
  2. Use itemCommand (CREATE, UPDATE, MERGE, DELETE, IGNORE) on each variant row.
  3. Make sure you have at least variantId or sku or barcode to match the variant.
    If an inventory quantity update is refused because an earlier attempt of the same request in this import failed (IDEMPOTENCY_PREVIOUS_ATTEMPT_FAILED), the row gets a warning and the quantity is not changed — check the row and run the import again.
  4. Save as CSV or XLSX → New Import in DataEase → upload → map columns → run.

Detailed steps: import-data.

3. Field list

Section titled “3. Field list ”

Legend
• Import field – can be sent back to Shopify.
• No flag – export-only (read-only).

Variant columns

Section titled “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 (Avalara AvaTax). Shopify no longer supports Avalara tax codes: the value is ignored on import with a “Tax code ignored” warning and the variant’s tax code is not changed.
  • 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
  • Inventory 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

Section titled “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.

Additional fields

Section titled “Additional fields”

More columns DataEase supports for this entity:

  • descriptionHtml — HTML-formatted product description. Import field
  • Description — Plain text product description. Import field
  • tags — Comma-separated list of product tags. Import field
  • tagsCommand — Action for tags (ADD, REMOVE, etc.). Import field
  • productCategory — Name of the product category. Import field
  • ProductCategoryId — Unique identifier for the product category. Import field
  • productMetafields — Custom fields for additional product information. Import field
  • collections — List of collections the product belongs to. Import field
  • smartCollections — List of smart collections the product is part of. Import field
  • media — Associated media files for the product. Import field
  • seoDescription — SEO meta description for the product. Import field
  • seoTitle — SEO meta title for the product. Import field
  • PublishedAt — Date and time when the product was published. Import field
  • TotalInventory — Total inventory available for the product. Import field
  • OnlineStoreUrl — URL of the product on the online store. Import field
  • mediaCommand — Action for media files (ADD, REMOVE, etc.). Import field
  • mediaAlt — Alt text for media files. Import field
  • mediaPosition — Position of media files in the product gallery. Import field
  • mediaStatus — Status of media files (ACTIVE, ARCHIVED, etc.). Import field
  • productOptions — Options available for the product (e.g., size, color). Import field
  • isGiftCard — Indicates if the product is a gift card. Import field
  • giftCardTemplateSuffix — Template suffix for gift card products. Import field
  • templateSuffix — Template suffix for the product. Import field
  • MaxVariantPrice — Maximum price among all variants. Import field
  • MaxVariantPriceCurrency — Currency of the maximum variant price. Import field
  • MinVariantPrice — Minimum price among all variants. Import field
  • MinVariantPriceCurrency — Currency of the minimum variant price. Import field
  • FeaturedMedia — Main media file featured for the product. Import field
  • variantGenerateFromOptions — Indicates if variants are generated from options. Import field
  • publicationScope — Scope of product publication (GLOBAL, LOCAL, etc.). Import field
  • options — List of options for the product variants. Import field
  • quantities — Quantities available for each variant. Import field