How to sell multiple quantities of the same product at different prices

7 0 9

Hello Shopify community!


I own a Market/cafe selling raw goods, juices, smoothies, and ice-cream, along with breakfast, lunch, and soup bars. The sale format I need within Shopify applies to most of these products in different ways, which I will try to explain below..


For starters, I have read through multiple app descriptions and tried a couple, but they all seem to miss the mark and, in a way, actually do the opposite of what I need. As in, I don't need to create separate bundles of different products to track multiple inventories, but rather multiple options of the same product (based on size). I've seen similar inquiries to mine on the community but most seem to only get developer solicitation comments. Yet, this seems like a pretty simple and widely needed feature, though I understand the coding may not be so simple.


Basically, what I'm after is a way to track the base inventory of a product while offering multiple quantity variants of that same product, with the option to do so at different prices for each variant. In other words, it would be a bit like offering a bulk price (though manually set as opposed to a percentage discount) via multiple quantity options as variants within a given product, while tracking the product's base inventory accordingly.


Here's an example: We make gourmet ice cream and I would like to be able to sell it both in-store (via Shopify POS) and online for local pickup. We offer ice cream in 3 sizes; "Single" for $4, "Double" for $6, or a "Pint" for $12. I have ice cream priced per scoop and I need each option to update a base inventory (e.g. 6 gallons, or 192 scoops) by it's given quantity (1, 2, & 4, respectively).


Is this possible? The only simple answer I've found in order to accomplish something similar in terms of updating inventory would require having 3 separate products on the page or in the POS, as opposed to 3 variants within the same product. 


Example 2 (This example simplifies the pricing aspect of what I need, yet still doesn't seem to have a simple solution): I sell a lot of raw market goods by weight and would like to sell them online, pre-bagged for local pickup. I order most of them by the pound and have built formula spreadsheets to convert our product pricing to ounces in order to more accurately track inventory within Shopify. I would like to offer variants of "1/2 lb" and "1 lb" for these within the same product while updating the base inventory (e.g. 800 oz) by each respective quantity (8 & 16 oz) when it sells. In this case, a customer shopping on our website who wants 1-1/2 lbs of Brussel Sprouts would have to add either 1x "1 lb" to their cart, then add 1x "1/2 lb" to the cart OR 3x "1/2lb". As mentioned, in this case the price would update directly in proportion to the number of base inventory items (base price in oz X variant multiple quantity = total price to purchase).


The only other option I have for this case is to post a description for our raw goods that tells the customer to order by-weight products in oz, which seems a bit chunky in terms of the UX (since that isn't how most people are used pricing produce).


SO: Within the variant section of a product, If receive 50lbs (800oz) of Brussel Sprouts I would imagine this to look something like:


Product Name: Brussel Sprouts


SKU: 101

Track quantity: YES

Quantity available: 800


Variant 1: [Name: "1/2 lb"] [SKU: 101] [qty of SKU: 8

Variant 2: [Name: "1 lb"] [SKU: 101] [qty of SKU: 16]


*customer buys 2.5lbs (40x base quantity)


Quantity available: 760


Does this make sense and does this capability exist within Shopify? Is there a way to offer multiple variations of the same product while updating a potentially different base inventory?


Any help would greatly appreciated!

Replies 4 (4)
Shopify Partner
105 0 26

@BG417Thanks for the in depth info!


Yes, Trunk can do this for you with its bundling/kitting feature. You can learn more about this feature from this help doc here (there are two examples that match what you described, one being packs and the other being materials):


Trunk will autocalculate the amount you can make based on the base inventory of a product. The only caveat is Trunk doesn't understand units, only multipliers, so for your 1b and 1/2 lb example, you would simply use the modifier 2x such that there are 2x 1/2lb in a 1lb.


Furthermore, It will work on the variant level as long as they have a SKU. Finally, here's Trunk's Shopify App Store listing:


Feel free to let me know if you have any questions. I'm happy to jump on a phone call if that makes things easier!

Sync your stock levels + bundles/kits in real-time between any number of Shopify, Amazon, eBay, Etsy, Faire, QuickBooks Online, Squarespace, Square, Tundra, WooCommerce stores with Trunk
Shopify Partner
105 0 26

Links above are broken. To learn more about Trunk's bundling feature:

Sync your stock levels + bundles/kits in real-time between any number of Shopify, Amazon, eBay, Etsy, Faire, QuickBooks Online, Squarespace, Square, Tundra, WooCommerce stores with Trunk
New Member
4 0 0

Are you there?

Thank you for your questions.

Do you fix your problem?

I have same problems.

Please help me.

2 0 0

Hi BG417. I think we're trying to achieve something similar. Have you had any luck with this? Would really appreciate the help if so! Cheers.