Skip to content
DataEase
Try for free

Discounts

A Discount lets you reward shoppers with promo codes, automatic deals, free shipping, or “Buy X Get Y” offers.
With DataEase you can:

  • Create hundreds of new codes in one upload.
  • Update rules, dates, or combine-settings in bulk.
  • Delete expired deals fast.

Shopify discount guide.


  1. Export
  2. Import
  3. Field reference
  4. Filters

  1. Pick CSV (safer for very long text) or Excel.
  2. Choose Discount as the entity.
  3. Select fields like type, startsAt, codesCount, etc.
  4. Run the task and download your file.

Need screenshots? See the Export guide.


Supported commands in command column: CREATE, UPDATE, REPLACE, DELETE, IGNORE
Supported code-line itemCommand: CREATE, UPDATE, MERGE, DELETE, IGNORE

  1. Get the sample sheet: Discount-import-sample.xlsx
  2. Fill rows:
    • type (DiscountCodeBasic, DiscountAutomaticBasic, etc.) is required for CREATE.
    • Each code goes in its own line with itemCommand.
    • Use handle or title to match when id is empty.
  3. Map columns in DataEase, upload, and start the import.

Full steps: Import guide

Notes

  • startsAt / endsAt change only if the column is included.
  • recurringCycleLimit = 0 means unlimited for subscriptions.
  • combinesWithShipping is forbidden for shipping discounts and will throw an error.
  • Shopify limits: 5 000 smart discounts and 60 rules per discount.

  • id — Discount ID (needed for UPDATE, REPLACE, DELETE).

  • title — Name seen by merchants and shoppers.

  • summary — Long description of the deal (admin only).

  • shortSummary — Short version of summary. Export only.

  • startsAt — When the discount becomes active (ISO 8601).

  • endsAt — When the discount expires. Use null for no end date.

  • status — Current state: ACTIVE, SCHEDULED, EXPIRED. Export only.

  • type — Required on CREATE. One of: DiscountCodeBasic, DiscountAutomaticBasic, DiscountCodeBxgy, DiscountAutomaticBxgy, DiscountCodeFreeShipping, DiscountAutomaticFreeShipping.

  • code — Promo code text (applies to code-based discounts only).

  • itemCommand — For each code row: CREATE, UPDATE, MERGE, DELETE, IGNORE.

  • discountClass — Controls how discounts combine (order, product, shipping). Since Admin API 2026-07 a discount can have several classes; this column keeps the first one. Export only.

  • discountClasses — All classes of the discount, comma-separated (for example PRODUCT, ORDER). Export only.

  • codesCount — Number of codes linked to the discount. Export only.

  • command — Main command for the discount: CREATE, UPDATE, REPLACE, DELETE, IGNORE.

  • customerGetsAllItems — true if all items get the reward.

  • customerGetsCollectionHandle — Handles of collections to reward.

  • customerGetsVariantsSku — Variant SKUs to reward.

  • customerGetsProductsHandle — Product handles to reward.

  • customerGetsPercentage — Percent off (0 – 1). Example: 0.2 = 20 % off.

  • customerGetsOnQuantity — Quantity of items that receive the reward (BxGy).

  • customerGetsAmountValue — Fixed money off (store currency).

  • customerGetsAmountAppliesOnEachItem — true to apply fixed amount to each item; else split across items.

  • customerBuysAllItems — true if any item can trigger the deal.

  • customerBuysCollectionHandle — Collections that trigger the deal.

  • customerBuysVariantsSku — Variant SKUs that trigger the deal.

  • customerBuysProductsHandle — Product handles that trigger the deal.

  • customerBuysAmount — Minimum spend needed.

  • customerBuysQuantity — Minimum quantity needed.

  • combinesWithOrder — true if this discount combines with order discounts.

  • combinesWithProduct — true if this discount combines with product discounts.

  • combinesWithShipping — true if this discount combines with shipping discounts.

  • appliesOncePerCustomer — true if each customer can use the discount only once.

  • usageLimit — Max total uses (null = unlimited).

  • customerSelectionAllCustomers — true if all shoppers can use the discount.

  • customerSelectionSegments — Customer segment IDs allowed or blocked.

  • customerSelectionCustomers — Specific customer IDs allowed or blocked.

  • recurringCycleLimit — For subscriptions: how many billing cycles the deal applies (0 = unlimited).

  • minimumQuantity — Minimum items in cart to apply discount.

  • minimumSubtotal — Minimum cart subtotal to apply discount.

  • appliesOnOneTimePurchase — true if works on one-time items.

  • appliesOnSubscription — true if works on subscription items.

  • usesPerOrderLimit — Max times the discount can apply on a single order.

  • maximumShippingPrice — Max shipping cost that still qualifies for free-shipping discount.

  • destinationSelectionAllCountries — true if free-shipping discount covers all countries.

  • destinationSelectionCountries — Two-letter country codes that qualify.

  • destinationSelectionIncludeRestOfWorld — Legacy column, kept for older files. Shopify no longer supports “rest of world”, so export always writes false for a country list (empty for all countries). On import, true with no destinationSelectionCountries is imported as all countries; true together with a country list applies the discount only to the listed countries (the row gets a warning). Use destinationSelectionAllCountries for all countries.


  • Code — Find discounts containing a specific code.

  • CombinesWith — Filter by combination flag (order_discounts, product_discounts, shipping_discounts).

  • DiscountClass — Filter by class (order, product, shipping).

  • DiscountType — Filter by type (percentage, fixed_amount, bogo, free_shipping).

  • Id — Export a single discount by id.

  • Method — code or automatic.

  • StartsAt — Range for active-from date.

  • EndsAt — Range for active-until date.

  • CreatedAt — Creation date range.

  • UpdatedAt — Last-updated date range.

  • Status — ACTIVE, EXPIRED, SCHEDULED.

  • TimesUsed — Min or max total uses.

  • Title — Partial match on title.


Need help? Our support team replies within 24 hours.

More columns DataEase supports for this entity:

  • hasTimelineComment — Indicates if the discount has a timeline comment (boolean).
  • totalSales — Total sales generated by the discount (numeric).
  • customerGetsAmountCurrencyCode — Currency code for the discount amount the customer receives (ISO 4217).