Product Type Book (by moku)

hi biscayne
ok.. working on the book filters isn't too bad once you locate the book files that do it.. the awkard thing is, for a multiple product search result page the zencart code does one thing, and for a single product search result it does another.

There is a url redirect line in the zencart code that does one of the 'return results' pages, in testing one needs to comment that out and then use php echo's to make whatever output you choose, appear. But, if you put a php echo in the code before the activated php redirect line, the redirect itself doesn't work. It can be frustrating..

If you have specific probs in code areas do p.m me rather than fill up the thread with deep technicals :)

Hello,

Does Ultimate SEO URL work with product type Book. Only the category links have been changed to the SEO links. Product links are still in the old format.

Is there any other better way of generating SEO url for Book product type.

Thank you.

HI
In the book zip there is folder 6_ultimate_seo_urls_137_for_books

At the time I did that, utlimate seo url was in zencart 1.3.7 version

You might find useful stuff in the above folder, follow your intuition
see README_ADDED_FOR_BOOKS.txt file

Quote:

---

Originally Posted by hareslade

HI
In the book zip there is folder 6_ultimate_seo_urls_137_for_books

At the time I did that, utlimate seo url was in zencart 1.3.7 version

You might find useful stuff in the above folder, follow your intuition
see README_ADDED_FOR_BOOKS.txt file

---

Thank you. That worked. I missed installing the 6_ultimate_seo_urls_137_for_books files under books.

Quote:

---

Originally Posted by yellowscooter

Hello,

Does Ultimate SEO URL work with product type Book. Only the category links have been changed to the SEO links. Product links are still in the old format.

Is there any other better way of generating SEO url for Book product type.

Thank you.

---

Hi yellowscooter,

I got the Book Product mod working with the CEON URI mod for SEO and user friendly URLs. Have a look at my site for an example:

http://www.edizioninautilus.it

Here's the thread for the CEON mod that is working well for me for this Product Type, categories, and EZ-Pages (with one minor exception I can't seem to figure out).

http://www.zen-cart.com/forum/showthread.php?p=732653

Good luck...

Jeremy

Hi

I'm finding it difficult to determine the version of the module to download. I'm running v1.3.7 of zen cart. I notice the latest version is v3 beta, but the 'beta' is a little off-putting. Is it quite stable?

Also, is there any reason why this useful mod is not available to download on the official zen cart site under 'Free software add-ons'?

Thanks

Faz

hi Chabbu
The 1.3.7 book version is ok as is (beta) because I sort of asked for testers, then zencart 1.3.8 came out halfway through my doing that.., so the final version is the 1.3.8 one.

The book add-on isn't in the site list because I never got round to it, I always hoped someone would take it there :)

I might have missed it in this thread, but is there a switch to display author name in products_all?

Perry

there should be one, it may be in a different section of the admin setups than the main book section, can't recall

otherwise if you can't find it, sledgehammer the class.productBookListing.php file in classes folder,

line 44 is probably the right switch,

Code:

---

SHOW_PRODUCT_BOOK_LISTING_AUTHORS == 1

---

make that 99 instead of 1, it'll stop authors I think, but it might be too wide an effect.

