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?
Thread: Coupons...mass upload
Results 1 to 4 of 4
-
6 Sep 2006, 10:32 PM #1
Zen Follower
- Join Date
- Dec 2005
- Posts
- 108
- Plugin Contributions
- 0
Coupons...mass upload
-
7 Sep 2006, 04:00 PM #2
Zen Follower
- Join Date
- Dec 2005
- Posts
- 108
- Plugin Contributions
- 0
Re: Coupons...mass upload
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).
-
7 Sep 2006, 06:00 PM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: Coupons...mass upload
what exactly do you mean by "correct dates"? What logic is used to determine what is correct or not?
Originally Posted by stevehare
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.
-
7 Sep 2006, 06:46 PM #4
Zen Follower
- Join Date
- Dec 2005
- Posts
- 108
- Plugin Contributions
- 0
Re: Coupons...mass upload
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!
Similar Threads
-
v150 Mass Upload/Insert of Product Images
By dharris0211 in forum Setting Up Categories, Products, AttributesReplies: 5Last Post: 20 Aug 2013, 03:00 AM -
Upload products en-mass
By nkb-ltd in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 9 May 2010, 08:30 PM -
How do you mass input coupons?
By bradlawson in forum Discounts/Coupons, Gift Certificates, Newsletters, AdsReplies: 3Last Post: 11 Apr 2008, 07:24 AM -
Mass edit of coupons
By stevehare in forum Discounts/Coupons, Gift Certificates, Newsletters, AdsReplies: 4Last Post: 20 Oct 2006, 06:53 PM
