Forums / Setting Up Categories, Products, Attributes / Product Type Book (by moku)

Product Type Book (by moku)

Started by moku on 12 May 2006, 6:37 AM · Views: 203,732

Results 521 to 540 of 647
11 Sep 2009, 12:20 PM
#521
chabbu avatar

chabbu

New Zenner

Join Date:
Jul 2007
Posts:
75
Plugin Contributions:
0

Product Type Book (by moku)

kburner:

Does anyone know if this will change/effect products I already have loaded?

Thanks, Kim

No it won't

11 Sep 2009, 12:58 PM
#522
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Product Type Book (by moku)

chabbu:

Hi

I'm looking into this again, and so far have found that you need to change the product type in the database and then insert the product ID into the product_book_extra table.

This at least gets the exisitng product title and description into a book type format.

Faz

Will it work with Google base feeder? Easy populate?

kburner
Burner Christian Bookstore
https://www.burnerbooks.com

11 Sep 2009, 1:00 PM
#523
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Product Type Book (by moku)

chabbu:

No it won't

Since I already have books loaded as product - general, Do I have to go back and change to book type?

kburner
Burner Christian Bookstore
https://www.burnerbooks.com

11 Sep 2009, 1:02 PM
#524
chabbu avatar

chabbu

New Zenner

Join Date:
Jul 2007
Posts:
75
Plugin Contributions:
0

Re: Product Type Book (by moku)

kburner:

Will it work with Google base feeder? Easy populate?

I don't know, as I haven't tried it with these mods yet. Perhaps someone else who has been using it a while can advise how they set up their store with this mod.

11 Sep 2009, 1:09 PM
#525
chabbu avatar

chabbu

New Zenner

Join Date:
Jul 2007
Posts:
75
Plugin Contributions:
0

Re: Product Type Book (by moku)

kburner:

Since I already have books loaded as product - general, Do I have to go back and change to book type?

You will have to insert products as product-book if you want the additional book related fields to show up. As far as I know, there is no easy way of mass migrating existing general products to the book type other than what I mentioned in the earlier post i.e. via the database.

You cannot easily change the product type via the Admin interface.

IF you can upload products via easy populate then this may be simpler, but I don't know if it is possible using easy populate.

13 Sep 2009, 3:20 PM
#526
rbryn avatar

rbryn

New Zenner

Join Date:
Sep 2009
Posts:
5
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

hi! chinesebks4children

Note I only do the multilanguage version now.. it will run in single language..

Hi again,

I'm trying to develop a multilingual book site. I hope you don't mind a multilanguage question?

I need to get the mutlibox search working in various languages. I posted this question and still no help.

Can you you let me know which files need to be modded in subsequent languages? (FR, ES, Pt, NL and some day Korean:unsure: )

Many thanks,

Rbryn

23 Sep 2009, 10:38 PM
#527
beau91324 avatar

beau91324

Zen Follower

Join Date:
Jul 2009
Posts:
149
Plugin Contributions:
0

Re: Product Type Book (by moku)

I just tried installing the Book Product Type to two systems, one local system using MAMP and it works just fine. The other was set up on a server and doesn't show anything, blank screen when I attempt to go to the admin to run the sql patch. Has anyone seen this happen before and know what I need to do to get it working.

I'm runing Zen-Cart 1.3.7 and I'm using bookshop template.

Beau

24 Sep 2009, 2:51 PM
#528
rbryn avatar

rbryn

New Zenner

Join Date:
Sep 2009
Posts:
5
Plugin Contributions:
0

Re: Product Type Book (by moku)

Solved ... thanks to hareslade.

I'm putting together a template for other language translators for the five or so files that need to be developed to support the products type books in other languages.

Any volunteers? French, Portuguese, Dutch, ?

Rbryn

rbryn:

Hi again,

I'm trying to develop a multilingual book site. I hope you don't mind a multilanguage question?

I need to get the mutlibox search working in various languages. I posted this question and still no help.

Can you you let me know which files need to be modded in subsequent languages? (FR, ES, Pt, NL and some day Korean:unsure: )

Many thanks,

Rbryn

24 Sep 2009, 3:33 PM
#529
beau91324 avatar

beau91324

Zen Follower

Join Date:
Jul 2009
Posts:
149
Plugin Contributions:
0

Re: Product Type Book (by moku)

:oops:
I found out what was happing, I was attempting to use the latest Book Product Type instead of an earlier version for Zen-Cart 1.3.7. When I used ZC1_3_7_EXTENDED_MOKU_BOOK_TYPE_JPH_V_2 everything work, so far.
:clap:

Beau

28 Sep 2009, 4:36 PM
#530
beau91324 avatar

beau91324

Zen Follower

Join Date:
Jul 2009
Posts:
149
Plugin Contributions:
0

Re: Product Type Book (by moku)

I'm using the version of Book Product Type for ZC 1.3.7 and I have noticed that in the All Products screen(?) the Publisher & ISBN text have not replaced Manufacture and Model. I'm sure that this has been fixed but I've not been able to find it in my searches. I'm very much a newbie to ZC so can someone please point me to where the fix is found.

Beau

6 Oct 2009, 9:40 AM
#531
ami114 avatar

ami114

New Zenner

Join Date:
Dec 2004
Posts:
22
Plugin Contributions:
0

Re: Product Type Book (by moku)

Links are not working

moku:

"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);
  1. multi language friendly;
  1. search books and authors with the standard search sidebox (and genre and/or types);
  1. shows authors names and isbn on product listing;
  1. 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?)
  • 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)

6 Oct 2009, 10:49 AM
#532
ami114 avatar

ami114

New Zenner

Join Date:
Dec 2004
Posts:
22
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

6 Oct 2009, 11:50 AM
#533
johnk avatar

johnk

New Zenner

Join Date:
Feb 2005
Posts:
56
Plugin Contributions:
0

Re: Product Type Book (by moku)

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!

10 Oct 2009, 8:48 PM
#534
beau91324 avatar

beau91324

Zen Follower

Join Date:
Jul 2009
Posts:
149
Plugin Contributions:
0

Re: Product Type Book (by moku)

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%') ) ) ) ]

Beau

21 Nov 2009, 4:31 PM
#535
gsis avatar

gsis

Zen Follower

Join Date:
Jun 2007
Posts:
140
Plugin Contributions:
0

Re: Product Type Book (by moku)

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?

We're now settled in at our final home - http://www.swiftbooks.co.uk - where you'll find an eclectic collection of used books. Still a lot of work to do, though!

14 Dec 2009, 11:31 PM
#536
berserker avatar

berserker

Totally Zenned

Join Date:
May 2006
Posts:
712
Plugin Contributions:
0

Re: Product Type Book (by moku)

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...

14 Dec 2009, 11:48 PM
#537
berserker avatar

berserker

Totally Zenned

Join Date:
May 2006
Posts:
712
Plugin Contributions:
0

Re: Product Type Book (by moku)

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?

15 Dec 2009, 1:45 AM
#538
berserker avatar

berserker

Totally Zenned

Join Date:
May 2006
Posts:
712
Plugin Contributions:
0

Re: Product Type Book (by moku)

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...

15 Dec 2009, 3:22 AM
#539
johnk avatar

johnk

New Zenner

Join Date:
Feb 2005
Posts:
56
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

15 Dec 2009, 3:40 AM
#540
berserker avatar

berserker

Totally Zenned

Join Date:
May 2006
Posts:
712
Plugin Contributions:
0

Re: Product Type Book (by moku)

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?