Anyone have any idea how to manage this scenario:
I need to have a database with the products in my warehouse. Each record with these fields name, price, stock, etc.
But I also need to create product packs, which inside have products from the same warehouse. The packs have their own price.
Can you think of some way to add products and packs to the invoices and that when packs are added, the list of products inside the pack appears. Any idea to manage the stocks of products when we sell a pack.
The packs are not closed therefore if I have 10 pencils in my stock, I can sell them separately or sell two packs of 5.