Magento 2 - Import data from Embedded ERP Magento 2

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 * from bms_supplier


Then export this query under CSV format and save it in your computer.

For file export, make sure to enable this options : 
  1. add row column header and select comma for field separator (Put columns names in the first row).
  2. Replace NULL with: leave empty
To import the file, go in your Connect account and select menu Purchase > Suppliers and click on the "Import" button in the bottom right corner.
Then select the file and the field delimiter, and click on 'Import' button.

Product / Supplier associations


To export suppliers from Magento2, run the following query :

select 
sup_code as supplier,
sku,
sp_sku,
sp_price,
sp_moq,
sp_pack_qty,
sp_shipping_delay,
sp_supply_delay
from 
bms_supplier_product 
inner join bms_supplier on sup_id = sp_sup_id
inner join catalog_product_entity on entity_id = sp_product_id


Then export this query under CSV format and save it in your computer.

For file export, make sure to enable this options : 
  1. add row column header and select comma for field separator (Put columns names in the first row).
  2. Replace NULL with: leave empty
To import the file, go in your Connect account and select menu Purchase > Product / Supplier associations and click on the "Import" button in the bottom right corner.
Then select the file and the field delimiter, and click on button "Import file now".

Stock


First you need to create the warehouses in MyFulfillment, this can be done from menu Inventory > Warehouses.

Once it is done, for each warehouse : 
  1. Export stock and location from Magento : go in the warehouse, go in the "products" tab and click on the export button
  2. Go in MyFullfilment, select menu "Wizard" and  then click on wizard "Stock import". Select the warehouse and the export file, map the columns (sku / qty / shelf location) and confirm import

Note : you can also export stocks using this sql query : 

SELECT
sku,
wi_physical_quantity,
wi_shelf_location
FROM
bms_advancedstock_warehouse_item
inner join catalog_product_entity on (wi_product_id = entity_id)
where
wi_warehouse_id = WAREHOUSE_ID



    • 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 ...
    • 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 ...
    • Magento 1 - Order comments import

      Magento 1 - Order comments import Importing order comments from Magento 1 to MyFullfillment is possible. Comments are imported in MyFullfillment ONLY when the order is imported.  We will not import comments in MyFullfillment after the Order has been ...
    • Magento 2 - Order comments import

      Magento 2 - Order comments import Importing order comments from Magento 2 to MyFullfillment is possible. Comments are imported in MyFullfillment ONLY when the order is imported.  We will not import comments in MyFullfillment after the Order has been ...
    • Magento 1 - Connect your instance to myFulfillment

      Overview The integration between Connect and Magento 1 will : import products and orders from Magento to Connect Send shipping confirmation and stock updates to Magento. When you integrate Connect with a Magento 1 website, you must keep in mind the ...