Trying to get this report...

  • Posts: 108
  • Thank you received: 0
9 years 9 months ago #187426

-- url of the page with the problem -- : www.fieldtestedgear.com/
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Safari 2.08
-- Error-message(debug-mod must be tuned on) -- : None

Hi there,

I am trying to get a couple of reports done that 'should be' pretty easy but for some reason I can't seem to get to work...

The Weekly Performance is the closest that I thought would work but it doesn't and shows really weird data results.

I'm just trying to have:

a. a Weekly Totals report that shows how many Products sold [order status: Confirmed and Shipped].
Starting on Monday each week [not a report showing the past 7 days].

b. a Weekly Totals report that shows how much money was sold [order status: Confirmed and Shipped].
Starting on Monday each week [not a report showing the past 7 days].

I have a nice Line Graph report showing daily totals of Products Sold and Dollars Sold, but I need the same thing
that adds up the 7 days for me [yes I know I could just add 7 numbers each week but I should be able to get that
in a report easily, right?]

Thanks,

Emmanuel.

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

  • Posts: 26146
  • Thank you received: 4026
  • MODERATOR
9 years 9 months ago #187517

Hi,

1. type products
order status : confirmed, shipping,
display type : listing (or else if you want something else)
display period : this week
specific options - displayed information : orders

2. Best is to use a "table" report with a line to summarize the sales of the week.
What the report "Main Statistics" is doing (but for the month) for his first line.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 108
  • Thank you received: 0
9 years 9 months ago #187598

Hi Jerome,

I tried your # 1, but that does give me what I am asking for above... with your settings, I get a listing of the last 7 orders...

That's great but I already have that and what I need is:

the week's [starting Monday] totals showing how many products are sold.
[ total du nombre de produit vendu par semaine commençant le Lundi ]

and the same thing showing how many dollars total are sold cumulatively for that week
[total du nombre de dollars vendu par semaine commençant le Lundi]

without having to add each day's worth of totals - like I currently do since I have daily totals of flash lights sold and daily totals of dollars sold...

Thanks, Merci

Emmanuel.

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

  • Posts: 26146
  • Thank you received: 4026
  • MODERATOR
9 years 9 months ago #187697

Hi Emmanuel,

I'm afraid that the current widget system won't allowed such kind of report.
At this moment the best will be to use a custom report in the view "dashboard | listing".
So you can perform a custom SQL query and display the result like you want.

I've also send a message to Nicolas about your request.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.059 seconds
Powered by Kunena Forum