Product Type Book (by moku)

[ami114]

Links are not working

"product type book" add support for books with a new product type (just like the core music product type, but with much more features)
a thread has been started in the previous forum, now in read-only. You can check it for records here.

features

1. easy installation without touching a single core file (thanks to zc override system);
2. multi language friendly;
3. search books and authors with the standard search sidebox (and genre and/or types);
4. shows authors names and isbn on product listing;
5. book attributes:
   
   • author (can have more than one author by book)
   • genre ("fantastic", "scifi", "shonen", "############", etc.) (many genres ok)
   • type ("artbook", "novel", "manga", "postcards", etc.) (many types ok)
   • color ("b&w", "color", etc?)
   • language (many languages ok) (use another small contribution "products languages")
   • condition ("brand new", "used (good)", "used (bad)", etc.)
   • pages ("123")
   • publication date ("2004", "31-12-1999", etc.)
   • 2 customs text fields
   • 2 customs boolean fields
   • publisher and isbn are reusing manufacturers and model core fields

demo
demo of product book for zencart

download
the last version is available here: product type book (product_type_book-moku-v?.?-yyyy-mm-dd) (both zip and tar.bz2 should be available)

[ami114]

Hi all,
can someone send me "Product Type Book (by moku) " mod files at amit4raj AT gmail DOT com OR post it here pls..
thk u

[johnk]

I've just switched on my Email notifications and received an email about this thread which I subscribed to many moons ago.

I'm using a slightly modified version of Paul Hailey's mods on my Trainz Resources Directory site http://trainzresources.com

Although my site is nothing more than a catalogue or directory without a shopping cart, the book mod allows me to take advantage of the Author's sidebox to show my visitors all items by the same author. In my case, that's a Contributor not an Author. If you visit the site, have a look at the Contributor's box on the top right. Click on the second listing 44090 to get an idea of how it all fits together.

Notice that I don't use all the available fields in Product Book. I prefer a looser arrangement.

I found that Paul's mod fell together pretty well, but it isn't really for the feint hearted. This is not a mod to install and test on a hosted site. It will drive you nuts. I use a brilliant WAMP package called Uniform Server. It's sooooo easy to install and use. Making changes or testing Zen Cart on your own PC is also a breeze. Zen cart installs flawlessly on the server and having tried others I can honestly say that this is the one to use.

Some time ago I wrote a document on how to install the server and how to install and run Zen Cart on it. The document is now a bit old-hat, considering that it was for ZC 1.3.7 and an earlier version of Uniform server, but it still has a little steam left in it yet. You're welcome to download it and encourage me to update it.

The link is http://digital-junction.com/announcements/zencart/ (It's 4 meg)

I've included a small readme file to update some of the variations, but the step-by-step instructions should work fine as they are.

Please enjoy!

[Beau91324]

From my readings of the post here I think this issues has been addressed, but I can not find the fix. I'm running Zen-Cart 1.3.7. with ZC1_3_7_EXTENDED_MOKU_BOOK_TYPE_JPH_V_2 (book product type) and I get a 1064 error message. Can anyone help?

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 zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ) , zen_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 (zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c ) LEFT JOIN zen_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 '%bonfire%' OR p.products_model LIKE '%bonfire%' OR m.manufacturers_name LIKE '%bonfire%' OR (mtpd.metatags_keywords LIKE '%bonfire%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%bonfire%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%bonfire%') )) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_product_book_extra pbe, zen_books_to_authors bta, zen_book_authors ba, zen_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 '%bonfire%' OR p.products_model LIKE '%bonfire%' OR m.manufacturers_name LIKE '%bonfire%' OR pd.products_description LIKE '%bonfire%'OR book_authors_name LIKE '%bonfire%'OR book_authors_nickname LIKE '%bonfire%'OR subtitle LIKE '%bonfire%') ) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_books_to_genres btg, zen_book_genre bg, zen_book_genre_description bgd 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 btg.products_id = p.products_id AND btg.book_genre_id = bg.book_genre_id AND bg.book_genre_id = bgd.book_genre_id AND bgd.language_id = 1 AND ((pd.products_name LIKE '%bonfire%' OR p.products_model LIKE '%bonfire%' OR m.manufacturers_name LIKE '%bonfire%' OR pd.products_description LIKE '%bonfire%' OR book_genre_name LIKE '%bonfire%') ) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_books_to_types btt, zen_book_type bt, zen_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 '%bonfire%' OR p.products_model LIKE '%bonfire%' OR m.manufacturers_name LIKE '%bonfire%' OR pd.products_description LIKE '%bonfire%' OR book_type_name LIKE '%bonfire%') ) ) ) ]

[GSIS]

Hi folks,

Sorry if I've missed any PMs - I'm guessing some will have been lost in a sea of Freecycle offers.

It's been a long time since I last visited. In the interim I've relocated, re-started my sales on Amazon (a complete relist of all my stock - still ongoing, a bit like painting the Forth Bridge), and I'm about to start redeveloping my online shop.

The first step is to choose the platform - probably Zen Cart as I have past experience of it, possibly something else depending on what's available. That, really, is the question ... is this product_type_book extension still available?

[Berserker]

Hello there,

I have installed this module and everything seemed to went smoothly. After adding a book product, Tabbe Products Pro doesnt seem to work for it tho. How do I get it to work for that? Also, has anyone managed to get this to work with Ceon URI Mapping?

Lastly, I need an extra field called Age Rating. How can I achieve that?

All the best...

[Berserker]

Forgot to add, im a little confused with all the extra fields in the Book - Product.

What does Show Book Misc 1, Show Book Misc (bool) 1, Show misc_3 on product info, Show misc_dd1 on product info etc. actually do? What are they for?

[Berserker]

I have been going through this module and I noticed there isnt any Languages text field in the product admin. Is that normal? How can I put what language the book is in? Should I use any of the spare field? I have Languages turned on in admin/book product type...

[johnk]

Those spare fields (I think there are six form memory) are there to do the things you are asking for. You just change the field mane to Age or Language or whatever.

I can't ask the first part of tour problem about Ceon URI Mapping because I haven't got a clue what it means. Please don't explain, it won't help me.

Product book could probably do with some documentation I agree, but I have at least 10 tutorials I must do first, and none help me pay my bills.

All I can say is that product book is working flawlessly on my site with almost a thousand entries.

John

[Berserker]

Got the Age Rating part. So basically, there is no Language text field to begin with? What does the switch in Catalog-Product Type-Product Book-Show Book Language do? I have it turned on but I dont see any difference. Lastly, could you tell me what are the Book DD2, Book DD3 and so on under extras are for?