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. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.
2. Select Metafields
3. Choose the discount metafield definition you want to map
4. Click Save Column
5. Enter or paste your metafield values
6. Click Sync to Shopify to publish those metafield changes

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

For more detail, see bulk edit Shopify metafields.

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.