Syncing/Bill of materials (Units v Cases)

[True_Origin]

I’m looking for an app that can support the following setup:

I have two stores—one for retail customers and another for wholesale.

• On the retail site, we sell everything in units and some items in cases.
• On the wholesale site, most products are sold in cases, with a few available in units.

1. Sync stock levels between both sites so that when an item is out of stock in one store, it’s also out of stock in the other.

• Real-time inventory synchronisation:
  • The app should ensure that stock levels update instantly across both the retail and wholesale stores whenever a sale is made.
  • For example, if a customer purchases the last 5 units of a product on the retail site, the wholesale site should immediately reflect that there is no remaining stock.
• Prevent overselling and stock discrepancies:
  • Since both stores share the same inventory, the app must prevent scenarios where a product appears in stock on one site while being sold out on the other.
  • This is particularly important during high-traffic periods when multiple customers may be purchasing simultaneously from both stores.
• Manage partial stock availability effectively:
  • Some products are available in both cases and single units, while others are restricted to only one format on a particular store.
  • The system should update stock accordingly so that customers on both sites see the correct remaining availability.
• Automatic updates for restocking:
  • When new stock is added to the system, both stores should update immediately, showing the correct available quantity.
  • For example, if 200 new chocolate bars arrive, both the retail and wholesale stores should reflect the updated inventory without requiring manual adjustments.
• Integration with multiple sales channels:
  • If orders are placed through external platforms (such as marketplaces, POS systems, or manual sales), the app should still ensure accurate inventory updates across both stores.

This functionality helps maintain a seamless shopping experience, ensuring customers always see accurate stock levels and preventing issues related to overselling or stock shortages.

2. Support a bill of materials (BOM) or similar functionality to accurately manage inventory when selling items in different quantities. Specifically, the app should:

• Handle unit and case sales dynamically:
  • If we have 100 bars of chocolate in stock and a customer orders a case of 10, the system should automatically deduct 10 from the total stock, reducing the available single units to 90.
  • If another customer later purchases 5 single bars, the stock should then decrease to 85.
• Ensure correct availability across both stores:
  • Since both retail and wholesale sites share the same stock, the system should correctly reflect the remaining quantity, whether a customer purchases by unit or case from either store.
  • For example, if a customer from the wholesale site buys 3 cases (30 bars), the retail site should immediately update to show only 70 bars left in stock.
• Allow mixed purchases without stock discrepancies:
  • Some items are primarily sold in cases on the wholesale site but may still be available in units. The system should prevent overselling by ensuring that both case and unit purchases pull from the same stock pool.
  • Example: If 5 cases (50 bars) are purchased, the system should not allow more than 50 individual bars to be sold separately.

This functionality ensures that inventory is always accurate and that customers can only purchase what is truly available, whether they buy by unit or case.

Would you be able to recommend an app that meets these requirements?

[Promer]

Hi @True_Origin 

Here are some apps that might fit your needs:

1. Stock&Buy – Great for multi-store inventory sync, real-time stock updates, and BOM (unit-to-case conversions). It also integrates with external sales channels.
2. Trunk – Simple and effective for syncing inventory across multiple stores, preventing overselling, and handling different product formats.
3. Connected Inventory by Shopify – Works well for syncing stock between stores and managing bundled inventory (e.g., unit vs. case).
4. Katana MRP – A powerful solution for manufacturers and wholesalers, offering live inventory tracking and BOM management

Hope this helps!

[Qoblex-Alain]

Hi @True_Origin, 

It sounds like you need a system that can sync inventory in real time across both stores, prevent overselling, and handle unit vs. case sales dynamically. Qoblex (formerly Stock&Buy) is designed for this—it ensures accurate stock updates across multiple sales channels, manages BOM for unit/case tracking, and keeps everything in sync without manual adjustments. Would you be open to trying it out? Feel free to book a quick demo, and we’ll help you get it sorted!