Inventory management raw materials and finished products

LHM1
New Member
3 0 1

Hi, 

I'm new to Shopify, and I have a client who sells perfume. They only have 12 different finished goods. They receive the scented liquid in bulk then fill up the bottles (5ml) and sell as the finished product. In a production situation, this would equate to a bill of materials with two components for a finished product called 'perfume'

Perfume

  1 x bottle

  5ml scent

 

I am looking for an app which allows me to monitor the stock levels for the finished product, both online and if I am selling in person through the POS, and also, monitors stock levels for the raw materials. If I buy the scent in bulk, I would want to then record each time I consume 5ml, and have an alert (or an automatic PO) to order some more when my stock reaches a certain level. For the finished product, when the stock reaches a certain level, alert me to 'make some more' or raise an automatic works order. I know I can set the stock levels against the finished product, but from what i can tell, this is ignored if I am selling in person. What happens if the person in the shop doesn't have visibility of the stock levels?

Can anyone recommend an app that would cater for this? As we are only talking about 12 items, and not hundreds, I am looking for something lightweight that cover all of the scenarios described.

 

Many thanks in advance

Lisa

0 Likes
axsuul
Shopify Partner
101 0 25

Trunk can definitely help you track your raw materials and final product inventory. You can learn more about the feature here: http://bit.ly/trunkhelpbundles

 

The only thing it can't do yet however is the stock notifications. Learn more about Trunk @ https://trunkinventory.com

⚡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
0 Likes
LHM1
New Member
3 0 1

I'll check it out thanks ,but it is really important to be able to track the stock quantities of the raw materials. Its make to order, so when a finished good is sold, automatically reduce the stock, and send some kind of reorder notification (or better still raise a PO automatically)

RhysC
New Member
1 0 0

How did you go mate? Did you find a product that suits your needs? I have the time to set something like this up now so might as well make the most of it!

0 Likes
danielpretorius
Shopify Partner
97 0 10

Hi Lisa,

 

We have a few clients that are using our Shopify & Airtable integration to accomplish the same objective - manage raw input inventory alongside the inventory of the finished product available to buy in Shopify. Happy to show you how it works in action. Also, check out our guide on how to manage and track Shopify inventory .

0 Likes
Conor123
New Member
3 0 0

Hi Daniel, 

I need the same solution, could you please let me know more.

Cheers

Conor

 

0 Likes
Tahar
Shopify Partner
20 1 1

Hi Lisa,

As far as I know, there is no native way to achieve such workflows directly in Shopify so you probably need an inventory management app that can handle BOM. 

Basically, you need to:

  1. Create a Perfume finished product that is configured as a BOM
  2. Create another product for the liquid - this would be a raw material product (a unit could be 5ml)

To acquire the perfume raw materials, you should ideally issue a PO to your supplier. Once the liquid is received, you can create an assembly order to produce your bottles of perfume. 

It is important, as you mentioned, to make sure whatever system you decide to go with has the ability to track both raw materials and finished goods inventory and cost. 

For your information, Stock&Buy has built-in functionality to allows you to achieve the above workflow while syncing with Shopify, at an affordable price. You can read more about BOM support in Stock&Buy here: https://www.stockandbuy.com/help/manufacturing/

I hope you will find this useful. Please don't hesitate to drop me a line if you have any questions.

 

Kind regards,

Tahar

0 Likes
GaryL
New Member
19 0 0

Hey @LHM1  -- I'm actually working on a product that helps organizing and facilitating inventory management, with specific features for produced goods.  I'd love to learn about the specific painpoints you are experiencing and if the solution I'm building can help out.  Want to shoot me an email at gary[at]explo.co? 

Looking forward to it!

0 Likes
MRPeasy_Madis
Tourist
8 0 1

With MRPeasy, you can manage your whole manufacturing business, including tracking your inventory and planning production. The system has a reorder point functionality so you'd be notified anytime you're due for another shipment of raw materials.

https://apps.shopify.com/mrpeasy-manufacturing-system 

0 Likes
axsuul
Shopify Partner
101 0 25

Links above are broken. To learn more about Trunk's bundling feature: https://go.trunkinventory.com/helpbundles

Furthermore, we now support low stock level alerts as well @ https://go.trunkinventory.com/help-low-stock

⚡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
0 Likes