Instead of updating hundreds of items individually to a minimum weight is there a trick to doing it site wide?
Example: all 1oz items become 3oz.
Thank you in advance.
Instead of updating hundreds of items individually to a minimum weight is there a trick to doing it site wide?
Example: all 1oz items become 3oz.
Thank you in advance.
Cheers!
v2.0+
SQL:
... assuming all your weights are only in oz and NOT in lbs. If you're using another weight formula, change the numbers accordingly.Code:UPDATE products SET products_weight=3 where products_weight=1;
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Couple of ways...
One shot deals would use sql statements.
Could be entered into the install sql script field provided in admin panel tools. Remember though that weights are entered as either lbs or kgs, so the appropriate conversion factor should be applied to address the weight(s).Code:update products set products_weight=3 where products_weight=1
Another is to use a tool such as EasyPopulate or apsona. Those may require other prerequisites to be met to work for you.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Thanks for sql patch it worked!
Cheers!
v2.0+
Bookmarks