Weight SQL mass change for music products (vinyl, CDs, tapes) - already solved

[wcbutler]

Hey all,

I've been asking a lot of questions here so wanted to provide something back if its helpful.

I run a music retail website and switch to the USPS module so I needed to get my weights all fixed so I wrote a few SQL statements to fix that.

PLEASE NOTE - this may not work with your site, so please rather than running these look at the logic

PLEASE NOTE - if you're not familiar with SQL I highly suggest you not doing this.

I posted the work as a Gist -
https://gist.github.com/wcbutler/9a6...03dbebd4e7134f

Hopefully this is helpful for someone, if not at least its more info out there.

[swguy]

thanks for sharing with the community.