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 421 to 440 of 647
26 Aug 2008, 12:21 AM
#421
dgcdesign avatar

dgcdesign

New Zenner

Join Date:
Aug 2005
Posts:
26
Plugin Contributions:
0

Product Type Book (by moku)

Is this module not available anymore? The download site seems to be, well... down?

26 Aug 2008, 10:58 AM
#423
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
The email advices are not working for me yet again, so I don't know what posts are solved without trekking back through the list.. I moved house recently so its a bit chaotic here. And I'm slightly out of touch with book product..
However
tHis is my test site for book product in single language
http://www.jphuk.co.uk/zc138a_t1/

I seem to remember probs with authors search were possibly originally due to not having a manufacturer in the book product item.. other than that, it works om my demo site?

The prob with the 'extra' data still showing with a disabled item, I agree, it shows the 'extra' data still, -if there isn't extra data the book item correctly disappears. I will look into this, but did anyone find the code solution?

26 Aug 2008, 11:54 AM
#424
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
It seems to me that the music product does the same thing, shows the extra data, rather than disappearing completely when the item is disabled in admin.

http://www.jphuk.co.uk/zc138a_t1/index.php?main_page=product_music_info&cPath=3&products_id=6
The above link is my demo site with a music product, the product you see is disabled (red) in my admin, note it has no title

Would someone check this out on a 1.3.8 zencart by putting a music product in and then disabling it, , see if I'm right

I'm not saying it isn't a book product bug, but music product seems to have the same thing?
Reason I checked out music product, is that I compared the book php files code with music product files code, they have similar code in terms of what the coding does.

Let me know..
btw of course, add the artist etc extra data into the music product, for the testing..

26 Aug 2008, 12:30 PM
#425
michaelhl avatar

michaelhl

New Zenner

Join Date:
Oct 2005
Location:
Germany
Posts:
60
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hello hareslade,
this is from the header.php in includes/modules/pages/

I take it from product_info and it it to product_book_info

 
 // if specified product_id is disabled or doesn't exist, ensure that metatags and breadcrumbs don't share inappropriate information
  $sql = "select count(*) as total
          from " . TABLE_PRODUCTS . " p, " .
                   TABLE_PRODUCTS_DESCRIPTION . " pd
          where    p.products_status = '1'
          and      p.products_id = '" . (int)$_GET['products_id'] . "'
          and      pd.products_id = p.products_id
          and      pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
  $res = $db->Execute($sql);
  if ( $res->fields['total'] < 1 ) {
    unset($_GET['products_id']);
    unset($breadcrumb->_trail[sizeof($breadcrumb->_trail)-1]['title']);
    header('HTTP/1.1 404 Not Found');

It seems not to work full, but the extras are not shown.

26 Aug 2008, 1:20 PM
#426
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 michaelhl
The code setup you used from the standard product header isn't the same as the code in the music product file..

It looks to me like the http 404 header has been added to zencart standard product, but not for music product,
which explains the posts about search engines not liking book product, which copies the music code.

The music code probably doesn't allow a 404 header to be written, (where the ordinary product does allow), because the 404 standard product code instructions are in the header, not in main_template_vars.php. You can't write a header after any html is output.

Technically the separate problem seen with extras data showing, is because the main_template_vars_product_type.php in both music and book product, is running when it shouldn't, i.e its getting 'extras' data.

main_template_vars.php switches to the 'noproduct' template when there is no product found to display (i.e when it detects the red 'disabled' setting for the product is present). But I don't yet understand why the extras data are apparently showing on the 'info' template - it should have switched to the noproduct template.

Has anyone tested the music product for the same extras data problem when disabled, yet, as I suggest?

If it turns out music product is faulty, then really a post should be put in a new main thread, asking for solutions for music product.

1 Sep 2008, 5:05 PM
#427
the_ocarina avatar

the_ocarina

New Zenner

Join Date:
Nov 2007
Posts:
9
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hey Hareslade,

Have you had any difficulties with your Zen Cart or mod when a shop has upwards 2,000 products?

I'm in a bit of a bind, which is detailed here: http://www.zen-cart.com/forum/showthread.php?p=604865#post604865

You don't need to read my entire problem, but I am curious about where I can go for answers in fixing the Zen Cart.

1 Sep 2008, 8:39 PM
#428
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 ocarina
There must be a processing time, or other limit somewhere on every sql request, you found it..
Either Hostgator has a type of sql processing limit which other hosts may not have,
or
the book sql might be proving too unwieldy because of the number of products

Or if you're showing 'product count' in categories menu links on the pages, turn that off it reduces sql requests.

Theres also a zencart global debug setting I think, that can show the sql process time period used, at bottom of each page, once you see it, if it says more than say 6 seconds its having trouble

I think all hosts limit the sql 'power' available per hosted site, as they are normally on servers with say 50 websites, and if one takes all the sql time up, the other sites will grind to a halt.

1 Sep 2008, 8:51 PM
#429
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)

generally... is anyone going to test the music product to see if it behaves the same as book product regarding the 'extra data' see several posts back?

Without confirmation I'm unable to post in the main forum regarding music product..

(The book product still shows up on its original url, even if the product has been disabled in admin.. does music product do exactly the same ?)

3 Sep 2008, 9:51 PM
#431
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
Depends which version zip you need 1.3.8 or 1.3.7

See left hand 'zencart matters' menu, at
http://www.jphuk.co.uk/zc/index.php as in my signature below

If the download doesn't work (but it should) try a different browser

