How to perform bulk import of coupon codes? Getting error code 1054.

[rmickus]

I am trying to figure out how to import a bulk number of coupons as we get ready for an upcoming GroupOn special.

Based on the forum articles I have read, I understand that this can be accomplished by importing a new file into the "coupons" table.

I have been trying to test this out and I keep getting the following error message:

#1054 - Unknown column 'A' in 'field list'

Does anyone have any suggestions on how to overcome this error?

Thanks....from a new non-technical zenner...

[kobra]

What are you trying to upload and what are you using to do so?

I mean the actual sql content as your error indicates a not found for column "A"

[rmickus]

I exported the "coupons" table using phpMyAdmin and specified the file format type to be "Excel 97-2003 XLS Workbook". I then opened this file on my computer using Excel, and performed a copy of one of the rows in the spreadsheet and then editted the new row in order to create a new coupon code. I then saved the file and used the import feature on phpMyAdmin to try and upload, but it keeps generating the 1054 error message. I also tried to export in an Open Office format (ODS) and then import the ODS file back, but this results in yet another type of error message.

[kobra]

I exported the "coupons" table using phpMyAdmin and specified the file format type to be "Excel 97-2003 XLS Workbook

I could not get that to work either
But exported as a sql in proper format just the coupon table and edited in a code editor and this was a success

[rmickus]

Thanks for the suggestion. I exported the coupons table as an SQL file and then added a new record into the file and imported it back as an SQL file......and now it's giving me the following message:

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0001 sec )

Thanks for any further suggestions....

[kobra]

Post yoour edit to the sql

Here is what I did with success

-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`) VALUES
(1, 'F', '892a088998', '10.0000', '20.0000', '2010-11-11 00:00:00', '2011-11-11 00:00:00', 100, 1, '', '', NULL, 'Y', '2010-11-11 16:32:39', '2010-11-11 16:32:39', 0);
INSERT INTO `coupons` (`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`) VALUES
(2, 'F', '892a088999', '20.0000', '40.0000', '2010-11-11 00:00:00', '2011-11-11 00:00:00', 100, 1, '', '', NULL, 'Y', '2010-11-11 16:32:39', '2010-11-11 16:32:39', 0);

[rmickus]

Here's the SQL code for what I am trying to do. I am using the import function on phpMyAdmin. Should I perhaps be using a different method?

INSERT INTO `coupons` (`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`) VALUES
(1, 'F', 'datz15', '15.0000', '45.0000', '2009-08-08 00:00:00', '2010-08-08 00:00:00', 0, 1, '', '', NULL, 'Y', '2009-08-13 18:33:34', '2009-08-13 18:33:34', 0),

[rmickus]

One other thing.....I noticed on the import options that there is a drop-down menu for the field called "SQL Compatibility Mode". It is currently set to "NONE". Do I perhaps need to select something different here?

[kobra]

You are missing the ending semi-colon

INSERT INTO `coupons` (`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`) VALUES
(1, 'F', 'datz15', '15.0000', '45.0000', '2009-08-08 00:00:00', '2010-08-08 00:00:00', 0, 1, '', '', NULL, 'Y', '2009-08-13 18:33:34', '2009-08-13 18:33:34', 0), 

[rmickus]

Ahhh, thanks for catching this. So, I was able to successfully execute the below SQL insert command under the SQL tab of the phpMyAdmin (i.e. not the import tab).

The message indicated that a new row was successfully inserted.

However, when I go to my ZenCart admin portal and look under the coupon admin section, I don't see the new coupon listed. Do you know if there is perhaps something else that also needs to be done, such as making an insert into the coupons_description table?

INSERT INTO `coupons` (`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`) VALUES

(26, 'G', 'groupon01', '50.0000', '0.0000', '2010-09-23 00:00:00', '2011-09-23 00:00:00', 0, 0, '', '', NULL, 'Y', '2010-09-23 13:06:02', '2010-09-23 13:06:02', 0);