[RELEASED] Export/Import tool for OpenCart 1.5.4.x

Any import tool available from Magento Opencart, one of my websites using Magento, I want to move it to Opencart as soon as I can, Magento becomes too much commercial and I hate that. Please help!

After a lot of testing with these scripts I ended up using csv files and phpmyadmin to do my import.

myproject install the import/export module
and i import the file to complete import
also file is export.export complet the file.
open the file is error occuree.
error:- screenshort

Hello,

I have install import/export module in opencart version 1.5.5.1. when i export the exelsheet 2007 then it can be open.

It's Display error"
"Exelsheet can not open the open the file category.xlsx because file formate or extension is not valid.Veryfiy tha file has not been currepted and that the file extension mathes the formate of the file".

shahid21290 wrote:Hello,

I have install import/export module in opencart version 1.5.5.1. when i export the exelsheet 2007 then it can be open.

It's Display error"
"Exelsheet can not open the open the file category.xlsx because file formate or extension is not valid.Veryfiy tha file has not been currepted and that the file extension mathes the formate of the file".

Your error description is so vague, if you want anybody to help you, you need to provide some more details.

siraj wrote: success the export file also open the file error file format or file extions not valid and file not be currputed

Again, you are simply not providing enough details, so I am unable to reproduce your error.

Hello,

I have a really strange problem when trying to Import the xls. I have no problems exporting it.

Actually I have been using this tool for some months without any problems.

2 days ago when I picked the .xls and clicked on Import, Chrome counted from 1% to 100% uploading the file and after that the page just refreshed. Nothing happend. Since than I tried many times to Import the file without any success, the page just refreshes itself right after the file is uploaded.

I haven't touched anything on my php.in on the shared hosting. Also haven't touched any of the files.

I have 1.5.4
upload_max_filesize = 999M
memory_limit = 256M
max_input_time = 60000
max_execution_time = 18000
post_max_size = 16M (the file is now right under 10MB and never been bigger)

So I had never had any issues until this now.
This is driving me really crazy, because I can't think of anything which might have broken the tool. I am wondering whether it might be something to be changed on the server for which I did not got notified.

I know without any error message and no changes it would be hard to tell what might be the problem. But if you think of something I would be happy to read it .

thanks.

I know without any error message and no changes it would be hard to tell what might be the problem. But if you think of something I would be happy to read it .

So, have you done the obvious and checked your server's error_log (can be acessed via your server's cPanel), or Opencart's system/logs/error.txt?

Hi,

Unfortunately there isn't anything related to the export/import files nor any /system/ files in both logs. I have also applied the backup from the last day it was working (both files and DB) but still not working, just refreshes the page.

thanks.

Did you try it in FireFox?

Hi, yes I tried Firefox, IE and Chrome.. also on different PCs, also tried to switch off firewalls, Antiviruses and so on.

vlaci wrote:Hi, yes I tried Firefox, IE and Chrome.. also on different PCs, also tried to switch off firewalls, Antiviruses and so on.

Might be a timeout issue of some sort, e.g. max_execution_time or, more likely, the max_input_time, see

http://uk3.php.net/manual/en/info.confi ... ution-time

Ohhh guys thanks for the effort, but it was only my fault, im sorry...

I have typed unintentionally 2 letters on the 1st line of php.ini, when trying to search for a word..

I have 1.5.4 installed and installed the tool. using vqmod.

is it possible to export from shop and import in another shop? i tried this, exported the file and imported it with the other shop. the admin says: succesfully imported but when I check I dont get any results. category and products are empty.

At the danger of repeating myself here:

If you have issues with the Export/Import tool, unless you can provide us with some proper details, I won't be able to help you.
Statements like "I get a blank screen" or "no results" are simply too vague.
At the very least, provide us with details like server's error_log and Opencart system/logs/error.txt, Opencart version, any other extensions installed, PHP configuration (e.g. php.ini).

Dear J.Neuhoff,

was ur last reply meant to be at my post?

--

by the way: problem solved.

Hey there, all of you having a problem with displaying no_image.jpg (or any other image placeholder) due to updated version of opencart and/or using the export/import tool.
This worked for me:
go to the path: /view/theme/default(or any other theme you use)/template/product/
and edit file: category.tpl
on line 49 you will find this code:

<?php if ($product['thumb']) { ?>
<div class="image"><a href="<?php echo $product['href']; ?>"><img src="<?php echo $product['thumb']; ?>" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a></div>
<?php } ?>


replace it with this:


<?php if ($product['thumb']) { ?>
<div class="image"><a href="<?php echo $product['href']; ?>"><img src="<?php echo $product['thumb']; ?>" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a></div>
<?php } else { ?>
<div class="image"><a href="<?php echo $product['href']; ?>"><img src="http://www.yourdomain.com/image/cache/d ... -80x80.jpg" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a></div>
<?php } ?>


also, go to lines: 112 and 146 (where the jqeury code is):

if (image != null) {
html += '<div class="image">' + image + '</div>';
}


and replace it with this:

if (image != null) {
html += '<div class="image">' + image + '</div>';
}

else {
html += '<div class="image">' + '<a href="<?php echo $product['href']; ?>"><img src="http://www.yourdomain.com/image/cache/d ... -80x80.jpg" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a>' + '</div>';
}

(or just add the "else" segment).
Notice - the path I gave for the image placeholder is where my placeholder is (no_image.jpg). You should choose the right path for your pic of course.
This will work on category pages. If you have other pages that display products (like "manufacturers-info.tpl for example) you need to find the lines in those file which match those I've mentioned above, and do the same thing.
Hope this was helpful.

Hi there,

Just trying to clone my store to test some new themes. I have a clean install with Journal theme installed, the extension seems to install Ok (not broken VQmod like Shoppica) but when I export the dummy data from the OpenCart instal I get the following result in Excel (as well as unexpected format warning):

<b>Notice</b>: Error: Unknown column 'p.cost' in 'field list'<br />Error No: 1054<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.cost, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.tag, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>/home2/jimslita/public_html/xxxxxxx.com/system/database/mysql.php</b> on line <b>49</b>

Is this likely an install fault on my part, or is this just not going to work with the Journal theme (it seems that disabling the theme doesn't help - is it possible to properly uninstal a theme?).

Any guidance would be greatly appreciated,

Regards

JIMSLITA wrote: <b>Notice</b>: Error: Unknown column 'p.cost' in 'field list'<br />Error No: 1054

There is no product.cost field in OpenCart 1.5.6.x, nor in any of the recent versions. Hence this makes me think that you are using the wrong Export/Import tool version. Re-install the correct one matching your OpenCart version.