Discounts - Matrixify App

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

Fields marked as “Export Only” cannot be imported/set in Shopify but can be exported with Matrixify export.

Excel Sheet Name

Discounts

When importing a file, to tell the app that you are importing Discounts, you can set the sheet/tab name to “Discount” or “Discounts”.

For example:

If using a CSV file then the file name can be “my-shopify-discounts.csv”
If using an XLSX file then the sheet/tab name would be set to “Discounts”. The file name for the XLSX file does not matter.

Even if the sheet/tab name is not set correctly, you will be able to manually change and set the entity you are importing after uploading file in the app.

See more on the Matrixify app import process and import user interface.

Need a quick start?

Download Discounts Demo file

See Tutorials about Discounts

Export And Import Column

Basic Columns

Column Description / Example Value

Column	Description / Example Value
ID	ID is an automatically generated number by Shopify to identify the item. It is filled in by an Export. Can be used for Import to identify and update existing Discounts. When creating new Discount, leave this value empty. Allowed Values Number Example 11920047631
Title	Title of the Discount to show in Admin. This is not a discount code – it’s the name to call all the discount codes of the same kind. To set the discount code, fill the “Code” column. If the Title column is not included in the import, it will automatically be set to match the value from the Code column. Allowed Values Text Example Xmas Discount
Command	When importing a Discount – 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. `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
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. Empty value for Automatic Discounts. When importing new Discounts with “Method” set as `Code` then the “Code” column is mandatory. Allowed Values Text Example christmas-sale-AB12
Code Command	When importing Discounts with Codes, tell the app what to do with Codes listed in the “Code” column. `MERGE`: will add Codes to the existing Discount without removing other Codes from the same Discount that are not listed in the uploaded file. If Code already exists in the Discount then it will not be changed and will remain in the Discount. `REPLACE`: Will replace Discounts existing Codes with those listed in the file “Code” column – remove Codes from the Discount that are not listed in the file and add new ones. `DELETE`: Codes listed in the “Code” column will be removed from the Discount. Codes not listed in the Discount in uploaded file will not be removed or changed. If no Code Command is specified, then the app will assume it as MERGE. Allowed Values MERGE REPLACE DELETE Example MERGE
Code Used Count *Export only*	A number of times the discount code has been used in Orders. If Discount has multiple Codes in then will export each code used count. Example 6
Total Used Count *Export only*	A number of times the whole Discount has been used in Orders. Example 12
Type	Type field specifies how Discount is handled within your Shopify store. See the Shopify manual for more details about different discount types.Mandatory column to import new Discounts. Allowed Values Amount off Products Amount off Order Free Shipping Buy X Get Y Example Amount off Order
Method	The Method column indicates if the Discount is Code or Automatic. Mandatory column to import new Discounts. Allowed Values Code Automatic Example Code
Value Type	The Discounts value type. Possible values changes based on the Discounts Type. Mandatory column to import new Discounts, except “Free Shipping” Discounts. Allowed Values For “Free Shipping” Discount – empty value. For “Amount of Products” and “Amount of Order” Discounts: Percentage Fixed Amount For “Buy X Get Y” Discounts: Amount Off Each Percentage Free Example Fixed Amount
Value	Discounts value. Empty for Free Shipping Discounts. Mandatory column to import new Discounts, except “Free Shipping” Discounts. Allowed Values Decimal number Example 10.49
Minimum Requirement	The type of minimum purchase requirements set for the Discount. For Buy X Get Y Discount will represent the Customer Buys section as it is also a minimum requirement for the Discount to be applied. Mandatory column to import new Buy X Get Y Discounts and cannot be set as “None”. Allowed Values None Amount Quantity Example Amount
Minimum Value	The minimum subtotal or quantity of items that are required for the discount to be applied. Mandatory column to import new Buy X Get Y Discounts. Allowed Values If “Minimum Requirement” is set to `Amount` – decimal number. If the provided value is more than 2 decimal places then it is rounded to 2 decimal places. If “Minimum Requirement” is set to `Quantity` – whole number. If the provided value is not a whole number then it is rounded down/floored to a whole number. Example 50.99
Limit Total Times	The number of times this discount can be used. Cannot be set for Automatic Discounts. Allowed Values Number Example 2
Limit One Use Per Customer	If TRUE, then each customer will be able to use this discount code only once. Cannot be set for Automatic Discounts. Allowed Values TRUE FALSE Example TRUE
Limit Uses Per Order	Limit for the number of times the Discount can be used within an Order. Can only be set to: “Amount of Products” Type Discounts with “Fixed Amount” Value Type. In Shopify Shows as a checkbox “Once per Order”. If the Discount is limited to “Once per Order” then value will be `1` as in 1 use per Order. If it is not limited then value will be `0`. “Buy X Get Y” Type Discounts. In Shopify Admin shows as “maximum number of uses per order” field. Allowed Values Number Example 1
Status *Export only*	Discount Status – cannot be imported. When importing, use the Starts At and Ends At columns to manage if a discount is Active, Expired or Scheduled. `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. Possible Values Active Expired Scheduled Example Active
Starts At	The date and time when the discount becomes active and is available to customers. If left empty, will start as imported.If set in the future, the discount will be shown as Scheduled in Shopify. Allowed Values Date & Time Example 2018-12-17 18:20:07 +0200
Ends At	The date and time when the discount expires and is no longer available to customers. If left empty, the code will never expire. 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
Created At *Export only*	The date and time when the Discount was created in your Shopify store. Cannot be set or changed and will always be when the specific Discount was actually created in your Shopify store. Possible Values Date & Time Example 2018-12-16 18:20:07 +0200
Updated At *Export only*	The date and time when the Discount was last updated in your Shopify store. Possible Values Date & Time Example 2018-12-17 18:20:07 +0200
Summary *Export only*	A detailed explanation of what the Discount is, who can use it, when and where it applies, and any associated rules or limitations. Possible Values Text Example 100% off one-time purchase products • Minimum purchase of £50.00 • One use per customer
Row # *Export only*	Will have a row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back.
Top Row *Export only*	It will have value `TRUE` for each “top row” of the Discount. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each Discount if the Discount is exported in multiple rows, such as due to multiple codes in a discount.
Applies To: Type	The type of item the Discount applies to. In the Shopify admin, this is selection if the Discount applies to specific Products or specific Collections for “Amount of Products” and “Buy X Get Y” Discounts. Cannot be set for “Free Shipping” Discounts. For “Amount of Orders” Discounts the value is “All”. For “Buy X Get Y” Discounts cannot be set to value “All”. Allowed Values All Products Collections Example Products
Applies To: Values	Item to which the Discount applies. If the “Applies To: Type” is set to “Products” then: to apply the whole product (all variants), the values will be Product handles. to apply Discount to individual variants in a Product, the values will be “handle\|variant SKU” combinations, with Product Handle and Variant SKU separated by a pipe. If the “Applies To: Type” is set to “Collections” then values will be the collection Handles. The Products, Variants or Collections to which the Discount applies to, must exist in the store, otherwise, error for the Discount will be returned when importing. Allowed Values Comma-separated handles for whole Products and Collections. “Handle\|SKU” combinations for individual variants. Example tshird-red, tshird-green tshirt-summer\|SKU1234

