Hikashop Order Export Includes User Points

Hi,

There is no option for this. However, the order_product_quantity would be equal to 0. So it would be similar to what you would get if you were to remove a product from an already created order.
The best would be to ignore the products with an order_product_quantity equal to 0.

A quick and dirty solution would be to change the line:
$query .= ' ORDER BY order_product_id ASC';
to:
$query .= ' AND order_product_quantity > 0 ORDER BY order_product_id ASC';
in the file administrator/components/com_hikashop/classes/massaction.php

A proper solution would be to add an extra option to the export action to exclude products with a quantity of 0 from the export.

Hi,

The order_product_quantity > 0 code modification should help. You can check the value of order_product_quantity in the hikashop_order_product table in the database for the points and it will be 0. And thus the rows for the points should be ignored with that extra condition in the code.

Note that you can't add that condition as a filter of the mass action. This won't work.
The products of the order are loaded during the export process, after the orders have been filtered.
Adding a filter on order_product_quantity > 0, or order_product_name not containing "User" won't work. This filter would mean "only select orders with at least one product with a quantity > 0" or "only select orders with at least one product with name not containing 'User'" and thus it would match with all the orders.
That's why I told you to change the code and not to add the condition as a filter of the mass action.