Products

Products are what you sell. Each product can have many variants (size, color, pack-size) and lots of extra data like prices, inventory, media, SEO, and metafields.
With DataEase you can bulk-export, update in Excel / Google Sheets, then import to Shopify in minutes.

(Official Shopify manuals → Products • Variants)

---

Table of Contents

1. Export
2. Import
3. Field list
4. Filter list

---

1. Export

1. Click New Export in DataEase.
2. Pick CSV (safe for long descriptions) or Excel.
3. Choose Products.
4. Use filters (by tag, vendor, status, etc.) if you need.
5. Select the columns you want (or All fields).
6. Run the task and download the file.

Need pictures? See the full how-to → export-data

Export speed. To stay within Shopify’s query cost limit, DataEase reads products in pages of 33. With the variantImage column the page is 20 products, and with the collections / smartCollections columns it is 12 products. Large exports with collection columns take longer; the file content is the same. See Shopify limits.

---

2. Import

1. Open the export file or duplicate the demo sheet.

2. Edit rows or add new ones. Use the command column:

   Command	What it does
   CREATE	Make a new product / variant / media row
   UPDATE	Change only the filled cells
   MERGE	Add or replace rows inside the product
   DELETE	Remove the product (or variant / media row)
   IGNORE	Skip this row

3. Key rules

   • Products match by id, or handle if no id.
   • Variants match by variantId; if blank DataEase looks for sku, then barcode, then option combo.
   • Media rows need media URL and mediaCommand.
   • SEO fields can’t be empty.
   • Inventory columns start with location: (use +10 / -5 to adjust).
   • If an earlier attempt of the same inventory update in this import failed, Shopify refuses to repeat it (IDEMPOTENCY_PREVIOUS_ATTEMPT_FAILED). The affected variant rows get a warning that the quantity set/adjustment was not applied — check the row data and run the import again.
   • Limit: Shopify lets you create 1 000 new products / variants per day once the store passes 50 000.

4. Save the file.

5. In DataEase choose New Import, upload the file, map the columns, and run.

Full import guide: import-data

---

3. Field List

Below is every column DataEase can show for Products, Variants, and Media.
Fields marked “Import field” can be sent back to Shopify. If not marked, they are export-only.

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

3.1 General helper columns

• row — Row number from the original export. Export only
• topRow — TRUE for the product header row, FALSE for variant or media rows. Export only
• lineType — Kind of row: Product, ProductMedia, Variant. Export only

3.2 Product fields

• id — Product ID. Primary key for updates. Import field
• command — Action for this product row. Import field
• title — Product name shown to customers. Import field
• handle — URL handle (unique, max 256 chars). Import field
• descriptionHtml — Rich-text (HTML) description. Import field
• Description — Plain-text description. Export only
• vendor — Brand / vendor. Defaults to store name if blank. Import field
• status — ACTIVE, DRAFT, or ARCHIVED. Import field
• productType — Custom product type text. Import field
• tags — Comma-separated tags (overwrites existing). Import field
• tagsCommand — Tag helper (ADD, REMOVE, REPLACE). Import field
• productCategory — Full taxonomy name. Import field
• ProductCategoryId — Taxonomy ID. Import field
• productMetafields — Dynamic metafield columns (see /metafields). Import field
• collections — Manual collections containing this product (the product was picked manually in the collection). Import field
• smartCollections — Collections that include this product through conditions, sub-collections, variant or app sources. Export only
• seoTitle — SEO title tag. Import field
• seoDescription — SEO meta description. Import field
• CreatedAt — Product creation time. Export only
• UpdatedAt — Last modified time. Export only
• PublishedAt — First publish time. Export only
• TotalInventory — Total stock of all variants. Export only
• OnlineStoreUrl — Live store URL for the product. Export only
• media — Media URL (one per media row, or ;-separated if grouped). Import field
• mediaCommand — Media row action. Import field
• mediaAlt — Alt text for the media. Import field
• mediaPosition — Media sort order (1-n). Import field
• mediaStatus — READY, PROCESSING, FAILED, UPLOADED. Export only
• Options — Dynamic option columns (Option 1 Name / Value, etc.). Import field
• isGiftCard — true to turn product into a gift card. Import field
• giftCardTemplateSuffix — Gift-card template file suffix. Import field
• templateSuffix — Alternate Liquid template for the product page. Import field
• MaxVariantPrice — Highest variant price. Export only
• MaxVariantPriceCurrency — Currency of highest price. Export only
• MinVariantPrice — Lowest variant price. Export only
• MinVariantPriceCurrency — Currency of lowest price. Export only
• FeaturedMedia — ID of the featured media. Import field
• variantGenerateFromOptions — true to auto-create variants from option sets. Import field (ImportOnly)
• publicationScope — [IsPublished] & [PublishedAt] per sales channel / market. Import field

