Post by SXGuy » Mon Aug 28, 2017 2:36 am

So ive noticed, that when you add products to the cart, they order by the categories, for example if i had a starters, mains, and desert category, and randomly add products they order in the order of the category sort order. However when i view an order invoice, the products are ordered in the order they were added to the cart.

How can i make it so, products are displayed in order of category sort orders? hopefully ive made it clear.
Last edited by SXGuy on Tue Aug 29, 2017 4:57 am, edited 1 time in total.

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by yodapt » Mon Aug 28, 2017 7:56 am

So, you want to see the products in the invoice in the same order as you see in the cart, is that right?

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by SXGuy » Mon Aug 28, 2017 1:09 pm

Yes

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by yodapt » Mon Aug 28, 2017 9:39 pm

Have you checked if you have any extension changing the cart order?

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by SXGuy » Mon Aug 28, 2017 10:50 pm

I believe I may have. I'm using a category module extension. So I guess they would appear in some order in the cart however I'm unsure which order they are inserted in to the order table by.

Ideally I'd like products inserted by order of category sort order. So products from category sort order 1 go in first then category sort order 2 2nd.

Or alternatively link the order table product ids by category I'd and sort based on sort order when viewing order invoices.

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by yodapt » Tue Aug 29, 2017 12:35 am

Check PM

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by SXGuy » Tue Aug 29, 2017 5:00 am

Ive solved the issue by ordering the order product table by model. I then used the products model details to include a number at the beginning to act like a sort order.

Now i can set all products i want shown first by adding 1 to the beginning of each product models info, or add 2 to products i want shown 2nd etc.

This is an especially good way of solving the issue if some stores admin requires order details of ordered products, displayed in a particular order

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am
Who is online

Users browsing this forum: No registered users and 63 guests