When I run the SQL patch for a new installation on v1.3.7, i receive the following error message:

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 'id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now())' at line 1
in:
[INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Enable the Book Search', 'SEARCH_PRODUCT_BOOK_ENABLED', '1', 'Add the books to the search engine 0= off 1= on', '7', '0', 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Quote:

---

Originally Posted by chabbu

When I run the SQL patch for a new installation on v1.3.7, i receive the following error message:

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 'id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now())' at line 1
in:
[INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Enable the Book Search', 'SEARCH_PRODUCT_BOOK_ENABLED', '1', 'Add the books to the search engine 0= off 1= on', '7', '0', 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

---

I assume that it is because of this error message that I see nothing in if i go "product type" and choose "Procuct general" and then click the "Edit Layout" button?

Don't worry - I managed to fix it.

The problem was when I tried to upload the SQL file. Instead I copied and pasted the contents of the SQL file directly into the SQL Query Executor from the admin and the statements executed without problems. I think it's something to do with the backslash preceding the apostrophes.

Faz

Where can you download the latest version of this? Can't find it in the add-ons section, and the link in the first post is dead dead dead. Thanks!

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

Quote:

---

Originally Posted by dansicle

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

---

Hi

That seems to be the correct, and only, link for v1.3.8. If you mean to ask if this is the support thread for the book type contribution, then yes, it's certainly where I've been posting questions to.

Hi

Is there a way of switching the concatanation of fields off in the product info page? Ideally I'd like the fields to be listed individually, like the ISBN, Publisher fields.

Any ideas where I should be looking (I saw some references in one of the files in the templates folder, but it all looked pretty scary!)?

Thanks

Faz

Quote:

---

Originally Posted by dansicle

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

---

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

Thanks, Kim

I have installed the book type on my Zen Cart 1.3.8 and am looking for a way to mass upload products. I have tried Easy Populate and while it does upload products (some information anyway) it will not allow you to create the book product type (a lot of posts on this issue). My question is can you change the product type in the database directly and have the information show up properly in the product configure template. (I have hacked around and found you cannot just change the products_type in the products table and have it work).

Any thoughts or experiences?

Thanks

I've installed the ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2

English works, but the other languages have a problem with the sidebar multibox.

The header to the sidebox states: BOX_HEADING_BOOK_SEARCH
And the first three drop-downs are empty, the last two state:

PULL_DOWN_BOOK_PUBLISHERS

PULL_DOWN_BOOK_ISBN

I thought that maybe it was just the Spanish page I am trying to get up, but later realized it was also a problem in the Finnish page that came with ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2


Presumably I need to edit the header ID's or something? Do I need to replicate a folder and files for each language? If so, surely someone has already done this for Spanish, French, Portuguese (and I wish there was Korean).

http://theimtn.org/resources/images/...OOK_SEARCH.gif

Lookin for bones!

RBryn

Quote:

---

Originally Posted by jstric15

My question is can you change the product type in the database directly and have the information show up properly in the product configure template. (I have hacked around and found you cannot just change the products_type in the products table and have it work).

Any thoughts or experiences?

Thanks

---

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

Quote:

---

Originally Posted by kburner

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

Thanks, Kim

---

No it won't

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

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.

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

Quote:

---

Originally Posted by 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

---

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

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.

Links are not working

Quote:

---

Originally Posted by 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);
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)

---

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

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!

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?

Quote:

---

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

---

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?

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

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?

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

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

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?

Is there any way to rearrange the field? Mine displays as follow:

Condition
ISBN
Publisher
Age Rating
Language

I would like to change it to:

Language
Format
ISBN-13
Publisher
Age Rating
Genres

Thanks...

Hi folks
Nice to see you still turning the handles of the book gismo

In general book product is great within zencart, but if you add 'unknown' add-ons
the chances are you'd have to modify them, because book contains extra fields
in separate tables that are addtional to zencart's normal field setup.

anyway.. just to let you know i'm on a canal boat near devizes wiltshire uk,
sometime i will get back into a house, not sure where or when yet.

the links for the book demo's should be on my signature below here,
and the site to get the file zips from, is still
http://www.jphuk.co.uk/zc/

Hello there,

Could someone please help me how to get this to work with Zen Lightbox.

Thank you

Quote:

---

Originally Posted by 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...

---

I have gotten this module to work together with the Ceon URI although I did the installation more than a year ago and don't remember if there was anything special I needed to do to enable it.

The Ceon module is, however, rather straightforward and well documented, so if you follow the instructions it'll work. See the website below for the example:

www.edizioninautilus.it

Jeremy

Quote:

---

Originally Posted by 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...

---

Did you get Tabbed Products Pro to work? If yes...How?

Thanks, Kim

Quote:

---

Originally Posted by kburner

Did you get Tabbed Products Pro to work? If yes...How?

Thanks, Kim

---

Unfortunately no...

Quote:

---

Originally Posted by Berserker

Is there any way to rearrange the field? Mine displays as follow:

Condition
ISBN
Publisher
Age Rating
Language

I would like to change it to:

