How to a full report for a performance?

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #249411

-- HikaShop version -- : 2.63
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.6

Hello,
I'm wondering if there is a way to download a full detailed performance to the store from orders to customers and everything in between?
Thanks

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #249414

Hi,

You can create reports via the menu Orders>Reports on the orders, the sales amounts, the best customers, etc. It's up to you to configure the reports to display what you want.
www.hikashop.com/support/documentation/1...hop-report-form.html

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

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #249455

I think what im trying to say how to download a full report, not just comparison between two years, i follow the instructions but that show ms nothing except the comparison between 2 years, what i want one click download a full report for any period i want, thanks

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #249457

Hi,

I don't understand what you mean by "full report". A report of what ? What should the report contain precisely ?
A list of the orders ?

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

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #249491

Hello Nick,
A full report for example has the performance of the week and the performance of the month, best buyers and so on, i can see everyone, in report or in the main dashboard but i thought maybe there is a way to download them as CVS or Excel so we can make statistics and then based on that we can release promotions and discounts
thanks

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #249494

Hi,

I'm still not following you.
"performance of the week" doesn't mean anything precise. The list of orders of the week ? The total amount of sales ? The total number of products sold ? The number of customers ? By best buyers, you mean a list of the best buyers ? How many ? All of them ? Do they have to be sorted alphabetically ? By total amount ?
Note that most of these can already be generated with reports in HikaShop.
And how do you want to put all that in a CSV ? A CSV's role is to have a list of elements (rows) with, for each, a set number of informations (columns).
You can't have at the same time a list of best customers, and a total amount of sales in a CSV. It doesn't make sense. That's why each report in HikaShop is to be configured for a specific data to display, and when you export it, you get that specific data listed in the CSV.
For example, if you create a report of the best customers and you export the CSV, you'll get a CSV with the data on the best customers report.

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

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #250918

Ok i understand everything you said, i will have to crate different report based on my needs, and then i can sort them as soon they are CSV files, but im submitting a attachment please take a look this where is my problem it shows very bad file to read and do any statistics

Attachments:

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #250956

Hi,

So what is the problem with that file ?
I see two columns, one for the products name, one for the total amount. Is that a problem ?

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

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #250990

See the picture of the file when i open it, how im going to read that, does it open different by you?
Thanks

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #250992

Hi,

Here is how I see it:
take.ms/kwK6W

I didn't get any screenshot of you regarding that issue so I don't know how it opens on your end.

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

  • Posts: 154
  • Thank you received: 1
8 years 1 month ago #251185

for me looks only on line
take a look

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

  • Posts: 82723
  • Thank you received: 13338
  • MODERATOR
8 years 1 month ago #251188

Hi,

Then the problem must be with the way you're opening the CSV. Try with LibreOffice Calc (what I use):
www.libreoffice.org/download/libreoffice-fresh/

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

  • Posts: 154
  • Thank you received: 1
7 years 9 months ago #258715

I got that and I used this application and works fine, one more question How i can download a report from the beginning of the date we start until today for example that shows list of customers names and and number of orders and total , so we can be able to send these customers gift cards and so on?

Thanks

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

  • Posts: 12953
  • Thank you received: 1778
7 years 9 months ago #258726

Hello,

A solution can be to directly export the data you want by using mass actions via "Hikashop->System->Mass Actions"

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

Time to create page: 0.086 seconds
Powered by Kunena Forum