InMotion Hosting Support Center

If you are building a large store with OpenCart, adding products one by one can be long repetitive process. There’s an extension that you can install that will allow you to export your current products in Excel, work offline on adding or editing new products, and importing the spreadsheet to add the new products to your store. This can save valuable time in getting your store operational.

You must have vQmod installed to use this extension. If you do not have vQmod installed and want more information about it please see our article on vQmod.

The memory requirements for this extension can be quite high. If you have more than 2,000 products in your store and are on a shared server, this plugin may not be suitable for you to use due to the high memory usage.

Installing the Bulk Import/Export Extension

  1. Download the extension from here: Bulk Export/ Import Extension for OpenCart. Be sure to scroll down the page and locate the Download tab. Download the one for your particular OpenCart version.
  2. Extract the files that you just downloaded
    opencart_export_1
  3. Upload the folders “admin”, “system”, and “vqmod” and their files from the “upload” directory to your root directory of your OpenCart Store using a FTP program.opencart_export_2
  4. Login to your OpenCart Dashboard
  5. In your OpenCart Dashboard go to: System > Users > Users Group
  6. Select the Top Administrator and click Edit on the right side.opencart_export_3
  7. Find the entry for tool/export in both Access and Modify dropdown lists and place a check by clicking on their boxes.

    Now you can use the tool in your dashboard by going to: System Export/Import

Congratulations, now you know how to install the bulk import/export extension for OpenCart Products!

Continued Education in Course OpenCart
You are viewing Section 27: 321: Installing the bulk import/export extension for OpenCart Products
Section 26: 322: Using the Bulk Export/ Import Extension in OpenCart
Section 28: 309: Installing the vQmod Very Simple AJAX Live Search Module

Support Center Login

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Bulk Import/Export extensions not appearing
Opencart 2.0.2 import export mod not appearing in admin
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
2013-09-19 5:23 am
hi. i have instll the extension. everything was ok. after i change the admin from config.php. i noticed that the export/import was no found in the system of open cart dashboard. please assist. thanks
Staff
11,186 Points
2013-09-19 8:01 am
Be sure that you have uploaded the files in the correct directory for your OpenCart installation. Also, you may have a browser caching issues, in which clearing your browser cache may also help.
n/a Points
2015-05-09 8:16 pm

Hi, I installed it, followed instructions and it works all the way through step 7.  But there is no option that comes up under the System menu.  I have installed vQmod (have other extensions working that use it) and I cannot seem to get this to work.  Every trick Ive tried hasn't worked yet.  Any help would be great :)

OpenCart 1.5.6.1

 

Thanks

Stephen

2013-09-19 9:32 am
error 403 appeared after i import my product data. When i want to manually insert new product or category, this error 403 appeared.
Staff
9,968 Points
2013-09-19 1:31 pm
Hello maneii,

A 403 error means access denied, so it could possibly be a permission issue with your files. We have an article on the 403 forbidden error that explains why you might be getting this.

Other than that it could be possible that you have a rule in your .htaccess file that is causing the 403 error. You might want to try to temporarily re-name your .htaccess file to something like .htaccess-BAK and see if you're still having issues, and then re-name it back if the issues are still persisting.

Please let us know if that works for you, or if you're still having problems.

- Jacob
2013-10-27 9:50 pm
Followed all instructions in the Bulk Import Export tutorial for opencart. Received the following error after I downloaded the excel file:
Fatal error: Class 'ZipArchive' not found in /home/gremilli/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234
Please help me.
Staff
9,968 Points
2013-10-28 7:26 pm
Hello mgremillion09, and thanks for your comment.

What version of OpenCart are you running, and which version of the OpenCart Export/Import Tool are you running?

When I downloaded opencart-1-5-4-x-export-import-13.zip and took a look at the /system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php file on line 234 there is no mentions of a ZipArchive class. It sounds like possibly you don't have all of the files uploaded, or have the improper version for your version of OpenCart.

- Jacob
2014-02-03 2:17 am
Hi Dear,
I really appreciate your work can you give me the Excel Format file to test it please.
Shan Ali

Staff
11,186 Points
2014-02-03 9:09 am
Hello alirajpoot44,

Unfortunately, we do not have a file in which you may use to test this functionality. You may, however, easily create one using Excel.
n/a Points
2014-04-07 8:58 am

I already have VQMod on my Opencart site. http://rocklove.us  Will I mess it up if I upload thes files from Bulk IMpor/Export?

Staff
28,219 Points
2014-04-07 10:34 am
Hello David,

Uploading the folders over existing folders will update any older files with newer copies. It should not have any detrimental effect on them. However, I would make copies of all the folders as a backup just in case.