Language
Format
ISBN-13
Publisher
Age Rating
Genres

Thanks...

---

Which file did you modify? Thanks,Kim

I have a bookstore that currently using regular product-general. I am trying to get this mod working. I really need it to be able to list everything. But, also need it to match for other products I have that are not books.

I use the MSRP pricing with product-general. Does anyone have product-book working with MSRP??

Kim

Loaded this mod and get redirected to page not found when I try to add a new product. I ran debug file and this error message.

HTML Code:

---

securityToken|s:32:"42e4e32af6d8dbbc79288302ad6482ec";language|s:7:"english";languages_id|s:1:"1";languages_code|s:2:"en";selected_box|s:13:"configuration";html_editor_preference_status|s:9:"FCKEDITOR";admin_id|s:1:"1";messageToStack|s:0:"";categories_products_sort_order|s:1:"1";display_categories_dropdown|i:0;

---

I only loaded the book main files. I have been using FCKEDITOR.

How do I fix this? Thanks, Kim

BTW, I am also trying to get MSRP to work with it. I modified these files.

I took this on with my test store. I followed the readme file for MRSP and tried to apply to product-book files.
Made these changes to get MSRP to work with product - book.

Sql file:

Originally added with product - general. I did not make any changes or additions to sql.

ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;


1. admin/includes/lang/english/product_book. manually installed to end of file...

define('TEXT_PRODUCTS_MSRP', ' MSRP: ');
define('TEXT_PRODUCTS_OUR_PRICE', ' Our Price: ');
define('TEXT_PRODUCTS_SALE', ' Sale Price: ');
define('TEXT_PRODUCTS_SAVINGS', ' You Save: ');
define('TEXT_PRODUCTS_PRICE_MSRP', 'Products MSRP:');

2. admin/modules/update_product.php
This file does not have product_book one. Made changes to
admin/includes/modules/update_product.php

Added:
$tmp_value = zen_db_prepare_input($_POST['products_msrp']);
$products_msrp = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['products_price']);
$products_price = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;

Added:
'products_msrp' => $products_msrp,


3. admin/modules/product/collect_info.php This file does not have product_book one. Changes made to
admin/includes/modules/product/collect_info.php

Added:
'products_msrp' => '',

and added:
p.products_image, p.products_price, p.products_msrp, p.products_virtual, p.products_weight,

Could not find...
<tr bgcolor="#ebebff">
<td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td>
<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_price_gross', $pInfo->products_price, 'OnKeyUp="updateNet()"'); ?></td>
</tr>

Therefore...did NOT add
and add immediately above it:

<tr bgcolor="#ebebff">
<td class="main"><?php echo TEXT_PRODUCTS_PRICE_MSRP; ?></td>
<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_msrp', $pInfo->products_msrp, ''); ?></td>
</tr>

4. includes/functions/functions_prices.php
Did not make any changes to file and did not see one for product_book

5. includes/languages/english/product_book.php
Added:
define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
define('TEXT_PRODUCT_SAVE', 'You save: ');
define('TEXT_PRODUCT_OUR', 'Our Price: ');

6. includes/languages/english.php
No other files modified.

I can see MRSP when I choose product - book and can add price. But, price does not remain when I click on preview. And I do not see it on site.

I am no expert at this. Is there anyone that can give suggestions on how to get to work?

I have:
zc 1.3.8a
ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2
ceon_uri_mapping_seo_3-2-4
multisite_module_0-4-2

My problem: When I do a search for "authors", then no result is displayed. I looked at the sql in the "book_authors_filter.php" and found out, that there is no result displayed because the table "books_to_authors" is empty!

How do I geht some data into this table? I do have authors, I do have books, and of course, I filled the author(s)-field when I added the book. Is this not enought?

I have never used the Author Field to enter author's names when adding a book. I did try it once, but seem to recall not being redirected back to the Book Entry screen. In other words, form memory, when you enter an author that way, you are taken to a special page where you enter all the Author details. If that's not happening, therein lies the problem.

The easiest way to enter Authors, is to go to Extras (next to Tools) and select Authors from there. Try to enter a few a
Authors at a time to save jumping to and thro. Then when you enter a book, you simply select the Author's mane from the drop down list. It works perfectly that way.

