Update Expire Date - Multiple Coupons


  • Default avatar
    peaces    
     10 years ago
    0

    I have a several thousand coupons created and need every one of the expire dates to be extended.

    Is there any way to go into the database and make the changes?
    Or
    Is there any way to export them all, make the changes and then import them?
    Or
    Other suggestions?

    Changing them one at a time will take a long time.
  • Your avatar
    seyi    
     10 years ago
    0

    Hello,

    Updating the database is your best bet:
    Table: #__awocoupon
    column: expiration

    The expiration format is in datetime, so for example "2013-07-01 14:32:52".
  • Default avatar
    peaces    
     10 years ago
    0

    Thanks Seyi,

    I also realized that I could run a report, save as .csv.
    Then change the dates in the .csv.
    Delete the specific coupons from the coupon area and then upload the changed .csv.

    Is this also viable or would it create problems?
  • Your avatar
    seyi    
     10 years ago
    0

    You cannot edit with an import, only add new.

    So yes, you could do it, but you would first have to delete the coupon codes you are importing. You would loose customer history of the specific coupons by doing this.
  • Default avatar
    peaces    
     10 years ago
    0

    Understood... Thanks