How to generate an order list by article

[jojo-466]

Dear folks,

is it possible to generate a report of orders ordered by articles? I tried with salesreport but only managed to order by state or by date.
Any ideas?

thanks alot
Joachim

[DrByte]

There is a Sales Report addon in the Downloads area that lets you slice and dice in multiple ways.

[jojo-466]

As I wrote in my first post I tried with Sales Report. You are right, you can play in multiple ways but no order list by article

Are there any other ideas? Otherwise I have to cook by myself.

Thanks
Joachim

[DrByte]

Sorry - I missed that note in your first post.

I'm not sure what you mean by "article".
Maybe you're referring to "product name"? or "number"? or "model number"?
Or something else?

You'll probably have to write your own custom report.

You might find the Sales Report contribution to be a helpful starting point.

[jojo-466]

Yes, I mean a list of orders ordered by product name. With Sales Report you can make order lists that are sorted by date and name of the customer and other criterion related with the customer. But you can't relate that list with article names. Or you have a list of sold products and article names but you can't relate them with the customers.
I see I have to make my own sales report.
We will see.

Thanks again
Joachim

[DrByte]

Hmmm ... try the "Products Purchased" report in the admin.
If you click on the product ID number in left column, it'll show you all orders for that product.

[jojo-466]

Thats exactly what I was looking for. I did not find it before because I use the german translation and there are missing some tags. I have to fill them manually. But thats no problem.

Thanks
Joachim