ID is an automatically generated number by Shopify to identify the item.
It is filled in by an Export.
Can be used for Import to identify and update existing Discounts.
When creating new Discount, leave this value empty.

Allowed Values

Number

Example

11920047631

Title

Title of the Discount to show in Admin.

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

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

If the Title column is not included in the import, it will automatically be set to match the value from the Code column.

Allowed Values

Text

Example

Xmas Discount

Command

When importing a Discount – 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.
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

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.

Empty value for Automatic Discounts.

When importing new Discounts with “Method” set as Code then the “Code” column is mandatory.

Allowed Values

Text

Example

christmas-sale-AB12

Code Command

When importing Discounts with Codes, tell the app what to do with Codes listed in the “Code” column.

MERGE: will add Codes to the existing Discount without removing other Codes from the same Discount that are not listed in the uploaded file. If Code already exists in the Discount then it will not be changed and will remain in the Discount.
REPLACE: Will replace Discounts existing Codes with those listed in the file “Code” column – remove Codes from the Discount that are not listed in the file and add new ones.
DELETE: Codes listed in the “Code” column will be removed from the Discount. Codes not listed in the Discount in uploaded file will not be removed or changed.

If no Code Command is specified, then the app will assume it as MERGE.

Allowed Values

MERGE
REPLACE
DELETE

