How to have one product affect multiple inventories

[RBCEric]

Hi,

I have a website where the products are classes and people can sign up for 1, 2, or 3 times per week. I have limited space in each class, so I need to know if someone signs up for Monday/Wednesday, I decrement those slots by 1 but still have capacity for Friday. So, if M/W fills up, I still want to offer the 1x for Friday if space is available.

I’ve tried playing around with some of the add-ons, but I don’t see a way I can have one product affect the inventory of other products, or have one product have multiple quantities to it and deduct appropriately (the shirt/size/color model is close though) Can this be done with the eCommerce plugin? I’m pretty sure I could do it with some custom code but I’d prefer to avoid that if possible.

Thanks!

-Eric

[wzp]

Let us imagine the following:

• You have 3 (class) products: Monday, Wednesday & Friday
• Each product has an inventory count of 10 (seat) units.
• You also have 3 (multiple session) bundles: Mon+Wed and Mon+Wed+Fri

  https://www.tipsandtricks-hq.com/ecommerce/how-to-configure-a-packaged-product-using-the-existing-products-262

 

I believe (you’d have to double check with a test) that as the bundled (class) products are sold, the individual (class) product inventories will go down accordingly.

[RBCEric]

Hi wzp,

I just checked and the individual item quantities that are part of the bundle do not decrement. In the test I just did, I selected a single day class and also a 2 day class. The plugin reported that the 2-day class was selected/paid, but it didn’t adjust the quantities of the individual days.

[admin]

The inventory of the bundled product will be affected ONLY. If you sell product ID 3 then the inventory of product ID 3 will be updated (otherwise there is more complication).

If you need to limit your inventory then limit the inventory of this bundled product. If you need to count inventory separately then count the bundled ones separately.

In your case it is best to not use any bundled product. Let them buy 1, 2 or 3 classes. Whatever they want to buy they can. They just add the items to their cart (they can add each class they want to the cart) then do a checkout. You are using the add to cart type buttons right?

[RBCEric]

Correct, the inventory of the bundled product was adjusted. For example, product id 12 has product ids 9 and 10. In my test, only 12 was incremented, not 9 and 10.

I think you’re right, don’t use bundle products. I’ll do separate entries for M/W/F and let people select which ones they want.

And yes, that was using the add to cart buttons.

Thanks again!

[Author]

Posts