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.
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 percentage markups, discounts, target margins, and rounding with Excel-style formulas, then fill them down the whole column.
Not a spreadsheet expert? Select a price column and raise or lower every price by a percentage or fixed amount in a couple of clicks.
Update cost per item and add Net Sales, quantity sold, Gross Profit, or Gross Margin analytics beside variant prices 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.
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.
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.
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.
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.
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.
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.
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 | One product at a time | 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 | Not in the standard CSV | Varies by app |
| B2B price list and catalog pricing | Yes | Per catalog, manual | No | Rarely |
| Cost per item and margin checks | Yes, with formulas | View only, per product | Manual | Limited |
| Review pending changes before they go live | Yes | Saves instantly | 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.
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.
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. You can also use cell and row history to see what changed, so you can always look back at earlier prices.
Open Mixtable for your store and edit your prices in bulk, the way you already think.
