LaserDisc Database
https://forum.lddb.com/

Trying to improve the Sellers' reporting
https://forum.lddb.com/viewtopic.php?f=10&t=9728
Page 1 of 1

Author:  admin [ 25 Mar 2021, 16:56 ]
Post subject:  Trying to improve the Sellers' reporting

Hello!

One of our best sellers here challenged me to make some improvements to the order reporting, while trying a few things, I also fixed a few bugs and added new links.

So... I tried a few things:

On the "Selling Orders": https://www.lddb.com/shop_orders.php

1/ Your selling orders will be ordered only by descending dates (no more aggregated by status)
2/ It just hit me that I never finished (2 lines of codes!) adding the Order # lookup as well! (the whole Order number without the #)

Now if you go to your Sales Report: https://www.lddb.com/shop_report.php

3/ It looks the same but click on a year, then click on a month and you will only see the orders for THAT month.

https://www.lddb.com/shop_orders.php?month=2021-02

4/ If it's empty, it might be because you already archived the orders. In that case click on "ALL": (always ALL by default now)

https://www.lddb.com/shop_orders.php?month=2021-02&show=all

5/ Now if you want them in ASCending order, just click on the "Date" column title.

https://www.lddb.com/shop_orders.php?month=2021-02&sort=date

Julien

Author:  admin [ 21 Jun 2021, 10:44 ]
Post subject:  Re: Trying to improve the Sellers' reporting

On the "Sales Report": https://www.lddb.com/shop_report.php

The graphs was also updated (dynamic and covering all years).
The X on the right of a year or month allows for a simple XLS export of all transactions (disc by disc) for easier review.

Julien

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/