Example

MERGE

Code Used Count

Export only

A number of times the discount code has been used in Orders.

If Discount has multiple Codes in then will export each code used count.

Example

Total Used Count

Export only

A number of times the whole Discount has been used in Orders.

Example

Type

Type field specifies how Discount is handled within your Shopify store.
See the Shopify manual for more details about different discount types.Mandatory column to import new Discounts.

Allowed Values

Amount off Products
Amount off Order
Free Shipping
Buy X Get Y

Example

Amount off Order

Method

The Method column indicates if the Discount is Code or Automatic.

Mandatory column to import new Discounts.

Allowed Values

Code
Automatic

Example

Code

Value Type

The Discounts value type. Possible values changes based on the Discounts Type.

Mandatory column to import new Discounts, except “Free Shipping” Discounts.

Allowed Values

For “Free Shipping” Discount – empty value.

For “Amount of Products” and “Amount of Order” Discounts:

Percentage
Fixed Amount

For “Buy X Get Y” Discounts:

Amount Off Each
Percentage
Free

Example

Fixed Amount

Value

Discounts value. Empty for Free Shipping Discounts.

Mandatory column to import new Discounts, except “Free Shipping” Discounts.

Allowed Values

Decimal number

Example

10.49

Minimum Requirement

The type of minimum purchase requirements set for the Discount.

For Buy X Get Y Discount will represent the Customer Buys section as it is also a minimum requirement for the Discount to be applied.

Mandatory column to import new Buy X Get Y Discounts and cannot be set as “None”.

Allowed Values

None
Amount
Quantity

Example

Amount

Minimum Value

The minimum subtotal or quantity of items that are required for the discount to be applied.

Mandatory column to import new Buy X Get Y Discounts.

Allowed Values

If “Minimum Requirement” is set to Amount – decimal number.
If the provided value is more than 2 decimal places then it is rounded to 2 decimal places.

If “Minimum Requirement” is set to Quantity – whole number.
If the provided value is not a whole number then it is rounded down/floored to a whole number.

Example

50.99

Limit Total Times

The number of times this discount can be used.

Cannot be set for Automatic Discounts.

Allowed Values

Number

Example

Limit One Use Per Customer

If TRUE, then each customer will be able to use this discount code only once.

Cannot be set for Automatic Discounts.

Allowed Values

TRUE
FALSE

Example

TRUE

Limit Uses Per Order

Limit for the number of times the Discount can be used within an Order.

Can only be set to:

“Amount of Products” Type Discounts with “Fixed Amount” Value Type. In Shopify Shows as a checkbox “Once per Order”. If the Discount is limited to “Once per Order” then value will be 1 as in 1 use per Order. If it is not limited then value will be 0.
“Buy X Get Y” Type Discounts. In Shopify Admin shows as “maximum number of uses per order” field.

Allowed Values

Number

Example

Status

Export only

Discount Status – cannot be imported.
When importing, use the Starts At and Ends At columns to manage if a discount is Active, Expired or Scheduled.

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.

Possible Values

Active
Expired
Scheduled

Example

Active

Starts At

The date and time when the discount becomes active and is available to customers.
If left empty, will start as imported.If set in the future, the discount will be shown as Scheduled in Shopify.

Allowed Values

Date & Time

Example

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

Ends At

The date and time when the discount expires and is no longer available to customers.

If left empty, the code will never expire.

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

Created At

Export only

The date and time when the Discount was created in your Shopify store.

Cannot be set or changed and will always be when the specific Discount was actually created in your Shopify store.

Possible Values

Date & Time

Example

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

Updated At

Export only

The date and time when the Discount was last updated in your Shopify store.

Possible Values

Date & Time

Example

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

Summary

Export only

A detailed explanation of what the Discount is, who can use it, when and where it applies, and any associated rules or limitations.

Possible Values

Text

Example

100% off one-time purchase products • Minimum purchase of £50.00 • One use per customer

Row #

Export only

Will have a row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back.

Top Row

Export only

