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

emilman wrote:Hi! I tried your application and it works perfect! Now I wonder if it would be able to work with multistore instalation. I'd be grateful if you explain a bit more about it, or, if you have already done that, please give me a link. Thanks in advance!

Multi store is already supported, look the for store_ids columns in the worksheets where you specify multiple store ids, seperated by commas.

What php-pear packages should be installed in order for this extension to work? I think that's where the problem is. As I said before, I can export to excel format perfectly. The problem comes in when I have to import the changes. When I click upload after choosing the edited file, it uploads to the server but there is no processing that takes place. Our office server is running ubuntu 12.04 and its pretty much got the basic php modules installed. So I'm wondering if there is a specific plugin or addon that has to be installed for it to parse the file and make the changes. My php.ini settings are fine and my .htaccess settings are fine as well.

loki52 wrote:What php-pear packages should be installed in order for this extension to work? I think that's where the problem is. As I said before, I can export to excel format perfectly. The problem comes in when I have to import the changes. When I click upload after choosing the edited file, it uploads to the server but there is no processing that takes place. Our office server is running ubuntu 12.04 and its pretty much got the basic php modules installed. So I'm wondering if there is a specific plugin or addon that has to be installed for it to parse the file and make the changes. My php.ini settings are fine and my .htaccess settings are fine as well.

Check your server's error_log or OpenCart's system/logs/error.txt for any error messages.

hi

i'm getting a error in the sheet
you know whate the problem is?

hi there i cant fix this problem

<b>Notice</b>: Error: Unknown column 'p.ean' 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.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=2 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=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 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>/home/green/domains/greenenergyholland.com/public_html/system/database/mysql.php</b> on line <b>49</b>

you know how to fix it ?

Hi,
Would you be able to make this tool support for extra product fields. Some fields are in new tables and some in existing tables. If so how much would it cost?

Thanks

baldex wrote:hi there i cant fix this problem

<b>Notice</b>: Error: Unknown column 'p.ean' 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.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=2 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=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 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>/home/green/domains/greenenergyholland.com/public_html/system/database/mysql.php</b> on line <b>49</b>

you know how to fix it ?

You are using a non-matching version of the Export/Import tool, e.g. the one for 1.5.4.x on an older OpenCart version.

lee420 wrote:Hi,
Would you be able to make this tool support for extra product fields. Some fields are in new tables and some in existing tables. If so how much would it cost?

Thanks

Send me your exact details of the additional fields and tables you wish to be added, using our Contact Us page, and I can work out a quote.

hi all,

can this be altered to input information of custom tabs/table?

kind regards,
Jave

mrjave wrote:hi all,

can this be altered to input information of custom tabs/table?

kind regards,
Jave

What exactly to you want to be added to the Export/Import tool? Contact us with more details.

Hi

I have used the tool before and it was great. However after a fresh install (15 times) when i try to open in excel i get the message the "The file you are trying to open "backup-catergories" is in a different format than specified by the file extension"

I click yes to proceed and the spreadsheet opens with one worksheet tab at the bottom, no data and no heading just a blank spreadsheet. Any ideas would be great.

Thx in advance

cstoner69 wrote:Hi

I have used the tool before and it was great. However after a fresh install (15 times) when i try to open in excel i get the message the "The file you are trying to open "backup-catergories" is in a different format than specified by the file extension"

I click yes to proceed and the spreadsheet opens with one worksheet tab at the bottom, no data and no heading just a blank spreadsheet. Any ideas would be great.

Thx in advance

Too little details, unable to reproduce your error.

Hello,

I have a question. Is it possible to just export categories or products or ..

I ask because my memory is set at 512M and post is set at 32M but it seems that my stores are way to big for such a load. What to do when i just want categories with shop id and descriptions (thats what i need to edit the most ofline). If i have a edit hint I probably can change the script myself.

Thanks in advance.

Regards

Hi
I'm using opencart 1.5.3.1, I have downloaded this module and tried to import 348 products using the instructions given, I managed to import 128 products only rest of the items never imported, when I tried re-importing again I am getting this error repeatedly "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!". I have checked the entire file I didn't see any problem. Am I missing something?

PLEASE HELP..!!!

mickeykhan wrote:Hi
I'm using opencart 1.5.3.1, I have downloaded this module and tried to import 348 products using the instructions given, I managed to import 128 products only rest of the items never imported, when I tried re-importing again I am getting this error repeatedly "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!". I have checked the entire file I didn't see any problem. Am I missing something?

PLEASE HELP..!!!

Unable to reproduce your error, too few details.

Hi,

First of all: great job on this extension!

I am now trying to get it to work with the Custom Page Titles extension (url: http://www.opencart.com/index.php?route ... on_id=7867), which I want to use for SEO purposes.
The Custom Page Titles extension adds these new fields to the database:

ALTER TABLE art1_category_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_information_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_product_description ADD column cptitle VARCHAR(255) NOT NULL;

It also contains a vQmod file that adds the custom page title fields to admin.

Because the export/import tool doesn't know these new database fields, any custom page title I make is deleted on import of an xls file. To solve this I've tried to add the new fields to your admin/model/tool/export.php file.
As a result I am now able to export the xls file with the new fields and correct content.
However when I import the xls file again it empties the database and doesn't populate it with new data.

I have tried hard to find the cause of this, but with my limited php knowledge I haven't succeeded.
Could you take a look at the attached php file?
You can find my entries with a search for 'cptitle'.
Would be very much appreciated :-)

I am running OpenCart 1.5.3.1 with opencart-1-5-2-x-export-import-10
Works fine without the custom page titles alteration.

My OpenCart error log shows no errors.

In the uploadProducts, put the 2 lines
immediately after the line
The same is true for the uploadCategories.

Thanx, that seems to have solved it!
I had put cptitle in the wrong position, under meta_keywords, before.

There's one more edit needed.
Because of the added column in the xls file the function storeAdditionalImagesIntoDatabase is now getting the image information from the meta_keywords column.
To solve this find:

$imageNames = trim($this->getCell($data,$i,31));

And change it to:

$imageNames = trim($this->getCell($data,$i,32));

jipsa78 wrote:There's one more edit needed.
Because of the added column in the xls file the function storeAdditionalImagesIntoDatabase is now getting the image information from the meta_keywords column.
To solve this find:

$imageNames = trim($this->getCell($data,$i,31));

And change it to:

$imageNames = trim($this->getCell($data,$i,32));

Well spotted!