Use case for Mixtable Spreadsheet Editor
Change base, market, and B2B prices across thousands of products at once, all in a familiar spreadsheet. Apply percentage markups and discounts with a click or a formula, then review every change and sync to Shopify when ready.
Spring Pricing - Acme Apparel Sync 4 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable loads your Shopify prices into a spreadsheet that stays connected to your store. Edit like in Excel or Google Sheets, then push reviewed changes back to Shopify.
Edit base prices and compare-at (sale) prices side by side, for a single product or thousands of variants at once.
Apply markups, discounts, target margins, and rounding with Excel-style formulas, or raise or lower a whole price column by a percentage or fixed amount in a couple of clicks.
See how each variant's price, cost, and fixed market and B2B prices changed over time in Cell history, including who synced each change.
Update cost per item, and add Net Sales, quantity sold, Gross Profit, or Gross Margin beside variant prices with Mixtable Analytics Spreadsheet before you choose what to reprice.
Set prices and compare-at prices for each Shopify market, using fixed values or currency conversion formulas with rounding.
Manage wholesale and VIP price lists for your B2B catalogs in the same sheet, one column per catalog price list.
Load any of these into a single pricing spreadsheet and split them across tabs if you like. Your price fields stay connected to Shopify, and you can compute helper columns like margin right beside them.
In the spreadsheet
Price Increase - Acme Apparel Sync 4 changesPreview Not a spreadsheet expert? You do not need to be. Filter to the products you mean, pick a price column, choose an adjustment, and Mixtable updates every visible row for you. Preview the result first, so nothing changes until you say so.
Guide: Change prices in bulk Global Pricing - Markets Sync 9 changesPreview Selling in more than one country? Each Shopify market can have its own price and compare-at price. Mixtable turns every market into a column, so you can see and update them together instead of clicking market by market.
Guide: Set market prices B2B Catalog - Acme Apparel Sync 9 changesPreview Keep retail, wholesale, and VIP prices in their own columns. Adjust each tier with formulas, see the impact on your margin, then sync your B2B catalog pricing to Shopify when it looks right.
Guide: Manage B2B prices Spring Markdown - Pricing Sync 4 changesPreview Type a formula once, fill it down the column, and every price updates. Percentage markups, discounts, and target margins work exactly like they do in Excel and Google Sheets.
Guide: Learn about price formulasReview and sync
Mixtable never pushes price edits silently. Every base, compare-at, market, and B2B change stays a draft, highlighted in your sheet. Open the preview for your worksheet, check each pending value, then run Sync to Shopify.
| Row | Product Variant | Field | Pending value |
|---|---|---|---|
| 2 | Oxford - M | Price | $67.15=C2*0.85 |
| 3 | Oxford - M | Compare at | $79.00 |
| 4 | Trouser - 32 | UK price | GBP 94.99="GBP "&ROUND(C3*0.85,2) |
| 5 | Trouser - 32 | Wholesale | USD 77.35="USD "&ROUND(C3*0.65,2) |
| 6 | Cap - OS | Cost per item | $16.00 |
Compare
If you change prices today, you are probably using one of these. Here is how they compare for editing Shopify prices in bulk.
| Pricing task | Mixtable | Shopify admin | CSV import and export | Other bulk-edit apps |
|---|---|---|---|---|
| Edit base and compare-at prices in bulk | Yes, with a sheet | Bulk editor, typed by hand | In Excel, then re-upload | Form-based |
| Change all prices by a set percent in a few clicks | Yes, point and click | No | In Excel, then re-upload | Sometimes |
| Pricing formulas for percent, margin, and dynamic rules | Excel-style formulas | None | In Excel, then re-upload | Fixed rules only |
| International and market prices | One column per market | Slow, per market | Extra columns per market | Varies by app |
| B2B price list and catalog pricing | Yes | Per catalog, manual | Separate catalog CSV | Rarely |
| Cost per item and margin checks | Yes, with formulas | Cost in the bulk editor, margin per product | Manual | Limited |
| Review pending changes before they go live | Yes | Live when you click Save | No preview | Some |
| No CSV file juggling | Yes | Yes | That is the whole workflow | Sometimes |
Comparison reflects typical bulk-pricing workflows. Shopify features can change over time.
Getting started
No CSV exports, no re-imports, no waiting. Connect your store and start editing.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a pricing spreadsheet.
Pull in your products and variants with the price columns you want to edit.
Use formulas, bulk percentage changes, copy and paste, fill down, and find and replace.
Every edit is highlighted, so you can confirm exactly what will update.
Push your changes back to the store in one move when you are ready.
Questions
Install the Mixtable Spreadsheet Editor from the Shopify App Store, open a pricing spreadsheet, and your products and variants load into a spreadsheet with their prices. Edit any price the way you would in Excel, then review the changes and run Sync to Shopify to push them to your store.
Yes. Base prices and compare-at (sale) prices each get their own column, so you can edit them together or on their own across as many products and variants as you need.
Yes, in two ways. You can write a formula like =ROUND(C2*1.10,2) and fill it down a column, or use the point-and-click bulk change tool to raise or lower a whole column by a percentage or fixed amount, with optional rounding.
Yes. Use formulas to calculate proposed prices from cost, inventory levels, dates, or supported analytics fields, and the sheet recalculates as that data changes. Prices never change on their own though: you review the calculated values and run Sync to Shopify when you want them live.
No. Formulas are there if you want them, but you can also edit prices cell by cell or use the bulk change tool to adjust an entire column at once, with no formula required.
Yes. Drop your sale prices into the price column and move the old prices into the compare-at column to show the discount, across as many products as you like. When the sale ends, roll the changes back the same way.
Yes. You can set prices and compare-at prices per Shopify market, using fixed values or currency conversion formulas with rounding, all from the same spreadsheet.
Yes. You can update cost per item where Shopify supports it, compute prices from cost to protect your margins, and manage B2B price list and catalog pricing for companies and locations.
No. Edits are held as pending changes and highlighted in the sheet. You review them and then run Sync to Shopify when you are ready, so nothing goes live by accident.
Yes. Mixtable records every variant's price, cost per item, and fixed market and B2B catalog prices, whether or not a worksheet shows them. Compare-at prices are recorded while a worksheet shows them. Cell history lists each change with the old and new price, when it happened, and whether it came from Shopify or from a Mixtable sync, including who clicked Sync.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and edit your prices in bulk, the way you already think.
