Price List Discount Type

Price lists are an advanced discount type in our app that makes it easier and more efficient to offer different discounts on different products. Instead of having to create long logic chains, you can use a spreadsheet-like editor to quickly edit prices. You can even import CSV files!

Use Cases

• Importing a list of B2B prices from a CSV for specific customers
• Offering different discounts on a large number of different products

Video Tutorial

Click the thumbnail above to watch our founder demonstrating how to use price list discounts.

Discount Template

Each row in your price list will be turned into a discount of this type. For example, if the "Discount template" is "Fixed price," then each row will become a fixed price discount. This is great for literal lists of prices. You can also use percentage or fixed amount discounts if you just want to apply different discounts.

Import CSV

To avoid having to manually add entries, click "Import CSV," and then drag and drop your CSV file. The app will then read it, search your store for the products/collections/variants/etc., and then add them to the table with their corresponding prices. Keep reading to learn the correct format.

Accepted CSV Formats

Our app can handle a wide variety of formats, because we know every CSV is different.

For best results:

• Use simple, plain-english headings, like "Product," "Product variant," "Price," or "Discount."
• Make sure the heading is accurate. For example, if your CSV references product variants, use "Product variant" as a heading instead of "Product."
• Cell values for products/variants/collections can be: numerical IDs, SKUs, or titles.
• Cell values for prices can be plain numbers or formatted currency. For best results, use just numbers, like 1.23 or 31,24.

More supported formats

Resource Identifiers:

• Product names/titles : Full product names as they appear in Shopify
• Product handles : URL-friendly product identifiers
• Product IDs : Shopify product IDs
• Variant SKUs : Product variant SKUs
• Variant IDs : Shopify variant IDs
• Collection names/titles : Collection names as they appear in Shopify
• Collection handles : URL-friendly collection identifiers
• Collection IDs : Shopify collection IDs

Discount Values:

The system can parse various discount value formats:- Plain numbers : 10 , 15.5 , 25

• Currency amounts : $5 off , €10 off , £15 off
• Percentages : 10% , 25%
• Descriptive amounts : 5 off , 10 discountThe parsing function extracts numeric values from these formats, so "$5 off" becomes "5" , "10%" becomes "10" , etc.

Separator

If your CSV file is not actually separated by commas, be sure to change the "Separator" setting.

A "separator" (also known as a "delimiter") is a character that separates each cell in a row in a CSV file. Usually for CSV files (which stands for "comma-separated values"), the separator is ,. However, if you are in Europe, where a , is often used to separate the whole and fractional parts of prices, your CSV might actually have ; as a separator.

Try opening your CSV in a plain text editor, like Notepad, TextEdit, or Vim to find out what the separator is.

Benefits of Price Lists

• Easier editing experience
• Ability to add/remove prices in bulk
• Your discounts can handle more line items because price lists execute fewer instructions than long logic chains.
• You can include more prices. If all the rows are the same type of resource (product, collection, etc), the app will store the price list in a format that requires less space.

FAQs

How many SKUs / rows can I include in a price list CSV?

There is no limit on the number of rows you can include in the CSV file itself. You can upload a file with as many rows as you like.

However, there is an indirect limit: the final price list data has a 10KB cap (this is a Shopify platform constraint on discount configurations).

In practice, this means the number of SKUs/products/variants you can include depends on how much space the final configuration uses once it is saved.

In the app, you will see a “Configuration size” progress bar that shows how close you are to this limit. It turns red when you exceed it, and some items may not be included if the limit is reached.

Your Feedback Matters

Your review helps keep this small business running. Please leave one on the Shopify App Store.

Updated on: 23/05/2026