It will have value TRUE for each “top row” of the Discount. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each Discount if the Discount is exported in multiple rows, such as due to multiple codes in a discount.

Applies To: Type

The type of item the Discount applies to.

In the Shopify admin, this is selection if the Discount applies to specific Products or specific Collections for “Amount of Products” and “Buy X Get Y” Discounts.

Cannot be set for “Free Shipping” Discounts.

For “Amount of Orders” Discounts the value is “All”.

For “Buy X Get Y” Discounts cannot be set to value “All”.

Allowed Values

All
Products
Collections

Example

Products

Applies To: Values

Item to which the Discount applies.

If the “Applies To: Type” is set to “Products” then:

to apply the whole product (all variants), the values will be Product handles.
to apply Discount to individual variants in a Product, the values will be “handle|variant SKU” combinations, with Product Handle and Variant SKU separated by a pipe.

If the “Applies To: Type” is set to “Collections” then values will be the collection Handles.

The Products, Variants or Collections to which the Discount applies to, must exist in the store, otherwise, error for the Discount will be returned when importing.

Allowed Values

Comma-separated handles for whole Products and Collections.
“Handle|SKU” combinations for individual variants.

Example

tshird-red, tshird-green

tshirt-summer|SKU1234

Type-Specific

Column	Description / Example Value
Buy X Get Y: Customer Buys Type	The type of item customers must purchase for the Discount to apply. In the Shopify admin, this selection is under “customer gets” to select the Discount to apply to specific Products or specific Collections. Allowed Values Products Collections Example Products
Buy X Get Y: Customer Buys Values	Item to which Customer must purchase for the Discount to be applied. If the Discount is set to apply to specific Products then: values will be Product handles, if Discount applies to the whole product (all variants). values will be product “handle\|variant SKU” combinations of variants to which the Discount applies to. If the Discount is set to apply to specific Collections then values will be the collection Handles. The Products, Variants or Collections to which the Discount applies to, must exist in the store, otherwise, error for the Discount will be returned when importing. Allowed Values Comma separated handles Example tshird-blue, tshird-yellow
Buy X Get Y: Customer Gets Quantity	Number of items customer will receive the discount for. Allowed Values Number Example 1
Free Shipping: Country Codes	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. Allowed Values Country Code Example CA,
Free Shipping: Over Amount	Amount starting from what free shipping will be applied with this discount code. Allowed Values Decimal number Example 20.00

Eligibility

Column Description / Example Value

Column	Description / Example Value
Eligibility: Customer Type	The type of Customer eligibility set for the Discount – either Discount applies to all customers, specific customer segments, or specific customers. Allowed Values All Segments Customers Example Products
Eligibility: Customer Values	Customers or Customer Segments which are eligible for the Discount. If “Eligibility: Customer Type” is set to `Segments` then in this field you will see the Customer Segment names. If “Eligibility: Customer Type” is set to `Customers` then in this field you will see the Customer Emails. When importing, the Customers or Customer Segments set must exist in the Shopify store. Allowed Values Text Example [email protected]

Eligibility: Customer Type

The type of Customer eligibility set for the Discount – either Discount applies to all customers, specific customer segments, or specific customers.

Allowed Values

All
Segments
Customers

Example

Products

Eligibility: Customer Values

Customers or Customer Segments which are eligible for the Discount.

If “Eligibility: Customer Type” is set to Segments then in this field you will see the Customer Segment names.
If “Eligibility: Customer Type” is set to Customers then in this field you will see the Customer Emails.

When importing, the Customers or Customer Segments set must exist in the Shopify store.

Allowed Values

Text

Example

[email protected]

Column Description / Example Value