Kindest Regards,
Scott M
n/a Points
2014-04-07 10:40 am

OK I will try..after I make a backup.   What confuses me is that the Template I had installed has the admin folder.. so if I overwrite the admin folder.. well is that gonna wipe out the files for the template?

Staff
28,219 Points
2014-04-07 10:59 am
Hello David,

No, the extension will add its own files to the admin folder. Files for other extensions and templates should not be affected at all. Just be sure to make the copy so you can always roll back in case of an error.

Kindest Regards,
Scott M
n/a Points
2014-04-07 11:24 am

Got it to install.. BUT the "System > Export/Import" is not showing up.  The boxes are checked.  My site is "rocklove.us" hosted of course on INMotion.

Staff
16,968 Points
2014-04-07 3:21 pm
Hello David,

Thank you for your question. As a test, I setup this extension on a new installation of OpenCart, and it does work successfully.

The important part of the guide, is where it states "You must have vQmod installed to use it." Make sure you have installed vqmod in OpenCart, before attempting this guide.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul
Staff
9,968 Points
2014-04-07 3:40 pm
Hello David,

It looks like while you had already uploaded the vQmod files, it doesn't look like your /vqmod folder had the correct permissions, and it didn't look like the install was ever run which is mentioned in our vQmod for OpenCart guide.

It was also hard to tell if you had the correct version of the Import/Export tool downloaded to match your version of OpenCart. So I went ahead and insured the correct version opencart-1-5-6-x-export-import-17.zip compatible with OpenCart v1.5.6, v1.5.6.1 was used as well.

I went ahead and left a copy of admin-BAK, system-BAK, and vqmod-BAK which had you original files in them in case you ran into any issues. But it looks to be working now.

Please let us know if you had any further questions at all.

- Jacob
n/a Points
2014-04-07 3:57 pm

Hey hey hey! It's workin now..and it also now uses the coolio "OpenShop" extension that I had! That must have been it.. the Template designer installed it for me.. I am not sure if he did the VQmod though!  But all's well that ends well..nice job fellas.  THANKS!!

Staff
9,968 Points
2014-04-07 4:04 pm
Hey David,

Awesome! Glad to hear that's working for you now, no problem at all!

The vQmod install step is an easy one to miss, and we've already updated this article itself to try to make it more apparent that needs to be done for this extension to function.

- Jacob
n/a Points
2014-04-28 8:44 pm

When I click in export show the message below:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 81 bytes) in /home/MYSERVER/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123

Staff
25,386 Points
2014-04-28 9:16 pm
Hello Ivanna,

Sorry to hear about the problem. As I do not have any way to see your exact installation, then we're unable to verify the specific issue. However, I would try to first increase the memory in your PHP.INI file. Here's a tutorial that will help: Updating your local PHP settings.

Please increase the memory limit and then let us know if you continue to have the problem. We would also need at least a URL or account information to continue to investigate the issue.

Regards,
Arnel C.
n/a Points
2014-05-28 4:38 am

please help.

thanks in advance

when i am change the Top Administrator in modify section i will get this error...

You do not have permission to modify user groups!

Staff
11,186 Points
2014-05-28 7:57 am
Only the administrator will be able to modify their user. If you need to modify this user, using a different user, you would need to do so directly within the database using PHPMyAdmin. Otherwise, you may simply log in as that user and make the changes needed.
n/a Points
2014-06-09 12:02 pm

wORKING PERFECTLY like a charm like a charm like a charm .  :)

n/a Points
2014-06-11 7:42 am

Hi, 

 The buld export and import works fine for adding say 400 products. But if I try adding 1000 products, it gives and error saying exceeded maximum execution time of 30 seconds. Where should I change the configuration for the same?

 

Regards

Aditya

 

 

 

Staff
11,186 Points
2014-06-11 8:44 am
You will need to adjust your php.ini file to allow for a higher execution time. To variable that you will need to change is the max_execution_time. You may also need to make your php.ini file recursive as well.
n/a Points
2014-06-18 8:39 am

hey  i have installed every thing but in group admin im not able to see. tool for bulk import/export. please help me where i m going wrong.i m testing in local host

Staff
11,186 Points
2014-06-18 8:43 am
After you have installed it, you will need to enable the extension for the user that is attempting to access it. To do so, you may follow steps 4 though 7 in this article.
n/a Points
2014-06-24 7:17 am

Hello,

I installed the plugin on the website but I do not see "System > Export/Import" on the admin panel.My system version is 1.5.6.1 and I have installed opencart-1-5-6-x-export-import-17.zip. Please guide us what am i missing. 

 

