need child product stocked from master product stock

[simon5968]

Hi

what I'm looking for is as follows:

master product = 1 x pallet (master product) has 20 x items on it (child products) - shown as buy-able product on store front - stock level 2, 

child product = 1 x item from master product - shown as buy-able product  on store front - stock level = 40 ((2 x 20 )master product stock level = 2, master product items on it = 20),

1. example 1:
   1. sales:
      1. 1 x master product,
      2. 20 child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. 0 x child products,
   4. resulting sale,
      1. OK,
2.  example 2,
   1. sales:
      1.  0 x master product,
      2. 21 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. 19 x child products,
   4. resulting sale,
      1. OK,
3.  example 3,
   1. sales:
      1.  0 x master product,
      2. 19 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 1 x master products,
      2. 1 x child products,
   4. resulting sale,
      1. OK,
4.  example 4,
   1. sales:
      1.  1 x master product,
      2. 21 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. -1 x child products,
   4. resulting sale,
      1. no sale,
5. example 5,
   1. sales:
      1.  0 x master product,
      2. 41 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. -1 x child products,
   4. resulting sale,
      1. no sale,

it also would need to work if the pallet had boxes of 12 items in,

so then it would be master product (pallet)- child product (case) - sub-child product (item)

 

how do I get this automatically working? 

Edited December 6, 2023 by simon5968

[simon5968]

 

How much of this cannot be automated? 

What app/s extension/s would be needed? 

[simon5968]

@Ivan Holbi whats the best way?

[Ivan Holbi]

On 12/6/2023 at 2:46 PM, simon5968 said:

Hi

what I'm looking for is as follows:

master product = 1 x pallet (master product) has 20 x items on it (child products) - shown as buy-able product on store front - stock level 2, 

child product = 1 x item from master product - shown as buy-able product  on store front - stock level = 40 ((2 x 20 )master product stock level = 2, master product items on it = 20),

1. example 1:
   1. sales:
      1. 1 x master product,
      2. 20 child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. 0 x child products,
   4. resulting sale,
      1. OK,
2.  example 2,
   1. sales:
      1.  0 x master product,
      2. 21 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. 19 x child products,
   4. resulting sale,
      1. OK,
3.  example 3,
   1. sales:
      1.  0 x master product,
      2. 19 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 1 x master products,
      2. 1 x child products,
   4. resulting sale,
      1. OK,
4.  example 4,
   1. sales:
      1.  1 x master product,
      2. 21 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. -1 x child products,
   4. resulting sale,
      1. no sale,
5. example 5,
   1. sales:
      1.  0 x master product,
      2. 41 x child products,
   2. in stock levels:
      1. 2 x master products in stock,
      2. 40 x child product in stock,
   3. resulting stock levels,
      1. 0 x master products,
      2. -1 x child products,
   4. resulting sale,
      1. no sale,

it also would need to work if the pallet had boxes of 12 items in,

so then it would be master product (pallet)- child product (case) - sub-child product (item)

 

how do I get this automatically working? 

Hi Simon,

As far as we can see the following module should meet your requirements.

https://www.oscommerce.com/app/packunits

Best regards,

Ivan