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
To tell the app that you are importing Discounts you need:
- If using CSV file then the file name needs to contain the word “discount”, for example, “my-shopify-discounts.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “discount”. The file name for the XLSX file does not matter.
Need a quick start?
Columns Available For Export And Import
Base Columns
Column | Description / Example Value |
---|---|
ID | ID is 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 ValuesNumber Example11920047631 |
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. Allowed ValuesText ExampleXmas Discount |
Command | When importing Discount row – tell the app, what to do with it:
If no Command is specified, then the app will assume the UPDATE command. Allowed ValuesNEW MERGE UPDATE REPLACE DELETE IGNORE ExampleMERGE |
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. Allowed ValuesNumber Examplechristmas-sale-AB12 |
Used Count
Export only |
Number of times the discount code has been redeemed.
Example6 |
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.
Allowed ValuesPercentage Fixed Amount Free Shipping Buy X Get Y ExamplePercentage |
Discount Value | Here you provide the percentage amount for the Percentage discount or just amount for Fixed amount.
The number should be negative. Allowed ValuesNegative decimal number
Example-50.50 |
Minimum Purchase Amount | Minimum purchase amount for discount to be applied. Orders below the minimum purchase amount will not have discount.
Allowed ValuesDecimal number Example20.50 |
Limit Total Times | Number of times this discount can be used.
Allowed ValuesNumber Example2 |
Limit One Use Per Customer | If TRUE, then each customer will be able to use this discount code only once.
Allowed ValuesTRUE FALSE ExampleTRUE |
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. Allowed ValuesTRUE FALSE ExampleTRUE |
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. Allowed ValuesNumber Example5 |
Minimum Quantity 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. Allowed ValuesNumber Example10 |
Status
Export only |
Discount Status cannot be imported. When importing use Starts At and Ends At columns to manage if a discount is Active, Expired or Scheduled.
Export can be filtered by Status. Allowed ValuesActive Expired Scheduled ExampleActive |
Starts At | Date and time, from what the discount can be used. If left empty, will start now.
If set in the future then discount will be show as Scheduled in Shopify. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Ends At | Date and time, till what the discount can be used. 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 Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Updated At
Export only |
It will be automatically updated, whenever you change the Discount data.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
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 – |
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 ValuesCountry Code ExampleCA, * |
Free Shipping: Over Amount
Only for Discount Type – |
Amount starting from what free shipping will be applied with this discount code.
Allowed ValuesDecimal number Example20.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 – |
Number of items customer have to buy to receive discount.
Allowed ValuesNumber Example1 |
Customer Buys: Collections
Only for Discount Type – |
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:
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 ValuesComma seprated handles Exampletshirts, best-selling |
Customer Buys: Products
Only for Discount Type – |
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:
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 ValuesComma seprated handles Exampletshird-red, tshird-green |
Customer Buys: Variants
Only for Discount Type – |
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:
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 ValuesComma seprated handles|SKU combination Exampletshird-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.
Allowed ValuesNumber Example1 |
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:
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 ValuesComma seprated handles Exampletshirts, 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:
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 ValuesComma seprated handles Exampletshird-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:
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 ValuesComma seprated handles|SKU combination Exampletshird-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:
You can find your customer groups in Shopify Admin, Customers section. To define a new customer group, create a new saved search. Allowed ValuesComma seprated names ExampleEmail Subscribers, From Latvia |
Applies To: Customers | Shopify generated Customer ID. If specified existing customer ID from that store, Discount will be linked to that customer.
To apply the discount code to several Customers use one of two approaches:
Allowed ValuesNumber Example1234567890 |
Applies To: Customers Email | Email for the customer linked to the Discount. Can be exported and import to link customer to the Discount.Exports one row per Customer linked to the Order. Can be imported as multiple customers in the same cell, separated by a comma. Allowed ValuesText Example[email protected] |
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 |
---|---|
Title | Put the comma-separated list of all the Discount Title which you want to filter by.
Possible Conditions
ExampleX-Mas2019, Black Friday Discount |
Status | Allows to export filters by their Status.
Possible Conditions
|
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. Possible Conditions
|
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. Possible Conditions
|
Created At | Allows exporting Discounts which were created 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
|
Updated At | Allows exporting Discounts which were last updated 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
|
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.