Price lists
Import and export prices with a CSV file
Set prices for hundreds of products at once in a spreadsheet. Export a price list, edit the prices in Excel or Google Sheets, and import the file back. On the Growth plan.
Use CSV import to
- Load a wholesale price sheet you already keep in a spreadsheet
- Change many prices at once, like a yearly price update
- Set quantity rules and price breaks for a whole range
- Keep a copy of a price list's prices
Quick steps
- Open a price list and click Import.
- Click Export current prices or Download sample CSV.
- Edit the file and save it as CSV.
- Click Import again, add the file, and click Import.
- Check the result message, then publish.
The screens below are the real NetWise app with sample data. Rest your pointer on a screen (on a phone, tap it) to watch the step, with captions. Press Replay to watch it again.
Open the Import prices window
Open a price list. In the product table, click Import at the top right. The Import prices window opens. It lists the columns your file needs, and under No file yet? gives you two ways to get a file:
Import works on Exact price and Volume discount price lists, the ones with a price per product.
Fill in the file
One row per variant. NetWise finds each variant by its SKU, so the SKU column is the only one you must have. The other columns are optional. Column names can use any capitals and spaces, so Adjusted price and AdjustedPrice both work.
| Column | What to put in it |
| ProductTitle | The product name. For your reference only. NetWise doesn't change it. |
| VariantTitle | The variant name, like Small. For your reference only. |
| SKU | Required. Must match the variant's SKU in your store exactly. |
| Display price (or your own label, like MSRP) | Optional. The price shown struck through next to the B2B price. Must be the same as or higher than AdjustedPrice. Only in files for price lists that show a display price. |
| AdjustedPrice | The B2B price per unit, like 18.50. Leave empty to clear this variant's price. |
For a Volume discount price list at Product & Variant level, add these columns too. What quantity rules do
| Column | What to put in it |
| Increment | Pack size, a whole number like 6. |
| MinimumQuantity | Fewest units per order, like 6. Must be a multiple of Increment. |
| MaximumQuantity | Most units per order, like 240. Leave empty for no limit. |
| Quantity Break 1, Price Break 1 | Where the first price break starts, and the price per unit from there, like 24 and 36.00. Add Quantity Break 2 and Price Break 2 for the next, and so on. |
An example for a Volume discount price list:
ProductTitle,VariantTitle,SKU,AdjustedPrice,Increment,MinimumQuantity,MaximumQuantity,Quantity Break 1,Price Break 1 Waffle Robe,S/M,WR-1,40.00,6,6,240,24,36.00 Waffle Robe,L/XL,WR-2,40.00,6,6,240,24,36.00 Cotton Bath Sheet,Default Title,CBS-1,44.00,,,,,
Import the file
Save your spreadsheet as a CSV file (UTF-8). Click Import, drag the file into Price file or click to choose it, then click Import. The page shows Importing products... while NetWise works through the rows.
When it finishes, a message says how many rows were updated, like Import completed: 14 updated, 2 warnings. Each problem row is listed with its row number and SKU. Rows with a problem are skipped, and every other row is imported. Fix the skipped rows in your file and import it again.
Importing saves the prices to the price list, but customers don't get them until you publish. Publish your changes
Fix import warnings
| Message | What to do |
| Variant not found in store | No variant in your store has this SKU. Check it for typos and spaces, or add the SKU to the variant in Shopify. |
| SKU is required | The row has no SKU. NetWise skips it. |
| Invalid AdjustedPrice: 12,50 | Prices must be numbers with a dot, like 12.50, with no currency sign. |
| AdjustedPrice cannot be negative | Use 0 or more. |
| CustomPrice (...) must be greater than or equal to AdjustedPrice (...) | The display price must be at least the B2B price. |
| MinimumQuantity must be at least 1, or Invalid MinimumQuantity (must be a whole number) | Quantities are whole numbers from 1 up. The same goes for Increment and MaximumQuantity. |
| MinimumQuantity (...) cannot exceed MaximumQuantity (...) | Lower the minimum or raise the maximum. |
| MinimumQuantity (...) must be a multiple of Increment (...) | With an increment of 6, use a minimum of 6, 12, 18 and so on. |
| Price Break 1 is required when Quantity Break 1 is provided | Each quantity break needs a price, and each price needs a quantity. |
| Quantity Break 2 (...) must be greater than previous break (...) | Each break must start at a higher quantity than the one before. |
| Increment is only used by the Volume discount template | This price list doesn't use quantity rules. Remove the column or clear the value. |
If the file has no SKU column, or two columns mean the same thing (like AdjustedPrice and Adjusted price), nothing is imported. Fix the header row and try again.
On the Launch plan
CSV import and export are on the Growth plan. On Launch, the Import button shows a lock. Clicking it opens Import and export are on the Growth plan. Click Upgrade to see plans, or Not now to keep editing prices row by row. Plans and billing
Good to know
- Import updates only the variants in your file. Variants you leave out keep their prices.
- A row adds its product to the price list if it isn't there yet.
- An empty price or rule cell clears that value for the variant. To keep a price, leave it filled in.
- For a new price list you haven't saved yet, use Download sample CSV. Export current prices is there once you save it.
- Open and save the file as CSV, not as an Excel workbook. Excel can drop leading zeros in SKUs, so check them before you import.
Questions
Why are some rows "Variant not found in store"?
NetWise matches rows by SKU only. The SKU in the file must match the variant's SKU in Shopify exactly. Variants with no SKU in Shopify can't be imported. Set their price in the product table instead.
Can I import into a Percentage off or Amount off price list?
Those templates set one discount for every product, so there are no per-product prices to import. Use Exact price or Volume discount instead.
Do I need to publish after importing?
Yes. Importing saves the prices to the price list. Click Publish or Publish changes to send them to your store.
Can I import prices in another currency?
Prices are read in the price list's currency, as plain numbers. Leave out currency signs and thousands separators.
Still need help?
Our team answers fast. Send us a message or book a short call and we'll set it up with you.