My zencart needs help. While entering new products I entered incorrect info for 'Product Qty Units:' field in the add new products form.

I can see that the database named ewramos_zenc1 has a table named products and a field called products_quantity_order_units.

This field currently holds a value of 1000 but needs a value of 1.

Can anyone supply SQLcode to update the field?

I'm no database guy so the help pretty much has to be 'cut and paste'.

Thanks in advance...