Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Ajax Attribute Manager 2.8.9.3- Sort Order Issue


radhavallabh

Recommended Posts

A very important aspect to be fixed very soon!! Please help

Sort order of option groups need to work some how a minor error is preventing it to work;

 

This is the actual problem what someone figured out and wrote----

 

 

The contrib seems to work fine from the admin section for me, I can move option values up/down within each option group, and move option groups up/down in relation to other option groups. Looks PERFECT.

 

however the reflection on my catalog is not perfect. The option values as ordered within option groups is retained, but the option group ordering is not reflected.

 

Can any suggest why? I have double checked product_info.php, and both of the 2 queries there sort by products_options_sort_order. So my code from that section reads like this:

 

[color="#000000"]$products_options_name_query [/color][color="#666600"]=[/color][color="#000000"] tep_db_query[/color][color="#666600"]([/color][color="#008800"]"select distinct popt.products_options_id, popt.products_options_name from "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_OPTIONS [/color][color="#666600"].[/color] [color="#008800"]" popt, "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_ATTRIBUTES [/color][color="#666600"].[/color] [color="#008800"]" patrib where patrib.products_id='"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$HTTP_GET_VARS[/color][color="#666600"][[/color][color="#008800"]'products_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and patrib.options_id = popt.products_options_id and popt.language_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$languages_id [/color][color="#666600"].[/color] [color="#008800"]"' order by popt.products_options_sort_order"[/color][color="#666600"]);[/color]
[color="#000088"]while[/color] [color="#666600"]([/color][color="#000000"]$products_options_name [/color][color="#666600"]=[/color][color="#000000"] tep_db_fetch_array[/color][color="#666600"]([/color][color="#000000"]$products_options_name_query[/color][color="#666600"]))[/color] [color="#666600"]{[/color]
[color="#000000"]                $products_options_array [/color][color="#666600"]=[/color][color="#000000"] array[/color][color="#666600"]();[/color]
[color="#000000"]                $products_options_query [/color][color="#666600"]=[/color][color="#000000"] tep_db_query[/color][color="#666600"]([/color][color="#008800"]"select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_ATTRIBUTES [/color][color="#666600"].[/color] [color="#008800"]" pa, "[/color] [color="#666600"].[/color][color="#000000"] TABLE_PRODUCTS_OPTIONS_VALUES [/color][color="#666600"].[/color] [color="#008800"]" pov where pa.products_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$HTTP_GET_VARS[/color][color="#666600"][[/color][color="#008800"]'products_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and pa.options_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$products_options_name[/color][color="#666600"][[/color][color="#008800"]'products_options_id'[/color][color="#666600"]][/color] [color="#666600"].[/color] [color="#008800"]"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"[/color] [color="#666600"].[/color] [color="#666600"]([/color][color="#000088"]int[/color][color="#666600"])[/color][color="#000000"]$languages_id [/color][color="#666600"].[/color] [color="#008800"]"' order by pa.products_options_sort_order"[/color][color="#666600"]);[/color]

 

 

I noticed that if you have the attribute sort order contrib the last query there is sorted by attribute_sort. Not that using that helps either. Also in attributeManagerConfig.class.php is it correct that both AM_FIELD_OPTION_SORT_ORDER and AM_FIELD_OPTION_VALUE_SORT_ORDER use products_options_sort_order? Does nothing refer to the attribute_sort column created by the attribute sort order contrib?

 

I don't see the need to install the attribute sort order contrib if the tablet column it creates isn't used. I installed it anyway. It seems this contrib uses the existing sort order columns from the 2 related tables in the DB.

 

Incidentally, no values are being generated in the products_options_sort_order column of the products_options table. Perhaps that gives a clue.

 

Any ideas appreciated, thanks for excellent config, presumably just missing something minor.

 

Please Help soon!!!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...