Post by Ozfarmer » Sun Apr 05, 2020 10:40 am

Hi Team, could anyone please me what SQL I could use in PhPMyadmin to bulk change all my customer status from 0 to 1? We are using 3.0.3.2 (not that you need that) All the best.
Last edited by Ozfarmer on Sun Apr 05, 2020 3:32 pm, edited 1 time in total.

Active Member

Posts

Joined
Wed Aug 17, 2011 7:08 pm
Location - Australia

Post by thekrotek » Sun Apr 05, 2020 1:46 pm

update customer set status = 1

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by Ozfarmer » Sun Apr 05, 2020 3:26 pm

Thanks, I appreciate your help, yes I have already had that set to 1 today, but how do I enable all the former customers in bulk?

Active Member

Posts

Joined
Wed Aug 17, 2011 7:08 pm
Location - Australia

Post by Ozfarmer » Sun Apr 05, 2020 3:31 pm

Whoops! Sorry mate, I didn't think before I typed! That's fixed it! Solved.

Active Member

Posts

Joined
Wed Aug 17, 2011 7:08 pm
Location - Australia
Who is online

Users browsing this forum: Majestic-12 [Bot] and 32 guests