Questions related to database tables

[superprg]

Give it a lower sort order to bring it up higher in the list.
This might require renumbering other categories to re-arrange sort orders.
NOTE: Blank (null) values come before numbered values. But normally you should not have any null values in sort order, so this is normally not an issue.

All the sub-categories
|_ CDROM Drives
|_ Graphics Cards (2)
|_ Keyboards (1)
|_ Memory
|_ Mice (2)
|_ Monitors
|_ Printers (1)
|_ Speakers

currently have sort order of 0
But in the database, there is no such order
How or why are they coming in this particular order?

[kobra]

Superprg:

All of this is in the admin and you do not need to mess with the DB at all...

Admin > catalog > select categories/products > you will have a list of the categories and at the right under "sort" the order...if you want to change it select the green circle with the "E" inside at at the bottom of the page displayed you can set the order. Same for the products. In your shop...the order can be set back in the admin for the view that you are looking at in the store. Alpha or the order that is set in the catalog, or price and so forth.

For a basic shop.; 90%+ of all the settings are in the admin...no requirement to dig into the DB...

May I suggest that instead of posting your questions about the DB that you post what it is that you want to do...and you will be assisted as to how to accomplish what it is that you want to do.

I would have expected that one with 300+ posts would have that figured out by now...

[superprg]

Thanks kobra very much for the reply

All of this is in the admin and you do not need to mess with the DB at all...

The reason why I am doing this is to understand databases better

For a basic shop.; 90%+ of all the settings are in the admin...no requirement to dig into the DB...

Most of the times, yes I know how to do things from Admin and thats what user is supposed to do. Any changes should be done from the Admin I agree

Superprg:

Admin > catalog > select categories/products > you will have a list of the categories and at the right under "sort" the order...if you want to change it select the green circle with the "E" inside at at the bottom of the page displayed you can set the order. Same for the products. In your shop...the order can be set back in the admin for the view that you are looking at in the store. Alpha or the order that is set in the catalog, or price and so forth.

Let me explain clearly
Currently sort order value for all these sub categories is 0:

|_ CDROM Drives
|_ Graphics Cards (2)
|_ Keyboards (1)
|_ Memory
|_ Mice (2)
|_ Monitors
|_ Printers (1)
|_ Speakers

That means whichever category they fall in they will be in top
Now, I changed the sort order for Graphics cards to 1
then I got this

|_ CDROM Drives
|_ Keyboards (1)
|_ Memory
|_ Mice (2)
|_ Monitors
|_ Printers (1)
|_ Speakers
|_ Graphics Cards (2)

Fine enough...
But what I dint understand is that for all categories except Graphics cards sort_order is 0 then who is deciding this particular order as I can see now( CD Rom, Keyboards etc) or is it just random?

Hope the question is clear


And sorry if my question is coming like a newbie question, but I want to be very clear
Thanks again!

[Ajeh]

0 is less than 1 so Graphics Cards at 1 comes after the other categories set at 0 ...

[superprg]

Thanks Ajeh
I got the answer here also :)
http://www.zen-cart.com/forum/showthread.php?t=43265

May be I have a long way to go before I understand zen cart! :)

[Ajeh]

one of those days ... see other thread for a way to do alpha/numeric text

[kobra]

Fine enough...
But what I dint understand is that for all categories except Graphics cards sort_order is 0 then who is deciding this particular order as I can see now( CD Rom, Keyboards etc) or is it just random?

Looks to be alpha to me???

[superprg]

Looks to be alpha to me???

Thats right kobra
Stupid me, took so much time to figure it out!

[superprg]

Can someone in layman terms explain to me the relevance of these tables


zen_products_options
zen_products_options_types
zen_products_options_values
zen_products_options_values_to_products_options

Went through few records in my database but could not get much the purpose
Thanks

[Ajeh]

They manage the attribtues ...

If you do not have a shop set up with the demo data, perhaps it would be a good idea so you can see how the tables work with data in them and their relationships to one another ...