Export/Import tool for OpenCart 1.5.0.x

The Export/Import tool is now available from the usual OpenCart extensions section, or from
http://www.mhccorp.com/opencart/export-import-tool

Hi

Export works fine

however when importing I get this error

Notice: Undefined index: 13 in /home/*****/public_html/shop5/admin/model/tool/export.php on line 873Error: 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 '74,13,64,0,0,0,'',0,'',0.00,'')' at line 1
Error No: 1064
INSERT INTO `product_option_value` (`product_option_value_id`,`product_option_id`,`product_id`,`option_id`,`option_value_id`,`quantity`,`subtract`,`price`,`price_prefix`,`points`,`points_prefix`,`weight`,`weight_prefix`) VALUES (11,,74,13,64,0,0,0,'',0,'',0.00,'');


Thanks
Ronnie

Send me a PM with your exported XLS file, and I take a look at it.

ronnieb wrote:Hi

Export works fine

however when importing I get this error

Notice: Undefined index: 13 in /home/*****/public_html/shop5/admin/model/tool/export.php on line 873Error: 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 '74,13,64,0,0,0,'',0,'',0.00,'')' at line 1
Error No: 1064
INSERT INTO `product_option_value` (`product_option_value_id`,`product_option_id`,`product_id`,`option_id`,`option_value_id`,`quantity`,`subtract`,`price`,`price_prefix`,`points`,`points_prefix`,`weight`,`weight_prefix`) VALUES (11,,74,13,64,0,0,0,'',0,'',0.00,'');


Thanks
Ronnie

I think I found the bug. Just fixed it, install and try again, it should work now.

Well go into the export tool and find where it is writing export list and in the sql string find the extra , in front of the 7 and remove and that should fix. 12 fields i counted if there 13 look for a miss spelll or somethingb. That is my best gueees.

If u do have 13 it is not pulling tghe daata product option id

Hi I uploaded the vqmod folder, but nothing seems to have happened. There was no 'tool/export' in the Top Admin User Group

hellogoodbye wrote:Hi I uploaded the vqmod folder, but nothing seems to have happened. There was no 'tool/export' in the Top Admin User Group

do you have vqmod installed? It's a seperate mod from this one you have to install it first before any vqmod scripts will work.

I believe so. I had to manually add the vqmod code into index.php and admin/index.php because it couldn't find the auto installer.

edit: just went back over to the vqmod thread, saw the host and redownload fixes so let me try those first and i'll post back.

i had trouble installing this in 1.5.0 with the vqmod and my vqmod files are up to date.

Instructions do not explain that you should still copy over the system and tools files.

If you manually add the language and variable data, it works fine.

SXGuy wrote:i had trouble installing this in 1.5.0 with the vqmod and my vqmod files are up to date.

Instructions do not explain that you should still copy over the system and tools files.

If you manually add the language and variable data, it works fine.

wait, so we still need to upload the admin and system folders? The instructions made it sound like all I needed to upload was the VQmod folder if I have VQmod installed.

no vqmod just handles the core files that get changed. Any new files still have to be uploaded. It is that way with every module. vqmod cannot create new files it only modifies existing ones.

Xsecrets wrote:no vqmod just handles the core files that get changed. Any new files still have to be uploaded. It is that way with every module. vqmod cannot create new files it only modifies existing ones.

when you say no, you mean, yes (for other folders)? Thanks for the newbie explanation. Uploaded the other 2 folders. and SXGuy's help

I've got a problem with the attributes. I added the attributes in the admin inside an attribute group, but when I edit the XLS and connect the attributes with products, these are not imported. Is this correct?

extigo wrote:I've got a problem with the attributes. I added the attributes in the admin inside an attribute group, but when I edit the XLS and connect the attributes with products, these are not imported. Is this correct?

Send me a PM with your XLS filewhich has the Import problem with the attributes, and I takle a look at it.

The problem with the attributes has now been fixed.

Thnx JNeuhoff, it is working like a charm now!

Just run the process following it to the letter - on 1.5x
Now have an admin screen that is "text_logged" and no options appearing on it apart from home & dashboard overview & latest 10 orders
Please advise where it's gone wrong asap!

Resolved - re-loaded the entire install for 1.5x and then loaded the import / export tool - quicker than waiting for a response on here lol
Next query - where do you find the export / import tool once you have ticked the boxes?

Under configuration