Review Shopify discounts in a spreadsheet

A Discounts worksheet gives you one row for each Shopify discount campaign or automatic promotion. It is useful for reviewing active and scheduled promotions, comparing discount rules, and exporting your discount catalog.

The standard discount fields are read-only in Mixtable. You can view and export them, but you cannot change a discount’s value, dates, limits, status, or combination rules from the worksheet. Discount metafields can be mapped to columns and edited with Mixtable Spreadsheet Editor.

What you can see

A Discounts worksheet can include:

• Title, status, and discount type
• Start and end dates
• Fixed amount or percentage value
• Total redemptions and number of discount codes
• Usage limit and whether the discount applies once per customer
• Whether the discount combines with order, product, or shipping discounts
• Shopify’s full and short summaries of the promotion
• Created and updated dates
• Shopify ID

One row represents the discount itself. The worksheet does not create a separate row for every redeem code attached to a discount.

Create a Discounts worksheet

1. Open a spreadsheet in Mixtable and click the + button beside the worksheet tabs
2. Select Shopify data worksheet, then click Continue
3. Select Discounts
4. On Choose your columns, keep the most-used fields or select the fields you want to review, then click Continue
5. Choose Load everything or Only rows that match rules
6. Click Create Worksheet

Useful ways to review discounts

• Filter Status to focus on active, scheduled, or expired promotions
• Sort by Starts At or Ends At to review your promotion calendar
• Compare Value Amount and Value Percentage across campaigns
• Use Total Redemptions to identify frequently used promotions
• Review the Combines With fields before planning overlapping campaigns
• Export the worksheet to Excel or CSV for campaign planning or auditing

Add discount metafields

Discounts can have Shopify metafields for custom campaign information. To add one to the worksheet:

1. Select an empty column or insert a new one. Empty columns have a non-green header; a green header means the column is already linked to Shopify data
2. Click the button in the column header
3. Select Metafields
4. Choose the discount metafield definition you want to map
5. Click Save Column
6. Enter or paste your metafield values
7. Click Sync to Shopify to publish the changes

Only mapped metafield columns are editable. The standard discount fields remain read-only.

For more detail, see bulk edit Shopify metafields.

Measure what a promotion produced

A Discounts worksheet shows how each promotion is set up, not what it produced. For results, Mixtable Analytics Spreadsheet calculates the total discount amount given away, and its Discount code filter groups redeem codes under their parent campaign, so a promotion that generated hundreds of codes still reports as one thing. Add the same set of columns for a second campaign and you have a like-for-like comparison.

Troubleshooting

The Discounts option is missing or no discounts load

Your Shopify connection must grant Mixtable permission to read discounts. Reconnect the store and approve the requested Shopify access if Mixtable prompts you to do so.

I changed a standard discount field but it did not sync

Standard discount fields are read-only. Make that change in Shopify. Mixtable Spreadsheet Editor can sync edits only from mapped discount metafield columns.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.