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 281 to 300 of 647
25 Aug 2007, 8:09 AM
#281
skydealer avatar

skydealer

New Zenner

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

Product Type Book (by moku)

Thanks GSIS for the info. I don't even bother with the lower priced books. If I see other dealers having them for $1 or less then they go right into the donation bin. My stock came mainly from a family collector and most of it is limited to single copies that I'm expecting to wait quite some time to find the right buyer. A good example is a book I just found while unpacking, it's just an 1866 copy of *After The Storm *by J.E Skinner, which typically sells for about $200-$225. But this copy was owned by Charles Dickens and has his bookplate in it as well as another plate stating Gadshill Place, June 1870. This is a unique item and it may take years to sell.

I'm looking at multiple venues as well as the zen cart database, but I do ship out several books a day, even with just only 10% of my stock listed. US Postal regulations have recently change regarding US Media Mail so a bookseller needs to either stand in line at the local PO (a real pain) or lease a postage meter or online service such as stamps.com. UPS is simply too expensive for 1-3 pound boxes.

Amazon & Alibris can both take batch loads, half.com does also allow csv (or tab-delimited files) to be transferred, upon approval (you can always download csv files of your inventory though) and some inventory tracking programs allow automated uploading to multiple venues.... which brings us back to this thread.

What I am hoping to see is if this patch allows the same by creating the necessary indexes so that I can simplify the process of updating stock after a sale.

The bookseller theme seems to have changed to where most sales are generated through the services of Amazon/Alibris/etc., as this is where the average person is going to find a "deal". Simple search engine positions no longer seem to be the rage unless you have a hard to find edition such as what I mentioned. I asked almost everyone that I knew who I knew bought books online where they shopped at. Amazon was the winner, eBay/half.com was 2nd, and the ones who were looking for the older stuff used Alibris or Bookfinder.

Still, updating a zen-cart database at the end of every days sales could turn out to be a pain, if a bookseller has both an online presence as well as a walk-in shop. And I've seen too many other booksellers try to make it just with a website and they're gone within a year. I don't like the idea of paying the fees involved on the other search sites, but the public seems to be going in that direction for buying. EBay sales are another issue, and a complex one at that. Selling books on eBay auctions seems to mean that you will sell them cheap or use them as a tool to advertise your business website.

I've talked to other dealers and asked about what they use for inventory databases. Some independent ones use Chris Land's services and are happy. Others use homebase, FileMakerPro or Booktrakker, etc. All of these (I believe) create a file that can be exported, usually in the comma delimited or UIEE format.

If Moku's mod can be set up to accept batch files that were created on outside inventory programs then it would be a dream come true. Unfortunately, I have not been able to get this to happen as of yet. :no:

But as since I am a zen noob I mainly blame this on my own ignorance... or perhaps my bad habit of too many beers while trying to mod php files.

:cheers:

31 Aug 2007, 12:42 PM
#282
gsis avatar

gsis

Zen Follower

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

Re: Product Type Book (by moku)

skydealer:

If Moku's mod can be set up to accept batch files that were created on outside inventory programs then it would be a dream come true. Unfortunately, I have not been able to get this to happen as of yet. :no:

I'm looking at making things work the other way round.

An extended Zen Cart + Moku will be the central repository for my operational data.

I'm still on the basics as a PHP/mySQL noobie - but I am getting a bit faster now!

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!

5 Sep 2007, 6:25 AM
#283
skydealer avatar

skydealer

New Zenner

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

Re: Product Type Book (by moku)

Would drop-down selections be easier for folks to enter book information rather than having to type the whole name? I don't know if it's possible in this configuration but some inventory programs have a nice feature whereas when someone enters in the first few letters it automatically goes to the most likely name.

This saves a lot of redundant typing, especially with common publishers such as Random House, Scribner's & Sons, etc. It also saves in typing errors.

I can provide lists of approx. 6000 publishers, plus items like the standard book sizes, book types, condition ratings, etc. if this is possible. I can provide them in either txt, html or csv format... whatever you want.


