PS4 Options not appearing in the order they were entered

6/08/2012 9:38 am | #1 sandy170299

The options on this page (products_detail.php?ProductID=36) were entered in the following order: x-small, small, medium, large and that is how they appear in the admin area when I go to edit them. However, they are appearing out of order on the product detail page. On other pages of the site, they are correct. I am using advanced options with this particular item, as the image changes based on the color selected, but I am also doing that with this item (products_detail.php?ProductID=23), and that one is working fine.

How can I keep them listed in the order in which I entered them?

Thanks!

6/08/2012 10:02 am | #2 Jason ByrnesWebAssist

in the webassist/plugins/shopping_cart/add_to_cart.php page, you will need to edit the code for variaus product option recordsets, there are a few of them.

you will need to add an order by clause to order by the optionID.

for example one of the options recordsets will have this code:

php:

$query_OptionValues = sprintf("SELECT DISTINCT ps4_options.OptionID, OptionName FROM ps4_options INNER JOIN ps4_optiongroups ON ps4_optiongroups.OptionGroupID = ps4_options.OptionGroupID  INNER JOIN ps4_productoptions on ps4_options.OptionID = ps4_productoptions.OptionID INNER JOIN ps4_products on ps4_products.ProductID = ps4_productoptions.ProductID WHERE ps4_options.OptionGroupID = %s AND (ps4_products.ProductStartDate IS NULL OR ps4_products.ProductStartDate <= CURDATE()) AND (ps4_products.ProductEndDate IS NULL OR ps4_products.ProductEndDate >= CURDATE())", GetSQLValueString($OGIDParam_OptionValues, "int"));

change that to:

php:

$query_OptionValues = sprintf("SELECT DISTINCT ps4_options.OptionID, OptionName FROM ps4_options INNER JOIN ps4_optiongroups ON ps4_optiongroups.OptionGroupID = ps4_options.OptionGroupID  INNER JOIN ps4_productoptions on ps4_options.OptionID = ps4_productoptions.OptionID INNER JOIN ps4_products on ps4_products.ProductID = ps4_productoptions.ProductID WHERE ps4_options.OptionGroupID = %s AND (ps4_products.ProductStartDate IS NULL OR ps4_products.ProductStartDate <= CURDATE()) AND (ps4_products.ProductEndDate IS NULL OR ps4_products.ProductEndDate >= CURDATE()) ORDER BY ps4_options.OptionID", GetSQLValueString($OGIDParam_OptionValues, "int"));

6/08/2012 10:33 am | #4 Jason ByrnesWebAssist

not every query, no, only the ones that are used by the options select lists:
OptionValues
ProductOptions
SubOptions
AddedOptions

should all have:
ORDER BY ps4_options.OptionID

added near the end of the query.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

PS4 Options not appearing in the order they were entered

6/08/2012 9:38 am | #1 sandy170299