Column	Description / Example Value
Purchase Type	Shopify Discount attribute “Purchase Type”. Allows to manage if Discount applies to one-time purchase items, subscription items, or both.Purchase Type cannot be set or changed for Buy X Get Y discounts. In Shopify, Buy X Get Y discounts only can be applied to One-Time Purchases.To set Purchase Type to apply to Subscriptions or Both, the store must have a subscription plan enabled by using any of the available Shopify subscription apps. Allowed Values One-Time Purchase Subscription Both Example One-Time Purchase
Purchase Type: Recurring Subscription Limit	Shopify Discount attribute “Recurring payments for subscriptions”. Can be set/managed only if the Purchase Type is `Subscription` or `Both`.In Shopify admin, this field is managed by selecting one of the below options which in the spreadsheet file are managed via a numeric value: “Limit discount to the first payment” – value “1” “Limit discount to multiple recurring payments” – value should be whole number greater than 1, indicating how many recurring payments the Discount applies to. “Discount applies to all recurring payments” – empty value. If the Discounts Purchase Type is One-Time Purchase then the Recurring Subscription Limit is exported as value “1” and ignored when importing. Allowed Values Number <empty> Example 1

Purchase Type

Shopify Discount attribute “Purchase Type”.
Allows to manage if Discount applies to one-time purchase items, subscription items, or both.Purchase Type cannot be set or changed for Buy X Get Y discounts. In Shopify, Buy X Get Y discounts only can be applied to One-Time Purchases.To set Purchase Type to apply to Subscriptions or Both, the store must have a subscription plan enabled by using any of the available Shopify subscription apps.

Allowed Values

One-Time Purchase
Subscription
Both

Example

One-Time Purchase

Purchase Type: Recurring Subscription Limit

Shopify Discount attribute “Recurring payments for subscriptions”.
Can be set/managed only if the Purchase Type is Subscription or Both.In Shopify admin, this field is managed by selecting one of the below options which in the spreadsheet file are managed via a numeric value:

“Limit discount to the first payment” – value “1”
“Limit discount to multiple recurring payments” – value should be whole number greater than 1, indicating how many recurring payments the Discount applies to.
“Discount applies to all recurring payments” – empty value.

If the Discounts Purchase Type is One-Time Purchase then the Recurring Subscription Limit is exported as value “1” and ignored when importing.

Allowed Values

Number
<empty>

Example

Combinations

Column	Description / Example Value
Combines with Product Discounts	Determines if the Discount can be combined with Product discounts. Allowed Values TRUE FALSE Example TRUE
Combines with Order Discounts	Determines if the Discount can be combined with Orders discounts. Allowed Values TRUE FALSE Example TRUE
Combines with Shipping Discounts	Determines if the Discount can be combined with Free Shipping discounts. Attribute does not exist for Free Shipping discounts as you cannot combine Free Shipping discounts with other Free Shipping discounts. Allowed Values TRUE FALSE Example TRUE

Column

Description / Example Value

Combines with Product Discounts

Determines if the Discount can be combined with Product discounts.

Allowed Values

TRUE
FALSE

Example

TRUE

Combines with Order Discounts

Determines if the Discount can be combined with Orders discounts.

Allowed Values

TRUE
FALSE

Example

TRUE

Combines with Shipping Discounts

Determines if the Discount can be combined with Free Shipping discounts.
Attribute does not exist for Free Shipping discounts as you cannot combine Free Shipping discounts with other Free Shipping discounts.

Allowed Values

TRUE
FALSE

Example

TRUE

Shareable Links

Discount URLs that can be used to share the Discount.

Can only be Exported and are always generated automatically by Shopify.

Column	Description / Example Value
Shareable Link: Target *Export only*	The type of page that’s associated with the URL. Possible Values HOME COLLECTION PRODUCT Example COLLECTION
Shareable Link: Title *Export only*	The title of the page that’s associated with the URL. Example Summer Collection
Shareable Link: URL *Export only*	The Discounts URL that can be used to share the Discount. Example https://testing-store.myshopify.com/discount/ctc-004
Shareable Link: Image URL *Export only*	The image URL of the item (product or collection) to which the discount applies. Example https://cdn.shopify.com/s/files/1/2244/9876/1234/files/red_shirt_123.jpg?v=1612358112

Column

Description / Example Value

Shareable Link: Target

Export only

The type of page that’s associated with the URL.

Possible Values

HOME
COLLECTION
PRODUCT

Example

COLLECTION

Shareable Link: Title

Export only

The title of the page that’s associated with the URL.

Example

Summer Collection

Shareable Link: URL

Export only

The Discounts URL that can be used to share the Discount.

Example

https://testing-store.myshopify.com/discount/ctc-004

Shareable Link: Image URL

Export only

