nyakubenko 8 years ago

Thank you for your work.

mycollstore 8 years ago

easy and very helpful even for beginners.

JNeuhoff 8 years ago

@dovils: Please use the 'Get Support' link, not this comments section, for technical support!

doviis 8 years ago

Hello,
I have installed plugin. Seems that I cannot get how it works. I have exported all my products to get the right template for my new products. Once I try to upload new products on that template I get message (in error log): Export/Import: Invalid worksheet names

doviis 8 years ago

2018-05-21 16:42:43 - PHP Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' ',0,'',1,0.00,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0,'1','1','1','1')' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (591,0,'','','','','','','',,' ',0,'',1,0.00,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0,'1','1','1','1'); in
public_html/system/library/db/mysqli.php on line 40

dahuja1977 8 years ago

How to resolve this error Export/Import: Missing product_ids in worksheet 'Products'!
as I have provided a product id in the file

JNeuhoff 8 years ago

See the above FAQ Page link for an answer.

cartdeveloper 8 years ago

Hi, I am new to OC. Your plugin instructions are good.I have installed it. I want to import products and categories. Do you have any Excel format? How do I import it? I am using 3X

JNeuhoff 8 years ago

Do an Export first to see the exact worksheet formats to be used.

artemleon 8 years ago

personally moderator of the chat room: I will write negative reviews every day until you solve my problem.

JNeuhoff 8 years ago

Please use the 'Get Support' link for technical issues. This comments section is not a support forum.

artemleon 8 years ago

so I use:
13.05 - # 170262
# 170307
14.05 - # 170433
15.05 - # 170562
And your support generally does not respond to user requests

JNeuhoff 8 years ago

If you are 'Oleg Buchinskij' then yes, we have answered your same question multiple times. Please check your email account at gmail.com which should have our replies via OpenCart's zendesk. The last reply was sent to on 16 May 2018 10:06:57 +0100

artemleon 8 years ago

I do not see any messages from you, you can duplicate them in a chat or email

JNeuhoff 8 years ago

I just forwarded it to your email account.

calota 8 years ago

Hello, I recieve this error in error log:
Export/Import: Invalid worksheet names
What it's wrong?

JNeuhoff 8 years ago

Just give the worksheets the right names, e.g. 'Products' etc. The error message is clear enough on this.

FabTop 8 years ago

OpenCart 2.2
Great extension, do what it says and support multi spreadsheet formats.
Easy to use!

appsdex92 8 years ago

Hi guys I tried to import my 500+ products from ebay and I converted it to .xlsx cause export/import extension can only import .xlsx, .ods and xls its not supported with .csv. However when importing the .xlsx spreadsheet file theres an error you can check below the link.
https://www.screencast.com/t/OISvyfkZ0

ibrokers 8 years ago

looks like a great tool, thanks.
I the 1.5 opencart there is no marketplace listed in the extensions dropdown, please advise how I can install the import / export on the old site, the 3.x install was simple, Thanks Pete

Jakuvos 8 years ago

hey there,
i exported products, changed my prices, and then i've import file
on front end i have my products with chcanged prices, but at the backend i have nothing, my products list is empty,
Can anybody help me please?

sebadamus 8 years ago

Strange, exactly the same problem here. Will try to look the forum for clues...

redjasper 8 years ago

HI There
I downloaded the extension and when i am uploading the extension i am getting the error/warning its going to change some files so i am not sure why it is doing this.

Please check the link for print screen
https://ibb.co/m1MY6x

Kindly let me know whats the issue

thanks
atif

JNeuhoff 8 years ago

Yes, it is safe to overwrite these files which all belong to a previous version of the Export/Import tool on your web server.

Khmelev88 8 years ago

Why are attributes not imported when exporting goods ??

JNeuhoff 8 years ago

They are. If you experience problems then please use the 'Get Support' link for technical support.

JNeuhoff 8 years ago

Just a reminder: This comments section is not a support forum. Please use the 'Get Support' button for technical support, including installation issues.

yudkinWebDeveloper 8 years ago

Hi! Thank you very much for plugin. Can you help with advice? I want to migrate my product items from OpenCart to Woocommerce, what I should to change for migration success? I hope you are well for answer =)
Thanks

JNeuhoff 8 years ago

The spreadsheet format for products data will be quite different for woocommerce, see e.g. https://docs.woocommerce.com/document/product-csv-importer-exporter/

You do an Export from you OpenCart site, but then it will be a copy and paste exercise into the Woocommerce spreadsheet columns. There might be some automated migration services out there, try to Google for it.

webneeds.biz 8 years ago

Hi , We are using V-2.0.0 & We have installed Import & Export Plugin in permission area it's showing fine and we have given necessary permission but it's not showing under Tools Tab Please let me know if anything needs to do????

JNeuhoff 8 years ago

This should help: https://www.mhccorp.com/faq/faq-export-import-tool

kerwen 8 years ago

how to download this module for 2 hours I can not understand

4adstudio 8 years ago

This is the best plugin for import and export. I've moved my shop from 2.3 to 3.0. I've had 3000 products and some of them had nearly 200 options. Remember to delete SEO column while moving from 2.3 to 3.0 as it's not supported in OC 3 Thanks !

aayushagarwal08 8 years ago

2018-04-15 8:15:46 - Export/Import: Missing product_ids in worksheet 'Products'!
2018-04-15 8:15:46 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/aa/public_html/shop/system/library/template/Twig/Autoloader.php on line 12
2018-04-15 8:15:46 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/aa/public_html/shop/system/library/template/Twig/Autoloader.php on line 30

How to fix this?

JNeuhoff 8 years ago

Please use the 'Get Support' link. See also https://www.mhccorp.com/faq/faq-export-import-tool

aayushagarwal08 8 years ago

Hey, thanks. I fixed this issue but when i upload the xls file. It gets successfully uploaded but the products do not reflect on the website. can you help me out with that?

surplustek 8 years ago

I have same problem, what was your solution ? Thanks

surplustek 8 years ago

HP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead.