I want to generate a list of discount codes (any advice appreciated for doing this) which I can then use to offer free shipping across the site, valid up until a specific date.

What's the best way to go about creating these discounts? I'd prefer not to have to manually create hundreds of discounts all the same except for the discount code.

1 Answer 1


Probably the most basic way to do it yourself is probably using Navicat and Excel. Create one discount that matches how you want it work. Export the SQL table to your desktop as a CSV or XLS file. Open that in Excel and duplicate the rows adjusting the code column as you want to show differences. Then import those rows back into the database. You could do it other ways, but this would be the novice ways for those with little MySQL/Php experience.

  • Thanks Parscale. I've just looked into Navicat, after your suggestion and think I'll trial it. PhpMyAdmin gets a bit tedious sometimes and I like the idea of being able to manage all of my databases from one place. Am I right in thinking there is only one table that will need editing, then? Jul 24, 2014 at 4:31
  • You should only need to edit the exp_store_discounts table. As always when making changes in the DB directly make a backup first just in case. Jul 24, 2014 at 17:17
  • This worked fine. I just used PhpMyAdmin and a CSV file. Jul 30, 2014 at 12:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.