Product Type Book (by moku)

[hareslade]

Hi Neelam
Whatever zencart contribution add-on you use, you'll often end up needing to learn some of what to do from reading the appropriate forum thread, and even buying that zencart manual. Or you can ask for paid help in the forum section

for beginners its absolutely a good idea to install a test zencart, for experimenting. Go on..just upload the contrib files, apply the sql patch in zencart admin...You can always delete the cart and start again if you need to... its free :) it doesn't go bang.. its fun...(sometimes)

The book contribs should work out of the box provided you understand that many of the book fields values are not texted directly into the admin book product page, you choose there from preset options dropdown lists.. therefore you have to go populate the authors list at start separately, because the tables are created empty on installation of the add on. We don't know what authors you require.. or what book formats you have..

So for instance, add an author to the authors list table... then all the books can see that choice for author in book admin. This method moku chose because it enables selection of more than one author for any one book.

[bearaman]

Hi,
I've installed your expanded mod and it looks great. Just what I needed. Great work.
Is it possible to enter the names of authors, publishers, etc. directly on the "Add Product" screen rather than selecting them from a dropdown menu? I'm finding that part a bit tedious and would love it if I could enter all the book details directly on one page.
Tahnks and well done.
Bearaman

[raunharman]

Can we make the search fileds more refind. Like In the search filed we can add fileds like Author/ ISBN/ Publisher like in the web site www.bagchee.com

Respnse will be appreciated.

[hareslade]

the (extended) book type is based on moku's design.. 'fraid you'll have to put up with pre-populating the dropdowns with authors etc,

You're doing the extra bit of work with the dropdown entries because the returns are worth it.. if you really wanted to type in author on the collect info page, you could turn on a spare field and call it author.. but the searches won't search it..

raunharman are you typing one fingered (I use two ;)
The search sideboxes are 'as they are', ISBN is model, so in theory an ordinary search (the standard search box provided by zencart) would find that.. publisher is manufacturer, the manufacturer sidebox will search that.

That was the point.. as already said, its the dropdown admin entries that are the ones searched by the moku-style sideboxes. The search searches by 'author number', not by author name.. its a posh/efficient way of designing the database tables.

It also avoids common long term mistakes like putting both 'J Blogs' and 'John Blogs' in as authors, or 'Blogs J'...'Blogs John' when they are all actually the same author, and you forgot exactly how you had put in the name, the first time a book needed it.

I know.. the old book contrib years back had that weakness, i ended up with exactly those sort of multiple entries ..

[raunharman]

The seach option is giving error.
When I type any keyword, I am getting the following error:

Advanced Search
Items starting with ... A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0 1 2 3 4 5 6 7 8 9

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT
in:
[select count(distinct p.products_id) as total FROM products p LEFT JOIN manufacturers m USING ( manufacturers_id ) , products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND ( p.products_id IN ( SELECT DISTINCT p.products_id FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%sikh%' OR p.products_model LIKE '%sikh%' OR m.manufacturers_name LIKE '%sikh%' OR (mtpd.metatags_keywords LIKE '%sikh%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%sikh%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%sikh%') )) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM products p LEFT JOIN manufacturers m USING ( manufacturers_id ), products_description pd, categories c, products_to_categories p2c LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, product_book_extra pbe, books_to_authors bta, book_authors ba, book_authors_info bai WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND pbe.products_id = p.products_id AND bta.products_id = p.products_id AND bta.book_authors_id = ba.book_authors_id AND ba.book_authors_id = bai.book_authors_id AND bai.language_id = 1 AND ((pd.products_name LIKE '%sikh%' OR p.products_model LIKE '%sikh%' OR m.manufacturers_name LIKE '%sikh%' OR pd.products_description LIKE '%sikh%'OR book_authors_name LIKE '%sikh%'OR subtitle LIKE '%sikh%') ) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM products p LEFT JOIN manufacturers m USING ( manufacturers_id ), products_description pd, categories c, products_to_categories p2c LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, books_to_types btt, book_type bt, book_type_description btd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND btt.products_id = p.products_id AND btt.book_type_id = bt.book_type_id AND bt.book_type_id = btd.book_type_id AND btd.language_id = 1 AND ((pd.products_name LIKE '%sikh%' OR p.products_model LIKE '%sikh%' OR m.manufacturers_name LIKE '%sikh%' OR pd.products_description LIKE '%sikh%' OR book_type_name LIKE '%sikh%') ) ) ) ]

[hareslade]

Raunharman, maybe you can p.m me with your cart page url and/or details of exactly what you did, for instance is it a sidebox (moku) search or the zencart search box, or the advanced search page with its various options

I don't use advanced search much, but it looks like the manufacturer is still being asked for, and recently I tried to alter the sql to avoid scanning manufacturer. Bear in mind there are so many possibilities (excuses excuses)

[hareslade]

For raunharman and anyone else who gets an sql error message using zencart main search box with either moku or my extended versions, go to the download page and locate update fix labelled may 2007, it may fix the problem.

Otherwise temporarily switch off 'search in books' in admin | ...product types ..book type... edit layout

Its the file in the fix, that addes extra sql to the end of the search sql made by the rest of zencart. There were some 'missing' local prefixes to some of the book tables field names, its commented in the fix file. Not all setups seem to need it though.

http://www.hareslade.com/zc/index.ph...roducts_id=482

[shedman1]

Hello, does this support 1.37? I had a look on your site but under the 1.37 downloads it is not listed.
Also do the search (drop down boxes come with it or do they need to be installed seperately?
I am looking for this type of mod for a Jewellery site ( seach by gemstone, by birthstone, by metal type etc>
Thank you in advance

[hareslade]

http://www.hareslade.com/zc/index.ph...roducts_id=482

shedman1 yes there is a 137 version... see link... its my version, moku ceased work on book type before 137 came out. Read the page text it explains some of your queries.

The optional 'grid' version is merely a different display format for product listings, similar to Dr Byte's contrib mod..

If you have the energy you can change the appropriate defines to suit your text labels requirements

[gluckfs]

1) I thought I read a post here that mentioned how to re-format the administration screen (used to enter book data) so that
a) I can change the order of the fields
b) I can change the title of the fields.

Can you let me know the files that need to be edited and where in the files the statements need to be re-ordered? (Approximate line number would be good).

b) I activated the "misc1" field, but it doesn't seem to show on the admin screen to allow data entry. Other fields that I have activated do show. Any advice??

Thanks