Monday, September 1, 2014

Cara export report penjualan,pelanggan toko online opencart


Didalam default toko online opencart di menu report tidak ada tombol untuk export/download report to excel, dari pengalaman saya dari keluhan pelanggan akhirnya saya mencari bagaimana bisa untuk membuatkan module export to excel report toko online opencart.

Pas kebetulan saya browsing ternyata di toko online opencart sudah menyediakan  extension export to excel, anda bisa download di sini extension export to excel setelah anda berhasil download silahkan instal extension didalam cPanel anda, adapaun fetured yang diberikan untuk extension ini adalah

The fields Exported are

Sales Orders Report :
Start Date,
End Date,
No Of Orders,
No Of Products,
Tax,
Total.

Sales Tax Report :
Start Date,
End Date,
Tax Title,
No Of Orders,
Total.

Sales Shipping Report :
Start Date,
End Date,
Shipping Title,
No. Orders,
Total.

Sales Return Report :
Start Date,
End Date,
No of Returns.


Sales Coupon Report :
Coupon Name,
Coupon Code,
Orders,
Total.

Product Purchased Report :
Product Name,
Model,
Quantity,
Total.

Customer Online Report :
IP,
Customer,
Last Visited Page,
Referer,
Last Click.

Customer Ordered Report :
Customer Name,
Email,
Customer Group,
Status,
Orders,
Products,
Total.

Customer Reward Points Report :
Customer Name,
Email,
Customer Group,
Status,
Reward Points,
No of Orders,
Total.

Customer Credit Report :
Customer Name,
Email,
Customer Group,
Status,
Total.

Affiliate Commission Report :
Affiliate Name,
Email,
Status,
Commission,
No of Orders,
Total.

Namun masih ada yang belum bisa sempurna dengan extension ini yaitu tidak bisa export report data yang sudah kita filter, penggunaan extension ini hanyalah export data all.

Tapi buat penggemar opencart yang setia jangan khawatir dengan hal itu ternyata penyedia extension Export report juga menyediakan yang berbayar silahkan lihat disini, adapun featurednya adalah

The fields Exported are

Sales Orders Report :
Start Date,
End Date,
No Of Orders,
No Of Products,
Tax,
Total.

Sales Tax Report :
Start Date,
End Date,
Tax Title,
No Of Orders,
Total.

Sales Shipping Report :
Start Date,
End Date,
Shipping Title,
No. Orders,
Total.

Sales Return Report :
Start Date,
End Date,
No of Returns.


Sales Coupon Report :
Coupon Name,
Coupon Code,
Orders,
Total.

Product Purchased Report :
Product Name,
Model,
Quantity,
Total.

Customer Online Report :
IP,
Customer,
Last Visited Page,
Referer,
Last Click.

Customer Ordered Report :
Customer Name,
Email,
Customer Group,
Status,
Orders,
Products,
Total.

Customer Reward Points Report :
Customer Name,
Email,
Customer Group,
Status,
Reward Points,
No of Orders,
Total.

Customer Credit Report :
Customer Name,
Email,
Customer Group,
Status,
Total.

Affiliate Commission Report :
Affiliate Name,
Email,
Status,
Commission,
No of Orders,
Total.

Semoga dengan pengalaman saya ini bisa membantu rekan2 penggemar opencart semua.

Terimakasih,
Admin


Website dengan version mobile dan themes yang responsive, pesan sekarang juga disini




0 komentar:

Post a Comment