3.3 Variant fields

• variantId — Variant ID (key for updates). Import field
• itemCommand — Action for this variant. Import field
• sku — Stock keeping unit. Import field
• barcode — UPC / EAN / barcode value. Import field
• variantUpdatedAt — Variant last update time. Export only
• variantCreatedAt — Variant creation time. Export only
• displayName — Product title + variant title. Export only
• inventoryQuantity — Total on-hand stock. Import field
• sellableOnlineQuantity — Stock available for online store. Import field
• availableForSale — true if purchasable. Import field
• variantImage — Featured image URL for variant. Import field
• position — Variant order (1-n). Import field
• price — Selling price (shop currency). Import field
• compareAtPrice — Compare-at price. Import field
• taxable — Charge tax? (true/false). Import field
• taxCode — Tax code (US-based, Avalara AvaTax). Shopify no longer supports Avalara tax codes: the column is still accepted, but the value is ignored on import and the row gets the warning “Tax code ignored”. The variant’s tax code is not changed.
• inventoryPolicy — CONTINUE or DENY when out of stock. Import field
• variantMetafields — Dynamic variant metafields. Import field
• weight — Weight numeric value. Import field
• weightUnit — GRAMS, KILOGRAMS, OUNCES, POUNDS. Import field
• requiresShipping — true if physical shipping needed. Import field
• requiresComponents — true if variant is parent bundle only. Import field
• cost — Unit cost (requires permission). Import field
• countryCodeOfOrigin — ISO-2 code of origin country. Import field
• harmonizedSystemCode — HS (tariff) code (6-13 digits). Import field
• provinceCodeOfOrigin — Province ISO-2 code (if needed). Import field
• tracked — Track inventory? (true/false). Import field
• quantities — location: Location Name dynamic columns – set or adjust stock. Import field
• fixedPrices — price / Market, compare at price / Market dynamic columns. Import field

3.4 Media status enum (export only)

• mediaStatus — READY, PROCESSING, FAILED, or UPLOADED.

3.5 Product status enum (import)

• status — ACTIVE, DRAFT, or ARCHIVED decide product visibility.

---

4. Filter list

Every filter you can use before exporting Products:

• Barcode — Filter by variant barcode.
• Bundles — Show only bundle products (true / false).
• CategoryId — Shopify taxonomy category ID.
• CollectionId — Products that belong to a specific collection.
• CombinedListingRoles — Filter by combined listing role.
• CreatedAt — Creation date range.
• DeliveryProfileId — Products linked to a delivery profile.
• ErrorFeedback — Products with Shopify error messages.
• GiftCard — Gift-card products only.
• Handle — Handle contains / equals text.
• HasOnlyComposites — Products whose variants are all bundles.
• HasOnlyDefaultVariant — Products with a single default variant.
• HasVariantWithComponents — Products that include at least one variant bundle.
• Id — Exact product ID list.
• InventoryTotal — Stock level greater / less than a number.
• IsPriceReduced — Products with at least one variant where price < compareAtPrice.
• OutOfStockSomewhere — Products that are out of stock in any location.
• Price — Variant price range.
• ProductConfigurationOwner — Owner app or channel ID.
• ProductPublicationStatus — PUBLISHED, UNPUBLISHED, etc.
• ProductType — Custom product type filter.
• PublicationIds — Products published to specific channels.
• PublishableStatus — Ready / not ready for publishing.
• PublishedAt — First published date range.
• PublishedStatus — PUBLISHED or UNPUBLISHED.
• Sku — Variant SKU matches.
• Status — Product status (ACTIVE, DRAFT, ARCHIVED).
• Tag — Contains tag.
• Title — Title contains / equals text.
• UpdatedAt — Last update date range.
• VariantId — Search by variant ID.
• VariantTitle — Variant title contains text.
• Vendor — Vendor equals text.

---

Need more help? Our support team replies within 24 hours.

Additional fields

More columns DataEase supports for this entity:

• productOptions — Options available for the product, such as size or color. Import field