Export products sold

Gi,

Go in the Orders>Reports menu.
There, create a new report like this:
i.imgur.com/BtBb9Od.png
As you can see, you can select the dates, restrict based on the order status, etc.
Note also the "limit" setting that you want to increase so that it can display all your products.
You also have an "export" button at the top of this screen to get a CSV file of the data.

Hi,

Indeed, the id of the products is not included. But I think it's a good starting point for what you want.
There is no option to add the id though. I think you would have to change the line:

$widget->exportFields=array('order_product_name', 'quantity');

$widget->exportFields=array('order_product_name', 'quantity', 'product_id');

Hi,

It's probably a problem with how you open the file in Excel. When you import the file, you can choose the separators and other options:
support.microsoft.com/en-us/office/text-...40-899f-f78bafe41857
If you just double click on the file to open it, then Excel won't provide the import interface and it will use its default settings, which may vary from one version of Excel to another and from one country to another.
So HikaShop also has CSV settings under the Files section of the HikaShop configuration so that you can adjust the format of the CSV files in order to better suit your version of Excel.

Hi,

There is no option for that.
I would recommend exporting all your products with the "export" button of the products listing.

Then, you can merge both CSV files with some small programing like powershell, Excel / PowerQuery, or Python:
www.reddit.com/r/PowerShell/comments/13i...o_excel_csv_columns/
www.reddit.com/r/excel/comments/bjwenw/c...s_into_1_excel_file/
www.reddit.com/r/learnpython/comments/13...on_common_column_id/

More simply, you can use an online service like :
mightymerge.io/merge-csv-files/

Once you have a merged CSV, sort the rows based on their quantity column, and remove all the rows with a value in that column. That way, you'll be left with all the products without any sale in the CSV.