Mort-lemur Posted December 19, 2013 Posted December 19, 2013 Hi, During moving databases between stores, a few of my options to products have somehow been mixed up. Is there an easy way via an sql command to view all products that have options allocated to them and what the options are for the product? - as I dont fancy manually going through 3000+ products to find the ones that are mixed up. I know I could probably do this with easypopulate - but that seems like overkill for what I need. Many Thanks Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
greasemonkey Posted December 19, 2013 Posted December 19, 2013 Couldn't you just re-import the effected tables from your old DB?
Mort-lemur Posted December 19, 2013 Author Posted December 19, 2013 @@greasemonkey Thanks, I already tried that several times - maybe they were messed up on my old store and I didnt notice........... Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.