Zen Follower
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?
Zen Follower
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).
Sensei
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
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Zen Follower
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!
Tell staff why this post should be reviewed.