The image URL of the item (product or collection) to which the discount applies.

Example

https://cdn.shopify.com/s/files/1/2244/9876/1234/files/red_shirt_123.jpg?v=1612358112

Export Filters

In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.

Note: total displayed item count and estimated time won’t be affected by the filters applied.

Filter	Description
ID	Filters Discounts that have specific Shopify IDs. Possible Conditions equals to any of not equal to any of Example 87123461124,1234897263,98273493214
Title	Put the comma-separated list of all the Discount Titles which you want to filter by. Possible Conditions equals to any of contains any of matches Pattern contains none of Example X-Mas2019, Black Friday Discount
Status	Allows to export filters by their Status. Possible Conditions Active Scheduled Expired
Method	Filter Discounts by their application Method to export only either Code or Automatic Discounts. Possible Conditions Code Automatic
Starts At	Allows exporting Discounts by their Starts At field. 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
Ends At	Allows exporting Discounts by their Ends At field. 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
Created At	Allows exporting Discounts by the Created At date – created date in the Shopify within a specific date range. Relative date condition allows you to export Discounts that have been created in the last full amount of time. 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
Updated At	Allows exporting Discounts by their Updated At attribute – last updated date in the Shopify within a specific date range. Relative date condition allows you to export Discounts that have been updated in the last full amount of time. 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
Total Used Count	Filter Discounts export by each Discounts Total Used Count. Possible Conditions equals less than less than or equal to greater than greater than or equal to between

Legacy columns

On February 20, 2025, the Matrixify app Discounts sheet export and import functionality was updated to use Shopify GraphQL.
We used the chance to also significantly improve the Discounts template format to be able to store all the newly available fields, and make it more understandable, user-friendly and more similar to the Admin UI field structures.

The following columns were removed from the Export setup and mapped to various other new columns and fields.
In Matrixify app Imports they will continue to work and will be recognized. You can see them in the Import UI marked as “Legacy”.

