Discounts

Allowed Values

Number

Example

11920047631

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.

Allowed Values

Text

Example

Xmas Discount

• 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.
• MERGE: will try to find the existing Discount, and update it with data from the row. If such a Discount will not be found, then it will create new.
• UPDATE: the app will search for an existing Discount and update it. If a discount cannot be found then it will fail to import.
• REPLACE: WARNING! Use this Command value to fully replace the whole discount, not individual fields. Using this Command value, the app will delete the discount from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file.
  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.
• IGNORE: the app will ignore this Discount and will skip it.

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

Allowed Values

NEW
MERGE
UPDATE
REPLACE
DELETE
IGNORE

Example

MERGE

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.

Allowed Values

Number

Example

christmas-sale-AB12

Export only

Example

6

Allowed Values

Percentage
Fixed Amount
Free Shipping
Buy X Get Y

Example

Percentage

The number should be negative.

Allowed Values

Example

-50.50

Only for Discount Type –
Buy X Get Y

In Buy X Get Y discounts you can specify what discount the customer gets for specific items. This can be a Percentage off items, the exact Amount Off Each item or if the customer gets Free items.

Works together with Discount Value column

The discounted value is set with the “Discount Value” column if the “Discount Value Type” is Percentage or Amount Off Each.

If the “Discount Value Type” is set to Free then the app will ignore the value provided in the “Discount Value” column as the item is free and does not have a specific discount value.

Default values when importing

If the “Discount Value Type” is imported as empty or the column is not in the file then:

• If creating new Discounts the app will assume it as Percentage.
• If updating existing Discounts, the app will use the existing Discount Value Type.

“Discount Value Type” will be ignored for Discounts that are not Buy X Get Y.

Allowed Values

Percentage
Amount Off Each
Free

Example

Amount Off Each

Allowed Values

Decimal number

Example

20.50

Allowed Values

Number

Example

2

Allowed Values

TRUE
FALSE

Example

TRUE

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

Allowed Values

TRUE
FALSE

Example

TRUE

The default is unlimited.

Allowed Values

Number

Example

5

Allowed Values

Number

Example

10

Export only

• Active – Starts At in the past and Ends at not set or in the future.
• Expired – Ends At in the past.
• Scheduled – Starts At in the future.

Export can be filtered by Status.

Allowed Values

Active
Expired
Scheduled

Example

Active

If set in the future then discount will be show as Scheduled in Shopify.

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Must be date and time after Starts At.

If set in the past then the discount will show as Expired in Shopify.

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Export only

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Only for Discount Type –
Free Shipping

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.

Allowed Values

Country Code

Example

CA, *

Only for Discount Type –
Free Shipping

Allowed Values

Decimal number

Example

20.00

Only for Discount Type –
Buy X Get Y

Allowed Values

Number

Example

1

Only for Discount Type –
Buy X Get Y

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.

Allowed Values

Comma seprated handles

Example

tshirts, best-selling

Only for Discount Type –
Buy X Get Y

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.

Allowed Values

Comma seprated handles

Example

tshird-red, tshird-green

Only for Discount Type –
Buy X Get Y

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.

Allowed Values

Comma seprated handles|SKU combination

Example

tshird-red|SKU-1, tshird-green|SKU-2

Allowed Values

Number

Example

1

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.

Allowed Values

Comma seprated handles

Example

tshirts, best-selling

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.

Allowed Values

Comma seprated handles

Example

tshird-red, tshird-green

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.

You can also list Variant IDs in this field.

Shopify limit is 100 variants for each discount code.

Allowed Values

Comma seprated handles|SKU combination

Example

tshird-red|SKU-1, tshird-green|SKU-2, 231598723511

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.

Allowed Values

Comma seprated names

Example

Email Subscribers, From Latvia

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.

Allowed Values

Number

Example

1234567890

Allowed Values

Text

Example

[email protected]

Possible Conditions

• equals to any of
• not equal to any of

Example

87123461124,1234897263,98273493214

Possible Conditions

• equals to any of
• contains any of
• matches Pattern
• contains none of

Example

X-Mas2019, Black Friday Discount

Possible Conditions

• Active
• Scheduled
• Expired

Relative date condition allows you to export Discounts that have Starts At the last full amount of time.
For example – Last 1 Days, would export Discounts with Starts At from last full day, so yesterday.

Possible Conditions

• on or after
• on or before
• date range
• relative date

Relative date condition allows you to export Discounts that have Ends At in the last full amount of time.
For example – Last 1 Days, would export Discounts with Ends At from last full day, so yesterday.

Possible Conditions

• on or after
• on or before
• date range
• relative date

For example – Last 1 Days, would export Discounts from last full day, so yesterday.

Possible Conditions

• on or after
• on or before
• date range
• relative date

For example – Last 1 Days, would export Discounts from last full day, so yesterday.

Possible Conditions

• on or after
• on or before
• date range
• relative date