Discounts are promotional tools that allow customers to receive reductions on their purchases. You can create different types of discounts including amount off products, amount off orders, free shipping, and buy-X-get-Y discounts.
Sample File
Download a sample spreadsheet showing how to import discount codes.
Discount Fields
These are all the fields you can import or export for discounts in Altera. Fields are grouped by category for easier reference.
General
Basic discount information and settings.
Field | Description | Example Value |
ID | Shopify's unique discount identifier | 3456789012 |
Title | Name of the discount | Summer Sale |
Command | Action to perform on this discount row | MERGE |
Code | Discount code that customers use at checkout | SUMMER2024 |
Code Command | Action to perform on discount codes | MERGE |
Code Used Count | Number of times the discount code has been used | 89 |
Total Used Count | Total number of times the discount has been used | 156 |
Type | Type of discount | Amount off Order |
Method | Whether discount is code-based or automatic | Code |
Value Type | How the discount value is calculated | Percentage |
Value | Discount amount or percentage | 20 |
Minimum Requirement | Type of minimum purchase requirement | Amount |
Minimum Value | Minimum subtotal or quantity required | 75.00 |
Limit Total Times | Maximum number of times discount can be used | 250 |
Limit One Use Per Customer | Whether each customer can use discount only once | true |
Limit Uses Per Order | Maximum number of uses per single order | 1 |
Status | Current status of the discount | Active |
Starts At | Date and time when discount becomes active | 2024-06-01T00:00:00Z |
Ends At | Date and time when discount expires | 2024-08-31T23:59:59Z |
Created At | Date and time when discount was created | 2024-05-15T14:20:00Z |
Updated At | Date and time when discount was last modified | 2024-07-10T09:45:00Z |
Summary | Detailed description of the discount rules | 20% off orders over $75 |
Row # | Row number in the spreadsheet | 1 |
Top Row | Whether this is the first row for this discount | true |
Applies To: Type | What the discount applies to | All |
Applies To: Values | Specific products/collections the discount applies to | wireless-earbuds,electronics-sale |
Type-Specific
Fields specific to different discount types.
Field | Description | Example Value |
Buy X Get Y: Customer Buys Type | What customers must buy to get the discount | Products |
Buy X Get Y: Customer Buys Values | Specific items customers must buy | laptop-stand,phone-case |
Buy X Get Y: Customer Gets Quantity | Quantity of items customers get for free/discount | 2 |
Free Shipping: Country Codes | Countries where free shipping applies | US,CA,AU |
Free Shipping: Over Amount | Minimum order amount for free shipping | 125.00 |
Eligibility
Fields that determine who can use the discount.
Field | Description | Example Value |
Eligibility: Customer Type | Type of customer eligibility rule | Specific Customers |
Eligibility: Customer Values | Specific customers or groups who can use | vip-members,premium-tier |
Purchase Type
Fields related to purchase type restrictions.
Field | Description | Example Value |
Purchase Type | Type of purchase the discount applies to | Subscription |
Purchase Type: Recurring Subscription Limit | Number of billing cycles discount applies to | 6 |
Combinations
Fields that control how this discount combines with others.
Field | Description | Example Value |
Combines with Product Discounts | Whether discount can combine with product discounts | true |
Combines with Order Discounts | Whether discount can combine with order discounts | false |
Combines with Shipping Discounts | Whether discount can combine with shipping discounts | true |
Shareable Links
Fields for creating shareable discount links.
Field | Description | Example Value |
Shareable Link: Target | What the shareable link targets | Product |
Shareable Link: Title | Title for the shareable link | Exclusive Summer Offer |
Shareable Link: URL | URL for the shareable link | |
Shareable Link: Image URL | Image URL for the shareable link |
Field Details
Title
The name of the discount. This field is required unless there's a unique code present that can identify the discount.
Starts At
The date and time when the discount becomes active. If left blank, the current time will be used, meaning the discount will be published immediately.
Command
Controls what action to perform when importing a discount:
NEW
: Create a new discount (fails if discount already exists)MERGE
: Update existing discount or create new if not found (default)UPDATE
: Update existing discount (fails if not found)REPLACE
: Delete existing discount and create new oneDELETE
: Delete the existing discountIGNORE
: Skip this discount row
Code Command
Controls what action to perform on discount codes when importing:
MERGE
: Add codes without removing existing ones (default)REPLACE
: Replace all existing codes with those in the fileDELETE
: Remove codes listed in the file
Applies To: Values
Specifies which products or collections the discount applies to:
For whole products: Use product handles (e.g.,
wireless-headphones,gaming-mouse
)For specific variants: Use
handle|SKU
format (e.g.,laptop-backpack|WH4567
)For collections: Use collection handles
Buy X Get Y: Customer Buys Values
Specifies what customers must purchase:
For whole products: Use product handles
For specific variants: Use
handle|SKU
formatFor collections: Use collection handles
Free Shipping: Country Codes
Country codes where free shipping applies:
Use 2-letter country codes (e.g.,
US,CA,AU
)Use
*
for "Rest of the World"Countries must be added to at least one shipping zone
Limit Uses Per Order
Controls how many times a discount can be used per order:
For "Amount off Products" with "Fixed Amount":
1
= once per order,0
= unlimitedFor "Buy X Get Y" discounts: Sets maximum uses per order
Purchase Type: Recurring Subscription Limit
Controls how many billing cycles the discount applies to:
1
: First payment onlyNumber > 1: Specific number of recurring payments
Empty: All recurring payments
Eligibility: Customer Values
Specifies who can use the discount:
If Customer Type is "Segments": Customer segment names
If Customer Type is "Customers": Customer email addresses
Discount Types
Altera supports the following discount types:
Amount off Products
Provides a fixed amount or percentage discount on specific products or collections.
Value Types:
Percentage
: Discount as a percentage (e.g., 25% off)Fixed Amount
: Discount as a fixed amount (e.g., $20 off)
Amount off Order
Provides a discount on the entire order total.
Value Types:
Percentage
: Discount as a percentage of order totalFixed Amount
: Fixed amount off the order total
Free Shipping
Provides free shipping to customers.
Value Types:
No value type required for free shipping discounts
Buy X Get Y
Customers must purchase specific items to receive other items at a discount or for free.
Value Types:
Amount Off Each
: Fixed amount off each qualifying itemPercentage
: Percentage off each qualifying itemFree
: Qualifying items are free
Discount Methods
Discounts can be applied using two methods:
Code: Customers must enter a discount code at checkout
Automatic: Discount is automatically applied when conditions are met
Minimum Requirements
Discounts can have minimum purchase requirements:
None: No minimum requirement
Amount: Minimum order subtotal required
Quantity: Minimum quantity of items required
Discount Status
Discounts have different statuses based on their timing:
Active: Currently available for use
Scheduled: Will become active in the future
Expired: No longer available for use
Discount Filters
You can use these filters to limit which discounts are exported:
id
: Filter by specific discount IDstitle
: Filter by discount titlecode
: Filter by discount codestatus
: Filter by discount status (active, scheduled, expired)type
: Filter by discount typemethod
: Filter by discount method (code, automatic)created_at
: Filter by creation dateupdated_at
: Filter by last update datestarts_at
: Filter by start dateends_at
: Filter by end datetotal_used_count
: Filter by total usage countusage_limit
: Filter by usage limitapplies_once_per_customer
: Filter by one-use-per-customer setting