resetting all product minimums to zero

[smap]

Hello.

I'm trying to find a way to reset all product minimums to zero (disable product minimums) without going in to each and every product in the site.

I was thinking at least there should be a way to do with with a SQL statement unfortunately I can't write it myself. :)

Does anyone know of a way to do this?

Thanks

[Parafanaylya]

Hi

If you want to display the products when there is no stock, there is a setting in admin->configuration->stock

Products status in Catalog when out of stock should be set to

and if you select 1 (default 0), the product status will remain on

How to write sql queries is not my forte'

[smap]

If you want to display the products when there is no stock

Not exactly but thanks. The client I'm building the site for initially wanted minimum purchase quantities on most products. They've since changed their mind and now want to allow shoppers to order 1 (or more of course) of any product.

I'm looking for a way to 'get rid of' or disable product minimum purchase quantites without revisiting every product in the store.

[Parafanaylya]

This is something that I'm waiting for in an easy populate module that's due for release quite shortly (hopefully), as I have hundreds of products with min quantities that need editing

[smap]

Well it was actually pretty easy using phpMyAdmin if you have access to that.

I went to the SQL tab and used the interface to build the query:

SELECT *
FROM `products`
WHERE `products_quantity_order_min` >1

I then checked all the resulting rows, selected Edit, then used Firefox's search to continually find products_quantity_order_min and change it to 1.

Took only a few minutes and everything seems OK.

Of course I backed up the database first. :)

[Parafanaylya]

That's pretty cool, but I have the following to do:

x no of products min qty 50
y no of products min qty 72
z no of products min qty 24

as a wholesaler, I don't want people buying 3 of the product, and if they do buy, they must buy in units eg, 50 or 100, nothing in between. I don't know how to do SQL queries.

parafanaylya

[smap]

That's pretty cool, but I have the following to do:

x no of products min qty 50
y no of products min qty 72
z no of products min qty 24

as a wholesaler, I don't want people buying 3 of the product, and if they do buy, they must buy in units eg, 50 or 100, nothing in between. I don't know how to do SQL queries.

parafanaylya

phpMyAdmin doesn't require you to write any SQL by hand. It has a point-and-click interface that basically does it for you. Of course your web host must have it installed or at least support it for this to even be an option.

The method I used would only be useful to you if you could query the database based on existing product categories. Select all products in category X, change all min qty to 50. Repeat for Y and Z with 72 and 24 min qty respectively.

In my situation, resetting all min qty to 1 ... it seems to do the trick.

[Parafanaylya]

I understand what buttons to push, but don't understand what's happening. I've gone to the SQL tab in products, checked the relevant products, double clicked the fields into the query box and I get this answer:

SQL query: Documentation

SELECT *
FROM `zen_products`
WHERE 1 `products_quantity_order_min` >24 `products_quantity_order_units` >24
LIMIT 0 , 30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'products_quantity_order_min` > 24 `products_quantity_order_unit

[smap]

SELECT *
FROM `zen_products`
WHERE `products_quantity_order_min` >24
AND `products_quantity_order_units` >24
LIMIT 0 , 30

There was a "1" (inserted automatically by phpMySqlAdmin) in your code and also I think you need an AND inbetween the 2 qualifiers.

I also had to change 'zen_products' to 'products' for my table name, but otherwise the code above is cut-and-paste from a successful query for me.

[Parafanaylya]

I'm getting really close to cracking this. My query reads:

Code:

SELECT *
FROM `zen_products`
WHERE `products_quantity_order_min` >24
AND `products_quantity_order_units` >24
LIMIT 0 , 30

but, it's not picking up the products I've selected with the checkboxes. The LIMIT 0, 30 are obviously the product by page, but how does it see the selected products in the query, i.e. what should the query read eg

product id 1 to 23 to have the values

products_quantity_order_min` >24
AND products_quantity_order_units` >24