Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Adding 1oz weight to all products?


Recommended Posts

I don't want to have to do it by hand....


The reason behind adding the weight, is that currently MOST items have 0 weight because I do free shipping for most items. BUT, now I am installing ccgv and this contrib requires that downloads be set to true, so that when someone buys a gift certificate they are not prompted for which method they'd like to use to ship it. I believe that setting this configuration value to true causes all items with 0 weight to skip the shipping options page.


SO, now I'm getting no shipping options for all the items that are marked as 0 weight (I want to give them the option of express shipping). If anyone has a better solution I'm open to suggestions, otherwise, how do I add 1 oz weight to all my products? (except gift certificates)



Quidquid latine dictum sit, profundum viditur.

Link to comment
Share on other sites

in mysql admin run this sql command:


update products set products_weight = 0.01

or use whatever non zero value that you want to have.


then just edit your giftvouchers back to 0 weight.


I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!


Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites


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

  • Create New...