Also - which is a better mod for a fully functional product type:

The original Moku versions located at http://moku.ghosthack.net/data/dev/zencart/ (which one should be downloaded?? There's so many to choose from) or Hareslades version at http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482

Are these both the same?

And would either of these give me a selection in the Product Types area of the admin?

I'm just looking at a nice admin product page were I can have fields for:

  • title (plus possibly an additional subtitle field)
  • author
  • illustrator
  • description
  • publisher name (and possibly location)
  • Edition
  • Printing
  • Number of pages
  • book type (hardback, softcover etc.)
  • book size (8vo 12mo 4to etc.)
  • ISBN
  • price (gross and net)
  • quantity
  • Signed by (author, illustrator, etc.)
  • key words
  • Image (upload or location)
  • and maybe category (fiction, nonfiction, mystery, scifi, etc.)
  • plus a few undefined fields for customizationI've been fiddling with several mods and have been dumping and reloading Zen cart about 20 times now (I'm getting pretty good at it.... I can install a fresh Zen in about 3 minutes!) while I try different things. I'm learning a lot but if someone has already created something of this nature I'd be more than happy to send them a donation rather than me attempting a patch to create one of these myself.

I'd be a fun challenge but time consuming.... and with 2 full time jobs time is a commodity that I don't have too much of!

Are these features that other booksellers are looking for as well?

I've been combing the forum for weeks now as I'm new to the whole ecommerece/database/template thing... so there's quite a learning cuve on my part.

9 Sep 2007, 6:13 AM
#284
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

My comments are interspersed:

skydealer:

Would drop-down selections be easier for folks to enter book information rather than having to type the whole name?

I believe that what you're looking for is what Microsoft call a 'ComboBox' in .Net and yes it would be a time saver.

I can provide lists of approx. 6000 publishers, plus items like the standard book sizes, book types, condition ratings, etc. if this is possible. I can provide them in either txt, html or csv format... whatever you want.This is something that I might be interested in as I've also been developing lists of these items.

Also - which is a better mod for a fully functional product type:

The original Moku versions located at http://moku.ghosthack.net/data/dev/zencart/ (which one should be downloaded?? There's so many to choose from) or Hareslades version at http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482

Are these both the same? No they aren't the same. The Hareslade product is superior, but stick with version 2 unless you need the multi-anguage support of version 3.
And would either of these give me a selection in the Product Types area of the admin?Yes for a short answer. I've already tried the book product as a restriction to categories and it works just fine.

I'm just looking at a nice admin product page were I can have fields for:- >

  • title (plus possibly an additional subtitle field)
  • author
  • illustrator
  • description
  • publisher name (and possibly location)
  • Edition
  • Printing
  • Number of pages
  • book type (hardback, softcover etc.)
  • book size (8vo 12mo 4to etc.)
  • ISBN
  • price (gross and net)
  • quantity
  • Signed by (author, illustrator, etc.)
  • key words
  • Image (upload or location)
  • and maybe category (fiction, nonfiction, mystery, scifi, etc.)
  • plus a few undefined fields for customizationI can think of a couple of others that I've been trying to add with only moderate success so far.- multi-volume boolean flag
  • books Volume number
  • Total volumes
  • Illustrator - as you mentioned
  • For those books without ISBN the LCCN or Dewey call number as options with appropriate flags in the US. Other countries, I don't know about.
  • A real SKU field as a five digit field is unacceptable.

