Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adjusting all products weight


shfifty

Recommended Posts

Posted

Hello, Im somewhat new to osCommerce and I had a Question about products weight. I have about 28,000 Products and each has the weight of 0.00lbs is there a fast way of adjusting the weight? There is just way to many products for me to go thought one at a time. Im trying to get my shipping to be more accurate.

 

Thanks for your help in advanced!!! :thumbsup:

Phil

Posted

Install the contribution easy populate.

 

Export your catalog as a csv file.

 

Update the file with the wts it in excel or other editor.

 

Import it back onto your site.

 

There are other ways but need a bit more techie knowledge

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

Posted

Are these products already in your store? Are these the only products in your store?

Do you have and know how to use any database manager, such as one that may be supplied to your account by your web host?

 

Using the SQL code below on your database will change EVERY weight to 0.00

update products set products_weight = '0.00'

I suggest that you test first by changing only one row and doublechecking. And don't forget to BACKUP, BACKUP, BACKUP.

update products set products_weight = '0.00' LIMIT 1

For ALL problems, please review this link first -> osCommerce Knowledge Base

Archived

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

×
×
  • Create New...