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 201 to 220 of 647
24 Apr 2007, 10:44 AM
#201
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Product Type Book (by moku)

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.

27 Apr 2007, 11:44 AM
#202
bearaman avatar

bearaman

New Zenner

Join Date:
Jun 2006
Posts:
57
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

30 Apr 2007, 6:38 AM
#203
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

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 https://www.bagchee.com

Respnse will be appreciated.

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

1 May 2007, 10:36 PM
#204
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

2 May 2007, 6:08 AM
#205
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

2 May 2007, 10:44 AM
#206
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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)

8 May 2007, 10:29 PM
#207
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.php?main_page=document_general_info&cPath=51&products_id=482

23 May 2007, 10:10 AM
#208
shedman1 avatar

shedman1

New Zenner

Join Date:
May 2007
Posts:
2
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

23 May 2007, 12:19 PM
#209
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_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

24 May 2007, 1:33 PM
#210
gluckfs avatar

gluckfs

New Zenner

Join Date:
Nov 2006
Posts:
21
Plugin Contributions:
0

Re: Product Type Book (by moku)

  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

24 May 2007, 10:04 PM
#211
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi gluckfs
re your (1) the order of the Display lines in the 'book info template' for the cart display can be easily changed by adjusting the order of the array entries in the big array, at the top of that book info template. (in ..\templates)

To re-order elements of the admin data entry page you will have to do it totally by hand, in the collect_info template.

Looking for the 'defines' entries which set the texts labels shown on pages is an art... but the defines are always in ..\languages\english or ..\languages\english\extra_defintions. (in \includes for the cart, under \admin for admin side).

The file names will have 'book' in them, see your original uploaded book contrib fileset.

Unsure why misc 1 field might not show in the admin side, but why not use one of the other misc fields?

29 May 2007, 6:39 PM
#214
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Raunharman.. If you mean show subtitles on the product listings, that's not a supported function. Only ISBN and/or author(s) can be shown...

If you wish to modify the file that adds the above ISBN etc, its class.productBookListing.php
Subtitle only exists when its a book product, whereas ISBN is a standard zencart field (=model) and the authors are got specially in class.productBookListing.php.

30 May 2007, 5:13 AM
#215
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

I think, I could not explain the problem.
Whne we click on any category, the list of books show up. What we want is that along with the title, the sub title should also show up. After the sub title ,a brief description should be there

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

30 May 2007, 5:13 AM
#216
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

Raunharman.. If you mean show subtitles on the product listings, that's not a supported function. Only ISBN and/or author(s) can be shown...

If you wish to modify the file that adds the above ISBN etc, its class.productBookListing.php
Subtitle only exists when its a book product, whereas ISBN is a standard zencart field (=model) and the authors are got specially in class.productBookListing.php.
I think, I could not explain the problem.
Whne we click on any category, the list of books show up. What we want is that along with the title, the sub title should also show up. After the sub title ,a brief description should be there

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

30 May 2007, 5:19 AM
#217
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

Raunharman.. If you mean show subtitles on the product listings, that's not a supported function. Only ISBN and/or author(s) can be shown...

If you wish to modify the file that adds the above ISBN etc, its class.productBookListing.php
Subtitle only exists when its a book product, whereas ISBN is a standard zencart field (=model) and the authors are got specially in class.productBookListing.php.
I believe that I could not explain the problem.
What I wish to get is that When we click on category, the list o books is displayed. At that place we need the title and subtitle to be displayed.

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

30 May 2007, 5:20 AM
#218
raunharman avatar

raunharman

Zen Follower

Join Date:
Dec 2005
Posts:
165
Plugin Contributions:
0

Re: Product Type Book (by moku)

I believe that I could not explain the problem.
What I wish to get is that When we click on category, the list o books is displayed. At that place we need the title and subtitle to be displayed.

http://www.raunharman.com
http://www.raunharman.net
Website Development, E-Book Solutions & Handicraft Exports

30 May 2007, 12:53 PM
#219
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Raunharman.... yes I did understand your post, product listing is the listing of books as you describe, when you click on a category?

One way of getting round the Subtitle issue is to remove the subtitle entry from the book subtitle (in other words don't use a subtitle entry!) then ADD the subtitle text onto your actual Title:

book title<br />The Subtitle

so that now the title displayed should have an added line of subtitle underneath it.

3 Jun 2007, 11:16 PM
#220
moderncraft avatar

moderncraft

New Zenner

Join Date:
Apr 2007
Posts:
35
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hey there!

OK, I'll admit to being totally confused. :-)

I'm working on a ZC site, and one of the products sold is Books. The client would like an easy way for them to add-in things like the title, author, pp count, year published, etc on the admin side (and then show this with each product on the visitor's side).

I think that Moku's BPT add-on will do the trick -- but I'm completely unsure which one to download.

hareslade, if I download and use your latest add-on from your site, does it include everything I'll need, or will I need to donwload Moku's and then yours (if I want the nifty search)?

At any rate, if someone could advise me as to which item in Moku's download list is the most correct, I'd be very appreciative. :-)

Thanks!