Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Power Store 4 changing the product order

Power Store 4 changing the product order

Thread began 1/27/2011 10:03 am by drewgss371883 | Last modified 1/31/2011 7:23 am by Jason Byrnes | 1426 views | 5 replies |

1/27/2011 10:03 am | #1 drewgss371883

Power Store 4 changing the product order

I have a store and my client wants to change the order of the product so it is not alphabetial

1/27/2011 2:38 pm | #2 Dani Chankhour

Sure, open the results.php page that is in the webassist/plugins/catalog/basic folder (you will need to make the same change to the results.php that is under the webassist/plugins/cataglog folder as well)

and Look for ORDER BY ProductName and change it to ORDER BY ProductID

1/27/2011 7:50 pm | #3 drewgss371883

If I do that then it will list by when the product was entered. I would have to go in to the database and change the id's. because I would not want my customer to mess around with the id's in the database.

If I go into the database and add a field "product_order" and then add a form field to the update form for products.

I am wondering how touchy the coding is.

1/28/2011 8:16 am | #4 Jason ByrnesWebAssist

That would be possible, but may take some hand coding to accomplish.

overall, the code should not be too touchy, but I would definitely back things up before making any changes.

1/30/2011 11:18 pm | #5 drewgss371883

Is there an easier way?

1/31/2011 7:23 am | #6 Jason ByrnesWebAssist

No, not for what you are trying to do.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.