Best inventory extension for complex situations (assembled products)?

Hi! We're considering migrating to OpenCart, and I'm looking at wether it can handle our complex inventory structure, i.e. assembled products. A few questions:

#1 We sell roller skates which we assemble from parts that we also sell on their own. So when a pair of skates with a particular wheel option sells, we need the stock of that wheel standalone product to also be subtracted from, and all the Option stock for any other skates offered with those wheels as well. This would be best handled by an extension which allows us to "build" products from other products. Does that exist?

#2 Is OpenCart (or an extension) capable of inventory control based on combinations of Options? i.e. a roller skate that has 3 Option menus: Size, Plates, and Wheels. If I end up having to use an external inventory management system. I'll need to be able to set the stock quantities for specific Size, Plates, and Wheels combinations. Is that possible?

Thanks!

1. Add product with options, such as size, plates and wheels.
2. When roller skates sold, roller skates and selected options inventory will be subtracted.

FutureMarmoset wrote: ↑

Fri Dec 22, 2023 7:10 am

Hi! We're considering migrating to OpenCart, and I'm looking at wether it can handle our complex inventory structure, i.e. assembled products. A few questions:

#1 We sell roller skates which we assemble from parts that we also sell on their own. So when a pair of skates with a particular wheel option sells, we need the stock of that wheel standalone product to also be subtracted from, and all the Option stock for any other skates offered with those wheels as well. This would be best handled by an extension which allows us to "build" products from other products. Does that exist?

#2 Is OpenCart (or an extension) capable of inventory control based on combinations of Options? i.e. a roller skate that has 3 Option menus: Size, Plates, and Wheels. If I end up having to use an external inventory management system. I'll need to be able to set the stock quantities for specific Size, Plates, and Wheels combinations. Is that possible?

Thanks!

Might want to look in the marketplace for something like chained options etc. Here is one: https://www.opencart.com/index.php?rout ... n_id=14468

There are others but you know your requirements best and you'll need to see what works for you.
I'd be interested to know what you come up with as a solution if you decide to move forward with Opencart.
Mike

I think the Product Option Switcher should do that.

This could possibly be a Solution for you:
https://demo.opencartbot.net/catalogue/

Thank you all for the help!

I looked at your recommendations and I don't think any of them do what we need, but close!

Here's an example of what we need it to do:

Product 1 (component)
Red roller skate wheels

Product 2 (component)
Blue roller skate wheels

Product 3 (component)
REDS Bearings

Product 4 (component)
KWIK Bearings

Product 5 (assembled product)
Super roller skates (pair of complete skates)
Parts:
- Boots
- Wheels
- Bearings
Options:
- Boot color (2 choices, black or white)
- Wheels (2 choices, Red or Blue)
- Bearings (2 choices, REDS of KWIK)

So product 5, the complete skate, is made of products 1, 2, 3, and/or 4 depending on the chosen options, and it's also made of a boot which comes in 2 colours (2 inventories) but are not sold on their own, just in complete skates (not visible on the front end, but has inventory control on the back end). The bearings and wheels however are also sold on their own. So, not only do we need chained options to specify stock quantities based on option combinations, we also need the inventory to sync across products. i.e. when we sell a skate with blue wheels and REDS bearings, we need the inventory of the wheel and bearing products to also be adjusted. And vice-versa: when we sell a set of blue wheel on their own, we need the inventory for the complete skate with the blue wheel option to be adjusted.

Options Combinations (or a similar chained option system) is similar to what we have in our current shopping cart, and it works but it requires an external database to hold the recipes for the assembled products, and sync the inventory across the many products.

Products Option Switcher seems to be more about navigation than inventory control. From what I read, all it does is redirect the user to another product page based on a menu selection.

Spare Parts Catalogue also appears to be more about the user interface to help the user find the right part for a given device. Very cool, but not actually what we need, unless the back end is rigged to do the component/assembled products inventory control. I didn't see any signs of it doing that in my perusing, but I could be wrong.

I'll take a look at other option chaining systems, maybe I missed the right one.

Any more help and recommendations are greatly appreciated!

I found this one:
Product Components

It sounds like it does what I need, but it doesn't seem very popular, and it's entirely in Russian. Isn't there a mainstream version of something like this?