Regards,

Sneha

Staff
11,186 Points
2014-06-24 8:37 am
This would not appear if you have not first activated the extension for the correct user group as explained within steps 4-7. I recommend following these steps again to ensure that you did not miss anything in them.
n/a Points
2014-06-24 1:41 pm

I did assign the user access too and it says the access is there for the administrator. I rechecked the files and all the files are in their respective folder. Anything else i might have missed. 

Staff
25,386 Points
2014-06-24 1:56 pm
Hello Sneha,

Sorry for the continued problem. Before we try anything further, I need to check if you were able to install vQMod. If that's not installed correctly, then the extension will not work. For information, please go to our installing vQMOD article.

Regards,
Arnel C.
n/a Points
2014-06-30 4:54 am

Hi 

Is there any file template available .all my trials are showing "its values are not in the expected formats!"

Staff
11,186 Points
2014-06-30 9:17 am
Could you clarify exactly where you see this error message?
n/a Points
2014-06-30 9:31 am

Hi Jeff

The mentioned problem is solved now.

One more query  - in case of non existing attributes , can it auto create attributes in a default group and then we can modify later.

This is one awesome feature I had used in WP all import (woocommerce plugin)

Just a suggestion though!!

Thanks for the great work

n/a Points
2014-07-03 5:35 pm

Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

please give me sample of xls file

Staff
9,968 Points
2014-07-03 5:44 pm
Hello Bhaskar,

I would recommend that you go ahead and Export your current products using this extension. Then you can just open up the resulting exported file and edit it to ensure your new products you're trying to import are in the appropriate format.

If you're unable to export, edit a few products and then import that info back into OpenCart. You could possibly be having an issue with the values you're entering in for your products.

Please let us know if you're still having issues.

- Jacob
n/a Points
2014-07-23 7:20 pm

Hello, I've downloaded and uploaded the extension in my website, and I got this page instead for the the admin panel,

Internal Server Error

please help.

Staff
9,968 Points
2014-07-23 7:38 pm
Hello sofia,

There are multiple reasons that a 500 Internal Server Error can happen on a website.

When you followed Step 3 and dragged the admin folder from the Extension files that you downloaded to the server, did you see that the admin folder already existed on the server? As the files in the Extension's admin directory should have simply been uploaded to the server-side one.

As soon as you uploaded the files via FTP, is that when you started receiving the error? Or did you login to the OpenCart admin and try to activate the extension and that's when problems started happening?

Unfortunately because your website is not hosted with us, I can't see the actual error being generated by the server. You might wish to contact your web host or use and control panel they've given you access to where you can view your site's errors to see what the actual problem is. It could be an issue with the permissions of the files you uploaded into your admin folder, or it might be something related to downloading the wrong version of the extension for the version of OpenCart that you're using.

Please let us know if you had any further questions at all.

- Jacob
n/a Points
2014-07-24 9:47 am

Thank you so much for your reply, the error shows after I upload the extention files, when I want to log in my admin to activate it, it shows me the error, I've checked the error log files and I got this:

[Thu Jul 24 09:36:17 2014] [error] [client 41.250.57.250] File does not exist: /home/sociucdq/public_html/500.shtml, referer: http://socialyardsell.com/test/admin/

 

What does it mean?

Staff
28,219 Points
2014-07-24 10:47 am
Hello Sofia,

The particular error you gave means that the program is trying to throw a 500 error, but cannot find the page to display it. I went to your admin login area and the login section is fine. When do you get the error? Is it when trying to log in?

Kindest Regards,
Scott M
n/a Points
2014-07-24 11:15 am

Here's what I get instead of the admin panel:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@socialyardsell.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

here's the url:

http://socialyardsell.com/test/admin/

 

Thanks!

Staff
11,186 Points
2014-07-24 11:22 am
This is typically caused by an issue within your .htaccess file. Try renaming any .htaccess files that are located on your site. Be sure that you have hidden files enabled as .htaccess files are hidden files.
n/a Points
2015-03-14 12:04 am

Hi im getting an error after installing the extension. I have read through your questions and comment that i should rename the .htaccess file. I've tried to do so but the error is still there. Please assist.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@zinckesa.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

n/a Points
2015-01-26 6:44 pm

Hello,

When i want to upload opencart-2-0-x-export-import-multilingual-2-19.ocmod to my opencart shop, i get a error

internal error.

but i dont cant find any problem. I dont have a server error log. how can i solve this problem.

 

My opcart shop is version 2.0.1.1

 

Staff
28,219 Points
2015-01-26 6:55 pm
Hello,