John

Quote:

---

Originally Posted by johnk

I have never used the Author Field to enter author's names when adding a book....

The easiest way to enter Authors, is to go to Extras (next to Tools) and select Authors from there. ...

Then when you enter a book, you simply select the Author's mane from the drop down list. It works perfectly that way.

---

Oh, got it. I did it this way, but as I just had added one author, I didn't SELECT the author in the "add book" dialog. So that's why I got the problem. With two authors, it's more obviouse that one of them has to be selected.

Thanks for getting me to it.

By the way: Do you have any ideas where to get out the extra author info (photo, description, website of author) in the shop? I just get the author name at book display. But no link, no description, no photo for the author.

Have a look at this page on my site. I use Zen Cart as a catalogue only. Look at the top right of my site. I've changes Authors to read Contributors. As you can see "Canon" is listed as a contributor.

Go to (Tools/Layout Boxes Controller) and set the following side boxes to be displayed:

sideboxes/book_authors displays an Author's dropdown (first item on the top right of my page)

sideboxes_authors_info (second item)

The information will appear wherever you select in the left or right columns.

Hope that helps.

P.S. This is a fantastic contribution. When you select an Author from the list, all the products (books) by that Author are displayed automatically.

If you click a book at random, the Author's details will be displayed for that book. As some shoppers may not notice this, you could add a line like: "See Author's Biography in side bar (top right)".

First of all, many thanks for all the hard work that hareslade has put into this fantastic addition. I was actually pretty astonished to see that such a thing as Zen Cart didn't already have all this book functionality!

Also, many thanks to johnk, who seems to have been very helpful while hareslade is out and about, floating around for fun. ;)

I've read the instructions in the files, read the forum from about page 40 on up, and gotten the thing installed in a basically fresh copy of Zen Cart 1.3.8a. I haven't put in any addons, only messed with the layout to make it match how the client wants their site to look. (I did use the override system properly, not editing the original files.)

I realized that the upload of /admin/includes/stylesheet.css has overwritten a lot of perhaps newer admin styles, because my admin section became extremely plain and unstyled. What I tried to do was pick out what was marked as "added by jph" in the new stylesheet, and add it to the original one, and uploaded it. Voila, the admin page looks like it did before, but the Pick A Date Available little popup calendar is gone!

Here is what I found to put into the admin stylesheet, perhaps there is something more I am missing.

Code:

---

