Home > Article > Backend Development > opencart import and export export/import function plug-in_PHP tutorial
opencart import and export export/import function plug-in_PHP tutorial
- WBOYOriginal
- 2016-07-14 10:11:221575browse
This version is only applicable to 1.5.5 and 1.5.5.1, please note when downloading.
Function: Website administrators can export and import in batches. The data includes all categories, products, and product options, and generates excel files in the format of xlsx;
Requirements and restrictions:
1. Currently only supports a single language;
2. The content requirements will be relatively high. For example, if your website has 13,500 products and 300 directories, then: the XLS file size will reach 9-10M; the memory will reach 13M when exporting; the memory will reach 355M when importing. To achieve this standard, the following PHP settings are required:
memory_limit 512M
post_max_size 16M
upload_max_filesize 16M
Not every server space can provide such high processing memory settings. So if you use basic server space and don't have a lot of products, it's ok. Otherwise, you need to find a better server space to rent that is suitable for opencart operation.
The above-mentioned high required memory is because PHPExcelReader needs it when parsing the file and loads it into the memory when it starts running.
Plug-in installation:
1. Download the opencart import and export export/import function plug-in;
2. Unzip;
3. Make sure you have installed VQMOD for your opencart system;
4. Copy the decompressed single directory (admin, system, vqmod) to the root directory of your website. Note that no files are overwritten at this time;
5. Set the permissions of the website administrator in the background (System > Users > User Group) so that they can access and edit this "opencart import and export export/import function plug-in";
6. At this time, the export/import menu option appears in the drop-down menu of the background system;
7. That's all!