Export Customer Orders for Single Product

-- HikaShop version -- : 4.2.2
-- Joomla version -- : 3.9.14
-- PHP version -- : 7.2
-- Browser(s) name and version -- : Firefox Developer
-- Error-message(debug-mod must be tuned on) -- : None

Hi looking for some guidance as some of the threads I have read regarding Mass exporter, etc are a little confusing as is using Export function of all data, takes some messing with Unicode, etc to format data in Excel correctly and far too much data.

All I would like to do is export all orders (single rows for multiple customer order) for a single product in a specific date range or entirely if easier as I can just sort by date using Excel.

Is this possible, and if so please could you tell me how?

Kindest regards,
Mark

Hello Mark,

There's actually no option to do it, so the solution will either be to :
- directly do it using code customization to properly filter the data returned by the export
or
- using mass actions via "Hikashop->System->Mass actions"
www.hikashop.com/support/documentation/167-massaction-form.html

Kind regards,
Mohamed Thelji.

Thanks for your response but it leaves me completely confused.

1: You can't see data for a single product? Seriously, why on earth would an eCommerce component not be able to see data for sales based on a specific item????? That's just basic functionality!

2: You need to write custom code? So you mean a plugin needs developing because you don't currently have or know of anything?

3: You can't do it but you can do it? Which is it? As per my original question, is there away to export a single product and it's customer sales into an excel spreadsheet or not???? I need to do it and asking if someone could please just tell me how? I have no idea how your mass exporter works and tbh it doesn't really follow any logic I understand, which is WHY I asked, is it possible and if so how?You say no it's not but you can with mass exporter???? Or you can't do it?

Appreciate your reponse but it soves nothing and leaves more questions than answers!

Hello,

I'm sorry if my answer wasn't clear enough and confused you, it wasn't the goal.

is there away to export a single product and it's customer sales into an excel spreadsheet

Yes, you'll find attached a screenshots of how you can configured your mass action via "Hikashop->System->Mass actions->New".

Finally, you'll just have to save it and click on process to download the exported CSV file.

Kind regards,
Mohamed.

It's ok i have done it myself exporting the data and converting to correct format and sorting by product SKU and then removing the unwanted data.

Thanks

Hi I cannot for the life of me get this to work, can someone help me I am desperate to do this for my client, why on earth a shop system would not have this as a simple export option begs belief!

I have successfully exported data and not a noob to all this stuff either, but you cannot just export a specific product using the mass export facility.

When you select a product ID it exports all products ordered by the customer not just the product you select so you get additional columns of unwanted data and whats even more frustrating is that it often exports the data and shows the customers products in order of selection so you can't just select unwanted columns and delete them.

I appreciate your pointing out how to do it, i know how to do it and understand the instructions which is why further up in my thread you will see I did it without any assistance, the issue is I cannot get just ONE PRODUCT to export in a list of customer orders without anything ordered being in the file exported.

Honestly I have used a few eCommerce components over the past 15 years using Joomla CMS, In comparison to something like Virtuemart the product and sales management and sales analysis functions of Hikashop are appalling. In the sales search you can't even filter a product from the dropdown to even export the sales which would be so logical.

Thanks for your input but I remain in exactly the same point I was in before you replied!

I absolutely cannot believe you have never been asked for single product sale export capability and that you think it is not required.

When making sales you need to see the amount of sales you have made per product and to see the proft margns. In Virtuemart I can export product sales based on a product ID and see all the profit I have made.

The issue with Hikashop is that you can't export data based on a specific product ID, so when you export sales it's EVERYTHING or nothing. If a customer has ordered multiple products the database export function only allows you to export all data and so you have to go through and remove all other product ID's and the table rows do not match, so you will have product_1 product_2 product_3 etc, and the products are in order customer adds to cart, not in product ID order. This causes endless issues.

You need to be able to simply select a product ID and export all sales for that product with the price paid, fact is my client and many other clients require this function, without being rude I honestly wish my client had not picked Hikashop as the solution because the export and sale data analysis side of the store has caused very time consuming administration issues, although you can see how many products sold, you cannot add together all the sales with cost=profit based on sale price. Same product can be sold at various prics depending on discounts, vouchers, etc. So the variables all have an impact and this helps clients to understand what products are better to offer than others and to see the margins being made.

You migt not think this is required, but it is, users need this data managment and the way Hikashop handles it, I'm sorry, but it's awful.

Don't get me wrong I like the interface and for the most part it's a pretty good eCommerce solution, we use the full system too with all the bells and whistles so when it came to exporting sales per product and we realised, you can't, my client was pretty peed off to say the least, because now instead of just exporting some data into Excel and looking at the sales (as explained) it takes literally hours to arrange the data and this also allows for human error, it's not good.

I appreciate as a developer you don't see the value in something if no-one asks, but from what I have seen searching your forum and Google quite a lot of Hikashop users have required this feature, but, if it's of no value to you you're not going to spend the time doing it.

My review for Hikashop would genuinely be:
" Amazing for a FREE version, brilliant capabilities if you get the full blown paid subscription, pretty easy to configure but if you need a solution for analysing sales, customer data and exporting data then this is not the solution for you!"

Aha, I see you do actually have the ability to create sales reports and export from a different part of Hikashop???? I think their has been confusion as I was solely looking at the Mass Actions NOT Reports, my apologies I think this will solve the solution.

I take some responsibility here as I could have just looked a little more in depth!

Thanks for your help and input.

Got there in the end I think! No worries, it's all there I think, just got to dig it out!

Again thanks for your patience and help.