Skip to main content

Import and export prices with a CSV file

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

  1. Open a price list and click Import.

  2. Click Export current prices or Download sample CSV.

  3. Edit the file and save it as CSV.

  4. Click Import again, add the file, and click Import.

  5. 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 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.

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 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.

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

Did this answer your question?