How to change prices on many Wix products at once (by percent, with rounding)
By Jake Marsh · Updated
To change prices on many Wix products at once with Swathwell, filter the grid to the products or variants you want, tick their rows, choose Price in Change many at once, and pick Change by percent or amount (for example +8 percent) with a rounding rule such as End in .99. Click Preview to see every old and new price side by side, click Stage N changes, then Review and apply and Apply N changes to Wix. Any price change can be undone from the Change log for 30 days.
Why variant rows matter
In Wix Stores, a product with options keeps a price for each variant. Wix's own bulk action in the Products tab changes the base price, and variant prices move with it. In Swathwell, each variant is its own row, so you can choose exactly which ones change:
| Product | Variant | Price before | +8%, End in .99, up |
|---|---|---|---|
| Linen shirt | S | 42.00 | 45.99 |
| Linen shirt | M | 42.00 | 45.99 |
| Linen shirt | XXL | 46.00 | 49.99 |
| Canvas tote | (no options) | 18.00 | 19.99 |
Rounding goes to the nearest ending by default; switch it to up or down in the same panel. 42 plus 8% is 45.36, which rounds to 44.99 with nearest or down and to 45.99 with up. The preview shows which you'll get before you stage anything.
Steps
- Open Swathwell from your Wix dashboard and wait for the grid to load.
- Filter to the rows you want. For example Categories contains "Shirts", or SKU starts with "LIN-". Select none to work on every row the filter shows.
- Open Change many at once and choose the Price column.
- Pick the operation:
- Change by percent or amount: +8 percent, -10 percent, +2.00, -0.50.
- Set to: one price for every selected row.
- Formula: a price built from other number columns (below).
- Round prices: tidy existing prices without changing them otherwise.
- Choose rounding: End in .99, End in .95, Whole number, Nearest 0.05 or Nearest 0.10, and up, down or nearest.
- Click Preview. Rows that would go below zero, or that can't take a price, are listed with the reason.
- Click Stage N changes. Staged cells turn yellow in the grid. Nothing has reached your store yet.
- Click Review and apply, give the change a name like "Spring price rise", and click Apply N changes to Wix.
Prices from a formula
Formulas use numbers, number columns in braces, + - * /, brackets and percent:
| Goal | Formula |
|---|---|
| Price is 2.5 times cost | {cost} * 2.5 |
| 10% off the current price | {price} * 90% |
| Cost plus packaging, doubled | ({cost} + 1.5) * 2 |
| Compare-at price 25% above price | {price} * 125% (on the Compare-at price column) |
A row with an empty cost is listed with "{cost} is empty on this row" instead of getting a price of zero.
Raising costs and prices together
When a supplier raises costs, change Cost first with Change by percent or amount, stage it, then set Price with a formula from {cost}. Both show in one review, and one apply writes them.
What it costs
Bulk price changes, formulas, rounding and the 30-day undo are in both Swathwell plans. Standard is $29 a month or $288 a year per site, for stores up to 5,000 products, with a 90-day change log. Pro is $59 a month or $588 a year, for stores up to 25,000 products, with a 1-year change log. A 14-day free trial runs through Wix (Wix asks for a card when it starts), and before it you can stage and review changes without applying them.
Swathwell: Bulk Product Editor
Edit products and variants in a grid, review every change, schedule sales, undo From $29 a month per site, or $24 a month billed yearly.
Questions
Will changing prices in Swathwell overwrite an edit someone just made in Wix?
No. When you apply, Swathwell reads each product from Wix again. A row that changed since you loaded the grid is skipped and listed, and you can reload and redo it.
Can I change the sale price on the older catalog?
On Wix's older catalog (V1) there's a product-level Sale price column. On the current catalog, use Compare-at price to show a struck-through original price.
How long does a big price change take?
Swathwell writes in parts of 25 products and paces itself to Wix's API limits, so thousands of products can take several minutes. Keep the tab open; finished parts are already in the Change log.
Can I undo a price change next week?
Yes, from the Change log for 30 days. Undo restores only rows that still hold the price Swathwell wrote.
Can I do a temporary price cut instead?
Use a scheduled sale: select the rows, click Schedule a sale for the selection, and the prices go back at the end. See how to schedule a sale in Wix Stores.
More Swathwell guides
- How to bulk edit SEO titles and descriptions for Wix products
- How to schedule a sale on Wix Stores products with a start and end date