The multi-volume idea is important as I have several sets with individual ISBN's for each volume and a collective ISBN for the entire set.> I've been fiddling with several mods and have been dumping and reloading Zen cart about 20 times now (I'm getting pretty good at it.... I can install a fresh Zen in about 3 minutes!) while I try different things. I'm learning a lot but if someone has already created something of this nature I'd be more than happy to send them a donation rather than me attempting a patch to create one of these myself.

I'd be a fun challenge but time consuming.... and with 2 full time jobs time is a commodity that I don't have too much of!I know the feeling well.:smile: By the time I'm done, I'll be an expert at Zen Cart. I'm also developing both Music and Movie products based on this version of the book product. Many of the criteria for all three are the same, so I expect to be consolidating a lot of the database tables and resultant code in the future. I'm also looking at writing a bulk uploader as hand entering over 3000 books, nearly 2000 movies and over a 1000 music items is more than I can bear to think about right now.:laugh:

> Are these features that other booksellers are looking for as well?Yes for my answer. I've been fiddling with this for about two months off and on.

I've been combing the forum for weeks now as I'm new to the whole ecommerece/database/template thing... so there's quite a learning cuve on my part.I'm afraid that there is not much beyond this thread on the forum for book products.:frusty:

Take care,

-phil

9 Sep 2007, 7:47 AM
#285
skydealer avatar

skydealer

New Zenner

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

Re: Product Type Book (by moku)

Phil, I am in the same boat. By the time we get this figured out we'll both be able to quote any line of code from memory from any Zen php file.
:D

I saw a few features while exploring a couple of other ecommerce and bookseller features. I liked the quick listing features offered in theartofbooks.com's online services (drop down selections, key phrases etc.) I also saw a nice feature in an ecommerce platform called litecommerce.com. If you fiddle with their admin area you'll see where the database fields can be easily assigned from any csv file. I think that this can be utilized for both csv as well as UIEE.

IF a bookseller is utilizing several platforms for selling... i.e Amazon, Half.com, whatever, plus the option of their own website (which is also my goal) then the task at hand is to be able to minimize the steps needed to maintain all of the listings when a book is sold.

A central inventory database that can up-link to all of these (with the exception of Zen) already exists. Several actually. Booktrakker, Prager, Bookwriter, etc. The missing link is a simple merge of the inventory databases into the Zen product fields. Litecommerce shows it can be done and the code just needs to be massaged a bit to merge with Zen.

THE 2nd IF:
Now - if a plug-in can be made that can provide all of the basic needs of inventory management as well as quick selection of fields (such as we mentioned earlier) then Zen's core could actually be used for inventory management. That part is beyond me at this point though as I don't know how the other matrix layouts work. Plus the book inventory programs all use the ISBN look-up systems, that automatically fill in the fields, which is a nice feature. Only about 20-25% of my books fall into the ISBN age-group though.

Chris Lands is already doing something along this line, but he charges a monthly fee for his services and his database merging is limited.

I see a great gameplan here. It's complex but I see what needs to be done. I already have all the common phrases in place as well as extensive lists showing publishers, book info, bla bla bla. That part is all done. Dropdown menus would be a nightmare with 6000 selections, plus the option would be needed to be able to update the list if a new publisher would need to be added in (which would be often for a used book dealer). I'm not sure this could be easily done if the data was stored in a SQL format. At least, not without possible consequences.

9 Sep 2007, 6:39 PM
#286
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 Skydealer and all

My father passed away in August, so I have been a bit pre-occupied
... and this 'auto-advise' of new posts by email has decided not to work, yet again!...

Some of you guys seem to be in the know slightly regarding book handling methods...

The book add on here is fairly simplistic, but does have plenty of fields. And a gap exists between our (amateur) book type and the complex ones used for pro users, the main area of 'weakness' is perhaps in the ability to upload extra books quickly etc.

The problem is that zencart only creates a new (book) record manually, that is, in a 'collect info' page online.. so uploading/adding data for multiple new books 'remotely' is not an easy thing to achieve, unless the database itself is directly updated without going through zencart.

And contribs that do this 'remote upload' elsewhere for zencart won't work on book type, because there are extra tables and so on.

As of the end of October (- providing I do actually get broadband again after I move house!) I'll maybe have some time to address realising any useful ideas.

if anyone wants to private message me regarding discussion of possible features feel free to do so, ........click on the (hareslade) name in corner, it'll give option to 'p.m' me.

Otherwise if its a straightforward issue, do it in this thread.. the version 3 book type is still officially in beta, although it seems that it mostly works ok.

10 Sep 2007, 4:20 AM
#287
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hareslade,

I agree that the book product upload problem is complex, to say the least, but I think it could be done directly into the database. A complex and multifaceted approach is required, but with the use of stored procedures in MySQL it shouldn't be unsolvable. I've done some similiar work in large networked databases (27 servers running 49 interconnected databases) and got it to work after months of documentation and development.

The keyword here is documentation and that's what I've been trying to do. As you said there are many tables both for Books and for Zen Cart that need to be queried before the new data can even be inserted.

The extra field that you provided are a great place to start, but I don't think there are enough for a professional bookseller site. This package is why I chose Zen Cart over Virtuemart anyway.

10 Sep 2007, 4:35 AM
#288
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

skydealer,

I looked at the sites you suggested and yes they have some of the features required. For the uploader, I'm thinking of something along the lines of the AOB site, but with some complex behinds the scene software that's required to deal with the complexity of the Book Product and Zen Cart tables.

Think of it this way. You upload a CVS file and in the file is a field called publisher. After getting the data, you have to check the value against the manufacturers table and see if it is already present. If it is then you return the manufacturers id otherwise you insert the new data and get the new id. Only then can you proceed to the next step.

Actually, now that I think about it that isn't the first field that would have to be processed. I think the first field would be to check the product type. You can see how complex this all becomes. Product Type table, Manufacturers table, Categories--with subcategory searching--table, all before you get to the actual book data. Not to mention possible searches of the Product and Book tables to see if the data already exists. In that case, with an exact match, you'd simply want to increment the inventory count.

There is much work ahead just for this not so little project.

10 Sep 2007, 7:10 AM
#289
meeven avatar

meeven

New Zenner

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

Re: Product Type Book (by moku)

My father passed away in August, so I have been a bit pre-occupied
... and this 'auto-advise' of new posts by email has decided not to work, yet again!...

Hareslade, sorry to hear that.

And, yes, the auto-notification feature doesn't seem to work. I never received these latest updates.

By the way, thanks to you for taking up Moku's work and extending it. It's such a badly needed module for ZenCart.

11 Sep 2007, 5:01 AM
#290
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

Just some thoughts on the uploader for suggestions and comments by those interested.

Booksellers store their inventory in so many formats that the only feasible method for providing a bulk upload to the Books -- or movies or music -- product type is a CVS file. A CVS file output is common to almost any of the packages used be it Excel, Homebase, Access or other database program.

I'm thinking that the user goes to a php page, selects a CVS file for upload and then is presented with the field headers of the CVS file. The user selects a table and field from the Zen Cart database to associate with that header. An option to save the format for later use should be included. The advantage here is that the user can generate the file without having to massage the data.

I'm not sure about how to specify the difference between rows in the CVS file that would indicate a DELETE product, CREATE a new product or UPDATE a product. My first inclination is a field with those keywords, but that means the user would have to massage the data.

Comments or suggestions anyone? I'm sure that I haven't thought of everything.

11 Sep 2007, 5:11 AM
#291
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

Hi Skydealer and all

... and this 'auto-advise' of new posts by email has decided not to work, yet again!...

You're so right. I'm surprised when I get emails informing me that the thread has been updated 24 hours after the event.:ohmy: Is that normal?

11 Sep 2007, 6:31 AM
#292
skydealer avatar

skydealer

New Zenner

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

Re: Product Type Book (by moku)

quailbooks:

You're so right. I'm surprised when I get emails informing me that the thread has been updated 24 hours after the event.:ohmy: Is that normal?

It shouldn't be. This forum uses an up-to-date version of VBulletin which is an expensive and pretty good forum software. I run this on my flight simulator tech forum (real flight sims... not the game. It's my "bill paying" job, the bookstore is a passion/2nd job).

