Product Ordering

[wfernley]

Hey :)

I need to setup a product ordering system. Currently I have a column in my products table which is called products_order. There is a number there and when I list my products (according to which category the product is in) it lists it ORDERED by the products_order column.

I need to setup an easy way to edit the listing though and I was curious what the most logical way to do this would be. I need it to be simple enough so that anyone can do it.

Can anyone help me out? I know how to make a form to edit 1 listing but doing multiple with the same names and values I am not familiar with.

thanks for your help :)

Wes

[coopster]

Are you talking about a sort order? Can you give some more details, Wes? Thanks.

[wfernley]

Hi thanks for the post :)

I actually have figured out the problem and it is working great :)

But basically what I was trying to do is setup a custom sort order for my products. I didn't want to order by price, name, or sku, but I wanted to setup an ordering system that went by the most popular products - and what my boss wanted at the top ;)

So I setup a special listing where there is a column and it sorts by that column. So if there were 5 products they would each have a value ranging from 1 to 5 and 1 would go at the top and 5 at the bottom.

The problem I was having though was about editing those values in a form. I figured out how to setup a SELECT form with options of 1 to 20 that they can be ordered. Then it would update all those products with the new order value.

Did I explain it well? :)

I did figure it out though and its working great. If you want any more info or have any ideas feel free to let me know

Thanks again.

Wes

[coopster]

I did figure it out though and its working great.

Awesome. Good for you.