Skip to content

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

  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.

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.

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.

ColumnWhat to put in it
ProductTitleThe product name. For your reference only. NetWise doesn't change it.
VariantTitleThe variant name, like Small. For your reference only.
SKURequired. 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.
AdjustedPriceThe 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

ColumnWhat to put in it
IncrementPack size, a whole number like 6.
MinimumQuantityFewest units per order, like 6. Must be a multiple of Increment.
MaximumQuantityMost units per order, like 240. Leave empty for no limit.
Quantity Break 1, Price Break 1Where 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,,,,,
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

MessageWhat to do
Variant not found in storeNo variant in your store has this SKU. Check it for typos and spaces, or add the SKU to the variant in Shopify.
SKU is requiredThe row has no SKU. NetWise skips it.
Invalid AdjustedPrice: 12,50Prices must be numbers with a dot, like 12.50, with no currency sign.
AdjustedPrice cannot be negativeUse 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 providedEach 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 templateThis 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"?

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.