Import data from Embedded ERP Magento 1

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 export stock information from Magento1, run the following query (make sure to replace WAREHOUSE_ID with the magento1 warehouse id): 

select
sku,
qty,
shelf_location,
notify_stock_qty as warning_stock_level,
use_config_notify_stock_qty as use_config_warning_stock_level,
ideal_stock_level,
use_config_ideal_stock_level
from
catalog_product_entity
inner join cataloginventory_stock_item on entity_id = product_id
where
type_id = 'simple'
and stock_id = WAREHOUSE_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 Inventory > Warehouses > [click on the warehouse] > Import tab.
Select the csv field separator, select your file and click on save button



Supplier information

To export suppliers from Magento1, run the following query : 


select
sup_name,
IF(LENGTH(sup_code) > 0, sup_code, concat('SUP_', sup_id)) as sup_code,
sup_contact,
sup_mail as sup_email,
sup_website,
sup_locale,
"1" as sup_is_active,
sup_comments as sup_notes,
sup_address1 as sup_street1,
sup_address2 as sup_street2,
sup_zipcode as sup_postcode,
sup_city,
sup_country,
sup_tel as sup_telephone,
sup_fax,
sup_order_mini as sup_minimum_of_order,
sup_free_carriage_amount as sup_carriage_free_amount,
sup_currency,
sup_tax_rate,
sup_shipping_delay,
sup_shipping_instructions,
sup_shipping_delay as sup_supply_delay
from
purchase_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

Then go in Connect, select menu Purchasing > Supplier, and click on the "Import file" button in the bottom right corner.
Then select your file and save


Product / Supplier information

To export product / supplier from Magento1, run the following query : 


select
sku,
IF(LENGTH(sup_code) > 0, sup_code, concat('SUP_', sup_id)) as supplier,
pps_reference as sp_sku,
pps_last_price as sp_price,
pps_is_default_supplier as sp_primary,
pps_supply_delay as sp_supply_delay
from
purchase_product_supplier
inner join purchase_supplier on pps_supplier_num = sup_id
inner join catalog_product_entity on entity_id = pps_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

Then go in Connect, select menu Purchasing > Product / supplier association and click on the "Import" button
Select the field separator and your file, and then save.




    • Related Articles

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