Missing "Minimum quantity"

[avrilev]

 

Hello guys,

 

I some products on my store, the field "minimum quantity" is missing (under Quantities on the left menu bar).

 

It shows in other products.

 

How can I restore this field in those products where it's missing.

 

Thanks a lot,

 

Avri

[NemoPS]

I think it's because you have combinations, you can setup minimum quantities for each of them from the combinations menu

[avrilev]

I think you're right!

Thanks.

 

BUT...

and this is a long one....

 

In my site, which deals with orthodontic products, there are some products with their combinations that shoot well over 100 items... One of my products has 496 combinations...

 

I need to set a minimum quantity for those items because I sell them in packs of 4 items each.

No one with a bit of sanity in his brain will go and edit 496 items one by one...

 

So is there anyway doing it by code? Or any other way...

Edited September 27, 2013 by avrilev (see edit history)

[NemoPS]

you can try with a SQL query, do you know a bit of SQL? What's your table prefix? Product id?

[avrilev]

Yes I know MySQL. 

 

I just thought that there is another way...

[NemoPS]

As far as I know, no!

 

You could try with update ps_product_attribute SET minimal_quantity = your_number where id_product = your_product_id

 

Fabio

[mysterion]

@avrilev

 

Sorry for opening an old post but I have the exact same requirement. Did you ever find a workable solution for this?

 

Thanks - David

Edited July 14, 2015 by mysterion (see edit history)