Product Type Book (by moku)

[MikeFarrant]

Hareslade,

I've just discovered that I have an error when I try to do a ISBN search...
When I type in a textual ISBN it comes up with:

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 'where book_isbn = 123456654' at line 3
in:
[select special from where book_isbn = 123456654]

I've probably messed up something but not sure where... do you know where this code would be coming from?

btw I've now got Authors and Genres automatically updating from an easypopulate upload. I've still got some work to do to get 'redundant' authors removed when products are deleted, and I am only pupulating the minimum fields to get the authors and genre searches working (so I don't allow for genre description or author url for example) but that would be quite easy to include... if required.

Mike

[hareslade]

Hi Mike,
I'll p.m you, the ISBN search is too complex to comment on here!

[chinesebks4children]

Mike and Hareslade,

I've mostly got what I want working and I wanted to thank you for your help.
Mike, if you get more of EasyPopulate working I'd like to know about that if you have a moment to pm me...

thanks again!

[zcusr]

...so I had an error of duplicate entry many times, but everything seems to be just fine, that's weird... perhaps information on checking your product type book installation would be useful...

anyway I was wondering has easy populate tab delimited file usage to bulk upload book listings been discussed?
I get that the easy populate mandatory "model" attribute is supposed to be used for ISBNs, but what about other book-specific info, something tells me that I should name the columns like the corresponding tables/rows or something in SQL, but perhaps that has already been discussed...

[detourned]

i was wondering if it was possible to have more than one author appear on two different lines.

what i'm hoping to do is this:

many of the books i'll be listing are works in translation. i would like to have the translator's name appear beneath the author's name, & be searchable as well.

or, how would i go about having a 'translator' field function in the same way as the author field?

thanks!

[MikeFarrant]

...so I had an error of duplicate entry many times, but everything seems to be just fine, that's weird... perhaps information on checking your product type book installation would be useful...

anyway I was wondering has easy populate tab delimited file usage to bulk upload book listings been discussed?
I get that the easy populate mandatory "model" attribute is supposed to be used for ISBNs, but what about other book-specific info, something tells me that I should name the columns like the corresponding tables/rows or something in SQL, but perhaps that has already been discussed...

zcusr
There's more to it than just adding the specific fields. The easypopulate.php needs to be modified also to populate the necessary tables. I have been working on this myself and also deleting using product status 9 but I am a busy guy on my day-job so work on it is a little hit-and-miss.

[MikeFarrant]

Mike and Hareslade,

I've mostly got what I want working and I wanted to thank you for your help.
Mike, if you get more of EasyPopulate working I'd like to know about that if you have a moment to pm me...

thanks again!

I've just PM'd you on this topic - check your mail :)

[MikeFarrant]

If you promise not to buy anything... (I have no books for you - but can and will take the money!!) Feel free to visit my book store... it's not too shabby to view now - although I have some way to go before it opens officially - The finished store will have around 500 products - books, cds and dvds

Special thanks to Hareslade for his help

I welcome any constructive comments...

http://www.branchchristianbooks.co.uk/shop/index.php

Thanks,

Mike

[focus360]

I have just installed this Mod. And had a very good search of this thread and others.

Currently the mod shows the ISBN and the author on the product listing page.

Is there any way I can show other fields on the product listing page?

I was hoping to display three or four other fields e.g. format, subject, size.

AND THANK YOU THIS IS A GREAT MOD!

[aenea]

Hi! I'm new here and am having fun implementing this software for an online bookstore we hope to set up.

I have two questions related to the search facility:

1) How can I make the keyword search search the additional book fields (author, subject, etc.) as well as the title and description? I paid a visit to MikeFarrant's online store and he appears to have got it to include the subject field in the keyword search, though not the author.

2) Where do I go to find the code that generates the ouput from the keyword search? I'd like to add some text to make it more obvious that clicking on the book's image will take the user to further details about the book.