We currently have very little documentation for OpenCart 2.0 as it is still very new and possibly unstable. This should change as we do more testing. This article is for the 1.5.x version. Do you have the specific error message you are getting? What are the exact steps you are taking to get the error?

Kindest Regards,
Scott M
n/a Points
2014-10-14 10:03 am

hey hi i have install the extension but its not shown in admin panel.give me any suggestion.

Staff
11,186 Points
2014-10-14 10:16 am
Be sure that you follow steps 5-7 as without these steps, you will not be able to see it.
n/a Points
2014-10-15 12:34 am

Extension installed easily. But when i try to open the exported file, I get an error.

Fatal error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 72 bytes) in system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 173

 
Staff
28,219 Points
2014-10-15 7:31 am
Hello Brandon,

That itself it a php specific error. You can find an article on that by searching in our Support Center. OR I can give it to you here. Fixing the php memory size exhausted error.

That should take care of you.

Kindest Regards,
Scott M
n/a Points
2014-10-15 12:46 pm

Thank you. Got the memory error figured out. Now I get this error:

Fatal error:  Class 'ZipArchive' not found in /system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 227

Staff
25,386 Points
2014-10-15 1:53 pm
Hello Brandon,

Sorry for the problem. The class "ziparchive" isn't something that appears to be loaded on the server. You may need to consult with your host to see about making sure it's loaded. If you're hosted with us, can you please provide us more information on your account so that we can look into it further.

Regards,
Arnel C.
n/a Points
2014-10-15 2:39 pm

Can I just install the module on my hosting account? Is it Archive_Zip? If not, can you advise what module needs to be installed?

Staff
25,386 Points
2014-10-15 3:16 pm
Hello Brandon,

You may want to refer to documentation for Zip installation for PHP. This is also discussed in this post on the topic of the error that you are seeing.

Regards,
Arnel C.
n/a Points
2014-10-15 7:39 pm

Hello, for some reason i cannot find the open cart dirctory folder in the ftp. But open cart is installed on the website and i have access to it. Can you help me figure this out. Is there a sub folder that open cart might be installed into??

Staff
25,386 Points
2014-10-15 8:00 pm
Hello Kitos76,

This kind of problem is probably based on the user that you're using to login to FTP. If it's a user that you created in cPanel, then you need to look at the directory that the user has access to. If it's set to a subdirectory, then you will not be able to see the OpenCart installation folder. You would need to make sure that the user has access to the public_html folder (or the actual Opencart installation folder). Be careful though if you assign the user to the public_html folder or the the directory. If the user is deleted and you say "yes" to delete the files, then ALL of the files in the folder are deleted along with the ftp user. It's easy to make that mistake, so I wanted to mention it and make sure that you are forewarned.

Hope that helps to resolve the issue. Let us know if you have any further questions.

Regards,
Arnel C.
n/a Points
2014-10-15 8:14 pm

I have access to all the folders via ftp including public_html , I found all the open cart components but they are not under an opencart directory. I started installing the bulk import/export extension files in the folders that are already on the server. Is this going to do any damage or is it undo able??

Now i installed all the files in the appropiate folders, i found the import export option in the users group, i enabled them , saved it but now i do not find it on my dashboard.
Staff
25,386 Points
2014-10-15 9:34 pm
Hello Kitos76,

Sorry you're still having problems locating where your files for OpenCart were installed. If you are hosted with us, then it's possible that there is NOT a folder named "OpenCart". The files for OpenCart may have been installed directly in the public_html folder. If you wish for us to verify that, then please provide us more information on your account and we can look for you. Otherwise, you can look for the configuration file called config.php to track down where your OpenCart install files are located.

You will have needed to make sure that VQMOD is properly installed. The extension will not properly work without it.

If you continue to have problems with the installation, please provide us more information on your account (if you are an InMotion Hosting customer). We can look further into the problem if needed.

Regards,
Arnel C.

n/a Points
2014-10-15 10:17 pm

I apreciate your assistance, i have installed the import/export tool. The version is correct for our open cart Version 1.5.4 , i found it on user groups, checked the access and modify box, and saved it. But I still do not see it on my Dashboard or under the system tab. What do you recommend or am i looking in the wrong place? 

Staff
28,219 Points
2014-10-16 7:13 am
Hello kitos76,

Did you also install VQMod prior to installing the import/export extension?

Kindest Regards,
Scott M
n/a Points
2014-10-18 2:35 am
Why i have this error ?
Fatal error: Class 'ZipArchive' not found in /home/shillex1/public_html/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 94
Staff
16,968 Points
2014-10-20 12:33 pm
Hello Stefan,

