Wadym 7 years ago

GROUP_CONCAT (DISTINCT CAST (pr.related_id AS CHAR (11)) SEPARATOR ",") AS related FROM ` product ` p 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;

Wadym 7 years ago

SELECT p.product_id, 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 AS weight_unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.sort_order, ua.keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum,

Wadym 7 years ago

At attempt to make Export to an Excel-file gives out such error:

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104

vellone 7 years ago

Instructions do not work. What file or files must we upload? I am using Version 2.0.3.1.
I tried the zip file and I get Internal Server error

please confirm proper procedure

tomeda 7 years ago

I cant make it work on OC 2.1.0.2, Installation process is successful than I go to modification and click refresh, but in user groups I can's see tool/export_import? I see the plugin in the menu Tools, but it says access denied!!!

dacoldflames 7 years ago

I'm also having this issue, Anyone with helpful information?

jamilnaz 7 years ago

Currently, I'm on "Version 1.5.5.1" and I want to go on "Version 3.0.2.0" Can this Extension Help me to Import/Export my products and all other things?
if yes any tutorial for this purpose?
thanks

mywork 7 years ago

It isn't very easy to migrate from 1.5 to 3.0 using this tool. You'll need to change some headings and the spreadsheet to match the format in 3.0
Definitely doable, just painful and requires a bit of trial and error.

J

splka 7 years ago

Great tool.
Everything looks good expet tags option, it dosen't export it

splka 7 years ago

I mean values from "oc_product_description>tag" didn't propretly exporting and importing

zhuangoo8 7 years ago

Please help me,I can't install this plugin, I will get "internal server error" during the installation process.

thecrmsolutions 7 years ago

Great handy tool. Made my life easier. Thanks a mil.

debeulp 7 years ago

Works good in Version ocStore 3.0.2.0
you can simple import or export your products to or from a xls file.
The easiest way is to export first your existing products, then you have the right structure and titles.

adlanmuh 7 years ago

can i see what is inside of the xls file? i have no idea with the format, i tried to export but failed.. the dev doesnt give an example the xls format :\

vijaydave117 7 years ago

Its showing permission denied and also not showing option in permission for "tool/export_import". please help me

zzaz 7 years ago

Version ocStore 2.3.0.2.3
product -->Links-->Main category
this parametr not export / import
When import, this setting is removed
because it is not in the file
when all products have this category
After importing in the admin panel, you need to manually indicate this category for all products.
so enjoying the import export of this module does not make sense.
will be good if this parameter was available to export / import

Продукт --> связи-->Главная категория
этот параметр не экспортируется в файл
поэтому при импорте этот параметр обнуляется и привязка категории исчезает.
после импорта в админке нужно по всем товарам заново в ручную указывать данную категорию.
поэтому пользоваться импорт экспорт этим модулем нет смысла.

splka 7 years ago

Looks like it works for me wihout any issues
http://prntscr.com/krdc95
Another issue - tags dosen't export and that's real issue

zzaz 7 years ago

Version ocStore 2.3.0.2.3
product -->Links-->Main category
this parametr not export / import
When import, this setting is removed
because it is not in the file

will be good if this parameter was available to export / import

lamenezes 7 years ago

I have a shop (1.5.6.4) and I need do export the products for a new shop(3.x). The moment I try to import in the new shop I receive a message: Export/Import: Invalid header in the Products worksheet (1.5.6.4 products)

dostikk@gmail.com 7 years ago

установить то установил ,но что то не импорта ,не экспорта не чего нету в меню панели

endix 7 years ago

Doesn't work Export! My shop (opencart 2.3.0.2) have 10 000 products. I'm trying to do Export. After pressing the button - long loading and I see empty white page. I used last version of "export/import". Need help.

ViralMESH 7 years ago

You need to up your max execution time on server by the sounds of it. Or do the export in batches of 2000 or so

MichielTombergen 7 years ago

Hello,

I have this module installed on a site o mine. No problem.

Now I want to install this module on another one, entry is in the menu. But the permissions aren't there, soo i cant use this atm.

Does anyone know how to fix this?

bobmarley 7 years ago

Not usable because not all information is importing. Categories OK, customers and products NO. I have error only if I'm importing file, which just exported before, without changes. Just exported and wanted import. But I see result.

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed.

Maybe I did something wrong, but how I writed before - impossible import file which just exported.

Good that this product is Free

Good luck ;)

georgejaradeh 7 years ago

HI I HAVE THE SAME PROBLEM
ANY HELP!!!!

ViralMESH 7 years ago

What does the error log file say? you may need to adjust the settings on the export / import. Make sure the headers are correct on the exported csv... check setting - Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'

m.rohan 7 years ago

i am having the same issue though i have changed the setting its still the same . any help . i am using 3.0

khalidHadi 7 years ago

I had the same problem and I solved it by deleting the duplicate SEO keywords ... (I have two languages in the site and the words of SEO were repeated and they were the cause of the error).

Laurens7802 8 years ago

Installed it, but when I export and import I get some errors
1) Export/Import: Keyword 'Others' used more than once for store_id '0' in worksheet 'CategorySEOKeywords'!
2) Export/Import: Invalid store_id='' used in worksheet 'CategorySEOKeywords'!

For the first error I understand the issue, but it's another addon that you can use the same name for more than 1 language so it's the same how it has exported it.
How can I resolve this issue that it does this check?

The second one I don't understand. It's how it exported it. In excel I don't see any flaws.

Hope you can help.
Great contribution that's for sure

adcarp 8 years ago

Thank you. big man.