[UPDATED] Export/Import tool for OpenCart 1.4.9

Hi, is there any news regarding multi-language version or version that allow append insted deleting old data? (for 1.4.9.x)

Thanks!

_x000D_

Anyone with this error..
I don't know if this is the correct way to fix this but here's what I did:

find all: "_x000D_"
replace all with: "<br>"

save as xls

Fixed..

I have just installed this wonderful tool on my opencart version 1.5.5.1 but unfortunately get this error when I try to download.

Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/share/pear:/usr/share/php') in /home1/mywebsite/public_html/admin/model/tool/export.php on line 2469

Not sure how to proceed, any help out there ?

EDIT !
Oooops silly me !
I forgot to put the system files in the PHPExcel folder, that was the problem.
Happily downloading now !

Can I use this to export products from 1.4.9 and then reimport them into a 1.5.6 OpenCart installation?

knight_47 wrote:Can I use this to export products from 1.4.9 and then reimport them into a 1.5.6 OpenCart installation?

Yes, you can. But bear in mind that formats of the worksheets are different between 1.5.6 and 1.4.9 versions of the Export/Import tool, so you'd have to copy and paste the old spreadsheet columns to the corresponding new ones first before Import.

Hi I'm new to OpenCart so don't be mean

Just started using this very useful tool and it has worked fine the first few times. Only now when i try to export the Spreadsheet, i receive an internal server error (500), and the opencart error log is blank. Do you know how i can fix this?

Thanks

TobyTheFox wrote:Hi I'm new to OpenCart so don't be mean

Just started using this very useful tool and it has worked fine the first few times. Only now when i try to export the Spreadsheet, i receive an internal server error (500), and the opencart error log is blank. Do you know how i can fix this?

Thanks

Welcome to OpenCart! To answer your question, first thing to do is to inspect the server's error_log (ask webhost for it), and OpenCart's system/logs/error.txt. It could be a timeout issue, but this is just a guess without seeing the log entries.

Installed Export/Import tool today (opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-9.zip). when trying to export I get the error: When I have changed the settings an click "Update Settings" nothing happens. The changes will not be saved.

thbr02 wrote:Installed Export/Import tool today (opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-9.zip). when trying to export I get the error:

Code: Select all

Option value 'svart --> L' is defined multiple times within its option!
In the Settings-tab please activate the following:
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'

When I have changed the settings an click "Update Settings" nothing happens. The changes will not be saved.

Sorry, wrote this at the wrong place..... I did not see the OC version 1.4.9

I am unable to reproduce your problem. If you send me a PM with your OpenCart and FTP login details I am happy to take a look at it.

JNeuhoff wrote:In file admin/model/tool/export.php, in function
populateProductsWorksheet, after the line containing

$storeIds = $this->getStoreIdsForProducts( $database );

add this:

$database->query( "SET SQL_BIG_SELECTS=1" );

This doesn't help for version 2.26. I asked couple times the developer through their website where to insert that line in the code, but with no answer.

Can anybody help? I have opencart 1.5.6.4, the tool worked initially, when there was less than 500 products, Now I have 800 and the error appeared.