Embedded ERP M2 data migration to myFulfillment

Embedded ERP M2 data migration to myFulfillment

Overview


This article explains how to migrate data from Embedded ERP Magento2 to myFulfillment.

For this, you need an access to your magento2 database

This article assumes that you have already connected myFulfillment with magento2, and products are imported.

Global workflow


  1. Setup M2 integration in myFulfillment and sync products & orders
  2. Import supplier (see below)
  3. Import product / suppliers (see below)
  4. Import purchase orders (see below)
  5. Create warehouses manually in myFulfillment
  6. Import stock & locations (see below)
  7. Remove Embedded ERP on Magento2

Recommended M2 integration settings

Attributes mapping (myF / magento):
  1. supply_discontinued / supply_discontinued

Technical guidelines

If you use PhpMyAdmin to run the export, follow these steps:

  1. Run the query and click on the "export" button at the bottom.
  2. Use the following settings in the next screen:
    1. Export method: custom
    2. Format: csv
    3. Dump all rows
    4. Columns separated with: ";" (semi colon)
    5. Replace NULL with: set to empty
    6. Remove carriage return/line feed characters within columns; enable



Supplier Import

Run the following query


SELECT 
sup_created_at,
sup_updated_at,
sup_name,
sup_name as sup_code,
sup_contact,
sup_email,
sup_website,
sup_locale,
sup_is_active,
sup_notes,
sup_street1,
sup_street2,
sup_postcode,
sup_city,
sup_state,
sup_country,
sup_telephone,
sup_fax,
sup_minimum_of_order,
sup_carriage_free_amount,
sup_currency,
sup_tax_rate,
sup_shipping_delay,
sup_shipping_instructions,
sup_sales_contact,
sup_accounting_contact,
sup_aftersale_contact,
sup_sales_email,
sup_accounting_email,
sup_aftersale_email,
sup_sales_phone,
sup_accounting_phone,
sup_aftersale_phone,
sup_sales_notes text,
sup_accounting_notes,
sup_aftersale_notes,
sup_opened_order,
sup_payment_terms,
sup_supply_delay,
sup_global_discount,
sup_website_id,
sup_enable_notification,
sup_attach_pdf,
sup_attach_file,
sup_file_name,
sup_file_header,
sup_file_order_header,
sup_file_product,
sup_file_order_footer,
sup_file_footer,
sup_m1_id,
sup_delayed_notification,
sup_delayed_notification_hours
FROM `bms_supplier`;

Then export the file to csv format (see technical guidelines above)

Open the file with a text editor and change the second column name to "sup_name":

"sup_created_at";"sup_updated_at";"sup_name";"sup_code";"sup_contact";"sup_email";"sup_website";"sup_locale";"sup_is_active";"s


Then go in myFulfillment, select menu wizards > data import > suppliers), select your file, leave the mapping in the next screen and click on the "process" continue button


Product / Supplier association import

Run the following query

SELECT
sku,
    sup_name,
    sp_availability_date,
    sp_base_price,
    sp_sku,
    sp_discontinued,
    sp_last_buying_price,
    sp_last_buying_price_base,
    sp_moq,
    sp_notes,
    sp_pack_qty,
    sp_price,
    sp_primary,
    sp_shipping_delay,
    sp_supply_delay
FROM
catalog_product_entity
    inner join bms_supplier_product on (entity_id = sp_product_id)
    inner join bms_supplier on sp_sup_id = sup_id;

Then export the file to csv format (see technical guidelines above)

Then go in myFulfillment, select menu wizards > data import > Product / supplier associations), select your file and click on continue

In the mapping screen, just change the mapping for the second column:



Then click on continue to import associations

Purchase orders import

Purchase orders must be imported when Embedded ERP is still installed in Magento.

Also you need to install the Boostmyshop Agent in Magento to add API that will allow myFulfillment to import Purchase orders:

Once the module is installed, go in menu Integrations, click on the M2 integration, then go in tab "Feeds" and run feed "PO Import"

Important notes:
  1. The feed will import only 100 PO at each execution so you may need to run it several time to import everything
  2. The feed will only create purchase order, it does not update purchase order. You can run it first to make some tests and import purchase order but before going live, make sure to delete all existing purchase orders in myFulfillment and then run the feed.

Organizers import

Run the following query:


select
increment_id as reference,
o_created_at as date,
o_title as label,
o_comments as comment,
o_status as status,
email as author
from
bms_organizer
inner join sales_order on (o_object_id = entity_id)
inner join admin_user on (o_author_user_id = user_id)
where 
o_object_type = 'sales_order'

Then go in menu Wizards > Data import > Organizer, select your file and then validate the import:




Stock & locations import

Run the following query (make sure to replace XXXX with the warehouse name):


select
sku,
wi_physical_quantity as qty,
wi_shelf_location as shelf_location,
wi_warning_stock_level as warning_stock_level,
wi_ideal_stock_level as ideal_stock_level
from
catalog_product_entity
inner join bms_advancedstock_warehouse_item on (entity_id = wi_product_id)
inner join bms_advancedstock_warehouse on (wi_warehouse_id = w_id)
where
w_name = "XXXXX"


Then go in menu Wizards > Data import > Stock & location, select your file and the warehouse, validate the mapping and click on button "Continue"





    • Related Articles

    • Import data from Embedded ERP Magento 1

      This article explains how to extract data from Embedded ERP Magento1 and import in Connect. Stock information Stock information includes physical quantity, bin location, warning and ideal stock levels. Export must be done warehouse by warehouse. To ...

    • Magento 2 - Import data from Embedded ERP Magento 2

      This article explains how to export suppliers from ERP Magento2 and import them into Connect Suppliers To export suppliers from Magento2, run the following query : SELECT sup_created_at, sup_updated_at, sup_name, if(sup_code, sup_code, sup_name) as ...

    • Magento 2 - Magento1 to Magento2 Migration

      This article describes the prerequiresites to migrate a MyFulfillment account from Magento1 to Magento2. Note : the migration process is charged 1199 euros by Boostmyshop. Prepare Magento2 platform The new Magento2 website must preserve the same ...

    • Data Import and Data Export

      Data import Navigate to Menu Wizard >> Scroll down to Data Import  You will find various import types of import as below: 1) Supplier import 2) Stock and location import 3) Product / supplier association import 4) Purchase order update Supplier ...

    • How to go Live with MyFulfillment

      This article explains how to go live with MyFulfillment, erase test data and enable feeds to CMS. Boostmyshop is of course at your disposal to support you during this transition. Prerequiresites Before you plan to go live with MyFulfillment, please ...