Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

change all Quantity of products at once


hawkeye050

Recommended Posts

Posted

i know this properly isn't possible, but my brother while setting up his website set all of the products on the site to 0, but he now has them in stock is there a easy way to change them all at once or does he have to change them 1 by 1 there are thousands :)

 

cheers chris

Posted

Yes you can either update them all to the same value using an sql statement along the lines of

 

update product set product_quantity = 1;

 

Or you can use a contribution called easypopulate to download a file of your products into a csv file and then after changing the values it can be uploaded to change the values.

 

Alternatively there are contributions to import stock levels from import files.

 

G

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 ======>>>>>.

Archived

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

×
×
  • Create New...