Multi store is already supported, look the for store_ids columns in the worksheets where you specify multiple store ids, seperated by commas.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!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Check your server's error_log or OpenCart's system/logs/error.txt for any error messages.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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
i'm getting a error in the sheet
you know whate the problem is?
Code: Select all
<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>
<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.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 ?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
What exactly to you want to be added to the Export/Import tool? Contact us with more details.mrjave wrote:hi all,
can this be altered to input information of custom tabs/table?
kind regards,
Jave
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
My shops running Opencart Multistore:
Koptelefoon, audio kabels en speakers kopen
Led lampen en verlichting
Alle kabels- audiokabel, computerkabel, stroomkabel
Koptelefoon en In ear oordopjes / oortjes Apple iPhone, Samsung Smartphone
Smartphone hoesjes en oordopjes Apple iPhone en Samsung
Online Aanbiedingen en Sales
Hoesjes, Covers en accessoires Tablet en smartphone
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.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..!!!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
Attachments
modified export.php
Code: Select all
$cptitle = $this->getCell($data,$i,$j++);
$cptitle = htmlentities( $cptitle, ENT_QUOTES, $this->detect_encoding($cptitle) );
Code: Select all
$name = $this->getCell($data,$i,$j++);
$name = htmlentities( $name, ENT_QUOTES, $this->detect_encoding($name) );
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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!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));
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 61 guests