Post by prototype0104 » Thu Apr 08, 2021 5:55 pm

Hi guys! I'm using OpenCart 3.0.3.2
I have some products that need different sort_order by category
Example:
Product 1 in category 1 need sort_order 1
Product 1 in category 2 need sort_order 2
I found some topics here but nothing solved..
I added sort_order column in product_to category to have:
id_product id_category and sort_order
Now I think to edit getProducts function and include JOIN function to get sort_order from o2c.
so I can order by sort_order from oc2.
What do you think?
Any other idea?
Last edited by prototype0104 on Thu Apr 08, 2021 8:50 pm, edited 1 time in total.

Active Member

Posts

Joined
Sun Mar 24, 2019 6:08 pm

Post by paulfeakins » Thu Apr 08, 2021 6:49 pm

prototype0104 wrote:
Thu Apr 08, 2021 5:55 pm
Any other idea?
If you can't find an extension, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by prototype0104 » Thu Apr 08, 2021 8:02 pm

Paying for what? I just requested an opinion.
I added order by p2c.part_number in model and it's all good..

Active Member

Posts

Joined
Sun Mar 24, 2019 6:08 pm

Post by straightlight » Thu Apr 08, 2021 8:32 pm

prototype0104 wrote:
Thu Apr 08, 2021 8:02 pm
Paying for what? I just requested an opinion.
I added order by p2c.part_number in model and it's all good..
Now that you have resolved your own issue, please add [SOLVED] at the front of the subject line on the first post.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 29 guests