Shopify Discount Limit Blues? How to Handle 2,000+ Product Variants for B2B Franchises

Hey store owners! Ever hit a wall trying to set up a discount for a huge number of products or variants on Shopify? You know, that moment when you’re manually clicking through product after product, and suddenly, you’re greeted with a frustrating 100-item selection limit? Trust me, you’re not alone. This is a common pain point, especially for businesses with extensive catalogs or complex B2B setups, like the one we recently saw discussed in the Shopify Community forums.

Our friend @sanfort, who runs Sanfort Schools, brought up this exact issue. They sell preschool kits and items to authorized Franchise Partners, each with their own customized bundles and restricted access (meaning franchises can’t see each other’s products). They needed a single discount coupon to apply to a whopping 2,000 selected product variants but were getting an error after 100. Using multiple coupon codes simply wasn’t practical for their customers. Sound familiar? Let’s dive into how the community tackled this and what solutions came to light.

Bypassing the 100-Variant Discount Limit: Two Robust Approaches

The good news is, while there isn't a direct setting to increase that 100-variant picker limit within the discount creation interface, the Shopify community quickly jumped in with some brilliant workarounds. The discussion, featuring insights from @ecom-4all, @Jack_BuildsShopify, @Ploqo, and @Maximus3, really highlighted two main strategies. Let’s break them down.

Strategy 1: Leverage Automated Collections for Scalable Discounts

This was the most popular suggestion and a fantastic general workaround for applying discounts to a large set of products. The core idea is to stop picking individual variants in the discount settings. Instead, you point the discount to a collection. A collection, whether manual or automated, counts as a single item in the discount setup, regardless of how many products it contains.

Here’s how you can set it up, as detailed by @Ploqo and echoed by others:

Step-by-Step: Automated Collections for Discounts

1. Tag Your Products: The magic starts with consistent tagging. For all the products (or parent products, if you want the discount to apply to all variants within them) that need to be part of this special discount, assign a unique tag. For Sanfort’s case, this could be something like franchise-partner-discount-A. You can do this via bulk edit from your product list or by importing a CSV.
2. Create an Automated Collection:
   • Go to Products > Collections and click Create collection.
   • Give it a descriptive name (e.g., "Franchise Partner A Discount Products").
   • Under Collection type, select Automated.
   • Set the condition: Product tag is equal to your chosen tag (e.g., franchise-partner-discount-A).

   This collection will now automatically populate with any product that has that tag, both now and in the future. Super efficient!

   
3. Point Your Discount to the Collection:
   • Go to Discounts and either create a new code discount or edit an existing one.
   • Under the Applies to section, choose Specific collections.
   • Search for and add the automated collection you just created.

   Voila! The discount now applies to every product in that collection, effectively bypassing the 100-variant selection limit.

   

   If you need to separate discounts by franchise, you can create separate automated collections for each franchise and apply different discounts, or apply a single discount to multiple collections. You can even limit each code to a specific customer segment for that franchise, as @ecom-4all suggested.

   

A crucial note for this method: A collection discount applies to the entire product. This means every variant of an included product will be eligible for the discount. If you need more granular control—say, only some specific variants of a product should be discounted—then our next strategy is likely a cleaner fit for you.

Strategy 2: The Power of B2B Catalogs and CSV Imports (The Cleaner Route for Franchises)

Given that @sanfort is already using Shopify’s B2B features for customized bundles and franchise-specific access, this approach was highly recommended by @Jack_BuildsShopify and @Ploqo as the cleaner, more robust solution. Why? Because B2B catalogs are designed for this exact scenario: offering specific products at specific prices to specific customer segments (like your franchises).

Instead of relying on a shared coupon that could become a synchronization nightmare (as @Jack_BuildsShopify wisely pointed out), you bake the reduced prices directly into the franchise’s dedicated catalog. This offers variant-level control and scales beautifully.

Step-by-Step: Setting Up B2B Price Lists with CSV

1. Utilize Franchise-Specific Catalogs: Since each franchise already has its own catalog and only sees its own products, this is where you'll define their special pricing.
2. Create a Price List: Within the B2B section of your Shopify admin, you can create specific price lists for each franchise partner.
3. Define Reduced Prices Per Variant: This is where B2B shines. You can set reduced prices for individual variants, not just entire products. There's no 100-variant cap here!
4. Bulk Import Prices via CSV: This is the game-changer for handling 2,000+ variants. Instead of manual selection, you can export your eligible variant IDs/SKUs, apply your desired price rules in a spreadsheet (a working CSV file), and then import that CSV back into Shopify to update the price list. This is your "bulk upload" solution!

The benefits here are huge:

• Precision: Discount specific variants, not just entire products.
• Scalability: Easily manage thousands of variants via CSV imports.
• Security: Only the assigned franchise sees those prices; no discount codes to type or accidentally share.
• Auditability: Your CSV becomes an auditable list of pricing rules, making updates and checks much simpler.

Which Path is Right for You?

If you're already deeply invested in Shopify's B2B features for managing franchise-specific products and access, the B2B Catalogs and Price Lists with CSV Import is almost certainly the superior and cleaner route. It provides the granular control, scalability, and security you need without relying on discount codes that might feel clunky for a dedicated B2B portal.

However, if your needs are simpler, or you're not using Shopify B2B and just need a way to apply a blanket discount to a large number of products (where applying to all variants of those products is acceptable), then the Automated Collections + Discount Codes method is an excellent, straightforward workaround that will save you a lot of manual clicking. It's a testament to the flexibility built into the platform.

It's awesome to see how the community comes together to find clever solutions to these kinds of challenges. Whether you're dealing with a few hundred items or thousands, there's usually a way to make Shopify work for your unique business model!