Post by misdirekted » Tue Jan 31, 2017 1:08 am

Hi! I was wondering if anybody could tell me how I can bulk update all of the expiration dates on our site's coupon codes? My manager has a tendency to create custom codes for different customers, and now we have over 1500 codes that she wants to make sure will not expire, but they all have different expiration dates that are coming up soon. Is there a way to change all expiration dates to the same date in year 2020 or something? Thank you!

Newbie

Posts

Joined
Tue Jan 31, 2017 1:05 am

Post by thekrotek » Tue Jan 31, 2017 1:18 am

The fastest way is to update it via database, using PHPMyAdmin:

Code: Select all

UPDATE `oc_coupon` SET date_end = '2020-01-01'

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


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by misdirekted » Tue Jan 31, 2017 1:23 am

thekrotek wrote:The fastest way is to update it via database, using PHPMyAdmin:

Code: Select all

UPDATE `oc_coupon` SET date_end = '2020-01-01'
Wow thanks so much! Talk about a fast response - much appreciated :)

Newbie

Posts

Joined
Tue Jan 31, 2017 1:05 am
Who is online

Users browsing this forum: No registered users and 41 guests