|Extension Name||Smart Export/Import(VQMOD)||Rating|
|Date Added||23 June 2013||Request Support|
|Date Modified||2 September 2016||Report extension|
the is important:
if it Save a lot of time, help you solve the problem,please rate 5 to this software thanks.
Management of many products is painful, you need to update the mass data, isn't it?
the function can export/import all product message and categories, support single language.
you can export all product info to excel ,then fix or insert new, import the excel!
so that is very easy manger your products.
if you need multilanguage ,please go to
[the multi language]
Export/Import to Excel the whole data for all your products, including Category / Options
1.The Smart Export/Import Tool allows to incremental import/export( Continuous import your product's data with Excel file one by one)
2.new data will be inserted. old data is still there,exist data is will modify
3.of all the categories, all message of products , and product options to an Excel spreadsheet file.
4.The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.
5.if system product is exist the excel,it will modify your system product's message.
if system product is not exist the excel,it will add the product's message to your system
6.you can batch modify your product data ,Such as price or quantity or model or points or seo_keyword or description etc,all the product's
7.you can export the product's by product_id ,begin product_id and end product_id
8.you can export the product's by batch too
9.the program dont delete your system data,your product's data is secure
I have solved this problem
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 106 bytes)
install the vqmod mod (v2.5.1),if you use 2.x,must use vqmod 2.5.1
Upload the folders 'admin', 'system', 'vqmod' and their files
from the 'upload' directory to your OpenCart root directory. Do not overwrite any files.
How to use:
login your store with admin then
1.system -> users -> user group - > select top administrator -> select all -> save
2.back your database use System -> Backup/Restore
3.system -> SmartExportImport
How to obtain the sample
You can export EXCEL, this file is an example,
you can modify and add new products in the excel,
if you want to add a product, need to add a new product ID and information in excel,
if you want to modify the products, please find the corresponding product ID ,it can be modified.
then upload the excel to system by smart export import
these is very simple ,so you do not need the demo website:)
There are several reasons can cause you don't see this function Smart Export/Import
1, you modify the the path of admin, such as admin modified myadmin
2, you modify admin\view\template\common\header.tpl
3, you use other plugins, compatibility (this can send e-mail to tell me you website admin and ftp info)
4, you do not have installed vqmod or it is not working properly
update for php7
solve the filter group miss problem
|Smart-export-import-opencart-18.104.22.168(single language).zip||22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199||[ Download ]|
|Smart-export-import-opencart-188.8.131.52(single language).zip||184.108.40.206, 1.5.2, 220.127.116.11||[ Download ]|
|user_guide(SmartExportImport-single_language).zip||18.104.22.168, 1.5.2, 22.214.171.124, 1.5.3, 126.96.36.199, 1.5.4, 188.8.131.52, 1.5.5, 184.108.40.206, 1.5.6, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124||[ Download ]|
|Smart-export-import-opencart-126.96.36.199(single language).zip||1.5.4, 188.8.131.52||[ Download ]|
|Smart-export-import-opencart-184.108.40.206(single language).zip||1.5.5, 220.127.116.11||[ Download ]|
|Smart-export-import-opencart-18.104.22.168(single-language).zip||1.5.6, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206||[ Download ]|
|Smart-export-import-opencart-220.127.116.11(single language).zip||1.5.3, 18.104.22.168||[ Download ]|
smart export/import extension:
the test help :
the export for example
export format is excel for office excel 97-2003
you can export the product message by product_id
your products number total is 8000
wish batch totals is 4000 then your batch total is 2
if Export number batch is 1 then export the excel product number from 1 to 4000
if Export number batch is 2 then export the excel product number from 4001 to 8000
the import for example
I am going to use your smart import/export backup excel file(the third section: 5001-8000),I am going
to add one category and several subcategories,and around 100 products(product id 8001-8100),
at the same time,I am going to modify product description from product id 7900-product id 8000,
and their price,quantities, then import this file,I would like to see product id 5001-7899 still there,
and the information of product id from 7900-8000 will be updated,and new products and their category,
subcategories from 8001-8100 will be inserted.