17 Feb 2023, 3:53 PM
New Zenner
- Join Date:
- Sep 2017
- Location:
- Raleigh, NC, United States
- Posts:
- 81
- Plugin Contributions:
- 0
Weight SQL mass change for music products (vinyl, CDs, tapes) - already solved
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/9a642ac24229bc4dc403dbebd4e7134f
Hopefully this is helpful for someone, if not at least its more info out there.
