How is going?

[hailong]

I'm keeping watching out the release 1.0.0, how it going? :smile:

[lesley]

It was just released, https://thirtybees.com/download/ Also here is our blog post on it as well, https://thirtybees.com/uncategorized/thirty-bees-1-0-0-released/

[hailong]

Congratulations! I'm going to install it and try out. I'm also considering migration from PS 1.6 to TB, would that be difficult?

[lesley]

It would not be too difficult, but we have not released a migration tool yet.

[hailong]

Since our new store is at the early beginning stage, just projects and categories, no order yet. I guess just exporting/importing would work. I'm cloning the code now, will have a try later.

[lesley]

It would. Let us know if you have any issues, we are great at fixing bugs quickly

[hailong]

Hi @lesley, how do you think if I copy over those DB tables directly, which named as pscategory* and psproduct*

[lesley]

That should work fine.

[gwasch]

@lesley: Is there a difference in db tables from PS1.6 & TB?

[wakabayashi]

Would you recommend just to wait for this migration module? Will this come soon? Cause I am setting up ThirtyBees now. But I want only to test with our real data...

[alwayspaws]

Good advice. My store is new since I restarted it from Magento to PS and now to ThirtyBees and I only have 115 products online.

[alwayspaws]

@mdekker said in How is going?:

You can use it for new stores, but the migration has not been documented, so if you want to migrate it is better to wait until we have written about every detail of the process. Migrating will otherwise be tricky.

Good advice. My store is new since I started from Magento, moved to PS and now coming over to ThirtyBees. I only have 115 products online.

[alwayspaws]

@Global-Moderators @mdekker Can you please merge this topic (How is going?) into this one: Eager to migrate from Prestashop 1.6 located at: https://forum.thirtybees.com/topic/35/eager-to-migrate-from-prestashop-1-6

[hailong]

Here is a quick update of my migration. I have successfully migrated the product and category data with following SQLs. The only difference between the two databases is the new field introduced by TB1.0.0, which is 'displayfromsub', so excluded it when copying over the category table.

BTW, since we have not built up the product attribute data yet, just skipped the attributes related tables in my practice.

```

Table: category

Node: field 'displayfromsub' is not in the source table

insert into thirtybees.tbcategory (idcategory,idparent,idshopdefault,leveldepth,nleft,nright,active,dateadd,dateupd,position,isrootcategory) select idcategory,idparent,idshopdefault,leveldepth,nleft,nright,active,dateadd,dateupd,position,isrootcategory from prestashop.pscategory where id_category > 11;

Table: category_group

insert thirtybees.tbcategorygroup select * from prestashop.pscategorygroup where id_category > 11;

Table: category_lang

insert thirtybees.tbcategorylang select * from prestashop.pscategorylang where id_category > 11;

Table: category_shop

insert thirtybees.tbcategoryshop select * from prestashop.pscategoryshop where id_category > 11;

Set 'Maximum depth' setting of blockcategories module

Table: product

insert thirtybees.tbproduct select * from prestashop.psproduct where id_product > 7;

Table: product_lang

insert thirtybees.tbproductlang select * from prestashop.psproductlang where id_product > 7;

Table: product_shop

insert thirtybees.tbproductshop select * from prestashop.psproductshop where id_product > 7;

Table: category_product

insert thirtybees.tbcategoryproduct select * from prestashop.pscategoryproduct where id_category > 11;

Table: image

insert thirtybees.tbimage select * from prestashop.psimage where id_product > 7;

Table: image_lang

insert thirtybees.tbimagelang select * from prestashop.psimagelang where id_image > 23;

Table: image_shop

insert thirtybees.tbimageshop select * from prestashop.psimageshop where id_product > 7;

insert thirtybees.tbemployee select * from prestashop.psemployee where idemployee > 1; insert thirtybees.tbemployeeshop select * from prestashop.psemployeeshop where idemployee > 1; ```

[wakabayashi]

Nice work :thumbsup: Are the first 10 ids in category default or why do you skip?

I hope ThirtyBees will deliver a clean installation soon. I hate this default/demo stuff...

[koskimaa]

@wakabayashi said in How is going?:

Nice work :thumbsup: Are the first 10 ids in category default or why do you skip?

I hope ThirtyBees will deliver a clean installation soon. I hate this default/demo stuff...

+1 on the clean installation. Default/demo stuff (plus all the useless analytics modules) has got to go.

[wakabayashi]

@koskimaa said in How is going?:

(plus all the useless analytics modules) has got to go.

What do you mean with this? Google Analytics?

[MockoB]

I think he means that he will use just GA and all other by default statistic modules are completely useless! Actually I just need "available quantities" and "shop search" statistics. Maybe we need "how to" where it is explained how to disable every possible statistic modules without break the shop :)

[wakabayashi]

I am not so sure, if this is true. I need better statistics about product sales for example. It doesn't differente between attributes. I haven't seen a good GA setup yet. As far as I know GA just takes infos by checkout. I also read in book about data analyse, that this part is not GA strenghts. But what if an order is cancelled? All in all I wish better statistics.

[MockoB]

May be if you sell many products that is true. When you sell couple of thousand you will know the best sellers without module :) personally I don't find any need using the base statistics and I think they are just flooding the database and hurt my site performance.

[hailong]

@wakabayashi Yes, the first 11 ids for category and 7 ids for product are the default demo data.

[Anima]

I do not have so many products, about 1000. But something that worries me a lot about the migration is the images, I have an average of 5 images per product, it will be very complicated to add one by one.

Can you tell me if the images will be a problem?

[alwayspaws]

@Global-Moderators @administrators @mdekker @lesley

Do you think it's a good idea to merge this forum topic with the one that has a clearly defined title - "Eager to Migrate from PrestaShop 1.6" at https://forum.thirtybees.com/topic/35/eager-to-migrate-from-prestashop-1-6 so that when we get bigger, people will be able to find migration information easier? IMHO, no one is going to search for "how is going" to find PrestaShop Migration information.

[alwayspaws]

@Anima said in How is going?:

But something that worries me a lot about the migration is the images, I have an average of 5 images per product, it will be very complicated to add one by one.

Can you tell me if the images will be a problem?

I hope not because I also have multiple images for some products.

Are we going to be able to add different image alt tags to each image?

[Anima]

What really worries me is the translation of the administrative area, I've already translated everything, and I can not translate that part.

I need everything 100% translated, because there are people to whom I will migrate the store that does not understand any English!