Hi I'm new to satchmo, but not to database applications.

I need to add an attribute to product but the default "satchmo product attribute" and "brand attribute"doesn't fit my needs because it's a 1:n relationship, and i need grouping and ordering every list on that field, i know my english isn't good so it's better the simple bookshop example:


category.html
------------------ slug=science
Science
    Technology
                                        book1
                                        book2
                                        book3
    Physics
                                        book1
                                        book2
                                        book3
---------------------- slug =Child
Child
    Fairy tales
                                        book1
                                        book2
                                        book3
    Adventure
                                        book1
                                        book2
                                        book3
---------------------------------- slug = travel
Travel
    Asia
                                        book1
                                        book2
                                        book3
    Europe
                                        book1
                                        book2
                                        book3

Every book has a publisher, and as i read on satchmo docs I can use product attribute but i have 2 problems

1- I would like in the admin page not to write everytime the name of publisher but choose from a combo( brands let me do it, but it's 1:n too)

2 - I need every list has publisher as the last grouping field

Referring the example it should become


category.html
------------------ slug=science
Science
    Technology
                        Publisher1
                                        book1
                                        book2
                        Publisher2
                                        book3
    Physics
                        Publisher1
                                        book1
                        Publisher2
                                        book2
                                        book3
---------------------- slug =Child
Child
    Fairy tales
                        Publisher3
                                        book1
                                        book2
                                        book3
    Adventure
                        Publisher1
                                        book1
                                        book2
                                        book3
---------------------------------- slug = travel
Travel
    Asia
                        Publisher2
                                        book1
                        Publisher4
                                        book2
                                        book3
    Europe
                        Publisher1
                                        book1
                                        book2
                                        book3


In a normal database application i would add a field "pub_id" on product table and make a lookup on a "Publisher table" (so I can order and grouping without problems)

In Satchmo i think the best approach is to make almost the same thing, modifing "Product" model adding pub_id field and creating Publisher table

Is this correct ?

Thanks to all




--
You received this message because you are subscribed to the Google Groups "Satchmo 
users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/satchmo-users?hl=en.

Reply via email to