I'm using Open Cart 1.4.9.1 in combination with the import/export extension.
It works fine except for one thing.
When i import the excel file i get the folowing error:
Code: Select all
Error: Column count doesn't match value count at row 1
Error No: 1136
INSERT INTO `opencart_product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`,`cost`) VALUES (1,1,'0','0',5,' ',19,'data/Abus_1958g.jpg',1,83,95,'2010-12-30 13:57:21',NOW(),'2010-12-30 13:57:21',0,1,1,0,0,0,0,0,'1','0','1','1',0);
When I place the price between quotes like this '83,95' the import works, but the number turn into 83,00.
This happens with al the prices.
When i copy the data in the excel sheet, the column has the correct format: ######0,00.
I tried it as character/text and as number but that doesn't mather.
When i use the export function en change the values afther the comma, the import works fine.
I think it has something to do with the copy of the data from one sheet to the other.
Could someone help me with this problem?