Product Type Book (by moku)

Hi tekram!

I guess it shouldn't be a problem, provided that your database settings are correct. Which means, that you use a charset (UTF-8), that can store both english and arabic characters.

Then maybe you could use the title field for arabic and the subtitle for english.

Thanks MarW!

that is anexcelent idea. if i were to do that, would the books be searchabe by arabic and english. ie, if one pt in a search term in to the search engine, it could be put in english and arabic.
secondly, i would lke to also dispy the authors in engsh and arabic. is there an easysolution to that?

it works!

you can searin both languages.

in terms of the authors, youan put the author names in arabic as a nickname which is displayed in parentheses with the name in english.

thanks for the advice Marw.
thanks for the mod moku.

I would've posted the same idea, I'm glad you figured it out yourself and it works!
:lookaroun

I was getting ready to write the following and found this thread...NEED HELP THOUGH:

Hello all:

I am very new to the cart and I am trying to get up and running... Everything seems ot be a breeze, except for something very important to my store.

I need to create a product type: Books

I need it to have the following fields: All the usual product stuff, AND manufacturer, size, pages, author, isbn, Style... I need these set so I can have these custom fields in every book product type.

I know nothing about doing this kind of thing... detailed help would be appreciated.

Thanks...

I don't understand this... I am using the classic theme. Will this work... Can someone talk me through installing this...

Hi!

It'll work if you use Zen 1.3 or any later versions. You can find instructions in the downloaded archive (readme.txt I guess).

In case you get stuck or need any help I'll be here tomorrow.

Good luck!
:smile:

is there a way to transfer pre-existing products into book type?

ie f we already have a catalog up and products are of general type.

thanks

Sure, but it'll take some SQL skills to to this.

I just had a quick look at the tables, so the list may not be complete, but you'll have to do these:

• products table: update the products_type field for every product to match the Product - Book type ID in the product_types table
• link the books to the authors, genres, etc (books_to_authors, books_to_genres, books_to_languages, books_to_types)

The first step is easy, a simple SQL update, but I'm afraid you'll have the to do the second manually, as these are different for every books.

If you have lots of books and can't figure the above out yourself, PM me and I'll try to write the SQL script for you.

I have completely destroyed my Zen Cart...

I have tried this porduct type 2 times and I cannot get it to work... I know it is my fault and lack of experience.

CAN SOMEONE PLEASE DO THE FOLLOWING FOR ME....

Is there anyway someone can take the original zen cart program... Put in the Book Product type... Zip it up, and send it to me... That way I can just upload it, install the whole thing again... and begin the customizing I need to... Just add the type to work with the default theme that comes standard with Zen Cart!

You can e-mail the file to [email protected]

Thanks...

Would like to adapt your Book product type to our needed Cars type. Only need to add single values per product: Year, Mileage. So, not needing any of the author, genre, and type tables, should I cut those bits and functions out of my version? Or can they safely be ignored? Of course, would not add the extra tables for those things. But was wondering about coding in templates and other files in your package.

Want new field Year (at least) to be searchable (search on mileage??? Could happen, I suppose). Any hints on whether that would happen automatically or if not then how to make it happen?

Thank you much,
--eon--

I don't know if this mod is working right. I went to choose product type and all I saw was:

Product - General
Product - Music
Document - General
Document - Product
Product - Free Shipping

But when I went to the extras section book type, author, color, condition is all their. Do I need to create a product type to select from?

Please I need all the help I can get.

I meant not working right.

you should not have to. it should show up on its own. try instaling in again.

is there an easy way to take books that are n an excel file and transport them in to the database as a book type product?

I, too, am having trouble with running two languages with product type book. Also, would like to see it integrated with EasyPopulate. Any news as far as that is concerned?

Hi folks
I don't know if Moku is on holiday :) but early on, he said someone please
modify the moku book type sql file so it works in zencart's admin patch

here's one I think works, let me know on a p.m, if it don't
http://hareslade.com/zc125/download/add_to_mysql_jph1_for_moku_booktype.zip

I don't know whether to switch over to moku's book type or not (I have one from an older style book type, which I developed and use on my own zc 125 site, see other threads) .. it depends whether moku is going to be around.. he seems to be away just now...

As someone said in the earlier posts, the 'hareslade' book type (that I modified from an older contrib) is not directly compatible with moku's, because of the different table layouts for book data.

However, the moku version has a more realistic table layout.. I got as far as updating my own version to beta 1.3.0 (see elsewhere), but there was a zencart bug in the copy functions in admin.. I never re-coded the correct version into the fileset..

The zencart team seem not to want to define a formal book type - there are loads of small bookshops would use it.. and now, we have two contrib versions not compatible..

I say all this.. what matters really is whether moku will support this new version through time.. I don't want to embark on using the moku version if I get lumbered with keeping it up to date :)

Any views/ appreciated...

hareslade:

I don't want to embark on using the moku version if I get lumbered with keeping it up to date :)Same reason why it's not built-in to Zen Cart...
Product types can make ideal contributions if they are kept up to date.

Well what I really meant was, if zencart had a standard extended product type with say 50 basic fields/tables, when it came to deciding which 'existent' fields/tables to use in the book type, it would not be a case of inventing extra fields (with non-compatibility to other contribs) and all the probs of manually adding them one by one by field name, into the standard zen code..

As it is, both book types still use 'manufacturer' as 'publisher' - which is a nuisance sometimes.. these are choices made because of coding difficulties of adding product fields and displaying them on admin pages.. yet there has been much effort gone into zencart overrides..

Standard mega-type

So if I was inside the team, (which of course I'm not) I would be looking for a standard product type 'add on' with a load of fields/tables, creatively named 1 to 50 or more :) etc and a 'standard contrib' sql that can add those fields/tables, but selectively in an actual add on, according to need. It could even have an online admin to set up active fields selection, which creates the correct admin product page layouts....

Just a thought. The moku contrib offers a nice commonality with the music type, but moku has to add fields which are now specific to his contrib.. same as I had to, on the one I did .. should I be looking to invent a product field-creation add on?

Moku, please, help!! Or anyone...
I've installed Product Type book and everything works fine.
The problem is if I set english language I have no problem, but if I change the language to spanish starts the problems (and I need only spanish language):

• when I want to see an author with only 1 book, it doesn´t seem to find the page: I see a blank page, or the message "there are no books...", either from the select box and from the authors name in the product info.
• if the author has 2 books, I can see the list with the 2 books of the author.(the index page).
  I seems that it can´t find the product book page, if there is only one book.
  Other problems I have:
• I can´t see a pop up or some page with the author information anywhere (info, url, photo, etc) even with english language, (I have no problems in the admin, I can write that info)
• and I don´t know what to do to display ALL books of a specific author, no matter the category.
  ¿Can you tell me where to start to find the solutions?
  Thanks a lot!!

I had a similar problem with my install of product type book (moku version). To fix it, I ended up deleting all products and putting them in again after I had installed PTB, making sure that all language fields were filled in with data. I don't know if this could be the solution for you, but I am just telling you what worked for me. Good Luck.