How to Export various data to csv / excel, both for admin and user + transaction history question
Posted: Thu May 02, 2024 11:00 am
Hi,
Currently looking for someone who can make the following extension(s) / modifications, or can help me to make it by myself:
1. Extensions similar to csv / excel export / import; in addition, we should be able to:
1. On admin side:
a) Order history - export orders to csv /or excel format; it is necessary to enable filter when exporting, so as to be able to export orders by orders' statuses, for example, Shipped orders only; I see it like: Admin - Sales - Orders - Export to CSV button. Should contain following data: JAN code, name, order No., item price, item weight, total order amount);
b) Transaction history: availability to export chosen client's transactions to csv/or excel.
c) Products - to export / import products in a form of price list (it includes JAN code, name, and price per each item);
2. The same for the front side: a user / client should be able to download the following data in csv/or excel format:
a) Orders history - orders export to csv/or excel; here the filtering also needed, so a client can choose orders by their status (Exp, shipped orders only); Account - Order history - Export to CSV button.
b) Transactions - transactions' history export to csv/or excel;
c) Products - to export products from our web site in a form of price list (also csv/or excel format).
3. In addition, if it is possible: each order automatically calculated in clients' transaction history, that is: after an order is made, the order amount deducted and reflected in the transaction history (both for admin and user), but the possibility to correct / add / cancel transactions should remain for admin.
The Opencart version is 3.0.2.0.
Please advise if you can help with it. Tried to apply public function, as explained here: https://code.tutsplus.com/building-a-pr ... cms-23725t , but only managed to create Export to CSV button in admin panel; looks cool, but does not work...
Your help will be greatly appreciated.
Waiting for your reply.
Currently looking for someone who can make the following extension(s) / modifications, or can help me to make it by myself:
1. Extensions similar to csv / excel export / import; in addition, we should be able to:
1. On admin side:
a) Order history - export orders to csv /or excel format; it is necessary to enable filter when exporting, so as to be able to export orders by orders' statuses, for example, Shipped orders only; I see it like: Admin - Sales - Orders - Export to CSV button. Should contain following data: JAN code, name, order No., item price, item weight, total order amount);
b) Transaction history: availability to export chosen client's transactions to csv/or excel.
c) Products - to export / import products in a form of price list (it includes JAN code, name, and price per each item);
2. The same for the front side: a user / client should be able to download the following data in csv/or excel format:
a) Orders history - orders export to csv/or excel; here the filtering also needed, so a client can choose orders by their status (Exp, shipped orders only); Account - Order history - Export to CSV button.
b) Transactions - transactions' history export to csv/or excel;
c) Products - to export products from our web site in a form of price list (also csv/or excel format).
3. In addition, if it is possible: each order automatically calculated in clients' transaction history, that is: after an order is made, the order amount deducted and reflected in the transaction history (both for admin and user), but the possibility to correct / add / cancel transactions should remain for admin.
The Opencart version is 3.0.2.0.
Please advise if you can help with it. Tried to apply public function, as explained here: https://code.tutsplus.com/building-a-pr ... cms-23725t , but only managed to create Export to CSV button in admin panel; looks cool, but does not work...
Your help will be greatly appreciated.
Waiting for your reply.