Get Excelify now
Get Excelify now

Discounts

See what each field/column from our “Discounts” template means including possible allowed values and examples.

Fields marked with “Exported only” tag cannot be imported/set in Shopify and but can be exported with Excelify export.

Excel Sheet Name

Discounts

​To tell the app that you are importing Discounts you need:

  • If using CSV file then the file name needs to contain the word “Discounts”, for example, “my-shopify-discounts.csv”
  • If using XLSX file then the sheet/tab name in the file needs to be “Discounts”. The file name for the XLSX file does not matter.

Columns Available For Export And Import

Base Columns

Column Description / Example Value
ID

Exported only

ID is automatically generated number by Shopify to identify the item.
It is filled in by an Export.
When creating new Discount, leave this value empty.

Number

11920047631
Title Title of the Discount to show in Admin.

This is not a discount code – it’s the name to call all of the discount codes of the same kind.

To set the discount code, fill the “Code” column.

If you will not import the Title column, it will get automatically set to the same as the Code from the Code column.

Text

Xmas Discount
Command When importing Discount row – tell the app, what to do with it:

 

  • NEW: will try to create a new Discount with the provided details. If such Discount will already exist (with the same ID or same Code), then the result will be Failed.
  • UPDATE: will try to find existing Discount, and update it with data from the row. If such Discount will not be found, then it will create new.
  • REPLACE: at first, if such Discount with provided ID or Code exists, then the app will delete it. After that, it will create a new one. If an existing Discount will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the Discount will be deleted and re-created.
  • DELETE: the app will delete the existing Discount, which is found by ID or Code. If such Discount will not be found, then the result will be Failed. This DELETE command is very handy for deleting Discounts in bulk.

If no Command is specified, then the app will assume the UPDATE command.

NEW
UPDATE
REPLACE
DELETE

UPDATE
Code Discount code that customers use at checkout. Required when creating a discount.

You can have several discount codes for one Discount. To create several discount codes, duplicate the row with the same ID or Title. When exporting a Discount with several codes, each code also will be put in a new line.

The maximum length is 255 characters. The code is not case-sensitive, which means that there is no difference if big or small letters are used.

Number

christmas-sale-AB12
Used Count

Exported only

Number of times the discount code has been redeemed.

6
Discount Type This is the discount type. You can set one of three types: give percentage discount, fixed amount discount or free shipping. The same principle, as entering them through Shopify Admin.

Percentage
Fixed Amount
Free Shipping
Buy X Get Y

Percentage
Discount Value Here you provide the percentage amount for the Percentage discount or just amount for Fixed amount.

The number should be negative.

Negative decimal number

-50.50
Minimum Purchase Amount Minimum purchase amount for discount to be applied. Orders below the minimum purchase amount will not have discount.

Decimal number

20.50
Limit Total Times Number of times this discount can be used.

Number

2
Limit One Use Per Customer If TRUE, then each customer will be able to use this discount code only once.

TRUE
FALSE

TRUE
Limit Once Per Order If FALSE, then the discount amount will be taken off each eligible product in an order.

Can only be edited for Fixed Amount discounts that are applied to specific Product/s or Collection/s.

TRUE
FALSE

TRUE
Max Uses Per Order Only for “Buy X Get Y” discount type: what is the maximum of allowed uses per order.

The default is unlimited.

Number

5
Minimum Number Of Items The minimum number of items to purchase to apply the discount code.
Can be used for all discount types, except for “Buy X Get Y”.The default is empty, which means 1.

Number

10
Starts At Date and time, from what the discount can be used. If left empty, will start now.

Date & Time

2017-10-06 23:03:00 UTC
Ends At Date and time, till what the discount can be used. If left empty, the code will never expire.

Date & Time

2017-10-06 23:03:00 UTC
Updated At

Exported only

It will be automatically updated, whenever you change the Discount data.

Date & Time

2017-10-06 23:03:00 UTC

Free Shipping Columns

These columns to be filled for Free Shipping discount type.

Column Description / Example Value
Free Shipping: Country Codes

Only for Discount Type –
Free Shipping

Country international codes, consisting of 2 letters, to which free shipping to be applied to.

To enter several country codes, you can either enter them in the same cell, separating country codes by comma. Or you can create new rows with the same Discount Code value, and have each country code in its own row.

It is important, that each Country Code is added to at least one Shipping Zone. You can do it in Admin: Settings -> Shipping -> Shipping Zones.

Use “*” to apply free shipping to the Rest of the World.

Country Code

CA, *
Free Shipping: Over Amount

Only for Discount Type –
Free Shipping

Amount starting from what free shipping will be applied with this discount code.

Decimal number

20.00

Columns for related items

In these columns you can specify additional parameters for discount code to be applied to. To give discount to particular products, variants, collections or customer groups.

Column Description / Example Value
Customer Buys: Quantity

Only for Discount Type –
Buy X Get Y

Number of items customer have to buy to receive discount.

Number

1
Customer Buys: Collections

