I have created a quantity based discount which gives customers automatically X% discount when buying 10 or more of a certain product variation across multiple product variations.
I have a lot of products and need to assign this discount to all the relevant product variations in my shop. I don’t see how to do this without ticking each variation one by one which would be very time consuming.
I’m not looking to subscribe to a third party app, so wondering if anyone has found a way to do this, maybe with exporting to CSV then making the change and importing back into Shopify.
Thanks
To my knowledge, Shopify doesn’t allow bulk assigning products/variants to a discount via CSV. Someone please correct me if I’m wrong.
Shopify Option
Doesn’t require a 3rd-party app but restricted to product level only discounts.
-
Bulk-tag products
- Products → filter to the set you want → Select all → More actions → Add tags
-
Create collection
- Create a collection with condition Product tag is equal to
qty-break-10 or whatever tag you use. Any product you tag later will auto-enter this collection.
-
Create discount
Matrixify Option
I know you’re not looking to subscribe to a 3rd-party app, but if you’re open to using Matrixify, you can potentially streamline this, especially the bulk-tagging part. It also allows for variant level discounts if needed. You can pay for a month with whatever plan matches the amount of products you’re working with and then unsubscribe once finished.
-
Bulk-tag products
-
Export Products (Basic columns) → keep Handle and Tags.
-
In your import file, add Tags with your marker (e.g., qty-break-10) and set Tags Command = MERGE so you add without replacing any existing tags.
-
Import back with Matrixify to update in bulk.
-
Create collection
- Assign products with the product tag you created (e.g.
qty-break-10).
-
Create discount
- Create one automatic “Amount off products” discount, set Minimum quantity = 10 and Applies to = that collection.
Matrixify can also create/update the discount itself in bulk. In a “Discounts” sheet you can set:
Target items with Applies To: Type = Products and list either product handles (all variants) or specific handle|variant SKU pairs to target only certain variants.