WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: svsanchez on August 17, 2017, 08:03:01 PM

Title: Exporting products from Bakery to Woocommerce
Post by: svsanchez on August 17, 2017, 08:03:01 PM
Hello everyone,

One of my customers has decided to move from Bakery to Woocommerce. He has hundreds of products on his Bakery shop, so I need to know if there's a way to export the products?

Thank you!!!
Title: Re: Exporting products from Bakery to Woocommerce
Post by: Gast on August 17, 2017, 10:55:25 PM
a hard job with a lot of risk  :roll: :roll: :roll:

if you search for a click-button-solution, its not possible.
if you're a php-developer, its possible to write a migration tool. you need the structure from the woocommerce-database tables and a lot of experients, how bakery works and where you found the informations about a item somewhere in the database

so the answer is: its of course possible, to export the bakery items and migrate this into a woocommerce-shop, but only with a script, that select all datas and write this in a usable form.
its not possible, if you search for a fast&ready-solution

here a german post (https://forum.WebsiteBaker.org/index.php?topic=25573.0) to export customer datas (item name, quantity, options, customer adress etc). a german customer ask for this in 2013 for a older bakery version. the customer send the result of this script, a csv-file with all customer datas to the shipping company and this company use this datas, to prepare the packages and print all adresses

this script is not up to date and not usable for your plan, but it show's a way for you
- select all items
- join the tables to get more informations about a item
- write all datas into the needed structure for woocommerce, maybe in multiple tables
- import this csv-file in phpmyadmin

thats the way, same like a (commercial) migrations tool. the most database selects are avaiable in the bakery-view_overview.php and view_item.php, so not needed to develop new selects, but you must handle the results and (maybe) also splitting the results for different tables. bakery use 10 database tables. i dont know, how woocommerce works
Title: Re: Exporting products from Bakery to Woocommerce
Post by: svsanchez on August 18, 2017, 10:24:32 PM
Thanks a lot for your answer Jacobi, I will have a programmer look at this next week :)