View Issue Details

IDProjectCategoryView StatusLast Update
0001477OXID eShop (all versions)2. ----- eShop backend (admin) -----public2010-04-27 08:23
Reportersmonkey Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.2.0 revision 23610 
Fixed in Version4.3.0 revision 26948 
Summary0001477: Sort orders in Order Summary according to Last-buy-date
DescriptionAdmin -> 'Administer Orders' -> 'Order Summary' (only in PE/CE).
In this list the column "Date" displays the date, when product has been bought for the last time. But when clicked on title of this column to sort the list, it is sorted by the date, when product has been bough for the First time.
Fix it please to make sorting of the list by Last-bought-date.
TagsNo tags attached.
Theme
BrowserAll
PHP Version6
Database Version6.0

Activities

birute_meilutyte

2009-11-16 10:29

reporter   ~0002071

Reminder sent to: smonkey

Hello,

first of all, if you want to search and sort orders, you have to do this in Admin -> Administer Orders -> Orders.

Admin -> Administer Orders -> Order Summary displays all ordered products (that were ordered in general and grouped by product), not the orders themself. those products can be searched and sorted by:
- Date (date of latest order, when this product was bought)
- Product No (product number)
- Quantity (how many units of this product was sold in general)
- Description (product title)
- Price (Quantity * Product_price)
    
At the moment in Admin interface lists are sorted only ascending, and possibility to sort both Asc and Desc would be feature request.

If you are filtering ordered products by date, it will find only those products, that were ordered on the specified date.

Could you please confirm which functionality you are talking about: sorting/searching orders (Administer orders -> Orders) or sorting/searching ordered products (Administer orders -> Orders summary) and provide a syntax, how you are filtering by date and time, if it gives you no result?

Greetings,
Birute M.

smonkey

2009-12-01 14:39

reporter   ~0002144

Hello,

ok, it's possible to filter the oder summary by date in the correct format (for example 2009-12-01). I will add a new feature request for adding a tooltip (like in order overview) for the right format (YYYY-MM-DD).
I will also add an feature request for generally sorting descending in order summary.

But it's still not possible to sort the list correctly by date. If you try to sort order summary by date, you will get a nearly random list. It looks like it's ordered by the first-buy-date but the last-buy-date is shown.

dainius.bigelis

2009-12-07 09:01

reporter   ~0002176

Description will be changed to fix the issue, that sorting should be made according Last-buy-date, which is displayed.
Also one feature request is recorded to display First-buy-date in this section:
http://oxid.uservoice.com/pages/31940-feature-requests/suggestions/408943

sarunas_valaskevicius

2009-12-15 16:53

reporter   ~0002230

fixed sorting in admin/list_order