Reports

  • Posts: 39
  • Thank you received: 4
  • Hikashop Business
2 years 1 week ago #346584

-- HikaShop version -- : 4.6.2
-- Joomla version -- : 3.10.11 stable
-- PHP version -- : 7.4.32

Hi, we use the report "order to ship" and the problem is, that the address typ used is billig address. We need to have shipping address for our purposes.
Pleas tell me, where are the reports located on the server? Which file must be updated? I could not find anything in the development area? BR Anita

File Attachment:

File Name: hikashopexport28.csv
File Size:3 KB

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 1 week ago #346586

Hi,

I suppose you'll want to change the line:

$leftjoin[]=' LEFT JOIN #__hikashop_address AS address1 ON a.order_billing_address_id=address1.address_id';
to:
$leftjoin[]=' LEFT JOIN #__hikashop_address AS address1 ON a.order_shipping_address_id=address1.address_id';
in the file administrator/components/com_hikashop/classes/widget.php
That way, when you do an export of a report of orders, it should use the shipping address instead of the billing address for the address columns of the CSV file.

The following user(s) said Thank You: Agabl123

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

Time to create page: 0.060 seconds
Powered by Kunena Forum