madlime 15 years ago

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 LEFT JOIN `product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

madlime 15 years ago

Error: Incorrect key file for table '/ramdisk/#sql_209f_0.MYI'; try to repair it<br />Error No: 126<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 `product` p LEFT

govath 15 years ago

I successfully install this extension... But the problem is when i export the list im getting an xls file with lots of symbols like the below :
ÐÏà¡±á;þÿ ¹

what im doing wrong and how can i fix this ?

BOBKIM7080 15 years ago

I just installed this.
I getting this message
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.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, 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_keywords, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, p.cost, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, ....

bthusby 15 years ago

@grgolf:
Your error is probably due to settings done to php.ini on the server. If you have many products in your db it requires a fair amount of memory available. A lot of web hosts don't offer too much memory as default. See the readme.txt for the module for more info.

grgolf 15 years ago

I'm getting the following error when trying to import. I'm using 1.5.1. Any help would be appreciated. I don't have that many products to import.

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

bthusby 15 years ago

I can export, but I receive an error when I import back in after I have done changes. The import works, but this error I don't get:

Notice: Trying to get property of non-object in /www/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 177

I have tried both Microsoft Excel and NeoOffice (OpenOffice clone for OSX)

lmb500 15 years ago

I've installed this perfectly via the instructions.

The file is only exporting categories to a .xls and not the products. Do you know what the problem might be? I have five "test" products installed, under the categories which were exported successfully.

Thank you.

JKL 15 years ago

Does it come with possible 2 languages. ?
When I import my products, the products only shows in the one language, and when I try to save them after some writing, it wants the Product Name for the other language.
For me it seems, that the Productname is the issue regarding the languages.

JAY6390 15 years ago

Noticed what appears to be a typo
The execution time for an import is 180 seconds where the export is 1800. Not sure which of these is correct (if not both) but thought it strange they were different

cglance08 15 years ago

gr8 extension, it works for me without any errors

http://www.creativeglance.com

cozziemo 15 years ago

Hi All,

Mod uploaded successfully it seems so far, just trying to get my head around image directory aspects.

So i have to upload the images to the server then place the file paths for each product into the spreadsheet so when import is done the image will be loaded with the imported listing information.

Please steer me in the right direction if i am wrong.

Cozzienz

Augustin Colesnic 15 years ago

@janvanherp

Great tool and praise to the author ! For the v. 1.5.1 the author should add in his readme file the next instruction:

In file admin/controller/common/header.php find:
THIS ONE TOO:

Find:
$this->data['backup'] = $this->url->link('tool/backup', 'token=' . $this->session->data['token'], 'SSL');

Add the following line after the found line:
$this->data['export'] = $this->url->link('tool/export', 'token=' . $this->session->data['token'], 'SSL');

Cheers to all!

JNeuhoff 15 years ago

Please post all bugs and support requests on the regular Opencart forum, I won't have time to check the comments here!

captainnuk 15 years ago

Hi,
I am not able to get Version 1.5.1 to work with this module after following the instruction to upload the files and checking the tool/export under Top Administrator, wondering do i have to modify any file to get this mod to work?
thx

arronjuk 15 years ago

Really like the plugin, it saved me having to upload a few thousand products!!!

...but is there a way to allow letters (A-Z) in the product code?

many thanks,

Arron

wenderson_chacau 15 years ago

Good Morning guys!
wanted the following to this module import / export xls to generate products with only
not need to generate categories and other things can someone help me?

Lao 15 years ago

Hello!

I started using this extension a few months ago. It's ok for now.

What I'd like to ask you is this: is there any way of putting categories' names instead of their' corresponding ID's? I'm talking about column C in the "Products" worksheet. It would be much easier to have names instead of numbers (IDs).

Thank you!
Lao Mayer

james_dennison 15 years ago

I had this working like a dream - best extension out there for me, saved me weeks of adding products and making changes. However I changed server to a different URL (specialisttapes.com) and now the tool is not working, I carefully installed and checked it and all seems to be in order however:

I get an error "It is a different format than specified by the file extension" when opening in excel.

The excel sheet is then a bit scrambled and has lots of "special characters" and code.

There is no paid for alternative to this so someone please help if you know a solution. Thanks in advance.

ps. @cozziemomo yes you can. Excellent addon when working.

cozziemo 15 years ago

Hi there,

Please correct me if i am wrong, but with this mod, i can create a spreadsheet and place all the products, descriptions, photos, prices, shipping costs etc and make a bulk list and do 1 bulk import? this would be awesome rather than creating products listing online one at a time.

Thanks

Cozzie