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 261 to 280 of 647
24 Jul 2007, 6:05 PM
#261
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Product Type Book (by moku)

I am using an adapted version of the V2 Book Type and am having trouble with the way the Author (in my case Artist) line displays when a product has more than one Author.

Here are two of my products for an example:

A single artist (this is how it should be)
Multiple artists (the attributes/add to cart box drops down the page)

If someone could take a look at it and at least help me figure out where to look for the cause, I'd really appreciate it. I'm not great at php and can't figure out if the problem is in the product_display template or CSS.

Thanks so much.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

30 Jul 2007, 3:17 PM
#262
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

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

I'm using "BETA1_ML_ZC1_3_7_EXTENDED_BOOK_TYPE_V_3_LANGS". I installed this long ago, but didn't realize the search was giving this error. I've turned off the search in the Book Product Type, but I'd like to make sure Books are going to be found during a customers search.
Is there a fix for this? I'm using cart 1.3.7, single lang, and it's my Thrift Shop if you want to take a look.
Thanks.

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

30 Jul 2007, 6:02 PM
#263
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)

hrm... apologies I've been away...
Both the links you give above now point to product music items not product book, are the links out of date? The book template is normally 'product_book_info' in the querystring, yours says product_music_info i think

The template used by each product type is different..

The css entries that defines that page layout sometimes needs to be adjusted. But of course there could indeed also be a css prob, or a particular browser that gives trouble.

In the book contrib, the css file 'stylesheet_book_prod.css' must be copied into the current template, if it's not 'classic' being used.

Let me know hrm, if you still have a book authors demo to look at

30 Jul 2007, 6:11 PM
#264
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)

gxjenkins
Well not all installs give the 'zencart standard search box' search error anyway..

If you can switch on your search temporarily and copy the sql error text, (if its giving trouble), but do send it to me by private message, otherwise it makes the posts here looooooong..

I could then check it out.. V3 books should have had the sql correction transferred from the older V2

31 Jul 2007, 5:22 AM
#265
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Product Type Book (by moku)

Switching on Book Search I get this error:
"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 '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR (mtpd.metatags_keywords LIKE '%sheldon%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%sheldon%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR (mtpd.metatags_keywords LIKE '%cheney%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%cheney%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%cheney%') )) ) 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 '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%'OR book_authors_name LIKE '%sheldon%'OR book_authors_nickname LIKE '%sheldon%'OR subtitle LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%'OR book_authors_name LIKE '%cheney%'OR book_authors_nickname LIKE '%cheney%'OR subtitle LIKE '%cheney%') ) ) 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 '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%' OR book_genre_name LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%' OR book_genre_name LIKE '%cheney%') ) ) 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 '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%' OR book_type_name LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%' OR book_type_name LIKE '%cheney%') ) ) ) ]"

After turning off the Book Search I can find books by searching for words in the title. That will be O.K. if I have to leave it that way.
I'd like to be able to search on Author, and the other search items. I feel like I've got a piece of this version, and a piece of that version. I installed this awhile ago, and then left it to work on another store, so I'm not sure if I left something out, or what.

Is there one install that brings everything up to the same version including any patches?

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

31 Jul 2007, 11:15 AM
#266
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 gxjenkins

The V3 beta does indeed include my fix for the search box.. but your sql shows there's still a bug... this part of code (excuses!) is moku's original design, so I need to look at it with intensity to see what it's supposed to do

There is obviously a small fault in the code (in the 'if' section on line 32 onwards in file class.productBookSearch.php..) where an 'AND' gets added into the construction of the query.

I will pm you now, asking for some more easy to get info.

