Unable to EXPORT CSV for sub-vendor orders / BackN

  • Posts: 43
  • Thank you received: 2
10 years 6 months ago #156635

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,

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
10 years 6 months ago #156647

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

$filters = array('b.order_type=\'sale\'');
this filter block the order_type to just "sale".
You can edit this line to put
$filters = array('(b.order_type=\'sale\' OR b.order_type=\'subsale\')');
in order to allow subsales 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.

  • Posts: 43
  • Thank you received: 2
10 years 6 months ago #156829

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.

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
10 years 6 months ago #156855

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,


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.

  • Posts: 43
  • Thank you received: 2
10 years 6 months ago #156875

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

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
10 years 5 months ago #156997

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,


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.064 seconds
Powered by Kunena Forum