Export/Import tool for OpenCart 1.5.0.x

JNeuhoff wrote:

hbg wrote:Hi, I opened it in Excel & received the same error. Maybe fill in a few of the blank cells, and try again? I have used a few different ones. The main issue I had was the description stuffing up, and adding html characters on 1.4.9.4.

I can open it just fine using OpenOffice 3.3.0. So maybe it's an issue with Microsoft's Excel not being backward compatable to the XLS BIFF8 format used by the PHP Pear Excel Writer software embedded in the Export/Import tool?

JNeuhoff wrote:The problem with the attributes has now been fixed.

NTCommerce wrote:

JNeuhoff wrote:The problem with the attributes has now been fixed.

I am using oc 1.5.0.5 and am having a problem with importing attributes. Can you tell me how this was fixed

xucngo wrote:Hi,

if somebody is interested, i'v made a small change to the script, so that it exports and imports multi language xls files

igama wrote:Could you share your version of the script?

Thanks

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<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.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, 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, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `sf_product` p LEFT JOIN `sf_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=2 LEFT JOIN `sf_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `sf_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `sf_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `sf_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=2 LEFT JOIN `sf_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 LEFT JOIN `sf_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `sf_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

abdipribados wrote:Hi JNeuhoff

First I want to thank you for this great module.
I already install it in my store using the 1.5.0.5 version and modules OpenCart "OpenCart-1-5-0-x-4-Export-import '.

The first time I used it, that's great. I export, modify, and import successfully.
But when I want to edit my product today, I get an error when exporting the database. I just get an excel file with a size of 2kb with only one cell with the text:

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<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.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, 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, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `sf_product` p LEFT JOIN `sf_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=2 LEFT JOIN `sf_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `sf_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `sf_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `sf_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=2 LEFT JOIN `sf_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 LEFT JOIN `sf_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `sf_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

Could you help me how to solved this problem ?
Thank you and sorry for my english

mysql_query("set sql_big_selects=1");

$query .= "ORDER BY p.product_id, pc.category_id; ";

teratyke wrote: I think I might be able to help, I had this problem previously. You could enable Big_Selects (as it suggests in the error)
I'm not sure we are using exactly the same version but I put this line...

Code: Select all

mysql_query("set sql_big_selects=1");

after this line..

Code: Select all

$query .= "ORDER BY p.product_id, pc.category_id; ";

in this file... admin/model/tool/export.php
Good luck

hbg wrote:Hi, I opened it in Excel & received the same error. Maybe fill in a few of the blank cells, and try again? I have used a few different ones. The main issue I had was the description stuffing up, and adding html characters on 1.4.9.4.

Ariskos wrote:Hello, I have the following problem with 1.5.1:
When I import the xls file, products and categories are appearing in the front end but I can't find any category or product in the admin panel to edit them..
Is it a known issue or am I doing something wrong?

EDIT: Ok, I found the solution of the problem, I had the admin language in English and as a defualt language I had Greek (because I need Greeks for the frontend).
Is there a solution to have Greek in FrontEnd (and that means that it should be default) and English in Backend Admin ?

grgolf wrote:I'm getting the following errors below when trying to import. My file size is 1.8mb. Any help would be greatly appreciated.

Fatal error: Out of memory (allocated 80740352) (tried to allocate 67 bytes) in /system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Fatal Error: Out of memory (allocated 80740352) (tried to allocate 67 bytes) in /system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

Lao wrote:Hi!

I have a bog problem I never encountered before: I uploaded the import file, all products appeared in front office, but when I go to admin page and check the Products page, there's no product listed.

What can I check?

Thank you!