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 :
- add row column header and select comma for field separator (Put columns names in the first row).
- 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 :
- add row column header and select comma for field separator (Put columns names in the first row).
- 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 :
- Export stock and location from Magento : go in the warehouse, go in the "products" tab and click on the export button
- 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 ...