Thank you for contacting us. Here is a link to a similar question we answered regarding the Fatal error: Class 'ZipArchive'.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul
n/a Points
2014-10-18 5:41 am

Hi

I have followed all the steps properly, vqmod is also installed but it still does't show export/import tool in system. Please help me out :(

 

Staff
16,968 Points
2014-10-20 12:37 pm
Hello abc,

Thank you for contacting us today. We are happy to help, but will need some additional information to help troubleshoot the problem.

What version of OpenCart are you using?

Can you provide a link to the site?

Are you using any other 3rd parry addons/plugins?

Thank you,
John-Paul
n/a Points
2014-10-29 3:02 pm

looks all good but when i export i get

 

2014-10-29 18:41:11 - PHP Warning:  realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/zpanel/hostdata/zadmin/public_html/quickstopballoons_co_uk:/var/zpanel/temp/) in /var/zpanel/hostdata/zadmin/public_html/quickstopballoons_co_uk/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 1752014-10-29 18:41:11 - PHP Warning:  tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/zpanel/hostdata/zadmin/public_html/quickstopballoons_co_uk:/var/zpanel/temp/) in /var/zpanel/hostdata/zadmin/public_html/quickstopballoons_co_uk/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 1972014-10-29 18:41:11 - PHP PHPExcel_Writer_Exception:  Could not close zip file php://output. in /var/zpanel/hostdata/zadmin/public_html/quickstopballoons_co_uk/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 399

Staff
25,386 Points
2014-10-29 4:11 pm
Hello Simon,

Sorry to see you're having a problem with the import/export extension. The issue is related to the error message which states "open_basedir restriction in effect". You will need to make changes to the open_basedir settings in your PHP configuration. You can see an example of the issue here (and the suggested solution here.

I hope that helps to provide you a solution. Please let us know if you have any further questions.

Regards,
Arnel C.



n/a Points
2014-11-06 4:15 am

When I get to step 3, it's asking if it is ok to overwrite the existing files? Because you don't mention this in your steps, I found it alarming. There are other options given - should I choose one of those?

Staff
28,219 Points
2014-11-06 9:15 am
Hello Amy,

I performed the install on a fresh OpenCart install and do not get that message. However, there are some files in the System folder that go under directory named 'shared' so it is possible you have another extension that was installed previously with the same file names. If you have followed standard procedure and have a backup copy handy in case something goes wrong, then you can certainly go ahead and have it overwrite the files. Be sure you have the backup ready in case it breaks another extension.

Kindest Regards,
Scott M
n/a Points
2014-12-15 1:16 pm

Muchas gracias. Me ha servido de mucha ayuda. Saludos

n/a Points
2014-12-22 5:21 am

Hello,

 

Everything is configured as mentioned. when  we try to export from System Export/Import page, am getting the following two errors.

 

<b>Fatal error</b>:  Uncaught exception 'ErrorException' with message 'Error: Table 'opencart3.oc_product_tag' doesn't exist&lt;br /&gt;Error No: 1146&lt;br /&gt;SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR &quot;,&quot; ) 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 &quot;,&quot; ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR &quot;,&quot; ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_ in <b>E:\xampp\htdocs\opencart3\system\database\mysqli.php</b> on line <b>41</b><br />

 