If this has been a chronic problem with this site the admin may have to adjust the VB email options in the admin area. The command "
Number of Emails to Send Per Batch" probably just needs to be increased.

I wanted to echo meeven's comments as well. Sorry to hear about your dad and I hadn't realized that you were the one who had taken over things from Moku. I hope we didn't step on any toes here... I was just wanting to input some wish-list things.

12 Sep 2007, 10:32 AM
#293
johnniew avatar

johnniew

New Zenner

Join Date:
Sep 2007
Posts:
1
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi. My first time here. I'm trying to install this mod but I'm stuck when it comes to the MySQL database. I have phpmyadmin but apart from creating back-up files, I'm a total novice. Is there a step-by-step walk-through on how to add the MySQL requests using phpmyadmin?
I'd be grateful. Sorry if this has been answered elsewhere - I did look! Thanks

12 Sep 2007, 12:53 PM
#294
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
A general comment...

regarding taking over from Moku, its a shame he pulled out because he is a great designer... I 'took over' only by default, this is an open thread and anybody is welcome to do work on the contrib. No toes to crush :)

The ideas about bulk book upload would really make a better contribution, but whatever method is used there needs to be a lot of internal product checks at the server end to avoid upsetting the zencart database.

As I probably said already, I tried the popular contrib that does this for standard products, I found it was very secretive, gave no feedback about any errors. Certainly the excel-style Comma Separated Values (CSV) are an obvious starting point, but whatever is at the 'web' end needs to be far more intelligent than the contribs I've used. If corrupted or only part-updated, the zencart database will just show crazy entries on a live website!

