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