<b>Fatal Error</b>: Uncaught exception 'ErrorException' with message 'Error: Table 'opencart3.oc_product_tag' doesn't exist<br />Error No: 1146<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 `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_ in <b>E:\xampp\htdocs\opencart3\system\database\mysqli.php</b> on line <b>41</b>

 

Can you please let me know where it went wrong.

Staff
11,186 Points
2014-12-22 11:13 am
This error is stating that it is trying to access a table that does not actually exist. Based on some research that I have done, it looks to be caused by a conflict with other extensions. I recommend disabling any other extension to see if that fixes the problem.
n/a Points
2014-12-29 3:20 pm

hi

i have installed the Export/Import Tool Successfully as described in the installation note / steps.

first i was unable to see the Export/Import Tool Under System Menu then i have added some lines as given by the Export/Import Tool installation note and now i successfully see it.

but afterward now whenever i try to click the Export/Import from system menu i get this error :

 

Permission Denied

 

where as i am the admin and with full access previlage and also have checked :

User Group/ Top Administrator :  all the Fields are Selected and i have checked it several times including the  tool/export_import selected/ Ticked.

 

Please help i need this export/import tool to be worked its a life saver tool.

So many thanks in advance for all of you developers Support and effort to help the community.

Regards

Afsar

Staff
25,386 Points
2014-12-29 3:47 pm
Hello Afsar,

Sorry for the problem with the import/export extension. Unfortunately, there are now two different installations of OpenCart - version 2.0 and 1.5x. Can you please specify what version you're running? The issue may be related to the version that you're running. The instructions for the document above do apply to the 1.5 version, but the main issue may be related to vQmod which has two different versions.

Please provide us this information and we can look further into the issue for you.

Regards,
Arnel C.
n/a Points
2015-01-08 9:12 am

Dear Arnel C.,

 

So many thanks for your quickly reply my opencart version is 1.5.6.4 i have solved the problem. there is no problem with this extension.

really thanks

Regards

Afsar Ahmed

n/a Points
2015-01-07 5:05 pm

hi

you have developed a wonderful product but one thing i want to ask that is there any product or extension through which we could copy or import the products from some one else store without having access to their admin.

suppose we want to list geepas products from their main website on our website every thing is same except price so they are 1500 products their entry one by one is too hard so if there is any way to directly copy from that website and list them to own website which will need a little bit changes

so i am waiting for a positive response

Regards

Sam

Staff
16,968 Points
2015-01-07 5:50 pm
Hello Sam,

Thank you for your question. Unfortunately, I am not aware of an extension for importing products from another site.

If you can get a product list or catalog from the site, you may be able copy them into an Excel spreadsheet that can be imported as described above.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul
n/a Points
2015-01-08 6:46 am

hi jhon

tnx for replying my query. so either is there any way to copy specific category products from any website and then upload it to own.

if there is then please let me know.

Regards

Sam

Staff
16,968 Points
2015-01-08 5:18 pm
Hello Sam,

Thank you for contacting us again. Unfortunately, you would have to custom code, or develop a solution for this, since there is no existing tool to accomplish this.

Thank you,
John-Paul
n/a Points
2015-01-12 7:57 pm

hello

i tried to install this multie times. even though it says installation complete it does not show in the permissions tab to be checked off nor in the system tab. it only show under istalled extensions. opencart 2.x latest version. i admin zencart and oscommerce boxes. wanted to try out open cart and wonder if this is normal with oc. bare bones default install with no mods. this was the first extension. tried with and without vqmod. no difference

 

thanks

jim

 

 

 

Staff
28,219 Points
2015-01-12 8:20 pm
Hello Jim,

This article is specific to the 1.5.x version. OpenCart 2.x is very new and has not been fully tested. I am not sure about any of the downloadable extensions working with it at this point. We are starting to write documentation and test some things for it, but so far we do not have much knowledge of this version.

Kindest Regards,
Scott M
n/a Points
2015-01-16 11:35 am

hi installed the extension but it gives me this message

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 16570 bytes) in /home/arcadebusiness/public_html/system/PHPExcel/Classes/PHPExcel/Cell/DataType.php on line 100

 

what is the solution for this problem to solve.

tnx in advance

Staff
25,386 Points
2015-01-16 3:37 pm
Hello Samir,

Sorry you're having problems with the Bulk import extension. If you have many products, then you need to find a way to reduce the number that you're exporting or importing. Otherwise, you will have a problem with the memory. Also, you have not specified what version of OpenCart you're using and what version of the plugin you installed. Please include that information when you're asking for technical support as it helps to properly assess the issue.

The error you're seeing those is common when importing a very large list of products. If that is the case, cut down on the number of products that your importing (or exporting) at one time.

Regards,
Arnel C.
n/a Points
2015-02-04 1:47 pm

Using most current version of opencart (as of today 2.0), downloaded an installed the correct version and vqmod.  Everything installed correction, vqmod showing cache files, site loads fine, but its not showing up in tools and its not a browser cache issue.  Any suggestions?

Staff
25,386 Points
2015-02-04 2:03 pm
Hello Keith,

VQMod is not something that will show in tools. You should see it appear in the extensions, though as per the screenshots on this page. Please review the instructions, compare them to what you did and then review your installation.

Kindest regards,
Arnel C.
n/a Points
2015-02-12 2:09 am

I installed the software to opencart 2.0.1.1 and now cannot access admin.

 

www.****************.com.au/admin

 

Help?

Staff
16,968 Points
2015-02-12 1:39 pm
Hello Richard,

Thank you for contacting us. I navigated to the admin page you provided, and it is loading up for me. Are you still having issues?

If you are, what is happening?

Are you getting any errors?

Any additional information that can help us test and duplicate the problem will help us in troubleshooting.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul
n/a Points
2015-02-12 6:41 pm

HelloI have installed vqmod succesfully, and then installed the import\export extension following all the point of this guide.Anyway, can't see the System Import\Export in my dashboard panel.the site is www.loveadultin.com/shopOpencart installed is version 2.0.1.1Thanx in advance for your help

n/a Points
2015-02-27 8:03 am

Marco,

I have installed the import/export tool in opencart theme version 2.0.1.1 and i can assist you in this matter if you need further assistance you can email me here : afsarctg@gmail.com 

Regards

Afsar Ahmed

Staff
28,219 Points
2015-02-16 10:25 am
Hello Marco,

The instructions above should work for you. We do not have specific instructions for OpenCart 2.0 as of yet. Theses instructions are for 1.5.x version so it is possible there is something different needed for 2.x versions.

Kindest Regards,
Scott M
n/a Points
2015-03-15 3:06 am

Hiya, I'm looking for an extension that will help me upload a product list - with no price. I am having a website built for print and embroidered clothing, I have my wholesalers catalog without prices to show what's available as well as a smaller core selection that has prices included... is this the one I need? Thanks so much in advance,

Staff
28,219 Points
2015-03-16 1:24 pm
Hello Helen,

This is the basic import/export extension. You may wan to check into extensions that remove prices or allow you to hide them. You may want to check out the different features available from the extension directory.

Kindest Regards,
Scott M
n/a Points
2015-03-18 11:11 am

hi, I have done all the steps which you have shown everything is done fine but when I go to dashbord I am unable to find export/import please guide me where to find it?

Staff
16,968 Points
2015-03-19 6:31 pm
Hello Manoj,

Thank you for contacting us. Our guide on Using the Bulk Export/ Import Extension in OpenCart includes a screenshot:

In that example, they go to System-->Export/Import.

If that is not working for you, please provide some details such as the version of OpenCart you are using, and any other 3rd party extensions/modules.

This will allow is to simulate your website in a test environment.

Thank you,
John-Paul
n/a Points
2015-04-06 12:08 pm

Hey guys. This is a useful article, thanks for posting it, helped me in great manner. Although  i was searching for more efficient way, to import\export products. I found this tools, not sure if this is OpenCart extension, or stand alone tool, but they have detailed documentation for this question: 

this is for import - http://store-manager-for-opencart-documentation.emagicone.com/products-management/import-products

and this is for export - http://store-manager-for-opencart-documentation.emagicone.com/products-management/export-products

I tried this on their trial version, had to spend few hours, but in the end i managed to do this bit more fluently. 

I hope this might help somebody. 

Chuck

Staff
16,968 Points
2015-04-06 12:29 pm
Hello Chuck,

Thank you for the suggestion. Feel free to contribute additional posts in our User Submitted section.

Thank you,
John-Paul
n/a Points
2015-04-10 6:49 am

Hi to all i need some help some one will guide me how i install this in to opencart 2.0.1.1 

i have installed this extension yet. import/export is just showing in user group and not showing in admin panel any one guide me how i use this in opencart 2.0.1.1  

 

Staff
28,219 Points
2015-04-13 7:18 am
Hello Fareed,

We have not yet created an article for OpenCart 2.x on this subject. I assume the method should be very similar. If you have any specific questions along the way, feel free to ask.

Kindest Regards,
Scott M
n/a Points
2015-04-13 11:31 pm

******************************1_Mon.log*******************************---------- Date: 2015-04-13 22:17:39 ~ IP : 73.45.170.179 ----------REQUEST URI : /admin/MOD DETAILS:   modFile   : /home/kingasho/public_html/vqmod/xml/export_import.xml   id        : Export/Import Tool for OpenCart 1.5.x   version   : 1.5.x-2.26   vqmver    : 2.4.1   author    : mhccorp.comFile Name    : admin/view/template/common/header.tpl(0)VQModObject::applyMod - SEARCH NOT FOUND (ABORTING MOD): <li><a href="/support/<?php echo $backup; ?>"><?php echo $text_backup; ?></a></li>

Staff
25,386 Points
2015-04-14 11:23 am
Hello 17006,

I'm sorry that you're having problems with the Export/Import tool for OpenCart. Unfortunately, without detailed information about the file you're trying to import, then you will need to look for support with the author of the tool. Check out these OpenCart support forum posts on this tool - they may have already experienced what you're seeing.

Regards,
Arnel C.
n/a Points
2015-04-27 3:00 pm

Got it to install..vqmod successfully installed and then installed the import\export extension , Access and Modify also cheked ,   BUT the "System > Export/Import" is not showing up.  plese help me

i was did as per your guide line steps.

1)opencart version is:2.0.0,

2) vqmod-2.5.1-opencart.zip

3)opencart-2-0-x-export-import-multilingual-2-26.ocmod.zip Verson2.0.0.0,

 

Staff
28,219 Points
2015-04-27 5:11 pm
Hello srinu,

This article is specific to OpenCart 1.5.x and as of yet we have no new articles for 2.x. We are beginning the process of writing those so we may have an article soon for this subject.

Kindest Regards,
Scott M
n/a Points
2015-06-19 9:48 am

Hi,

I'm really puzzled.

I have the opencart 2.0 and a default template.

I've read all the instructions. Did as it says. But still can't see the extention in the admin panel. 

I also checked the rights and the vqmod. It says, that it is already installed. What else can I do? Please help.

Thanks,

Stacy R.

 

Staff
25,386 Points
2015-06-19 12:51 pm
Stacy,

Make sure to that you you're using the appropriate version as well as the correct version of any required software. If you're still not able to see it, then you should contact the authors of the plugin for further support.

I hope that helps to answer your question! If you require further assistance, please let us know!

Regards,
Arnel C.
n/a Points
2015-05-13 12:26 am

i have got following error while import products list using your import/export plugins

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

 

please help me i have succesfuly install plugin in opencart 2.0.1.0 version.

thanks.

 

 

Staff
25,386 Points
2015-05-14 10:38 am
Hello Kapil Vyas,

Sorry for the problem with the import/export plugins. These plugins were not developed by InMotion. If you can provide more information about the exact name and version of the plugin, we can look into it further. Also, finding the error log and then providing the error, would help to determine why it's failing. Otherwise, you should contact the developer for of the plugin for further support.

Regards,
Arnel C.
n/a Points
2015-05-24 7:11 am

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

2015-05-24 10:59:50 - Export/Import: Undefined option_value_name 'Bath End Panel' for optiion_id '5' used in worksheet 'ProductOptionValues'!

pls advice how to get rid off this error while importing

Staff
3,885 Points
2015-05-27 9:40 am
Hello Shiv,

It seems that you are trying to import duplicate items to your database. I would check both the file you are trying to import and the database. If there are duplicates then remove them from the importing file.

Best Regards,
TJ Edens
n/a Points
2015-05-27 3:47 pm

Hi,

I went through the installation procedures for vqmod and the import/export tool with no issues but like some others i cant see the System > Export/Import in my dashboard page. Can you please help with this, I installed  on Open Cart Version 2.0.1.1 using opencart-2-0-x-export-import-multilingual-2-26.ocmod and vqmod-2.5.1-opencart

Looking forward to your response,

Thank You.

Staff
25,386 Points
2015-05-29 10:58 am
Hello Kenny,

Sorry for the problem with with Import/Export tool. Unfortunately, we did not write the code. Your best avenue of support is to contact the author of the extension that you're using. You can find more information by going to the download page from the OpenCart site. If you have any further questions or comments, please let us know.

Regards,
Arnel C.
n/a Points
2015-07-06 6:37 am

i have installed this plugin and checked the tool/xls_import  

in user group section .But no option shown under system. My opencart version is 2.0.1.1 and latest vqmode is installed. Please Help 

Thanks in Advance

Staff
25,386 Points
2015-07-06 10:13 am
Hello Yogesh,

We would still need more information on the version that you installed. What version of the extension did you install? What version of vqMod? Make sure to sure read the readme.txt file for specific installation instructions. Additionally, make SURE that your vqMod is installed correctly. If its not working, then the extension won't work either.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.
n/a Points
2015-07-06 2:36 pm

Sir,

i have installed  v2.5.1-opencart vqmode and installed using this /vqmode/install and get success message. opencart-2-0-x-export-import-multilingual-2-26.ocmod.zip version of your extension is installed by me. Files of extension directly uploaded by filezilla.

Staff
25,386 Points
2015-07-07 2:05 pm
Hello Yogesh,

If you look at the page where you can download the extension file, you can see that the actual versions of OpenCart which are compatible. Using the latest one is probably the reason that it's not working. Please make sure to check for these version incompatibilities before proceeding.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.
n/a Points
2015-07-07 12:39 am

i have insatalled v2.5.1 opencart and insatalled with url /vqmode/install and get succesfull installaton message. i have directly copied you plugin files to my root folder(varsion installed is : opencart-2-0-x-export-import-multilingual-2-26.ocmod.zip).

n/a Points
2015-07-27 6:34 am

Installing works fine. I also got file imported successfully. Now what..

my site goes into maintaince mode. and I don't see any products added to the product page. What might have gone wrong...

Staff
28,219 Points
2015-07-27 3:04 pm
Hello Vivek,

Did you set it to maintenance mode? Did your products disappear? What errors do you see on the screen? Did you add any other extensions prior to this happening? What version of OpenCart and the module are you using?

Kindest Regards,
Scott M

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

116 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!