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);