Jump to content
thirty bees forum

hailong

Members
  • Posts

    7
  • Joined

  • Last visited

hailong's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. I'd prefer to deploy the code from my own git repo, since I may have some code changes periodically. Can somebody suggest the proper way to migrate DB only for the upgrade? Thanks!
  2. hailong

    How is going?

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

    How is going?

    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; ```
  4. hailong

    How is going?

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

    How is going?

    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.
  6. hailong

    How is going?

    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?
  7. hailong

    How is going?

    I'm keeping watching out the release 1.0.0, how it going? :smile:
×
×
  • Create New...