Import price lists

Import prices to your wholesale price lists by uploading a CSV (comma-separated values) file. You can import price lists that contain:

  • Specific products offered at set prices. It is not possible to import prices for price lists that are based on discounts.
  • Minimum and maximum order quantities, volume-based price breaks, and quantity increments.

Shopify Plus

The Wholesale ecommerce channel is available to Shopify Plus plans only.

You should import your prices to a price list if you use an external system, such as an ERP or spreadsheet, to create and maintain your price lists. Prices that are imported can be updated by another import only. You also cannot convert an imported price list to a manually maintained price list. If you want to use Wholesale to maintain your prices, then manually create your prices.

For each product variant that you want to import:

  • you need a barcode or SKU associated with it in Shopify
  • your CSV file must also include its barcode or SKU.

You can import prices when:

  • you create a price list
  • you edit an existing price list that contains imported prices. When you import prices to an existing price list, all prices and product variants listed in the price list are replaced.

Sample CSV files

You can download and view sample CSV files to use as templates for creating your own import file:

If you use a sample file to create your own prices, then make sure that you remove all the sample information.

Format of the CSV files

Your CSV file needs to contain the following information:

  • The first line needs to list the names of the columns (the column headers) that you have chosen to import.
  • Each additional line needs to contain the pricing information for a specific product variant. Each product variant must exist in Shopify and it must have either a barcode or a SKU associated with it.

The following table describes the columns that you can use in your CSV file:

Column Required Description
sku Required for product variants that do not have barcodes. If all your product variants have barcodes, then you do not need to include this column in your CSV file. The SKU (Stock Keeping Unit) associated with the product variant. This SKU value must match the SKU of the product variant in Shopify.
barcode Required for product variants that do not have SKUs. If none of your product variants have barcodes, then you do not need to include this column in your CSV file. The barcode associated with the product variant. This value must match the barcode of the product variant in Shopify. If your CSV file contains both SKUs and barcodes for the product variants, then the barcode is used to match the product variant in your store.
wholesale_price Required The wholesale price for the product variant in your price list. This value accepts a number with up to two decimal places. The following are examples of acceptable values: 55, 55.1, and 55.10. Use decimals to separate dollars and cents. Do not format this number with comma separators or use a number ($) or cent (¢) sign.
minimum_units Optional Minimum number of units per order. This number needs to be a whole number.
maximum_units Optional Maximum number of units per order. This number needs to be a whole number that is greater than the value entered for minimum_units.
increments Optional Multiple by which the wholesale buyer can order the product variant. For example, if the amount is 12, then the buyer can buy 12, 24, or 36 units, but not 4 or 15. This value accepts a whole number. If this column is not specified, then the default increment is one.

Volume-based pricing

Volume-based pricing offers different per-unit prices for all ordered units depending upon the amount that is purchased. You can import prices with volume breaks using a CSV file that uses the following columns:

Column Required Description
sku Required for product variants that do not have barcodes. If all your product variants have barcodes, then you do not need to include this column in your CSV file. The SKU (Stock Keeping Unit) associated with the product variant. This SKU value must match the SKU of the product variant in Shopify.
barcode Required for product variants that do not have SKUs. If none of your product variants have barcodes, then you do not need to include this column in your CSV file. The barcode associated with the product variant. This value must match the barcode of the product variant in Shopify. If your CSV file contains both SKUs and barcodes for the product variants, then the barcode is used to match the product variant in your store.
wholesale_price_1 Required Base price of the product variant that you want to offer to your wholesale buyers. This value is the per-unit price that your buyers will pay when their order quantity is an amount between from_quantity_1 and to_quantity_1. This value needs to be a number with up to two decimal places. For example: 55, 55.1, and 55.10. Use decimals to separate dollars and cents. Do not format this number with comma separators or use number or cent signs.
from_quantity_1 Required when wholesale_price_1 is specified. The minimum number of units of the product variant that your wholesale buyer needs to order. This value needs to be a whole number.
to_quantity_1 Required when wholesale_price_1 is specified. Maximum number of units that your buyer can purchase at the per-unit price of wholesale_price_1. This amount is the end of the first volume-break threshold. Buyers who purchase more than this number of units will pay a lower per-unit price for all the units that they purchase. This amount needs to be a whole number that is at least 1 greater than the value entered for from_quantity_1.
wholesale_price_2 Optional Per-unit price of the product variant that your wholesale buyers pay when their order quantity is between from_quantity_2 and to_quantity_2. This price must be less than the value of wholesale_price_1, and it must be number with up to two decimal places. For example: 55, 55.1, and 55.10. Use decimals to separate dollars and cents. Do not format this number with comma separators or use number or cent signs.
from_quantity_2 Required when wholesale_price_2 is specified. Minimum number of units that your buyer needs to purchase to pay the per-unit price of wholesale_price_2. This amount needs to be a number that is 1 more than the amount entered for to_quantity_1.
to_quantity_2 Required when wholesale_price_2 is specified. Maximum number of units that your buyer can purchase at wholesale_price_2. This amount needs to be a number that is at least 1 more than the amount entered for from_quantity_2.
wholesale_price_3 Optional Per-unit price of the product variant that your wholesale buyers pay when their order quantity is between from_quantity_3 and to_quantity_3. This price must less than the value of wholesale_price_2 and it must be number with up to two decimal places. For example: 55, 55.1, and 55.10. Use decimals to separate dollars and cents. Do not format this number with comma separators or use number or cent signs.
from_quantity_3 Required when wholesale_price_3 is specified. Minimum number of units that your buyer needs to purchase to pay the per-unit price of wholesale_price_3. This amount needs to be a number that is one more than the amount entered for to_quantity_2.
to_quantity_3 Required when wholesale_price_3 is specified. Maximum number of units of the product variant that your buyer can purchase in a single order. This amount needs to be a number that is at least one more than the amount entered for from_quantity_3.
increments Optional Multiple by which the wholesale buyer can order the product variant. For example, if the amount is 12, then the buyer can buy 12, 24, or 36 units, but not 4 or 15. This value accepts a whole number. If this column is not specified, then the default increment is 1.

CSV file limitations and details

The following list contains details about the CSV file that you need to provide:

  • The first line in the CSV file needs to contain the names of the column headers. All other lines in the CSV file need to contain pricing information for a single product variant.

  • The order of the columns is important and every row must have the same sequence of columns. For columns that are optional, any preceding columns (including other optional columns) must be specified. For example, to specify the maximum_units column, you must also specify the minimum_units column in your CSV file.

  • The import matches the lines in your CSV file to product variants in your store by using the barcode or the SKU (if there is no barcode). If the import can't find a match in the store, then the pricing information for that line is not imported. Both columns can be included in your CSV file, but if all your product variants have barcodes, then you don't need to include the SKU column. Similarly if all your product variants have SKUs, then you don't need to include the barcode column. Both columns need to be included if some of your product variants have barcodes only and some have SKUs only.

  • If you don't use barcodes to identify your product variants in your CSV file, then each product variant in your store should have a unique SKU. If this is not the case, then all product variants that share the same SKU are given the same price. If there is a discrepancy in the pricing, then the lowest price is the one used.

  • If a barcode or SKU contains special characters, such as a comma, then you must use double quotes to enclose the barcode or SKU. Make sure that your file uses straight quotes (" ") and does not use smart quotes (curly quotes) such as those often used in spreadsheet programs.

  • Use UTF-8 encoding to avoid generating unwanted special characters in your file.

  • Separate columns with commas.

  • Each line must be separated by a line break (\r\n).

Examples

  • In the following example, all product variants in the price list have unique SKUs and there are no minimum or maximum quantities or quantity increments:
  sku,wholesale_price
  22311233,12.55
  12345311233,8
  • In the following example, all product variants in the price list have unique barcodes, minimum_units, maximum_units, and quantity increments:
barcode,wholesale_price,minimum_units,maximum_units,increments
22313555563,12.55,1,10,2
12345311233,8,1,
99999998889,9,,,
80980980980,1000,,,6
  • In the following example, the product variants have SKUs but they do not have barcodes. Two product variants share the same SKU numbers. In this example, two different prices are entered for the same SKU number. The lowest value will be used to assign the wholesale price to any product variant in the price list that has this SKU:
  sku,wholesale_price
  90210333,12.55
  90210333,8

When this CSV file is uploaded to the Wholesale channel, any product variant that has the SKU 90210333 will be have the wholesale price of $8.

  • In the following example, the first product has one quantity break:
  sku, wholesale_price1, from_quantity_1, to_quantity_1, increments
  80980980980,10,2,50,2
  99999998889,25,,1

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free