vijaydave117 8 years ago

I have installed Import Export tool successfully but when i click on "Import/Export" option from Tool its shows "You do not have permission to access this page, please refer to your system administrator.". Please help me ASAP

walkietalkie 7 years ago

Go to System - Users - User group - Click on pencil icon to edit a group - Click Select All

dacoldflames 7 years ago

The Import/Export is not available in the list of things to be selected

dacoldflames 7 years ago

Ok, i think i found a solution to this, You must have installed the "Import/Export" Module through the "Extension Installer" but the truth is, Not all the files were uploaded in your root directory. So the solution is, Upload all files in the
downloaded "Import/Export" folder into their corresponding root directory and you are good to go. Mine works fine after doing this

vsdev 8 years ago

Is there an Import template sheet somewhere?

ViralMESH 7 years ago

just do a export from a default opencart install ( each version is slightly different)

rvanapeldoorn 8 years ago

After installing i execute the export function. Thats works great, i can open the file in Excel
But!! When i want to import the same file i get an error:
PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/website.nl/public_html/vqmod/vqcache/vq2-system_library_template_Twig_Autoloader.php on line 30

I read that i am not the only one with this problem, but a (understable) solution i can't find. The error mention to install Composer? What is that? Why in the install documentation won't tell that. And why is that needed. I can export a file, so why can i import the same file?

suryamunjal 8 years ago

Hello,
Could you help me . i have import export tool and size chart extension that adds size chart on backend which can be displayed... But when export the products , every product values like product name and product description are exported but not size chart. i have to manually go to every product and input the size chart. Also when i input size chart for 100 products, after that if use i import export tool to import excel sheet of products, all the data of size chart is gone.

this is the size chart extension i am talking about

https://www.opencart.com/index.php?route=marketplace/extension/info&extension_id=27985&filter_search=SIZE%20CHART&filter_license=0

sudasoguz 8 years ago

how can i export as xml file?

sapkhan107 8 years ago

is currently unable to handle this request.
HTTP ERROR 500
i am importing data from opencart 1.5.6.4 to 2.1.0.0 showing above error please give me solution of this porblem

theunique 8 years ago

How can use category name instead of category itd on products export?

ZufixZufix 8 years ago

Help me please!. I downloaded this extension to my store but opencart shows me the folowing information: Syntax error unexpected token < in JSON at position 0

I'm using opencart 2.1.0.2

crazyshark 8 years ago

Can use category name instead of category_id and how can we do it

sanjeev123456 8 years ago

am using in opencart 3.0.2.0
am facing below error . please provide me solution
"Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed."

Vivek_Jain 8 years ago

Hi .. i just installed this for opencart 3.0.2 but this extension is not coming under the module section so i am unable to install it. Please support me.

AgentN 8 years ago

Hi there, we have received error when using the extension and have been asking for support for many weeks - but there are no reply from the support forum nor from the get support ticket.

Somebody please kindly reply to the errors we got

georgejaradeh 7 years ago

SAME PROBLEM :(

sunsys 8 years ago

Please also include extension removal instructions and state clearly if this extension modifies any core files or not. TY

Choco2 8 years ago

Easy to install and very easy to use.

JNeuhoff 8 years ago

Please do NOT post technical support requests on the comments section. Use the 'Get Support' link. Also read the installation instructions, and the FAQ page at https://www.mhccorp.com/faq/faq-export-import-tool

aemutilidades 8 years ago

Good Morning! I use the module to import products perfectly. But as I have many products, putting the image in another tab of the worksheet is very laborious, can you put the other photos in the main tab on the side of the main image?
Another question, my hosting is dedicated, but when I put 500 products in the worksheet, it does not load, do you have to do some configuration?
Thanks in advance for the answers.

JNeuhoff 7 years ago

See my response to your OpenCart support ticket.

loginetsolutions 8 years ago

You have an error on the last release for OC 3. On the model, on function validateCategoryIdColumns you take the highest row then make the for loop from 1 to $ < highest row. Actually it should be -1 (for ($i=1; $i<$k-1; $i+=1) {}) Same for foreach ($worksheets as $worksheet) {} couple of lines below. Otherwise you will get the highest line empty generating the error category id missing.

JNeuhoff 7 years ago

Actually the code is correct, the first line is at index 0, which is the heading line.

loginetsolutions 7 years ago

No, it is not. PHP loop for (as you constructed) go one more time in the loop (because you started at 1 and not at zero) and found your highest row empty! Same for Products. That's why people complain about it in these comments.

JNeuhoff 7 years ago

Sorry, no, you are mistaken. If a worksheet has 5 rows, then PHPExcel's getHighestRow() returns 5. Our own getCell(&$worksheet,$row,$col,$default_val='') function uses a 0-based row index and a 1-based column index. Hence the validateCategoryIdColumns works correctly.

loginetsolutions 7 years ago

I maybe was wrong, and it is the Excel file. I have no idea. There is an Excel and PHPExcel bug that I just discovered debugging your script. As anybody else, I have edited the exported excel file. I have added 50 new rows. I added data to 49 and select row and delete data. Well, somehow the 50 row contains some formatting I have added maybe and function getHighestRow() reads it as the last row but actually the last row with data is 49. I have fixed it by opening the Excel file and select row by clicking its number and then press delete. First time I have selected only data and press delete. Make a test! You'll see it is true.

loginetsolutions 7 years ago

Switch back to for ($i=1; $i<$k; $i+=1) {} and it is working flawless. Thanks!

see more replies...

leatherboy 8 years ago

Hi. I use export/import with O.C. 3.0.2.0 for 6 months. I use 2 languages in my eshop. Suddenly it doesn't export the second language. It exports and creates excel columns only for the default language. Is there anything I could do to fix this problem? Shall I reinstall it?
thanks

leatherboy 8 years ago

Sorry for the trouble. I reinstalled it and it works. I just don't know why it happened. Anyway it works now.

vmalyshev 8 years ago

Hi Excellent tool. But I can not upload. I have made changes in the Excel file and then tried uploading in the same format. Failed and error shown: 0 Joomla\CMS\Form\Form::getInstance() could not load file
Why?
Thanks.

Toxa 8 years ago

how many products can I import at once?