Cart products order

[MP-zoho]

Hi all,

 

I have 3 categories in my shop.

The category A has few items (about 10 items) and the category B and C has many (more 50).

So, when customers add items to their cart, I would like to sort the list of products in their cart by category : how can I do that ?

 

EDIT : I use prestashop 1.6.0.9.

 

 

Thanks

Edited November 10, 2015 by YuccaOne (see edit history)

[NemoPS]

You can try editing Cart::getProducts

 

$sql->orderBy('cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC');

You might try to order by cl.name

[MP-zoho]

 

You can try editing Cart::getProducts

 

$sql->orderBy('cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC');

You might try to order by cl.name

 

Hi Nemo1,

 

That exactly what I need (in my case :

$sql->orderBy('cl.`id_category`','cp.`date_add`, p.`id_product`, cp.`id_product_attribute` ASC');

).

 

Thanks

[Welele]

Hello everyone. It is possible sort the products order by EAN-13 or UPC field??

 

I dont use this fields and I would like sort the orders invoice because my store and stock is too big. 

 

Reference numbers and another fields are disordered. I need a new field to sort.

 

Thanks and regards

[Welele]

Please. I need help. Is this possible?

 

 

Best regards

[NemoPS]

Yes, you can just use the same condition mentioned above on p.ean13 for example

[Welele]

Thanks for you comment!

 

I will tray and respond in this post.

 

Thnks angain!

[Welele]

I tried modify the file "classes/cart.php", in line 515:

 

 

                  // Build ORDER BY

                 $sql->orderBy('cp.`date_add`, p.`ean13`, cp.`id_product_attribute` ASC');

 

 

 

As well, I tried this:

 

 

                 //Build ORDER BY

                 $sql->orderBy('p.`ean13` ASC');

 

 

 

But doesn´t work. The item position is always by user put into the cart.

 

What is exactly the condition that I need??

 

 

Thanks and best regards

[Welele]

PLease.

 

I need help

 

Please

 

Thanks

[NemoPS]

It might be shuffled somewhere else in the code, like with javascript, hard to tell.  Are you using a custom template?

[Welele]

Yes. This one:

 

http://eggthemes.com/prestashop-homefurniture.html

 

 

But we never had problems applying any customization in the code. We have another shop with native theme. I will try in this and respond you later.

 

Thanks and regards

[Welele]

I tried in my other shop (with default template) and doesnt work netiher.

 

 

I tried this:

 

 

                 //Build ORDER BY

                 $sql->orderBy('p.`ean13` ASC');

 

 

Any help?

[Welele]

I found solution!!

 

ean13 is a varchar, dont sort by number if you dont put data like this:

 

01

02

03

04

05

06

07

08

09

10

.

.

.

.