Successfully installed Export/Import on version 0.7.7, export to spreadsheet, update data, and tried to import and I am getting this error:
- I also verified all installation against PDF documentation:
Error: Unknown column 'Array' in 'field list'
Error No: 1054
INSERT INTO `product_to_image` (`product_id`, `image_id`) VALUES (1,Array), (2,Array), (8,Array), (13,Array) ;
Any thoughts?
Can you send me a copy of your spreadsheet file so I can take a look at it? Perhaps there were errors when you edited your spreadsheet.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
See attached for export with no modifications.....
Thanks, I downloaded your attachment and will take a look at i tomorrow morning.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
There were 2 columns missing in your 'products' worksheet:
'special
offer'
and
'featured'
When I inserted them (they are only being used with OpenCart's extension from http://www.opencart.com/contribution/in ... tion_id/27 installed, but are always required in the worksheet) it worked fine.
Are you sure you using the latest version of the Export/Import module?
Anyway, I attach corrected spreadsheet file to this message.
'special
offer'
and
'featured'
When I inserted them (they are only being used with OpenCart's extension from http://www.opencart.com/contribution/in ... tion_id/27 installed, but are always required in the worksheet) it worked fine.
Are you sure you using the latest version of the Export/Import module?
Anyway, I attach corrected spreadsheet file to this message.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Also, please make sure that your products always belong to at least one category, which is not the case with OpenCart's default database. I may apply a fix to the Export/Import module to make sure the module will also work when a product doesn't belong to any category.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 3 guests
