how to sell multiple quantities of the same product at different prices.

BG417
Tourist
6 0 7

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

Inventory:

SKU: 101

Track quantity: YES

Quantity available: 800

Variants:

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!