[if various people do consistently work on the book contrib, 'we' could set up better ways of progressing. The V3 contrib is on my Hareslade site in beta, merely because it takes ages to identify bugs, and once on the Zencart download site its not so easy to update (in my view!) . Its not because I'm a control freak!]

The 'version 3 beta' is the current offering, see the top area at
http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482
it tries to meet requirements for multilanguage sites for book products, and that is the one to consider as the most advanced, for 1.3.7 carts. It also works in single language.

The Moku version halted at Zencart version 1.3.5 I think, and its inevitable that eventually it will not work correctly on current zencart versions. My 'single language' version 2 at the above page also works for 1.3.7, but personally I won't update that for future zencart versions.


Regarding the 'new' users of the contrib without prior experience, 'we' don't normally touch the existing database directly by using phpmyadmin. [In fact, the sql patches in a contribution normally have no ' table prefix' so phpmyadmin cannot use them unless you manually add the prefix that you selected, for each table mentioned in sql.]

All contribs should supply an 'sql file' textual file which is to be applied in zencart admin, under tools 'sql patch'

Because sql instructions (which can add or delete database tables or fields etc.) sometimes fail, -(even just because you might be running the latest mysql version, and the contrib. was made before that version) - its best to always install the 'database backup/restore' contribution, which I think is still available.

With that backup contrib. you can save the existing zencart database before applying an 'sql patch'. And believe me, sometimes the sql patch will only half complete, so you just must have the original database to restore, or you end up having to install the cart again, to get a useable clean database.

However, for those who know how to use phpmyadmin, its easier because you can go in and correct/change the database as required, if you know what to do.


So for new users........in the book contrib on my hareslade site, you'll find inside a folder called 1_BOOK_MAIN_FILES, a folder 'catalogue' contains the files to upload into zencart, plus a folder RUN_THIS_FULL_INSTALL_SQL_PATCH_FOR_DATABASE
containing file ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V3.txt
which is the sql patch. Apply the sql patch in zencart admin using the admin menu page 'sql patch'. But backup the database first!

There are other folders in the pack, these (begining 2_ to 7_ ) are other bits you could use subsequently - after using folder 1_BOOK_MAIN_FILES

My apologies if the readme files in the pack are not always easily understandable, its difficult to put suitable texts when I know the actual contrib inside out, where others do not!

14 Sep 2007, 3:54 PM
#295
quailbooks avatar

quailbooks

New Zenner

Join Date:
Dec 2006
Location:
Nevada
Posts:
6
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi,

Sorry that I didn't respond yesterday, but I teach a class at the college and had to get ready for that Wednesday and Thursday.

My comments are interspersed:

hareslade:

Hi
The ideas about bulk book upload would really make a better contribution, but whatever method is used there needs to be a lot of internal product checks at the server end to avoid upsetting the zencart database.

As I probably said already, I tried the popular contrib that does this for standard products, I found it was very secretive, gave no feedback about any errors. Certainly the excel-style Comma Separated Values (CSV) are an obvious starting point, but whatever is at the 'web' end needs to be far more intelligent than the contribs I've used. If corrupted or only part-updated, the zencart database will just show crazy entries on a live website!

I agree as I've tried to use it also with very little success and didn't feel like paying to try the commercial version.

BTW, I looked at the MySQL documentation and found out why it is that stored procedures are not used in Zen Cart. Simple answer is that MySQL didn't support them fully until V5.0.1. Until the Zen Cart development team makes the decision to restrict development to MySQL 5.0 and above then I'll have to use the Zen standard for the upload module.

You had an excellent suggestion in the PM about storing the CVS data and processing with an error report. That's the way most uploads seem to work. Delimiters aren't really a problem as a selection of checkboxes for delimiter type (tab, comma, semicolon, etc.) seems to be the standard.

If you want to work on the book product while I do the upload module it would work for me.:smile:

hareslade:

if various people do consistently work on the book contrib, 'we' could set up better ways of progressing. The V3 contrib is on my Hareslade site in beta, merely because it takes ages to identify bugs, and once on the Zencart download site its not so easy to update (in my view!) . Its not because I'm a control freak!

Not a bad idea! Some sort of cooperative area on the web? A restricted forum for developers with a file exchange area probably is best. That's something to think about.

hareslade:

The 'version 3 beta' is the current offering, see the top area at
http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482
it tries to meet requirements for multilanguage sites for book products, and that is the one to consider as the most advanced, for 1.3.7 carts. It also works in single language.

Yes, I've downloaded it and I'll make a fresh install this weekend. I'll be interested in what the changes have been.

On that subject, perhaps you'd like to keep an idea or wish list of items --maybe you already do-- of identified features that users would like. I'd suggest putting them in as named items instead of the generic terms you've used in the past. It would make the product more standardized and since users can turn features on/off through product layout they can customize there.

I'll start with some ideas:

  1. Multi-volume sets needs a bool flag and volume # of volumes #
  2. Model number identifier from dropdown (ie: ISBN10, ISBN13, LCCN, whatever) as most older books don't use ISBN and ISBN has changed from a 10 digit to 13 digit number this year.
  3. Book Club Edition boolean flag and maybe a text identifier of what club --I'm not sure about the last.
  4. Some method of setting the default value of a dropdown selection. IE: for the model number identifier above. I'm not sure how this would work, but will think about it. > hareslade:

Because sql instructions (which can add or delete database tables or fields etc.) sometimes fail, -(even just because you might be running the latest mysql version, and the contrib. was made before that version) - its best to always install the 'database backup/restore' contribution, which I think is still available.

With that backup contrib. you can save the existing zencart database before applying an 'sql patch'. And believe me, sometimes the sql patch will only half complete, so you just must have the original database to restore, or you end up having to install the cart again, to get a useable clean database.

However, for those who know how to use phpmyadmin, its easier because you can go in and correct/change the database as required, if you know what to do.

I've already run into the problem of the SQL not reading the file completely, reporting errors that don't exist, etc. from the tool. So I fully support the idea of running backups --often!

hareslade:

My apologies if the readme files in the pack are not always easily understandable, its difficult to put suitable texts when I know the actual contrib inside out, where others do not!

Not a problem at all. You should see some of the code that I've had to deal with in the past and what they considered documentation.:laugh: Yours look absolutely wonderful in comparison.

In Summary:

I'm going to concentrate on the uploader and leave the book product development to Paul. In parallel, I'm also using the book product as a starting point for a movie product type (type 9 for now) that supports the various movie formats. The two are so similar that the project is trivial.

14 Sep 2007, 9:17 PM
#296
fcegarra avatar

fcegarra

New Zenner

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

Re: Product Type Book (by moku)

Hello,

I want to find how I can create a link to display the produtcs selected by manufacturers, colors and other attributes for exemple. I have knowledge in MySQL and PHP but I can't figure out how to do it.

I don't know which file(s) I need to edit to do it. I would like a link called for exemple "the red ones" on my header where users click on it and see all the red products displayed in the main page..

i hope I could understand everything and help me!
Is it possible to do it with product type book??

Thanks a lot

F.

14 Sep 2007, 10:56 PM
#297
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)

