mg3ddesign Posted July 8, 2012 Share Posted July 8, 2012 Hi there I'm trying to change all my products so that they have an updated date, this is so that google can see the site map better and have a date rather than 0000-00-00 00:00:00 I know that all new products have a date but I have over 500 older products that don't. I have tried exporting, changing it in excel then importing but the date is not imported. Does anyone know how I can bulk change the dates using a MySQL command in the admin section. Thanks Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 8, 2012 Share Posted July 8, 2012 I use this query format to make those kinds of changes, but I DO NOT know if there's a better way to do what you want. Be sure to back up your database before trying it. UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); Quote Link to comment Share on other sites More sharing options...
mg3ddesign Posted July 8, 2012 Author Share Posted July 8, 2012 Very Helpful, thank you. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 8, 2012 Share Posted July 8, 2012 Hope it works for you. Please let us know if that solves your problem. Quote Link to comment Share on other sites More sharing options...
mg3ddesign Posted July 8, 2012 Author Share Posted July 8, 2012 Yes that solved the problem Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted July 8, 2012 Share Posted July 8, 2012 Great! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.