Beyond the 100 Limit: How to Apply Shopify Discounts to Thousands of Products (The Community's Best Hacks!)

Hey folks! Ever felt that familiar pang of frustration when you're trying to set up a discount on Shopify for a massive range of products, only to hit a brick wall at 100 variants? You're not alone. This is a common head-scratcher for many store owners, especially those running complex B2B operations or managing large inventories.

I recently saw a great discussion pop up in the Shopify Community forums, where a store owner, sanfort, was grappling with this exact issue. They needed to apply a single discount coupon to up to 2,000 selected product variants for their franchise partners, who each have customized bundles and use Shopify B2B for access control. The 100-variant limit was a real blocker.

Thankfully, the community rallied with some seriously smart workarounds. Let's dive into how you can bypass this limitation and manage your large-scale discounts like a pro.

The 100-Variant Discount Limit: What's Happening?

First, it's important to understand where this limit comes from. As several community members, including ecom-4all and Ploqo, pointed out, the 100-item cap is specifically on the product/variant picker itself within the discount creation UI. It's designed for manual selection, not for managing thousands of items. But don't worry, you don't need a feature request to increase it; there are better ways!

Solution 1: The Smart Collection Strategy (Your Go-To Hack!)

This was the most popular and straightforward solution offered by the community, with ecom-4all, Ploqo, and Maximus3 all advocating for it. The core idea? Stop picking individual variants! Instead, point your discount at a collection. A collection can hold thousands of products, and Shopify's discount system treats it as a single entity.

Step-by-Step: Setting Up Your Automated Discount Collection

This method is fantastic for scalability and future management. Here's how you do it:

1. Tag Your Products: This is the magic step. Go to your product list and use a bulk editor or a CSV import to add a unique tag to all the parent products (or specific variants, if you prefer to filter at the product level first) that should be eligible for the discount. For example, if you have a discount for 'Franchise A,' you might tag all their products with 'franchise-a-discount'. This is much faster than manually selecting 2,000 items!
2. Create an Automated Collection: In your Shopify admin, go to Products > Collections and create a new collection. Crucially, make it an automated collection. Set the condition to 'Product tag is equal to [your chosen tag]'. Now, any product with that tag will automatically join this collection, today and in the future. No manual updates needed for new products!
3. Point Your Discount to the Collection: Open your discount code settings. Under 'Applies to,' choose 'Specific collections' and add the collection you just created. There's no variant limit here because you're selecting one collection, not 2,000 individual items.

Here's a visual of how that automated collection setup looks, shared by Ploqo:

And how you link the discount:

One important caveat: As Ploqo rightly pointed out, a collection discount applies to the entire product. So, if your product has multiple variants (e.g., different sizes or colors), and only *some* of those variants should be discounted, this method might not be precise enough. That's where our next solution comes in.

Solution 2: Leveraging Shopify B2B Catalogs for Granular Control

Given sanfort's situation with franchise partners and B2B, this solution is incredibly powerful and, as Jack_BuildsShopify and Ploqo suggested, often the cleaner route for complex B2B pricing.

If you're already using Shopify B2B (which sanfort was!), you have access to Catalogs. Catalogs allow you to set specific pricing for products and variants for different companies or customer segments. This means the reduced price is simply the standard price for that franchise – no coupon code needed!

Step-by-Step: Using B2B Catalogs for Bulk Pricing

1. Create/Edit a Price List within a Catalog: For each franchise partner, you'll have a B2B company and an associated catalog. Within that catalog, you can create a price list.
2. Import Prices by CSV: This is where you get your bulk upload power! Instead of manually selecting variants in a discount UI, you can export your eligible variant IDs/SKUs, apply the desired reduced prices in a spreadsheet (CSV), and then import that CSV back into your catalog's price list. This handles thousands of variants in one go, offering an auditable list of your pricing.
3. Assign the Catalog: Ensure the correct catalog (with its specific price list) is assigned to the relevant franchise partner's B2B company. This means only that franchise will see those custom prices, and they won't need to enter any discount codes.

This method offers variant-level precision, which is crucial if only certain variants of a product should have special pricing. It also streamlines the customer experience by showing them their specific pricing directly, removing the need for coupon management and potential sharing issues.

Which Solution is Right for You?

• Choose the Automated Collection Method if: You need a simple discount applied to entire products (meaning all variants of an eligible product get the discount), and the discount is fairly universal or applies to broad groups. It's quick, easy to manage, and scales beautifully.
• Opt for B2B Catalogs (with CSV import) if: You're already using Shopify B2B, need highly specific variant-level pricing, want to avoid discount codes altogether for specific partners, or require robust, auditable price lists for different customer segments. This is the professional, integrated solution for complex B2B scenarios. If you're looking to start or grow your own store, Shopify is an incredible platform that offers these powerful features and more.

The beauty of Shopify is often in knowing these clever workarounds and leveraging its built-in features in unexpected ways. Both of these strategies effectively bypass the 100-variant selection limit, giving you the flexibility to manage discounts for thousands of products without breaking a sweat. So, go forth and discount with confidence!