fcegarra
(nearly) anything can be done if one spends enough time on it!

The book type can already search for authors, genre etc, which is essentially similar.. those files that create the 3 or 4 sidebox dropdowns lists for searches, could perhaps be copied and altered for searching different fields


quailbooks
by all means get into uploaders, I'm sure we'll be pleased to test it for you..

I'm unsure which things to suggest regarding easing development interactions,
I can host a forum on hareslade.com, or perhaps someone else wants to...

(If I do it, it'll have to be a PhpBB forum... )

Wiki on zencart I think is more for the contribs in the downloads list?

Somewhere I also have free software that handles projects, but that would necessarily be limited to the ''main developers'', as it needs more careful use.
Files can be uploaded/downloaded with it..

Any other suggestions from those who've already done this sort of loose knit developers thing in a small way?

19 Sep 2007, 12:39 AM
#298
fcegarra avatar

fcegarra

New Zenner

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

Re: Product Type Book (by moku)

Thanks Hareslade for your help!!

I am still stuck and I don't know how do to it! It seems easy when you think about it, it is to show every single "red" products for exemple in the same list or every single products with the same price..
Do you know which file I could altered to do what I want?

thanks a lot for your help

19 Sep 2007, 6:23 PM
#299
berrybatens avatar

berrybatens

New Zenner

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

Re: Product Type Book (by moku)

Hello,
I am using the misc_8, misc_9 and misc_10 fields from product type book to display ISBN10, ISBN13 and NUR. How can I add these fields to the search engine (SQL code?)?

Thanx for helping out

Berry...

20 Sep 2007, 10:20 PM
#300
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)

