You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Question on the Product Sort Order for default displays within a category.
If product A has a value of 1 and product B has a value of 0 shouldn't product B display before Product A? Apologies if that sounds like a an 8th grade math problem. I am doing this and still have product A listed before B.
Also assuming this is how I get the display to work. What would be the sql command to change all the values of a product within a category to a value of 0/1?
Thanks
Offline
Yes, 0 before 1. No stupid questions, only stupid answers. I imagine you've selected to sort by name or price in your product listings. To view according to sort order, select the default sort option when viewing a product list.
Offline
I realized I had changed my ECOM-Prod default from the default to ASC. Quick followup - I would like to set the
Product Sort Order value = 0 for * Products in xCat. Is this how I would write this? sql skills are a little rusty.
Offline
I would like to set the Product Sort Order value = 0 for * Products in xCat
UPDATE ecom_prod SET sortorder=0 WHERE xcat LIKE '%categoryidhere%'
Would also be helpful if Product is in xcat add to to xcat2
UPDATE ecom_prod SET xcat2=xcat
or combining the two:
UPDATE ecom_prod SET sortorder=0, xcat2=xcat WHERE xcat LIKE '%categoryidhere%'
Offline
First one worked great to set sort order to 0.
I couldn't get the second one working. Also just to clarify. Looking to take All products assgined to xcat A and give those products the additional assignment xcat B.
Hope you get a change to see this. Working on a big project this weekend.
Last edited by coatzel21 (02-11-2017 13:10:54)
Offline