Orders + Options Excel Export for Opencart 2 and 3

Orders + Options Excel Export for Opencart 2 and 3
INTRODUCTION

This script should work in all OpenCart 2.x and 3.x installations because it extracts the data directly from the OpenCart Database and does not rely on any OpenCart directory files. No VQMod, OCMod, theme or permissions required!

The script just dumps readable order data in an Excel file, you may later use Excel functions to auto-format the data according to your needs.

INSIDE THE PACKAGE

There are two versions of the script within the ZIP package. The first one exports the contents directly to the Excel format and should work in most of the installations if your computer/database/server uses English/Latin character sets.

If the exported XLS appears with strange characters you should use the UTF-8 TXT version of the script. It allows conversion of different database charsets to UTF-8 and then exports it to a semicolon delimited .TXT file that can later be imported into Excel.

INSTRUCTIONS

1. Edit the script in any text editor. Set the configuration of your database, table prefixes and set an access PASSWORD. The password will protect the script from outside access and should be different than the DB password.

2. Place the modified script in any accessible (but safe) folder in your server, for example, the OpenCart /admin directory.

3. Access the script by using the following URL. Remember to replace YOURPASSWORD with the password you set in the configuration file.

URL: https://www.yourserver.com/yourfolder/admin/order_export.php?pw=YOURPASSWORD

4. If everything is OK you will be prompted to download the Excel file.

5. Each line of the Excel file represents one order item or item option. You may group options for the same item by using the column product_item.

6. In case of error the file will be downloaded as a PHP file. Open it to find what's wrong.

7. If the characters are not displaying correctly consider the UTF-8 TXT version of the script. This requires an additional configuration of the source database charset.

LICENSE

MIT. Do whatever you want with it.

DID IT WORKED?

Then please rate the script. I ask no donations for it.

NEED HELP?

Please visit the following website and use the comments box:

http://www.danbp.org/p/node/125

I will not answer any questions from the comment box below.

SUPORTE EM PORTUGUÊS

Por favor use a seção de comentários do site:
http://www.danbp.org/p/pt-br/node/125




Download
  • Developed by OpenCart Community
  • Documentation Included

Rating

Compatibility
2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2, 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 4.x.x.x, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8

Last Update
27 Dec 2021

Created
1 May 2017
4153 Downloads
29 Comments
danpeig
danpeig
Member since: 18 Nov 2016

View all extensions Get Support