Watch our interactive walkthrough? to complete this setup from start to finish.
PRICE LISTS
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.
1. 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:
Export current prices: downloads every product in this price list with its current prices, ready to edit and import back. The file is named after the price list. Only for a price list you have saved.
Download sample CSV: downloads price-list-sample.csv, with the same columns and no rows. Fill it in yourself.
Import works on Exact price and Volume discount price lists, the ones with a price per product.
2. 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 |
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 |
MinimumQuantity | Fewest units per order, like |
MaximumQuantity | Most units per order, like |
Quantity Break 1, Price Break 1 | Where the first price break starts, and the price per unit from there, like |
3. 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.
4. 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 |
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.
5. 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"?
Can I import into a Percentage off or Amount off price list?
Do I need to publish after importing?
Can I import prices in another currency?
Related guides
Create a price list
Exact price
Volume discount
Quantity rules and price breaks per product
Publish and unpublish a price list
Plans and billing


