How can I link product variant weight with base inventory for my coffee business?

[unbornink]

Hi,

I provide roasted coffee, we batch roast products so have a base inventory for each blend. We then sell this in either 250g or 1kg bags. We only pack the coffee with each order, taking from the base inventory. I want to be able to link a product variant (bag weight) to the base inventory. So if I have 20kg in inventory, 1 customer buys a 250g, it's deducted from the 20kg, leaving 19.75kg left, or buys 1kg it leaves 19kg. 

Note: Each product has 8 variants (2 sizes and 4 grinds), although the grind type doesn't affect the stock levels.

I've tried a number of stock sync or bundle apps to try to solve this but can't seem to get this to work. We have about 40 types of coffee, some of which are single batch runs, so manually adding these in complex bundles doesn't seem to be an efficient solution.

WooCommerce has a solution based on a stock attribution. 250g = 1, 1kg = 4. I need something similar perhaps? 

[aosoble]

HI @unbornink ,

I'm currently putting the finishing touches on an app designed to solve your exact problem. My app allows users to configure raw materials and a bill of materials for each product variant.

In your use case, you would configure raw materials like this:

Materials	Quantity
Arabica	20,000g
Robusta	18,500g

Bill of Materials:

Product Variant	Bill of Materials
Arabica (Grind A, 250g)	Arabica - 250g
Arabica (Grind B, 1kg)	Arabica - 1000g
Robusta (Grind B, 1kg)	Robusta - 1000g

Among other features, the app supports both make-to-order and make-to-stock strategies. The app will be released very soon. Let me know if you have any questions or in case you want early access.

[unbornink]

Hi Aosoble

It would be great to get early access and test out your app. Sounds promising.

[ssfractured]

I would also love early access to help test this.

[Joe47]

Hi @unbornink,

We recently launched an app Material Manager to help managing inventory for stores like yours. It allows you to enter your raw materials and then specify how much of each raw material each of your variants need. The variants inventory levels are then always updated to the maximum that can be created based on the inventory of the raw material.

In your case you would enter each a raw material for each of your blends and then choose a unit of either g or kg. Then you would assign the weight needed to each variant. For 250g if you use kg it would be 0.25kg, or simply 250g if you use grams.

If you blend you coffees after roasting you could also sell single origin and different blends drawing down from the same inventory.

Feel free to reach out if you have any questions.

[EasifyApps]

Hi @unbornink,

Your coffee inventory management can be easily handled using the Easify Inventory Sync app. Here's a straightforward way to set it up 🤗:

• Create a Base Product: This will represent your total coffee inventory (e.g., 20kg/20,000g).

• Create Bundle Groups: Use the app to connect each of your coffee bag sizes with the base inventory. For example, if you offer coffee in 250g and 1kg bags, you'll need to create 2 bundle groups. Here's how you can set up the group for the 250g bag:

  • Master Product: The "250g" bag size variant
  • Component Product: The Base product you created, with the quantity per bundle set to 250g.

  Similarly, create a bundle group for the "1kg" bag size.

Expected Results:

• The quantity of "250g" and "1kg" variants will be automatically calculated based on the inventory of the Base product.
• When a bag size is purchased (e.g., 250g), the corresponding amount will be deducted from the Base product inventory (-250g). After that, the new Base product inventory will recalculate the available quantity for all bag size variants, ensuring an accurate inventory management loop.

The app is user-friendly and comes with a comprehensive setup guide. I hope you give it a try!