Simple "products to ship" report using widgets

  • Posts: 130
  • Thank you received: 1
12 years 2 months ago #68099

Hi,

I would like to create following simple report:

all products with order status confirmed sorted by ascending / descending with following displayed in each row:

product name, product quantity (optionally product category)

Currently I am able to configure following report:

all products with order status confirmed sorted by price (best or worst) with following displayed for each row:

product name, total price

Is it possible to modify the second report using just widget system so it resembles first report?

Thanks,

Karol

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

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
12 years 2 months ago #68329

Hi,

You can change the "type" of your report from "sales" to "orders" and that will give you the total quantity sold per product instead of the total amount.
The category name is not displayable here without modifying the code.

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

  • Posts: 130
  • Thank you received: 1
12 years 2 months ago #68416

Thanks Nicolas.

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

  • Posts: 130
  • Thank you received: 1
12 years 1 month ago #76056

Nicolas,

We've been using this for a while and although it's better than nothing there still few changes I would like to make.

Is it possible to structure the report as follows:

Order Id / Product Id / Product Quantity (of the Product Id belonging to the Order Id) filtered by order statuses as necessary

What we're basically looking for is a way to quickly discern what products we need to ship (to which orders) as that helps us with doing our orders and/or with quickly turning out order from customer.

Thanks,

Karol

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

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
12 years 1 month ago #76436

Well, there is no option for that. Now I don't know if it's possible to add these columns easily or if it would require development as Eliot is the one in charge of the reports. He will be back at the end of the week and will be able to answer you at that time with either a solution or tell you if that's possible to add an option to it or not.

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

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #76602

Hi there,

I'm looking at the code right now but I'd like more information to see if this is possible.
First I'd like to know which widget you are using, a screenshot of your widget configuration may be helpful.
Then, what exactly do you imagine? Do you want orders to be listed for every product they contain? I mean, a row for each product in each order?
I'll try to do my best with these informations :)

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

  • Posts: 130
  • Thank you received: 1
12 years 1 month ago #76918

Eliot,

See screenshot below for my configuration of the report:




As for the what I would like to have would be following rows:

Order Id, Product Id, Product Category (optional), Product Quantity with option to filter report by order statuses as necessary, if you could then column sort the resulting list that would be golden.

So to answer your question yes I would like to how a row for each product in each order with identifier to which order the product belongs i.e:

Order 1, Product 1, 3 items sold
Order 2, Product 1, 2 items sold

Thanks,

Karol

Attachments:
Last edit: 12 years 1 month ago by karolko.

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

  • Posts: 2334
  • Thank you received: 403
12 years 1 month ago #77698

Hi there,

Sorry for the time I took to answer.
So what you are asking for is currently not possible in Hikashop.
However, I'm looking at the code and there may be a way to do it but it's not that easy.
We'll see how hard this is to integrate and decide if we will or not add this functionality.
I'll let you know :)

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

  • Posts: 130
  • Thank you received: 1
12 years 1 month ago #77806

eliot wrote: Hi there,

Sorry for the time I took to answer.
So what you are asking for is currently not possible in Hikashop.
However, I'm looking at the code and there may be a way to do it but it's not that easy.
We'll see how hard this is to integrate and decide if we will or not add this functionality.
I'll let you know :)


Understood, as it's something that I believe would be useful for other users I hope that this will get's priority :)

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

  • Posts: 18
  • Thank you received: 0
10 years 10 months ago #144319

If we can't see an itemized list of the products to be shipped, how do we pick the times ? Or we suppose to go through and print each order individually ?

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

  • Posts: 2334
  • Thank you received: 403
10 years 10 months ago #144546

I'm not sure I understand what you mean by "pick the time". Could you be more specific?

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

  • Posts: 18
  • Thank you received: 0
10 years 9 months ago #148574

I meant pick the items..

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

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
10 years 9 months ago #148581

If what you want is to get a listing of the orders and their products so that you can ship them, you can click on the "export" button of the orders listing. That will give you a CSV that you can open in excel with one row per order and all the items listed for each order in the columns near the end of the CSV.

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

  • Posts: 18
  • Thank you received: 0
10 years 9 months ago #149163

That export is completely useless.. a person that ordered 10 items.. the row extends over several pages. If you try to print it, you'll bet several pages with just one row on it.. then then a main front page with a bunch.. the purchaser's name and address ends up on a different page then the items ordered.

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

Time to create page: 0.104 seconds
Powered by Kunena Forum