Legacy Column	Description / Mapped Columns
Used Count	Legacy Export-only column. Equivalent new template column: Code Used Count – same value as in legacy column.
Discount Type	Legacy column. Previously used for the following Discount types: “Percentage”, “Fixed Amount”, “Free Shipping” and “Buy X Get Y”. Equivalent new template columns: Type – used for the actual Discount Types: “Amount of Products”, “Amount of Orders”, “Free Shipping” and “Buy X Get Y”. Value Type – used for the Discount value types, such as “Percentage”, “Fixed Amount”, and others.
Discount Value	Legacy column. Change – the value in this column was previously exported as a negative decimal number. Equivalent new template column: Value – when exported, will export as positive value.
Discount Value Type	Legacy column. This column was used only in Buy X Get Y Discounts for possible values “Percentage”, “Amount Off Each” and “Free”. Equivalent new template column: Value Type – will be exported with the same possible values for Buy X Get Y discount – “Percentage”, “Amount Off Each” and “Free”.
Minimum Purchase Amount	Legacy column. Grouped functionally for legacy columns: “Minimum Purchase Amount, “Minimum Quantity Of Items” and “Customer Buys: Quantity” as they cannot all be set at the same time. Equivalent new template columns: Minimum Requirement – if the minimum purchase requirement is set to amount then the value will be “Amount”. Minimum Value – the minimum purchase requirement amount value.
Limit Once Per Order	Legacy column. The legacy column was used only in Amount of Products Fixed Amount discounts. Equivalent new template column: Limit Uses Per Order – The Legacy columns value “FALSE” will translate to new columns value “0” as in not limiting uses per Order. If the Legacy columns value was “TRUE”, it would now translate to value “1”, as in limiting to one use per order.
Max Uses Per Order	Legacy column. The legacy column was used only in Buy X Get Y discounts. Equivalent new template column: Limit Uses Per Order – same value as in the legacy column.
Minimum Quantity Of Items	Legacy column. Grouped functionally for legacy columns: “Minimum Purchase Amount, “Minimum Quantity Of Items” and “Customer Buys: Quantity” as they cannot all be set at the same time. Equivalent new template columns: Minimum Requirement – if the minimum purchase requirement is set to quantity of items then the value will be “Quantity”. Minimum Value – the minimum purchase requirement quantity.
Customer Buys: Quantity	Legacy column. Grouped functionally for legacy columns: “Minimum Purchase Amount, “Minimum Quantity Of Items” and “Customer Buys: Quantity” as they cannot all be set at the same time. The legacy column was only used in Buy X Get Y Discounts. Equivalent new template columns: Minimum Requirement – if the customer buys is set to the quantity of items will export as “Quantity”, if set to purchase amount will export as “Amount”. Minimum Value – the customer buys quantity or amount value.
Customer Buys: Collections	Legacy column. Grouped functionally for legacy columns: “Customer Buys: Collections”, “Customer Buys: Products” and “Customer Buys: Variants” as they cannot all be set at the same time. Equivalent new template columns: Buy X Get Y: Customer Buys Type – If the Customer Buys for Buy X Get Y Discount is set to specific Collections then exported as “Collections”. Buy X Get Y: Customer Buys Values – same value as in the legacy column.
Customer Buys: Products	Legacy column. Grouped functionally for legacy columns: “Customer Buys: Collections”, “Customer Buys: Products” and “Customer Buys: Variants” as they cannot all be set at the same time. Equivalent new template columns: Buy X Get Y: Customer Buys Type – If the Customer Buys for Buy X Get Y Discount is set to specific Products then exported as “Products”. Buy X Get Y: Customer Buys Values – same value as in the legacy column.
Customer Buys: Variants	Legacy column. Grouped functionally for legacy columns: “Customer Buys: Collections”, “Customer Buys: Products” and “Customer Buys: Variants” as they cannot all be set at the same time. Equivalent new template columns: Buy X Get Y: Customer Buys Type – If the Customer Buys for Buy X Get Y Discount is set to specific Products then exported as “Products”. Buy X Get Y: Customer Buys Values – same value as in the legacy column.
Customer Gets: Quantity	Legacy column. Equivalent new template column: Buy X Get Y: Customer Gets Quantity – same value as in the legacy column.
Applies To: Collections	Legacy column. Grouped functionally for legacy columns: “Applies To: Collections”, “Applies To: Products” and “Applies To: Variants” as they cannot all be set at the same time. Equivalent new template columns: Applies To: Type – if the Discount is set to apply to specific Collections then exported as “Collections”. Applies To: Values – same value as in the legacy column.
Applies To: Products	Legacy column. Grouped functionally for legacy columns: “Applies To: Collections”, “Applies To: Products” and “Applies To: Variants” as they cannot all be set at the same time. Equivalent new template columns: Applies To: Type – if the Discount is set to apply to specific Products then exported as “Products”. Applies To: Values – same value as in the legacy column.
Applies To: Variants	Legacy column. Grouped functionally for legacy columns: “Applies To: Collections”, “Applies To: Products” and “Applies To: Variants” as they cannot all be set at the same time. Equivalent new template columns: Applies To: Type – if the Discount is set to apply to specific Products then exported as “Products”. Applies To: Values – same value as in the legacy column.
Applies To: Customer Groups	Legacy column. Grouped functionally for legacy columns: “Applies To: Customer Groups”, “Applies To: Customers” and “Applies To: Customers Email” as they cannot all be set at the same time. Equivalent new template columns: Eligibility: Customer Type – if the Discounts Eligibility is set to “Specific customer segments” then exported as “Segments”. Eligibility: Customer Values – same value as in the legacy column.
Applies To: Customers	Legacy column. Grouped functionally for legacy columns: “Applies To: Customer Groups”, “Applies To: Customers” and “Applies To: Customers Email” as they cannot all be set at the same time. Equivalent new template columns: Eligibility: Customer Type – if the Discounts Eligibility is set to “Specific customers” then exported as “Customers”. Eligibility: Customer Values – exported as Customer Emails.
Applies To: Customers Email	Legacy column. Grouped functionally for legacy columns: “Applies To: Customer Groups”, “Applies To: Customers” and “Applies To: Customers Email” as they cannot all be set at the same time. Equivalent new template columns: Eligibility: Customer Type – if the Discounts Eligibility is set to “Specific customers” then exported as “Customers”. Eligibility: Customer Values – same value as in the legacy column.

Good To Know

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 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.