Only for Discount Type –
Buy X Get Y

The Handles of linked Collections that customer buys to apply discount. This allows copying Discounts between shops, too.

To apply discount code to several collections use one of two approaches:

  • put Collection Handles, separated by a comma in the same row cell,
  • put each Collection Handle in its own new row, by duplicating the same Discount Code for each row.

To see the Collection Handle, you can export Collections and find Handle in the Export file. Or you can see Collection Handle as the last URL part when looking in Admin into SEO fields section.

Comma seprated handles

tshirts, best-selling
Customer Buys: Products

Only for Discount Type –
Buy X Get Y

The Handles of linked Products that customer buys to apply discount. This allows copying Discounts between shops, too.

To apply the discount code to several products use one of two approaches:

  • put Product Handles, separated by a comma in the same row cell,
  • put each Product Handle in the new row and fill in Discount Code with the same code for each row.

To see the Product Handle, you can export Products and find Handle in the Export file. Or you can see Product Handle as the last URL part when looking in Admin into SEO fields section.

Comma seprated handles

tshird-red, tshird-green
Customer Buys: Variants

Only for Discount Type –
Buy X Get Y

The Handle|SKU combination of linked Product Variants that customer buys to apply discount. This allows copying Discounts between shops, too.

To apply discount code to several Product Variants use one of two approaches:

  • put Product Handle|SKU combinations, separated by a comma in the same row cell,
  • put each Product Handle|SKU in the new row and fill in Discount Code with the same code for each row.

To find Product Handle|SKU combinations, you can export Products and take from “Handle” and “Variant SKU” column in the Export file. Or you can see it in the Admin.

To list Variant IDs, you don’t need to enter Product Handles – otherwise, it will apply the discount to the whole Product as well.

Shopify limit is 100 variants for each discount code.

Comma seprated handles|SKU combination

tshird-red|SKU-1, tshird-green|SKU-2
Customer Gets: Quantity
Only for Discount Type –
Buy X Get Y
Number of items customer will receive the discount for.

Number

1
Applies To: Collections The Handles of linked Collections that customer gets discount for. This allows copying Discounts between shops, too.

To apply the discount code to several collections use one of two approaches:

  • put Collection Handles, separated by a comma in the same row cell,
  • put each Collection Handle in its own new row, by duplicating the same Discount Code for each row.

To see the Collection Handle, you can export Collections and find Handle in the Export file. Or you can see Collection Handle as the last URL part when looking in Admin into SEO fields section.

Comma seprated handles

tshirts, best-selling
Applies To: Products The Handles of linked Products that costumer gets discount for. This allows copying Discounts between shops, too.

To apply the discount code to several products use one of two approaches:

  • put Product Handles, separated by a comma in the same row cell,
  • put each Product Handle in the new row and fill in Discount Code with the same code for each row.

To see the Product Handle, you can export Products and find Handle in the Export file. Or you can see Product Handle as the last URL part when looking in Admin into SEO fields section.

Comma seprated handles

tshird-red, tshird-green
Applies To: Variants The Handle|SKU combination of linked Product Variants that customer gets discount for. This allows copying Discounts between shops, too.

 

To apply discount code to several Product Variants use one of two approaches:

  • put Product Handle|SKU combinations, separated by a comma in the same row cell,
  • put each Product Handle|SKU in the new row and fill in Discount Code with the same code for each row.

To find Product Handle|SKU combinations, you can export Products and take from “Handle” and “Variant SKU” column in the Export file. Or you can see it in the Admin.

To list Variant IDs, you don’t need to enter Product Handles – otherwise, it will apply the discount to the whole Product as well.

Shopify limit is 100 variants for each discount code.

Comma seprated handles|SKU combination

tshird-red|SKU-1, tshird-green|SKU-2
Applies To: Customer Groups List of customer groups, which can use this discount code.

To apply the discount code to several Customer Groups use one of two approaches:

  • put Customer Groups, separated by a comma in the same row cell,
  • put each Customer Group in the new row and fill in Discount Code with the same code for each row.

You can find your customer groups in Shopify Admin, Customers section. To define a new customer group, create a new saved search.

Comma seprated names

Email Subscribers, From Latvia
Applies To: Customers Shopify generated Customer ID. If specified existing customer ID from that store, Order will be linked to that customer.

To apply the discount code to several Customers use one of two approaches:

  • put Customer IDs, separated by a comma in the same row cell,
  • put each Customer ID in the new row and fill in Discount Code with the same code for each row.

Number

1234567890

Good To Know

  • When you want to bulk update existing Discounts, you need to have either ID, or “Discount Code” column (whichever comes first), because it will search for existing Discount by this “key”.
  • To update only some columns of existing Discounts, remove those columns from the Excel file, which you don’t need to update. Then the Import will not touch them.
  • If you will have the Column with an empty value, then this field will be changed to empty.
  • When you copy Discount codes from one shop to another, if they have related Collections Products or Variants, make sure that those exist in your other store, too.