Incidentally, to 'private message' someone just click on the user's name in top left of the post, it should give the option to p.m that person. Myself I prefer not to see the longer sql's in the thread, because unless one is a sql genius (which I'm not) reading sql is not fun..

6 Aug 2007, 5:52 AM
#267
jazeem avatar

jazeem

New Zenner

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

Re: Product Type Book (by moku)

The calender control next to the 'Date Available:' field on the add new book screen is not working for me. On the bottom of the browser it 'shows error on page'. Attaching the error message screen shot. But I am able to manually key in the date. Is it a known issue?

6 Aug 2007, 12:09 PM
#268
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)

jazeem:

The calender control next to the 'Date Available:' field on the add new book screen is not working for me. ... Is it a known issue?
Hi Jazeem
It is now! I'll look into it

6 Aug 2007, 2:06 PM
#269
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 Jazeem
I racked my brains looking as to why the spiffy calendar fails on the book collect info page 'available date', but I could not see what's different from the standard product collect info page (which works ok).

I put a temporary very minor fix in the javascript file that creates the calendar, (around line 72, marked jph), the modified file (zipped) is at
http://www.hareslade.com/zc125/downloads/fixes/spiffyCal_v2_1_jscript.zip

Upload to replace /admin/includes/javascript/spiffyCal/spiffyCal_v2_1.js

The original already there is the standard zencart file.

(If anyone wants to try locate the real prob, let us know. Using firefox enables you to look at the exact javascipt fault, using javascript console in 'tools'.

The fix I did does not seem to affect the calendar anyway, the 'inhibited' part says it just locks the 'get calendar' button down when a calendar is showing.. but it seems to do that, even with the fix!)

6 Aug 2007, 7:01 PM
#270
berrybatens avatar

berrybatens

New Zenner

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

Re: Product Type Book (by moku)

Hi, first of all congratulations with this fabulous multilanguage product type book!
I made a V3 Beta 2 installation and everything works fine.:smile:
My question: There is one ISBN field. I need one ISBN10, one ISBN13 and a NUR field. All needed fields are similar to the ISBN field. How can I add these fields to my ZenCart?

6 Aug 2007, 10:15 PM
#271
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 berrybatens

The ISBN field is really zencart product 'model' field, so it's not one that can be easily duplicated and then appear exactly the same as ISBN does, (e.g ISBN appears in product listings for book products)

But the book 'misc' fields that are spare can be used as extra data lines in the product book display lower section... these are fields that take up to 255 characters.

if you have a look in the admin ....
catalog | product types | product book | edit layout

You may see that there are some fields called 'misc...' 1 to 10
Some of these are already on (1) but those set to '0' should available for use, if set to 1.

If one of those spare is switched on, (maybe avoid misc_1) it should then appear, both in admin side book product page, (collect info page), and also appears in the data lines listing on the cart book display provided a value was inserted in admin for that field.

You would have to also find the books 'defines' php file entries to change the textual labelling of the field, in both the admin (admin/includes/languages/), and the cart defines (/includes/languages/) /your_language, if you don't want labels to remain as 'misc_' which is their currectly set label text.

9 Aug 2007, 9:30 PM
#272
berrybatens avatar

berrybatens

New Zenner

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

Re: Product Type Book (by moku)

Thanx for the clear explanation, I worked it out and everything looks good! I have even skipped the original ISBN field and made new ISBN fields and a NUR field from the MISC fields. It works perfectly.
I still have one more question; Is it possible to only show the Gross price of a book instead of Net and Gross?

12 Aug 2007, 10:38 AM
#273
meeven avatar

meeven

New Zenner

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

Re: Product Type Book (by moku)

Is the product type book recommended as the only way for building a bookstore? I notice in the README_main_book_install.txt that it talks about a few core files being replaced. What implications does this have for zencart upgrades and code maintenance? Will upgrading ZenCart overwrite these changes?

Also, I couldn't quite understand the difference between ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V3.txt and only_use_the_patch_for_FULL_V3_install.txt

I am installing this for the first time, so I am not sure which patch to use.

12 Aug 2007, 11:18 AM
#274
meeven avatar

meeven

New Zenner

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

Re: Product Type Book (by moku)

