· DataEase · Documentation  · 5 min read

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

2. Import

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

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

    CommandWhat it does
    CREATEMake a new product / variant / media row
    UPDATEChange only the filled cells
    MERGEAdd or replace rows inside the product
    DELETERemove the product (or variant / media row)
    IGNORESkip 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).
    • 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. Import field

smartCollections

Smart collections containing this product. 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). Import field

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.

Share: