How to deduct the incoming inventory by weight

[Ting89]

I’m looking for a better solution to manage tea inventory. We order tea by weight and pack the teas into different weights.
For example: We order 10kg red tea and pack the tea into a 100g bag and a 15g sample bag. I have to update the incoming inventory to 100g bags x100. When we sell 15g sample bag x10, I have to adjust the inventory manually. I’m looking for a tool that can deduct the inventory automatically. If I sell 100g bag x10 and 15g sample bag x10, the remaining inventory should be 8kg and 850g
Is there any function or app I can use to deduct by weight instead of the quantity?

[FusionInventory]

Hi @Ting89 

We recently released Fusion Inventory which is designed to handle your use case. The app will allow you to track how many grams of Red Tea you have and how many grams of Red Tea each product sale should deduct. You would do this by configuring materials and bill of materials as follows:

Materials:

Name	Quantity	Unit of Measure
Red Tea	10,000	Grams
Black Tea	8,000	Grams

Bill of Materials for "Red Tea - Sample":

Name	Quantity
Red Tea	15

Bill of Materials for "Black Tea - Normal":

Name	Quantity
Black Tea	100

After Inventory Sync is enabled, the app will take care of syncing your inventory of product variants to Shopify after each order is placed/cancelled or when new materials are added or deducted.

Feel free to reach out for any questions, feedback or suggestions for new features. We'll be constantly making improvements to the app.

[EasifyApps]

Hi @Ting89,

The Easify Inventory Sync app can streamline your inventory management. Here’s a quick overview of how it works 😊:

1. Create a Draft Product: Set up a base product to track your total inventory (e.g., 10kg or 10,000g).

2. Set Up Bundle Groups: Use the app to create 2 bundle groups that connect your base product with different tea bag sizes (e.g., 100g and 15g).

3. Automatic Inventory Sync: The app will calculate how many bags of each size are available based on the base product's inventory. When a tea bag is sold, the app deducts the corresponding amount from the base product, and then updates the quantities for each bag size accordingly, ensuring accurate inventory tracking.

The app offers a demo and a detailed guide tailored to your needs. I hope you find it useful and give it a try!