Sort Order Of Products When Adding Order In Admin

General General Questions
1

Whats the default sort order ? I cant tell. Can I change it to price or product code somehow

Thanks

john

https://prnt.sc/jt11yt

2

it appears it is done by product (name) and then product_id based on the SQL debugger output from the 'manage' page. Unfortunately, the debugger doesn't track ajax requests but the order appears to be the same. But you seem to be in a "picker" where my "add product" for a new order is an auto-fill drop-down that is predictive based on entered text.

The query ends up being:

SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id WHERE 1 AND prices.usergroup_id IN (0) GROUP BY products.product_id ORDER BY product asc, product_id ASC LIMIT 0, 10
3

Hello.

We have addon for independ sorting in admin panel. Maybe he could be useful.

https://cs-cart.pl/moduly/narzedzia/independent-sorting-in-the-panel/?currency=USD&sl=en

Best regards

Robert.

4

Thanks Robert, will your addon do this ? it doesnt seem to show it does, or can anyone make a mod for me to do this

5

Hello John.

I sent you message with access to demo shop with this addon for test.

Best regards

Robert.

6

Hello John.

I sent you message with access to demo shop with this addon for test.

Best regards

Robert.

Works thanks

Purchased

JOhn

7

Hello John.

I sent you message with access to demo shop with this addon for test.

Best regards

Robert.

How long until I can download Robert

8

Hello John.

Yesterday I sent you a package.

Best regards.

Robert.