fcegarra
'fraid you might have to learn some php/sql programming skills, but as I said working with the filters is (to me) quite complex.

berrybatens
same sort of answer really... the 'extra' data fields are in separate tables, you would have to look at the search sql's in the sql product filters, and get brain ache like I do..

See below, ** for some further comments on the above

Actually why I'm posting is to say, I found this guy Nicholas who I've just emailed, because he's updated Easy Populate so it perhaps works properly for ordinary product uploads. However, he does charge for the module.

Anyone wanting to upload book products might do well to sign on with his forum thread (as ctcentralinfo did) about book at
http://www.zencartbuilder.com/forums/viewtopic.php?t=137&highlight=book and show some interest.

I reckon one way or another 'we' might find it easier to go for Easy Populate regarding bulk book product upload manipulation? It sounds like Nicholas's module has ironed out a lot of the old strife with older versions.


** As i remember it, the basic search function normally shows all valid products, but an extra filter, usually in '/includes/index_filters' adds a small bit of sql to cut down what's shown, often depending on product type..

Unfortunately the 'small' bit of sql gets quite big sometimes, with many options, and its difficult to see at first how it all works anyway because its all done in pieces..!

Sometimes its easier to see what happens in a 'sidebox' search code, rather than in the 'main' searches code.

You might do better looking at the book files for sidebox searches e.g style or subject. Maybe you could see how to create an equivalent different sidebox, for a different search field. I'm guessing..