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  sup_created_at, sup_updated_at, sup_name, if(sup_code, sup_code, 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, 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
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
sku,
if(sup_code, sup_code, sup_name) as sup_code,
sp_sku,
sp_price,
sp_base_price,
sp_primary,
sp_notes,
sp_moq,
sp_shipping_delay,
sp_supply_delay,
sp_pack_qty,
sp_last_buying_price,
sp_last_buying_price_base,
sp_discontinued,
sp_availability_date
from
catalog_product_entity
inner join bms_supplier_product on (sp_product_id = entity_id)
inner join bms_supplier on (sup_id = sp_sup_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 ...

    • 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 ...

    • 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 ...