Export Customers and Order data to Excel XLS/CSV

*** Now for Opencart 3.0.x.x ***

This tool allows you to quickly and easily export your customer, orders, product line and any related option details to an Excel (.XLS, .XLSX) file or a zipped set of CSVs. Ideal for then importing into your own accounts package or using for sales reporting and calculating. Or simply use the customer data for a mailing campaign.

Features
========
* NEW! Ability to export product options applied during the order
* Filter customers by newsletter subscription status. Ideal for email campaigns.
* Added new function allowing you to filter on missing orders ie abandoned orders.
* Choose between flat data type or multiple sheets
* Extremely simple to install, 2 stage install process (see Documentation)
* OCMOD enabled
* Date and ID filters to export specific data
* Export customer records for a mailing campaign
* Export orders, products and customer records
* Outputs full order information including line items, taxes and shipping
* File formats supported .XLS, XLSX or .CSV formats
* Choose between compressed (ZIP) or uncompressed formats
* Full email support (email address in supplied install.txt file)

A 2.0.x.x demo is available here

Navigate to "System -> Tools -> Export cust. data"

username: demo
password: demo



The fields exported are:

Customer data
---------------------
Customer ID
First Name
Last Name
Full Name
Email
Telephone
Fax
Company
Address 1
Address 2
City
County
Postcode
Country
Customer Group
Store
Newsletter
Status
Approved

Order data
----------------
Store ID
Store Name
Store URL
Customer ID
Customer Group Id
First Name
Last Name
Email
Telephone
Fax
Payment First Name
Payment Last Name
Payment Company
Payment Company ID
Tax ID
Payment Address 1
Payment Address 2
Payment City
Payment Postcode
Payment Country
Payment Country ID
Payment Zone
Payment Zone ID
Payment Address Format
Payment Method
Payment Code
Shipping First Name
Shipping Last Name
Shipping Company
Shipping Address 1
Shipping Address 2
Shipping City
Shipping Postcode
Shipping Country
Shipping Country ID
Shipping Zone
Shipping Zone ID
Shipping Address Format
Shipping Method
Shipping Code
Comment
Total
Order Status ID
Affiliate ID
Commission
Language ID
Currency ID
Currency Code
Currency Value
IP
Forwarded IP
User Agent
Accept Language
Date Added
Date Modified
Including the additional Tax and shipping lines that you create

Order products
---------------------
Order Product ID
Order ID
Product ID
Name
Model
Quantity
Price
Total
Tax
Reward
Option Name
Option Value
Option Type

Click here for a list of our other extensions

What customers say about Export Customers and Order data to Excel XLS/CSV

HemiDart
Essential.
~HemiDart




Price
$20.00

  • Developed by OpenCart Community
  • Documentation Included

Rating

Compatibility
3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 4.0.0.0_b, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2, 2.1.0.1, 2.1.0.2, 2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0

Last Update
26 May 2021

Created
29 Mar 2013
510 Sales
195 Comments
krikey
krikey
Member since: 3 Oct 2010

View all extensions Get Support