0

The scenario is as follows:

Product A, SKU 1000, sold as 1 roll of 1000 meters of cable, price 800 euro Product B, SKU 1000, sold per meter of cable, price 1 euro

Those products should share the same inventory, if one piece of product A is sold, the available quantity of both products should be reduced automatically (product A by 1, product B by 1000). If 500 pieces of product B are sold, the available quantity of both products should be reduced automatically (product A by 1, product B by 500).

So its like this: multiple products, same SKU, different units, same inventory.

I am working with Magmi to import products into Magento so I think using a 3rd party plugin is not an option here. Whats the best solution in this case? I have done quite some research but haven't found how to tackle this issue.

Thanks in advance,

Hope to hear from you

2

Here are my 2 cents. Since A & B have the same SKU and should share the same inventory, why not make it a single product?
This way the stock is reduced correctly when you buy X meters.
If the price for product A is not 1000 * price of B then you can easily manage this with tire prices.
Create a tire price where customer group is ALL GROUPS and Qty is 1000 and set the appropriate price.
The prices should be per meter.

  • Hi Marius, thanks for the reply. Yet I dont understand how I can let the customer make a choice between meters and roll. Should I look at configurable products then? – Joost Mattheijssen Nov 8 '13 at 15:53
  • You don't let them choose. Just add a message in the product description saying 1000m = 1 roll. and if they want a roll they fill in 1000 for qty. – Marius Nov 8 '13 at 19:27
  • I have implemented it like this and it works fine. Thanks for the advice! – Joost Mattheijssen Nov 11 '13 at 12:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.