/* added by jph */
/* language colours */
td.maincolor1, tr.maincolor1{background-color:#FFFFCC;}
td.maincolor2, tr.maincolor2{background-color:#CCFF99;}
td.maincolor3, tr.maincolor3{background-color:#CCCCFF;}
td.maincolor4, tr.maincolor4{background-color:#FFCCFF;}
td.maincolor5, tr.maincolor5{background-color:#FFFFCC;}
td.maincolor6, tr.maincolor6{background-color:#99FFFF;}
/* warns is set to copy dropdown values across */
td.warncolor, tr.warncolor{background-color:#CC0033;
}

---

Thanks and appreciation in advance to whomever can help me! I am fairly familiar with CSS, and half half a handle on php, but this is my first experience with Zen Cart, and despite a bit of a challenge, I'm really liking it.

Quote:

---

Originally Posted by sashafiero

I was actually pretty astonished to see that such a thing as Zen Cart didn't already have all this book functionality!

---

I don't think it's very astonishing... a tiny handful (me included) of people who use zencart would ever need this highly-specific functionality.

Zencart "standard" must be kept "generic". It has to be (in most respects) a one-size-fits-all package.

The fact that such modules are available is more a testament to the clever folk who write such add-ons, and that ZC offers a robust platform upon which such customizations can be built in the first place.

Ah, yes, this is a very good point. We can't expect them to include every type of thing people sell out there! :)

And you're right, it does speak well for ZC that it IS possible to customize it so well.

It's an interesting comment Schoolboy, but why then does Zen Cart include music, record companies and the like? Surely there would be no more demand for a music shop than a book shop? Both are excellent on-line marketing opportunities.

Having said that, PJH has put an enormous amount of work into this module, although he is always quick to to thank Moku who we should not forget for the foundations.

sashafiero, when you say the Admin section got a little plain, I'm not quite sure of what you mean there. The overall admin section isn't affected, but Product Book admin page could do with a makeover. I actually did this a year or so ago and got it looking very snazzy. Unfortunately I managed to delete the entire store which was only running on a Wamp server at home. I'll probably get around to it again one day, but I hardly use any of the features in my Catalogue.

I also have to give a personal vote of thanks to Paul who answered al my emails and helped my through a few problems a year or so back.

I am just a "sample of one" so my observations are probably more anecdotal than factual, but over the last 6 years I have built about 120 Zencart webshops for people all over the world.

Of these, about 35% have been to sell music - usually CD's and MP3 downloads - sometimes just music, other times alongside other products. So that's more than a third of all stores I have built that have required a "product - music" capability.

In the last 6 years I have only ever set up 3 bookshops, and of those only 2 requested the "product - book" module - even though I indicated its availability to the third owner.

So, in my experience, TEN TIMES the number of sites I have built have required the music product features, compared to sites that required the book product features.

I do agree it is a fantastic module - and I have thought about "cloning" it to suit things like car parts and accessories...

When I started using this module it drove me mad having to select Product-Book from a dropdown list before adding a new title.

I actually changed the database so that product-book was the default, but then I discovered an easier way.

Just edit the highest level category you can. Right at the bottom of the page you will see:

Restrict Product Type to "Product General".

Just click the little arrow next to "Product General" and select "Product Book".

You can then make the change to include or ignore sub-categories.

it works like a charm!

Quote:

---

Originally Posted by johnk

When I started using this module it drove me mad having to select Product-Book from a dropdown list before adding a new title.

I actually changed the database so that product-book was the default, but then I discovered an easier way.

Just edit the highest level category you can. Right at the bottom of the page you will see:

Restrict Product Type to "Product General".

Just click the little arrow next to "Product General" and select "Product Book".

You can then make the change to include or ignore sub-categories.

it works like a charm!

---

That is the method recommended in the README...

Ha, I guess I should have taken a screenshot. When I say "plain" I mean completely unstyled. The whole admin section, not just the books admin (which I realize isn't great, but I'm not concerned about that).
Well okay, I'll just put the "new" stylesheet back up, take a screenshot for your amusement.

Well, Schoolboy, I guess it could come down to the people you meet. As an ex printer and publisher, most of the people I know who want to set up online stores are book retailers. I have yet to meet one Music/CD retailer. Ain't that amazing?

That is drastic! I did an install just the other day to write a tutorial I have yet to publish and I got nothing like that. I just took the Product Book download and dumped the catalogue section straight into Zen Cart. As it doesn't overwrite any files, the over-ride system isn't really necessary. If you upgraded Zen Cart, none of the product book files would be harmed.

It's getting late, but I'll dig the tutorial out and publish it in the next day or so.

Quote:

---

Originally Posted by johnk

Well, Schoolboy, I guess it could come down to the people you meet. As an ex printer and publisher, most of the people I know who want to set up online stores are book retailers. I have yet to meet one Music/CD retailer. Ain't that amazing?

---

Yeah ... as I said, I am a "sample of one" so my evidence is entirely anecdotal.

It's not so much the people I meet, bu the people who meet me...

All I do is bait my marketing hooks and dip them into that vast ocean called "the global marketplace" - and to date 10 times the number of people who've wanted bookshops ask for music shops! :D

About overrides, I was just talking about my own style edits. It looks completely different from standard ZenCart, for which I praise ZC's use of stylesheets! :D I haven't touched the admin stylesheet.

I'm looking at the notes about what ZC files get overwritten, and see these two notes:

Code:

---

admin/stylesheet.css  merely to put colours on the book collect info page

admin/includes/javascript/spiffycal_v2_1.php clears an IE minor script bug allows calendar use

---

So that stylesheet really shouldn't have affected it. And the spiffycal is the thing that's not working now, and I made sure the files are there (and I'm using Firefox on a mac, not IE), so not sure why the calendar isn't showing up.

Has anyone been able to get MRSP pricing working with this mod? or even another pricing module that shows retail and discount for a product?:frusty:

Thanks,
Kim

Something else to note about my problem is that spiffycal is used in a couple places, and not only does it hide the calendar, it hides the fields into which I could otherwise just type the dates. This is happening on add Product - Book, add Product - General, add sale in SaleMaker... now I'm wondering if this actually has to do with Product Type Book or not.

I did a search, and some people who were having SpiffyCal problems were able to fix it by making the directory and file names have the correct capitalization. I rejoiced, thinking that here is a simple fix, but alas, my directory and file names were already correct.

Quote:

---

Originally Posted by johnk

...
sideboxes_authors_info ...
Hope that helps.

---

Yes, thank you.

Hi, I eddited this module to go well with my computer game shop but I cant create new product of game_type and also has problem with showing fields with multiple option. I attach screenshot of my admin creating new product also main files in moduls product_hry and sql file. Please help me, I am quite desperate! As you can see from the picture I cant get product id so I suppose that problem is somewhere with tables connecting.

Firstly, the product ID isn't created until the record is saved. The logic being that the ID can be used again if you cancel before completing the record. When you edit the record, the ID will then be displayed.

Secondly, I don't think multiple options are an option with the book mod. Unlike dresses which come in a multitude of colours and sizes, a book only comes in one size, otherwise it's another book. For example, you would have a record for a soft cover version and a record for a hard cover version. That's the way I see it anyway.

Finally, I can't see the value in using Product Book for a Computer shop. It can be done of course, but you have to weigh the advantages with the disadvantages.

I think the standard version of Zen Card would probably do a better job. The various attributes give you so much more freedom where options are concerned. You can still group manufacturers, but you can do things like let your customer decide on how much ram they need etc.

Try not to confuse all the extra fields offered in Product book with the limited number in Zen Cart. If you set up a nice template using tables, you can add any amount of data in each listing. Even without tables, you can still create bulleted lists etc.

Have a look at the Zen Cart sample files for video cards as an example. Here's a site where you can run the demo and even choose a template or two while you're at it: http://(sorry, site offline)/

Quote:

---

Originally Posted by johnk

Firstly, the product ID isn't created until the record is saved. The logic being that the ID can be used again if you cancel before completing the record. When you edit the record, the ID will then be displayed.

Secondly, I don't think multiple options are an option with the book mod. Unlike dresses which come in a multitude of colours and sizes, a book only comes in one size, otherwise it's another book. For example, you would have a record for a soft cover version and a record for a hard cover version. That's the way I see it anyway.

Finally, I can't see the value in using Product Book for a Computer shop. It can be done of course, but you have to weigh the advantages with the disadvantages.

I think the standard version of Zen Card would probably do a better job. The various attributes give you so much more freedom where options are concerned. You can still group manufacturers, but you can do things like let your customer decide on how much ram they need etc.

Try not to confuse all the extra fields offered in Product book with the limited number in Zen Cart. If you set up a nice template using tables, you can add any amount of data in each listing. Even without tables, you can still create bulleted lists etc.

Have a look at the Zen Cart sample files for video cards as an example. Here's a site where you can run the demo and even choose a template or two while you're at it: http://(sorry, site offline)/

---

I have posted picture of already modified product_type, it is in czech so it could make you confused. In my point of view information about for example hardware requirements, game language, multiplayer and so long are for custumers very important. BTW it looks like I solved my problem

I managed to get SpiffyCal working; it was just a matter of file permissions. For whatever reason, it was set at 600, so I made it 644, and now it's fine. :blush:

My next issue is, I am struggling to make my front page look like I want - with each listing having the image on the left, the name and stuff on the right. I realize this may not really be in the scope of this topic, but maybe some of the experts in here can help!

Hi,

jphuk.co.uk is down - does anyone have a copy of/link to the latest mod?

Thanks,
Chris

Hello all,

New to Zen cart, okay with PhP and able to figure out most patterns.

I have skimmed through these pages and found numerous downloadable add-ons.

The people using this bookstore/zen cart will ne average pc users.

Can you recommend the easiets, less buggy bookstore add-on and whereto download it?

Thanks,
Doug

Quote:

---

Originally Posted by moochris

Hi,

jphuk.co.uk is down - does anyone have a copy of/link to the latest mod?

Thanks,
Chris

---

Hi Chris...

THIS LINK works for me...

Quote:

---

Originally Posted by d20group

Hello all,

New to Zen cart, okay with PhP and able to figure out most patterns.

I have skimmed through these pages and found numerous downloadable add-ons.

The people using this bookstore/zen cart will ne average pc users.

Can you recommend the easiets, less buggy bookstore add-on and whereto download it?

Thanks,
Doug

---

Hi Doug

See what link I give to Chris above.

You can see the RESULT HERE (one of my demo sites)

Hi all:

We're in the process of launching a bookstore online and I'm looking for the bookstore contribution that's mentioned on this thread, but the links are all dead.

Can anyone post the correct URL to download the files please?

tx
Kamy

Quote:

---

Originally Posted by kamy

Hi all:

We're in the process of launching a bookstore online and I'm looking for the bookstore contribution that's mentioned on this thread, but the links are all dead.

Can anyone post the correct URL to download the files please?

tx
Kam

---

Hello Kamy,

Please check here.

I'm wondering if i can use this module, without loosing all my data (mysql)

i have a working book shop: www.symbolic-books.be

Make a full backup of your MySQL files and your bookshop, then add the files and SQL patches manually. It's very wise to do it all on a test program/database first. I use a WAMP package on my personal computer to test stuff before committing.

Quote:

---

Originally Posted by johnk

Make a full backup of your MySQL files and your bookshop, then add the files and SQL patches manually. It's very wise to do it all on a test program/database first. I use a WAMP package on my personal computer to test stuff before committing.

---

I'd like to display the ISBN, Author and Publisher similar to the one on this site near the image, how can I go about doing that?:frusty:

Quote:

---

Originally Posted by eOstrE

I'm wondering if i can use this module, without loosing all my data (mysql)

i have a working book shop: www.symbolic-books.be

---

I'd like to display the ISBN, Author and Publisher similar to the one on this site near the image, how can I go about doing that?:frusty:

I keep trying to get this module to work, but to no avail and I get errors with daily cron job I have setup. I have decided to back it out.

I could not find the uninstall SQL...Does anyone know where it is? I looked through files and could not find it.

I backed out all files and loaded original. Now, I am getting errors on my product page for:

PREV_NEXT_PRODUCT
TEXT_PRODUCT_MODEL
TEXT_PRODUCT_WEIGHT
TEXT_PRODUCT_MANUFACTURER

I am not sure if these relate to SQL. I am not good at php.

Thanks, Kim

I've installled the mod several time and it ran perfectly for over a year. Fisrtly, the easiest way to test the mod is by running your store on a personal server like Wamp before committing.

Secondly, you should backup the database and Zen Cart before installing the mod. That's mentioned everywhere in the mod's docs, throughout this forum and in Zen Cart's docs. If the mod doesn't work, simply delete everything and reinstall the backups.

I'm not sure if you can delete the mod's database entries because it will also use some of Zen Cart's tables.

Although the file structure and documentation look complex, it's a very simple mod to install. I actually wrote a tutorial on it but I got sidetracked. I do intend publishing it one day, but don't know when that will be.

Quote:

---

Originally Posted by johnk

I've installled the mod several time and it ran perfectly for over a year. Fisrtly, the easiest way to test the mod is by running your store on a personal server like Wamp before committing.

Secondly, you should backup the database and Zen Cart before installing the mod. That's mentioned everywhere in the mod's docs, throughout this forum and in Zen Cart's docs. If the mod doesn't work, simply delete everything and reinstall the backups.

I'm not sure if you can delete the mod's database entries because it will also use some of Zen Cart's tables.

Although the file structure and documentation look complex, it's a very simple mod to install. I actually wrote a tutorial on it but I got sidetracked. I do intend publishing it one day, but don't know when that will be.

---

Thank you for the reply. And yes I did do backups and had it installed on wamp. Kept trying to work at it since issues were minor, but finally decided I could not fix. I reinstalled original files. But now getting the message above. That is why I thought maybe it was SQL. And SQL needed to be uninstalled.

Kim

Kim, like yourself I'm not into PHP, but those messages thinggys are appearing because the appropriate TEXT is missing from your language files. How that happened I can't say, but if you re-upload the original Zen Cart language files all should be okay. The problem with the module is a lack of documentation and we can't blame anyone for that.

If you give me a day or two, I'll see how far I got with the installation tutorial I was writing. If it's far enough advanced, I could send you a copy.

Quote:

---

Originally Posted by johnk

Kim, like yourself I'm not into PHP, but those messages thinggys are appearing because the appropriate TEXT is missing from your language files. How that happened I can't say, but if you re-upload the original Zen Cart language files all should be okay. The problem with the module is a lack of documentation and we can't blame anyone for that.

If you give me a day or two, I'll see how far I got with the installation tutorial I was writing. If it's far enough advanced, I could send you a copy.

---

I will double check language files to make sure I loaded original. I just needed to know where to start. Thanks. And it would be great if you could send a copy of installation tutorial. :smile:

nice information thanks

Quote:

---

Originally Posted by johnk

If you give me a day or two, I'll see how far I got with the installation tutorial I was writing. If it's far enough advanced, I could send you a copy.

---

I am looking at this mod and would appreciate a copy of your installation tutorial.

TIA

Thanks to all that made this addon.

Have one small problem.

I added misc 1 and changed it to UPC.

Now on product info page there is a , before used or new.

Have tried admin developers tool kit and can't locate the stray comma.

Does anybody have any suggestions on how I can locate and remove it?

TIA
Anna

This add on looks perfect for my needs, as anyone tried to get it working on 1.3.9d?
I am working from scratch, new install of ZC along with a new DB but when I try to add a new product type of "book" through admin, I just get a blank page?

New install ZC 1.3.9d
New DB
All files for book product type (V4)
SQL run & all tables created
SQL for dummy authors ect run & ok

All the admin/extras/book(s) are there & accept input no problem

BUT if I try to add a new "product - book" I only get the admin header load, no options for adding a new product.

All other product types still allowme to enter data as required.

I tried 4 complete installs so don't believe there is a missing file.

Any help appreciated thanks

I have since tried 1.3.8a & no luck here, at least I do get a message now.

parse error in admin\includes\modules\product_book\collect_info.php
on line 1766


This is so annoying, of all the reported problems users have had, they did get past the install stage.

I must be doing something wrong but can't work out what.

Any help once again would be appreciated

Hi,
Figured out what I was doing wrong with the comma.
But now all my listing are showing new in description.
Can I just comment out the tpl_product_book_info_display.php
line A which is showing the new?

TIA
Anna

Please forgive I was over looking a tic box for new or used.

Love this addon.

I am trying to setup an online bookstore. I have a huge excel/txt database with columns for author, binding, size, price, description, excerpt, surnames, etc. I know that I can configure a column with all the information in one cell and upload through Easy populate, but is there a program where I can use my excel database/easy populate and have it upload these columns separately?

If you have a Excel SS & wish to load it into your MySQL DB, then you need Navicat.

Brilliant piece of kit.

This is the website - http://books.hashworld.com.au/

I am trying to get the ISBN, author name, publisher etc but it is not showing up. I am new with zen cart and finding it pretty hard to get through.
I will be really thank you if anyone can help me out!! I want feature like: http://www.jphuk.co.uk/zc138a_t3/page.html?id=6

When i create new product, i want features like isbn, author name, publisher features in it.

please Suggest.

Have you been in admin/tools/layout box controller & set to show?

Hi All,

I'm starting with a fresh installation using the latest versions. The WAMP server site currently consists of:

Latest version of Zen Cart
The Bookshelf template
Contact Us - Add Subject
Expanded Category List
Latest version of Product Type Book.

The problem I'm experiencing is that I do not see any product type book form in the admin area when I try to add a book type product. It appears that collect_info.php is not running.

Adding a general product works fine.

What am I missing?