Import products table

[svsanchez]

Hello,

I would like to know if there's a way to IMPORT a product table made in excel. I have to build a site with almost 6000 products which they have on an excel table where they have the product name, categories, images, sku, etc... the customer had his Joomla site hacked and called me asking if we could rebuild his site with WB, but he isn't going to upload all his products again via the browser interface and I told him it could probably be done by importing the DB via phpMyAdmin or something like that!

[freeSbee]

Hi svsanchez

As you already mentioned you can use phpMyAdmin to import text into the DB. But remember there will still be plenty of work re-adding the product images since they are not stored in the DB.

Regards Christoph

[jacobi22]

the database import is not the problem, if you know something about excel, PHP and mysql.
i think, the problem ist: you need image and thumb folders and pages with the entrys in the database
maybe its easyer, if you work step by step in the bakery admin backend

[svsanchez]

So, what you mean is that I wouldn't be able to import the DB with a field containing the product's image name (for example product1.jpg, product2.jpg, etc)?

[jacobi22]

So, what you mean is that I wouldn't be able to import the DB with a field containing the product's image name (for example product1.jpg, product2.jpg, etc)?

the system for bakery && wb is a little complex. its not enough, to have only a database table for all products (in bakery called mod_bakery_items)
this table needs information about page_id, sections_id and item_id
with the page-id you have to build a file in the folder "pages", a entry in the db-table pages with all informations about this page, the page-tree btw.
with the sections_id you have to build a entry in the database table sections
and with the item-id you have to build the folders for every image and every thumb

maybe, it works if you have a empty wb-project without any other pages or old section, so that you can start with page_id 1

i build the same with 140 items (i know, not 6000), i startet in wb with the product tree, for every category one bakery shop. and the i build only empty item pages in bakery, only the item name - so that i have the entrys in the pages-table, in sections and in bakery_items, so that i can start with a php-writed adapter to change the sql-file step by step
read the infos from 3 db tables for item-id 1, put them together in a new INSERT, and this item by item, category by category

we called in german "sissiphus-job" - a never ending story   

[svsanchez]

Thanks Jacobi, Bakery is a great little product but still needs to evolve as this would be a very time consuming effort. I hope the people behing it will continue adding useful features like this

[svsanchez]

Just wondering... WB is such a great CMS that I have new customers calling me and they want their product catalogs, but unfortunately I am being contacted by people with bigger companies and bigger catalogs, who already have their catalogs in excel.

So I was hoping that in the 3 months that elapsed from this post's opening someone would have been able to create a product import module that can handle the product images as well.

The previous customer didn't want to manually upload his catalog so it was a lost customer, and this new one has more than 2000 products