Creating an add-on "product type book" for ZC 1.5

[mesnitu]

hi
Can you please say something positive ?

I think I see what you mean. I've finish a site made in Drupal for a book distributor (no shop). But with feed importer, and all the extras fields and mappings, it's quite easy to import the products, But , there's always that problem, specialty in Portuguese, where there is a lot of accents. So the author "João" is different from "Joao", or "joao" or " joao" (a empty space).
Something for Genres or Publishers.

I don't know how the core of csv imports works, but I guess, if no ID or matching string is found, new ones are created.
If one imports 100 books, and has to rectify 20, it's always easier (not to mentioned competitive ) .
Or simply restore a backup, and redo to match the corresponding author, genres, etc ,names and upload again.

But yeah, this is probably very complex for my knowledge, but looking at EP, it looks "simple". But I guess I'm wrong.

Best regards

[philou]

do you import 100 books with 100 authors, or maye 100 books with 20 authors?

If you want to hear seomthing positive, then I think you will find that importing books as "normal" products, conevrting them to bookx and then mass assign genre, authors, series you will find it takes less time and is less headache than trying to work out duplicates and missing matches :)

best,
p.

[mesnitu]

But how do you mass assign that ? Exporting tables and working with excel ? Or do you have another technique?

Best Regards

[philou]

Let me quote from the README file :)

NEW IN 0.9.4: Assign & remove Author / Publisher / Series / Genre / Imprint to multiple books at once

Linking a book to authors / series / imprint / publisher / genres
You can link a product you are editing to any author / series / imprint / publisher / genre via their respective popups, but there may be situations where you would like to quickly assign e.g. a new genre to multiple books at once. This can be done by selecting the author / series / imprint / publisher / genre via ADMIN -> Extras -> BookX: Genres -> Genre. At the bottom of the edit screen there are two "multi-select" fields, where you can choose multiple books and assign the current genre. Inversely, you can use the bottom field to remove the assignment of the genre from multiple books at once.

[mesnitu]

Yes, when everything else fails read the instructions :)

I've seen that, but honestly I haven't use it that much. I'll try to see if it suits the needs of this site.

Thanks

Best Regards

[mesnitu]

Hi again
Just an aside : I was rechecking what I've done about 4 or 5 months ago, cause as I said, I've been in drupal, and now it's a little puzzling to remember zencart way again, but I quite made the export part, and I didn't remember.
Works as the Music products does, so if bookx is active (by the user), products type 6 are exported and adds the bookx fields. For now i have

v_bookx_genre | v_bookx_isbn | v_bookx_size v_bookx_volume v_bookx_pages v_bookx_publishing_date v_bookx_publisher v_bookx_series v_bookx_binding v_bookx_printing v_bookx_condition v_bookx_author

successfully exported (as you said, the easy part)
Now, EP, uses the model as unique. In my case I use isbn as model too, but I guess it makes no difference
I've check the categories and it's more or less like genres. A categories_description and categories tables. If EP handles this quite well, it must handle the genres too.
So I give it a go.
And meanwhile, work with that featured that you mentioned.

Thanks
Best Regards

[fjbern1943]

Using zencart version 1.54 and latest version of this plugin. Installed per instructions, checked 3 times. When I goto: mysite/myadmin/index.php?action=bookx_install I get a file not found error. I do not have a bookx_install file. Is this the problem????? Seems all information is in the admin.. Get same results if I try to run the install from the BookX Installation and Tools menu in the admin/tools?????? Also noticed I do not have a tpl_modules_whats_new.php file?

Please help!

[fjbern1943]

Using zencart version 1.54 and latest version of this plugin. Installed per instructions, checked 3 times. When I goto: mysite/myadmin/index.php?action=bookx_install I get a file not found error. I do not have a bookx_install file. Is this the problem????? Seems all information is in the admin.. Get same results if I try to run the install from the BookX Installation and Tools menu in the admin/tools?????? Also noticed I do not have a tpl_modules_whats_new.php file?

Please help!

Here is the error log:

[08-Aug-2015 13:08:20 America/Chicago] PHP Fatal error: 1146:Table 'christi_storefront.product_bookx_extra' doesn't exist :: select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_description, CONCAT_WS(""
,pd.products_name
,IF(NULLIF(be.volume, "") IS NOT NULL, CONCAT_WS("", " <span class='bookxProdVolume'>", REPLACE("vol. %s", "%s", be.volume), "</span>"), "")
,IF(NULLIF(bed.products_subtitle, "") IS NOT NULL, CONCAT_WS("", " &ndash; <span class='bookxProdSubtitle'>", bed.products_subtitle, "</span>"), "")
) AS products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id ,pd.products_description from products p, products_description pd
LEFT JOIN product_bookx_extra be ON be.products_id = pd.products_id AND (be.publishing_date IS NOT NULL) AND (DATEDIFF("2015-08-08",
CONCAT_WS("-",
SUBSTRING(be.publishing_date, 1,4 ),
IF(SUBSTRING(be.publishing_date, 6,2 ) = "00", "01", SUBSTRING(be.publishing_date, 6,2 ) ),
IF(SUBSTRING(be.publishing_date, 9,2 ) = "00", "01", SUBSTRING(be.publishing_date, 9,2 ))))
< 0) LEFT JOIN product_bookx_extra_description bed ON bed.products_id = pd.products_id AND bed.languages_id = "1" where p.products_id = pd.products_id
and pd.language_id = '1'
and p.products_status = 1
and p.products_id in (498, 502, 1304, 1305, 3764) AND (be.publishing_date IS NOT NULL) AND p.products_quantity > 0 ORDER BY be.publishing_date DESC, p.products_date_available DESC ==> (as called by) /hsphere/local/home/christianstore/christianstore.biz/includes/modules/responsive_sheffield_blue/new_products.php on line 54 <== in /hsphere/local/home/christianstore/christianstore.biz/includes/classes/db/mysql/query_factory.php on line 155

[lruskauff]

When you run the install from the admin or from the URL, what is the exact error? Does it tell you which file is not found? The install is not a file itself, it is built into the admin.

[fjbern1943]

When you run the install from the admin or from the URL, what is the exact error? Does it tell you which file is not found? The install is not a file itself, it is built into the admin.

Here is the error message:
HTTP 500 error

That's odd... Microsoft Edge can’t find this page

This page can’t be displayed, because this site’s server might be under maintenance or there could be a programming error.

Using chrome I get this error:
WARNING: An Error occurred, please refresh the page and try again. Did you see the error Log info I posted?