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 prices are supported?

Unfortunately, there is no one-size-fits-all answer. It depends on what other logic you have. If all the rows are the same type, then the app will store them in a format that lets you easily store hundreds of them in the price list.

Your Feedback Matters

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

Updated on: 21/10/2025