Export/Import tool for OpenCart 1.5.0.x

The files are slightly different from one version to another. Check the file headers carefuly and you'll see them.

The spreadsheet columns are slightly different between the 1.4.9.x and 1.5.1.x versions of the Export/Import tool. You'llhave to copy and paste the columns from the old to the corresponding new spreadsheet. Also, use XLS, not XLSX file format.

Is anyone else having trouble importing options? I am using 1.5.1.1 and as far as I can tell the export is fine but on import the options change.

Exported:
Option - Size/Colour. Type - select. Value - 12/14 Blue
Imported:
Option - Size. Type - select. Value - SML

This seems very random. Mostly it knocks out an entire option which then affects every product that option applies to, and it replaces it with one other option value all the way through. The replacing value is not usually from the same option group either.

Any help or advice would be appreciated thanks!!

ccM wrote:Is anyone else having trouble importing options? I am using 1.5.1.1 and as far as I can tell the export is fine but on import the options change.

Exported:
Option - Size/Colour. Type - select. Value - 12/14 Blue
Imported:
Option - Size. Type - select. Value - SML

This seems very random. Mostly it knocks out an entire option which then affects every product that option applies to, and it replaces it with one other option value all the way through. The replacing value is not usually from the same option group either.

Any help or advice would be appreciated thanks!!

Try the latest Export/Import tool from http://www.mhccorp.com/opencart/export-import-tool

Thanks for the suggestions guys. Upon investigating I found the difference between the two versions of the files and copied and pasted my info into the proper locations in the new version of the export file. I re-ran the import and it worked fine.

Hi,

I'm currently changing from a zencart site to a OpenCart Site.

I've found and installed this module ok and can get it working up to around 2000 products ive tired changing the php.ini and .htaccess file.

So i thought id split my 5000 products down and do them in 3 batches.

However when i upload the second batch it deletes the 3rd, is their anyway to stop this module deleting all the data before it runs?

Thanks.

ccM wrote:Is anyone else having trouble importing options?

Yes, mine is acting weird, too.
Everything imports and exports correctly, options are listed and can be changed in the admin section, but they do not appear in the front-end.
Only the drop-down "Please select" menu appears without the available options.
I downloaded and installed the latest version of Import/Export, using OC 1.5.1.3.

JNeuhoff, what might be the problem?

misscaprice wrote:

ccM wrote: Everything imports and exports correctly, options are listed and can be changed in the admin section, but they do not appear in the front-end.
Only the drop-down "Please select" menu appears without the available options.
I downloaded and installed the latest version of Import/Export, using OC 1.5.1.3.

JNeuhoff, what might be the problem?

Send me a PM with copy of your XLS file you tried to import, and I take a look at it.

I assume you are using the latest Export/Import release? Because I did a fix with for the options just a few weeks ago.

I just looked at it, and it imports just fine.

I think the reason why you don't see the options on the frontend is because you have them set to 'subtract'=true while the 'quantity'=0. If you don't need stocklevel tracking for your options, use 'subtract'=false, and the options will show up just fine on the frontend.

Yes, there was the issue. Everything works just fine now.
The spreadsheet used to work very well with previous version of OC. If it weren't you, I would never have thought this may be the reason.

My Mistake, problem fixed

I'm having problems with options. I'm running a fresh install of ocart 1.5.1.3 and a copy of the import/export tool that was downloaded today (12/16/12). I added about a hundred products via the spreadsheet and imported them into the install, everything seems correct except the options. When I go to edit a product that was added via the tool there are no options applied to it at all. When I export, they are still now shown.

What am I doing wrong?

Thanks,
Clay

Just kidding, looks like it was a stupid mistake on my part.

I love this tool!

Thanks to teratyke for this post

http://forum.opencart.com/viewtopic.php ... 78#p185778

It fixed my export problem which suddenly just appeared. Must be a size thing.

Thankyou again.

Paul.

PS I don't know what I would do without this tool. It is fantastic.

I have a question about this great tool.
In products tab there is a column that is for the number a products i visit.
How can i do to not reset this. Can i set this to blank?

And one more question.
I have bought a modul "spec tab", how can i insert this to my import/export tool?
It would be so great to insert all the spec in the csv file.

Thanks!

Xciso wrote:I have a question about this great tool.
In products tab there is a column that is for the number a products i visit.
How can i do to not reset this. Can i set this to blank?

And one more question.
I have bought a modul "spec tab", how can i insert this to my import/export tool?
It would be so great to insert all the spec in the csv file.

Thanks!

As regards the 'viewed' column: I think this should indeed be preserved in the DB, will change that in a coming release of the Export/Import tool.

As regards the spec tab: I assume you are talking about additional field in the 'product' table and the corresponding 'Products' worksheet. Take a look at the admin/model/tool/export.php,especially the functions populateProductsWorksheet, uploadProducts and storeProductsIntoDatabase, these are the functions that need to be expanded to support additional product fields.

Is there any chance I can use categories name instead of categories IDs in the import file?

Lao wrote:Is there any chance I can use categories name instead of categories IDs in the import file?

Unforunately, no. Category IDs are needed.

Thank you for quick replying.

Hi,

I'm using OC 1.5.1.3. Exporting seems to be working fine but I keep getting an error when I try and import:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,0,'1','1','0','1')' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`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`) VALUES (214,1,'','','',5,'282',12,'data/products/214.jpg',1,433.55,0,'2007-09-20','2012-01-05 16:18:32','2012-01-01',0,1,1,9,,0,0,0,'1','1','0','1'); in /var/www/opencart/system/database/mysql.php on line 49

Can you help please?

rendered wrote:Hi,

I'm using OC 1.5.1.3. Exporting seems to be working fine but I keep getting an error when I try and import:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,0,'1','1','0','1')' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`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`) VALUES (214,1,'','','',5,'282',12,'data/products/214.jpg',1,433.55,0,'2007-09-20','2012-01-05 16:18:32','2012-01-01',0,1,1,9,,0,0,0,'1','1','0','1'); in /var/www/opencart/system/database/mysql.php on line 49

Can you help please?

Looks like the field 'viewed'hasn't been filled in in your spreadsheet.

As I said, the next version will remove this column from the worksheet,as it shouldn't be overwritten i the database by the Import.