Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Sort Order Of Products When Adding Order In Admin Rate Topic   - - - - -

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4282 posts

Posted 09 June 2018 - 06:33 PM #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


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10595 posts

Posted 09 June 2018 - 08:13 PM #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

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 337 posts

Posted 09 June 2018 - 09:04 PM #3

Hello.

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

https://cs-cart.pl/m...rency=USD&sl=en

 

Best regards

Robert.


Team of SoftSolid
cs-cart.pl

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4282 posts

Posted 10 June 2018 - 10:15 AM #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


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 337 posts

Posted 10 June 2018 - 05:05 PM #5

Hello John.

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

 

Best regards

Robert.


Team of SoftSolid
cs-cart.pl

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4282 posts

Posted 10 June 2018 - 05:34 PM #6

Hello John.

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

 

Best regards

Robert.

Works thanks

Purchased

JOhn


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4282 posts

Posted 11 June 2018 - 10:47 AM #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


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 337 posts

Posted 11 June 2018 - 10:55 AM #8

Hello John.

 

Yesterday I sent you a package.

 

Best regards.

Robert.


Team of SoftSolid
cs-cart.pl