Excel Export for Opencart

Excel Export allow you to easily export all your orders into an Excel files. You can choose to export as invoice or list.

Requirements

• Opencart 1.5.3.x to 1.5.6.4
• vqmod opencart module
• PHP5

Old version

This repo is now separate by branch. The current branch is the latest supported version of Opencart : 1.5.5.x. However, if you want to use this extension for 1.5.3.x to 1.5.4.x version of Opencart, please use the following link : https://github.com/SoftMonkeyJapan/opencart-excel-export/archive/1.5.3.x-to-1.5.4.x.zip

Installation

[Manual]

• Download this: https://github.com/SoftMonkeyJapan/opencart-excel-export/archive/1.5.5.x-to-1.5.6.4.zip
• Unzip that download.
• Go into the unzip folder
• Merge the system folder into your system opencart directory
• Merge the admin folder with your admin opencart directory
• Merge the vqmod folder with your vqmod opencart directory

Usage

Initialization

By default, you won't be able to use the component due to permissions restrictions. In order to change this behavior, go under System->Users->Users Groups and then edit the group you want to allow the access.

In Access Permission and Modify Permission, check the item report/export_xls and then save. You can now use the component.

How to use

For more details on how to use it, go to http://kartono-loic.com/app/webroot/excel-export/documentation/

Features

The plugin can actually do the following things :

• Export an order as invoice including the Store logo if any
• Export an order as list including the following informations :
  • Order ID, Invoice Number, Store Name, Customer, Customer Company, Customer Email, Customer Telephone, Total (Price), VAT, Date of Purchase, Quantity, Product Name, Color, Size, Firstname, Lastname, Address, City, Postal Code, Region/State, Country, Shipping Method
• Export all orders as list in one file
• i18n support for the following locales : English, French, Russian, Chinese (zh-TW)

Thanks

It's important to thanks poeple that helped me improve this extension :

• Laurent Chapin
• 阿維
• Ilsur Bilalov

License

License under MIT