4 Sep 2008, 11:27 PM
#432
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Product Type Book (by moku)

how can I enable display or activation of url for authors, when I click on author in a product page, it does do the filter action than going to th eauthor url.
the same question for displaying the text of description of format, conditions, etc.

5 Sep 2008, 11:07 AM
#433
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)

not sure quite what you mean in your post reza,
maybe p.m me with a page url as info, and description of the situation

there are a lot of display settings in the admin for book, in the 'product type' edit page

5 Sep 2008, 1:01 PM
#434
bookwise avatar

bookwise

New Zenner

Join Date:
Jun 2008
Posts:
23
Plugin Contributions:
0

Re: Product Type Book (by moku)

Can anyone out there help me make adjustments to the default product type please on a standard install of V1.3.8 for a bookshop?

What I'm hoping for is to eliminate the need to add a new product type by just rejigging the default one to suit my needs. I figure that if I can change music genre to subject and recording artist to author then I will have the main changes I need. I have worked out how to change the wording in the language file so that music genre appears as subject but I can't work out what language file I need to change so that recording artist appears on the product page as author.

Also I want to show format (std, trade etc) and new or used description of books on the main product page. How can I easily achieve this? By adding these fields to the database or by working through attributes?

Can't make sense of the bookshop mod. Downloaded it but couldn't work out what I needed to upload. I am sure it is excellent but to some one like me it is totally confusing.

Thanks. I'm a newbie by the way:smile:

5 Sep 2008, 10:02 PM
#435
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 bookwise, maybe you need to get more zencartwise before attempting mods
i.e like what we have to do, work out slowly, where the files are that do various things

the book product isn't too bad, you may get through a few zencart test sites first if you're new to installing add-ons
Adding fields for new/used and so on is a programming chore, thats why book type exists!

In the book zip pack is a folder 1_BOOK_MAIN_FILES
Within that is folder 'catalogue', thats the one to upload the contents of, into the zencart main folder.

You also need to alter the database tables by using from folder RUN_THIS_FULL_INSTALL_SQL_PATCH_FOR_DATABASE
file ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V4.txt inside zencart in the admin 'sql patch' page

BUT i suggest first, you get the 'database backup' add on from the add ons list, make sure you have
a database backup BEFORE you apply the book sql patch. Just in case summat goes wrong..

All this is told in the readme file README_main_book_install.txt in folder 1_BOOK_MAIN_FILES.... thats where the info is..

6 Sep 2008, 11:04 AM
#436
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Product Type Book (by moku)

wel, when you see a product in product info display page, when you click on authors, it goes to show all bookd from this author (so, filter function), while in admin we can put a url (inetrnal, or external url) or this author, I don't find any place on the front page of site where I can find the url link to authors' url.

I hope this is now clear, the best example, see our demo site and click on the authors of a book.

6 Sep 2008, 11:14 AM
#437
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Product Type Book (by moku)

is thre any way to make or have more defined search functions: example:
http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html

in actual situation, when I click on authors filter, it gives me a long list of authors, so actually the customer remains within so much data even if for us we did a filter of many data.

summarized: we know that one author can have some subjects, and each subject can have some types, , then using the link above , I suppose we should have the possibility to define more specific search options for book products withou loading many times by filtering this options (authors, subjects, types, ) individually.

another intressant link here wich should be better for us due to use dirctly from mysql:
http://php-ajax-code.blogspot.com/2007/07/ajax-triple-dropdown-with-states-cities.html

(advantage: used mysal, so very good for us to use bok tables)


http://www.opencrypt.com/blog.php?a=22
also good, still in progress, but it used also mysql, )


6 Sep 2008, 11:34 AM
#438
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Product Type Book (by moku)

oops: also this one which is more flexible and more robotic

http://www.opencrypt.com/blog.php?a=23

6 Sep 2008, 12:22 PM
#439
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Product Type Book (by moku)

I added this line to tpl_advanced_search_default.php
after manufacturer field:

<fieldset class="floatingBox forward"> <legend><?php echo ENTRY_MANUFACTURERS; ?></legend> <?php echo zen_draw_pull_down_menu('manufacturers_id', zen_get_manufacturers(array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS))), $sData['manufacturers_id']); ?> <br class="clearBoth" /> </fieldset>

//this is what I added after above lines bof: adding extra filed to search function: authors list

<fieldset class="floatingBox forward"> <legend><?php echo ENTRY_MANUFACTURERS; ?></legend> <?php echo zen_draw_pull_down_menu('book_authors_id', zen_get_book_authors(array(array('id' => '', 'text' => MAX_BOOK_AUTHORS_LIST))), $sData['book_authors_id']); ?> <br class="clearBoth" /> </fieldset> //eof

but the filed of authors doesn't been displayed.
Is this not a good way to get more search definitions for advanced search for book products?
for echo entry manufacturers, I didn't know where I should put definition to come from it to here. anayway, the important is that we get authors, and other options of a book in the search functiionality to decrease the number of results and more customer friendly result page.
a result page with more than 50 articles is never intressant for a customer.

6 Sep 2008, 1:21 PM
#440
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 reza
Well I expect you'll find a way of altering the search function, under certain conditions there is a dropdown for products lists , an 'A B C D ' filter, it sounds like you need that sort of thing somewhere for authors..

I'm not able really to make specific suggestions, it'd take a long time for me to sort it out ..maybe on zencart 1.4 when we all have to totally rewrite our add-ons coding :)