Coupons...mass upload

I have 8,000+ coupon codes to upload for a client.

I'm hoping there is a way to upload those codes from a spreadsheet directly into the mysql database/table.

Can anyone offer some suggestions?

I was able to import my data...but I still have a problem.

The start and expire dates are incorrect.

Is there a way through PHPMYADMIN to change each record to reflect the correct dates (I know I can change each one individually, but I need to make mass changes).

stevehare:

Is there a way through PHPMYADMIN to change each record to reflect the correct dateswhat exactly do you mean by "correct dates"? What logic is used to determine what is correct or not?

What format were the dates in before you uploaded them?

The database wants date-time values as: 2006-09-07 09:00:00

The dates were showing up in the admin as 2037-11-30.

In the db they were 0000-00-00.

I have fixed the issue...it was a format problem on my spreadsheet.

Thanks!