Inventory Tracking When Selling by Weight

Alex45
New Member
1 0 0

Has anyone figured out a way to automate inventory management when selling multiple variants (with tiered pricing) of the same product by weight?  I have researched this problem extensively and I've tried Quantity Breaks and Bundles to no avail.  For instance, imagine there are 3 variants of the same product with tiered pricing, as illustrated below:

Green Tea
4oz $10
8oz $15
16oz $25
 

If I only have 16oz left in stock and someone purchased the 16oz variant, the 4oz and 8oz variants could still be purchased while they're out of stock.  Likewise if someone ordered a 4oz variant someone could still purchase the 16oz even though there are only 12oz left.  I can't be the only one with this problem, and if it were possible to solve, you would think someone would have made an app for it already.  

Is there any way to work around this at all?

0 Likes
Max_old
Shopify Staff
Shopify Staff
150 0 15

Hi Alex, 

I’m Martha from the Shopify team. 

If I understand your example properly you have a product Green Tea available in 3 separate variant sizes 4oz $10, 8oz $15, and 16oz $25. You can track the inventory levels of each variant weight, if you wish. 

This can be done through the product page. Products > Products and edit variants.

Or Bulk editing the properties “Inventory tracking” to Shopify tracks this product's inventory and make sure the variants do NOT allow Overselling if you don’t want the 16 Oz version to be selected. 

If you are selling Green Tea only in 4 Oz intervals, and not distinct variants, this becomes a bit more complex and it depends a bit on your product and how your limits are created. If you are using an app that helps promote quantity breaks, you can use this in conjunction with the above restrictions. 

If you want to share some examples we can take a look directly. Feel free to email support@shopify.com!

Cheers, 
Martha
 

derdottore
Tourist
9 0 2

I don't think this solves his (and my) problem. I am having the exact same issue.

Of course we could track the inventory levels of each weight, but that doesn't solve the problem. Here is another example to better understand the problem:

 

Let's say I am selling cheese and I only have one product. So I have 1kg of this cheese in stock. On my website I am offering 3 variants: 100g, 200g, 500g. So if you buy 500g I go and cut off 500g of my 1kg cheese. So there are 500 remaining. The next customer now shouldn't be able to buy 1x 500g and 1x 200g piece, as there are only 500g remaining.

 

Hope you understand now. 

 

Actually this is a very frustrating problem as you'll only restock, when your product is out of stock and you'll also always have orders with quantities you don't have in stock anymore. Right now my cheese is in stock whether it is 200g or 5kg. And this is a big problem and a lot of work.

 

Best,

Mauro

KritikaSingh
Excursionist
22 0 2

Hey did anyone figure this out :/

im stuck at the exact same thing

alazzaro
New Member
1 0 1

anyone find an answer to this?

derdottore
Tourist
9 0 2

Hi guys!
I am now trying to fix this issue with an ERP-System. I will implement JTL soon and am very optimistic this provides a solution to this problem.

0 Likes
JonasSchindler
New Member
2 0 0

Hi folks, I am also looking for the exact same solution as all of you, but I will not move to another shop system. I am hoping that somebody must have created an app for Shopify that can do exactly that! or, hopefully will develop something to solve this problem.

 

There are so many scenarios where sellers might need a shared inventory solution with custom quantity deduction for each variant (variable).

Wine -> buy one bottle or a case of 6. Parent Product has one inventory that is shared by the variants

tea, coffee, flowers, vegetables, fruits ...

 

Well, I might just start developing it myself and start selling it here  

0 Likes
policenauts
Pathfinder
108 6 19

Hi all,

We are the developer behind the 5-star rated Sell Products by Weight for POS app which solves this issue for in-person sales: https://apps.shopify.com/sell-products-by-weight. Our app enables scale integration, inventory adjustment, COGS reporting, tax-exempt products, etc. 

We are now beginning development to extend functionality to online sales. If you have a need for this, can you please fill out this brief questionnaire so that we can better understand the use case? https://forms.gle/vjMUzZ3wZxHWYmCo7

Thank you very much.

0 Likes