- Posts: 43
- Thank you received: 2
Unable to EXPORT CSV for sub-vendor orders / BackN
12 years 4 months ago #156635
by drmad
Unable to EXPORT CSV for sub-vendor orders / BackN was created by drmad
I am testing the new shop/market version in our UAT environment, and found below issue.
This is an Backend issue:
- Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors;
- I have checked / selected the required orders from the list
- file exported is 0 byte without any contents.
p.s Using the same method, export CSV for main-order has no issue.
Best regards,
This is an Backend issue:
- Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors;
- I have checked / selected the required orders from the list
- file exported is 0 byte without any contents.
p.s Using the same method, export CSV for main-order has no issue.
Best regards,
Please Log in or Create an account to join the conversation.
12 years 4 months ago #156647
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic Unable to EXPORT CSV for sub-vendor orders / BackN
Hi,
Exporting "subsales" in HikaShop backend is not possible by "definition".
In the file "administrator/components/com_hikashop/views/order/view.html.php" at the beginning of the function "export" you will find this code
this filter block the order_type to just "sale".
You can edit this line to put
in order to allow subsales too.
Regards,
Exporting "subsales" in HikaShop backend is not possible by "definition".
In the file "administrator/components/com_hikashop/views/order/view.html.php" at the beginning of the function "export" you will find this code
Code:
$filters = array('b.order_type=\'sale\'');
You can edit this line to put
Code:
$filters = array('(b.order_type=\'sale\' OR b.order_type=\'subsale\')');
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
12 years 4 months ago #156829
by drmad
Replied by drmad on topic Unable to EXPORT CSV for sub-vendor orders / BackN
Hi Jerome,
Thanks for your codes and suggestions.
Actually the reason for us to extract vendor report, is to calculate the % commission charges & summarize the amount of money we need to payback respective vendor at month-end. We prefer NOT to have any core-hack / code changes for this purposes.
I guess it's hidden somewhere with hikashop/market. (There are too many functions with the reporting tools) Would you mind to guide us how to extract reports for below items? (We will normally do it once a month for all vendors), in CSV format for data record and trending projection. (excel, etc)
** Currency should be included/ indicated into below reports
1) Extract the Sales Records for each vendor in a month,
2) Extract data for Payment Amount we need to pay to our vendors for each end of month
3) Extract data for Commission that we charge for each vendors vs. orders
Thanks.
Thanks for your codes and suggestions.
Actually the reason for us to extract vendor report, is to calculate the % commission charges & summarize the amount of money we need to payback respective vendor at month-end. We prefer NOT to have any core-hack / code changes for this purposes.
I guess it's hidden somewhere with hikashop/market. (There are too many functions with the reporting tools) Would you mind to guide us how to extract reports for below items? (We will normally do it once a month for all vendors), in CSV format for data record and trending projection. (excel, etc)
** Currency should be included/ indicated into below reports
1) Extract the Sales Records for each vendor in a month,
2) Extract data for Payment Amount we need to pay to our vendors for each end of month
3) Extract data for Commission that we charge for each vendors vs. orders
Thanks.
Please Log in or Create an account to join the conversation.
12 years 4 months ago #156855
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic Unable to EXPORT CSV for sub-vendor orders / BackN
Hi,
I think I will put something in HikaMarket to override the HikAshop filters during the export.
You should be able to export the sub sales too. So in my point of view, it is not a core hack.
HikaMarket propose some statistics to the vendors ; we can see to add some reports in the backend too.
Regards,
I think I will put something in HikaMarket to override the HikAshop filters during the export.
You should be able to export the sub sales too. So in my point of view, it is not a core hack.
HikaMarket propose some statistics to the vendors ; we can see to add some reports in the backend too.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
12 years 4 months ago #156875
by drmad
Replied by drmad on topic Unable to EXPORT CSV for sub-vendor orders / BackN
Hi Jerome,
Thanks. So I can safely add your proposed code at the moment and you will enhance the filter in future release (or same stable release), am I correct? Please also consider to add some report that will be run by the market owner, like...
1) Vendor's performance (individual sales) report
2) Vendor's payments / charges report
Thanks
Thanks. So I can safely add your proposed code at the moment and you will enhance the filter in future release (or same stable release), am I correct? Please also consider to add some report that will be run by the market owner, like...
1) Vendor's performance (individual sales) report
2) Vendor's payments / charges report
Thanks
Please Log in or Create an account to join the conversation.
12 years 4 months ago #156997
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic Unable to EXPORT CSV for sub-vendor orders / BackN
Hi,
Yes, you can add the modification.
The code I will put in HikaMarket will be different but the result will be the same.
Regards,
Yes, you can add the modification.
The code I will put in HikaMarket will be different but the result will be the same.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: drmad
Please Log in or Create an account to join the conversation.
Moderators: Obsidev
Time to create page: 0.214 seconds