Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to alter all products quantities ?


Krisz1

Recommended Posts

Hi guys,

 

I'm currently running a OsC v. 2.2 store with over 300 products, and I need to set the quantity of all my products to 100. i don't keep track of my inventory with OsC and some prods are running low warning my online customers.

 

I barely know SQL Syntax, but I know how to get to the query box of PhpMyAdmin.

 

Can anyone help me with the correct syntax to execute? I think it's simple, but I don't want to ruin my database..

 

Many thanks!

Link to comment
Share on other sites

TRy looking in the sql section of www.w3schools.com

 

It will ba alonfg the lines of

 

update products set product_qty = 100

 

If you get it wrong nothing will be updated, if you take a back up before you start ......

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...