I have a few questions about the product type book mod. It seems to fill a great need, judging by the fact that this forum post has one of the largest number of views. My qeustions are:

  1. Is this recommended as the only way for building a bookstore or is it okay to go with the product general type?
  2. I notice in the README_main_book_install.txt that it talks about a few core files being replaced. What implications does this have for zencart upgrades and code maintenance? Will upgrading ZenCart overwrite these changes?
  3. I couldn't quite understand the difference between ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V3.txt and only_use_the_patch_for_FULL_V3_install.txt . I am installing this for the first time, so I am not sure which patch to use.
  4. Also, "Apply SQL in folder RUN_THIS_SQLPATCH_FOR_DATABASE in zencart admin sql patch section" is a bit cryptic. I understand the following patch syntax reasonably well:

patch filetobepatched < patchfile

but can't correlate this to the specific patch file and the directory in which the patch should be run.
Thanks in advance.

13 Aug 2007, 5:48 AM
#275
jazeem avatar

jazeem

New Zenner

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

Re: Product Type Book (by moku)

meeven:

I notice in the README_main_book_install.txt that it talks about a few core files being replaced. What implications does this have for zencart upgrades and code maintenance? Will upgrading ZenCart overwrite these changes?

I wanted to ask the same question.

13 Aug 2007, 5:38 PM
#276
meeven avatar

meeven

New Zenner

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

Re: Product Type Book (by moku)

Sorry about the double post. I have no idea how it happened.

17 Aug 2007, 3:08 AM
#277
meeven avatar

meeven

New Zenner

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

Re: Product Type Book (by moku)

I am facing a bit of frustration getting this to work. :dontgetit

I have uploaded all the files, but can't figure out the cryptic, "3. Apply SQL in folder RUN_THIS_SQLPATCH_FOR_DATABASE in zencart admin sql patch section".

I want to run the patch for the full version since this is a fresh install, but I don't see a "zencart admin sql patch section" among the install files. Where exactly is this? And what is the file against which this patch has to be run? Or, does this patch have to be run through phpmyadmin or something?

Also, I had renamed my original zencart admin folder to something else. It isn't clear from the readme files if the 'admin' folder for this product type is different from the original admin folder or if I need to upload the contents of this admin folder to my renamed admin folder. I ended up uploading the whole contents of this product type's catalogue folder, so there is now the original admin folder(renamed) and the admin folder for this product type. Is this the right way to do it?

I will be thankful for some help with all this.

22 Aug 2007, 12:57 PM
#278
gsis avatar

gsis

Zen Follower

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

Re: Product Type Book (by moku)

After a few false starts I finally have the main part of the Extended Moku mod working, and will be implementing the search box and other odds and ends as I start to bring the revised site back up to speed.

I started out trying to implement version 3, from the Zen Cart Downloads area, on a brand new local Zen Cart with no other mods. This took me down a dead end as I wasn't able, with my limited php knowledge, to clear up what appears to be a T_CONSTANT_ENCAPSED_STRING syntax error in or around line 1714 of collect_info.

After rebuilding a clean Zen Cart I was able to implement version 2, from the hareslade.com web site, without problems. As I only use one language, at present, I don't see this as a problem for my site - but it's certainly a caveat for those who need the multi-language features of V3. I've now repeated this implementation on my live site, and will be adding the other odds and ends as they're needed and as time permits.

I've re-organised my categories but now have over 500 books to change from Product - General to Product - Book. I'm aware of another thread that advises against changing the Product Type, but would like to get these 500 products changed as quickly as possible. An initial trial of one product shows me that there will be problems but they might be quicker to fix than copy/pasting all of the data!

Any thoughts, anyone?

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!

25 Aug 2007, 4:56 AM
#279
skydealer avatar

skydealer

New Zenner

Join Date:
Aug 2007
Posts:
19
Plugin Contributions:
0

Re: Product Type Book (by moku)

I'm bumping this thread to keep it alive. :smile:

I'm in the same boat as some of the other posts. I'm pretty fair with SQL databases, and even run a vbulletin forum (which is what this forum uses) but the modding didn't quite go as expected.

I'm playing with a clean, new install of version 1.3.7 on Zen. My server has MySQL version 4.1.20. I've wiped out the Zen Cart install and re-tried the ISBN plugin several times and it's still not showing up in the admin area. The database is showing the tables...
books_to_authors
books_to_genres
books_to_languages
books_to_types
book_authors
book_authors_info
book_color
book_color_description
book_condition
book_condition_description
book_genre
book_genre_description
book_type
book_type_description

a second attempt created the following fields (just in case it needed the prefix)

zc_books_to_authors
zc_books_to_genres
zc_books_to_languages
zc_books_to_types
zc_book_authors
zc_book_authors_info
zc_book_color
zc_book_color_description
zc_book_condition
zc_book_condition_description
zc_book_genre
zc_book_genre_description
zc_book_type
zc_book_type_description
zc_get_terms_to_filter
zc_product_book_extra

The site is just for test purposes (at goodnerd.com) until I get everything worked out. The other issue will be how to one imports the bookfields from a database program such as bookttrakker, bookhound, pragersoftware or UIEE.

Do online booksellers enter their products twice? How do they list a book in both their online zen-cart store and also upload their stock listings to sites like Amazon or Alibris?

I have about 20,000 books to eventually list, of which I only have about 2000 cataloged so far. The ISBN ones are on half.com and the inventory database is a CSV file, the other I used Pragersoftware and it's a UIEE file. My site was using bookwriterweb to generate the book pages, but I'm wanting to switch to a zen-cart setup and I was hoping this ISBN plugin would do the trick but I'm striking out and I'm seeing the same results every time I install it. I just can't figure out where I'm screwing up.

The original instructions went okay until the last few lines of SQL modding, but I saw in one of the other posts what the fix was. Still, no changes in the admin area.

25 Aug 2007, 5:57 AM
#280
gsis avatar

gsis

Zen Follower

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

Re: Product Type Book (by moku)

skydealer:

Do online booksellers enter their products twice? How do they list a book in both their online zen-cart store and also upload their stock listings to sites like Amazon or Alibris?

Some very small sellers probably only ever list on one venue and end up out of business if that venue pulls the plug on them. Companies like Amazon are quick to do this if, for example, they receive more than a certain number of complaints in a short time. Amazon does little to protect its sellers - it is only interested in keeping buyers happy.

Very small sellers probably do manually cross-list. Without a business plan to introduce the tools to support growth they either stick at the size they can handle or try to grow too big and let customer service (and leisure time) suffer as they try to keep up with the listing in numerous places.

Those who plan to grow usually recognise that the right tools are essential. They allow time, in their business plan, for research and development. They have the tools in place as and when they're needed to either support growth through faster listing (and cross-listing) or by effective use of cheap labour. The ideal situation is to make effective speed-listing tools available to the cheap labour.

Order fulfilment and churning are other issues.

In order fulfilment the keys are to find and pack the book as quickly as possible. In the UK - over certain limits - it's more efficient and cheaper to have RM come out and collect your outgoing mail than it is to go to the post office. Once the mail is ready to go you make better use of your time by being at your desk than in the queue at the post office (especially on pension day).

Churning is about getting rid of old stock. It's a particularly important issue for those with storage problems. I list low-value books into particular boxes, give them 6 months, then churn the whole box. I still have to weed out long-standing non-sellers from the main stock (I give them 12 months) but it's less time consuming as I collect the expired stock whenever I visit a particular box to pick a book for an order.

Automatic cross-listing is a huge time saver and multiplies the opportunity for your stock to be seen and sold with relatively little effort by you or your staff.

Amazon can take a batch upload.

I don't know about Alibris or Abebooks but I wouldn't be at all surprised if they can do the same.

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!