Post by baronen » Wed Aug 07, 2013 12:15 am

Hello.
How do I configure productpanel in admin to sort by date and not by name?
I've tried some extensions that didn't work and I've tried to change in the php file without luck.

How is we supposed to get controll over new products if they are not sorted by date?

Newbie

Posts

Joined
Thu Aug 01, 2013 7:18 pm

Post by butte » Fri Aug 09, 2013 10:48 pm

In phpMyAdmin you can sort the table by date (last two fields on the right).

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by matte2k » Thu Nov 07, 2013 4:44 am

Is there an answer to this. Im not at all comfortable with phpMyAdmin

Active Member

Posts

Joined
Thu Mar 01, 2012 7:07 pm

Post by butte » Thu Nov 07, 2013 5:49 am

What are your version and theme?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by matte2k » Thu Nov 07, 2013 5:52 am

butte wrote:What are your version and theme?
OC 1.5.5.1 with theme MetroShop

Active Member

Posts

Joined
Thu Mar 01, 2012 7:07 pm

Post by butte » Thu Nov 07, 2013 7:37 am

Does admin still have the same look and feel that it did before you installed the MetroShop theme, that is, admin is nothing like the MetroShop storefront?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by matte2k » Thu Nov 07, 2013 1:38 pm

Yes. The admin has still default theme.

Active Member

Posts

Joined
Thu Mar 01, 2012 7:07 pm

Post by khurrum » Fri Nov 15, 2013 11:28 am

In the file admin/controller/catalog/product.php

Find the following code:

Code: Select all

	if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'pd.name';
		}

		if (isset($this->request->get['order'])) {
			$order = $this->request->get['order'];
		} else {
			$order = 'ASC';
		}
Replace with following code:

Code: Select all

if (isset($this->request->get['sort'])) {
 $sort = $this->request->get['sort'];
 } else {
 $sort = 'p.date_added';
 }

 if (isset($this->request->get['order'])) {
 $order = $this->request->get['order'];
 } else {
 $order = 'DESC';
 }
In the file admin/model/catalog/product.php add the red marked code

$sort_data = array(
'pd.name',
'p.model',
'p.price',
'p.quantity',
'p.status',
'p.sort_order',
'p.date_added' //add this column name
);

Newbie

Posts

Joined
Wed Oct 23, 2013 10:36 pm

Post by Mahakal » Sun Sep 25, 2016 3:30 pm

I did it,it is not working.

New member

Posts

Joined
Sun Sep 04, 2016 2:42 am

Post by victorj » Tue Sep 27, 2016 4:35 am


Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by nihal31 » Thu Jun 15, 2017 4:24 pm

replace 'pd.name' with 'p.date_added'

Newbie

Posts

Joined
Thu Jun 15, 2017 4:22 pm

User avatar
Newbie

Posts

Joined
Mon Sep 19, 2016 4:31 pm
Location - Desk Table

Post by victorj » Fri Jun 16, 2017 6:23 am


Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by sdsoftware » Sun Jun 18, 2017 5:16 pm

You can check the module victorj mentioned which is free and seems nice.

Or you can check my module Admin Category/Manufacturer/Attribute Filter that CAN sort by date added as well among others!

Software Support And Development www.sdware.eu
Ccookie Module || Admin Category/Manufactory/Attribute Filter || Admin Customizer || Bank Tranfer Extended
Business Inquiries Here
My extensions Page Here


User avatar
New member

Posts

Joined
Mon May 29, 2017 3:37 pm


Post by williamino » Fri Jul 19, 2019 2:27 am

victorj wrote:
Tue Sep 27, 2016 4:35 am
working module to sort products

http://www.opencart.com/index.php?route ... _license=0
we need current version of this somebody please!

paypalbuys.com


User avatar
Newbie

Posts

Joined
Sat Apr 09, 2016 1:25 am
Location - Australia

Post by williamino » Fri Jul 19, 2019 2:30 am

we need this for OC. 3.03 etc please!

paypalbuys.com


User avatar
Newbie

Posts

Joined
Sat Apr 09, 2016 1:25 am
Location - Australia
Who is online

Users browsing this forum: No registered users and 191 guests