Mixtable’s spreadsheet interface, combined with its Bulk Number editor, gives you a number of ways to increase the prices of your Shopify products in bulk. Here we’ll only look at increasing prices in bulk, and for more price editing tips see our full help page on how to bulk update your shopify prices.
The Bulk Number editor performs mathematical changes, allowing you to perform the same mathematical operation on a number of cells (e.g., increase by 10%). You specify the type of calculation to perform, and the updater will do it for you, applying the operation on the existing values in the cells. If a column has a mix of numbers and text values, only the cells with number values will be updated.
You activate the Bulk Number editor by clicking on its button in the toolbar. In the dialog that opens you’ll see a few inputs:
Mixtable works just like Excel, and if that’s your comfort zone you can use Excel formulas to update your prices. Simply map two columns to your price (either on a Products or a Variants worksheet). Cells in both column will display the current price. Update the cells in one of the price columns with a formula to increase the value of the other price formula by some value, e.g., multiply by 1.1 to increase the value by 10%. You’ll see the formula cells get a light purple background, meaning they are ready to sync to Shopify. Now just click the Done Editing button and Mixtable will sync the updated price values to Shopify.