Data Import and Data Export

Data Import and Data Export

Data import

Navigate to Menu Wizard >> Scroll down to Data Import 

You will find various import types as below:
1) Products update
2) Product / supplier association
3) Purchase order update
4) Stock and location
5) Suppliers

Supplier import

You can import the Supplier as stated in the Link or just create a CSV file with the header and its data to import.



Stock and location import

You can import the stock and location here just select the warehouse and the CSV file with the SKU or Barcode, Quantity, Location, Ideal and warning Stock level.



Product / supplier association import

You can also import the Product / supplier association from the template by a CSV file.



Purchase order update

You can update the Purchase order from the CSV.



Products update 

The product attributes can be updated here. The default file format is CSV. SKU of the product is mandatory. 

Data Export

You can export CSV data from the Wizard >> Data Export.

1) Export Supplier
2) Product / Supplier Export
3) Stock Export
4) Product Export

Export Supplier

Select the output format and click on button Continue. You can export data on CSV or in Excel format.



Product / Supplier Export

Select the output format and click on button Continue. You can export data on CSV or in Excel format.



And here is the example CSV file.



Stock Export

Select warehouse, date and the output format, then click on button Continue.
If you leave the date field empty, export will contain current stock levels. If you select a date in the past, quantities will be the stock at this date.



Product Export

Select the required file format and the desired product attributes to be exported. 


    • Related Articles

    • Accounting Export

      Intro: The Accounting Export section allows you to get access to detailed CSV files with data that can be filtered for deeper analysis and accounting purposes. We offer different templates for different needs to improve ease of access to the needed ...

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

    • Suppliers Export

      Suppliers export 1. How to access To access the supplier Export function, simply go into menu : Purchasing >> Suppliers There, you will find located at the top left corner an "Export" button, allowing you to export the suppliers grid data. 2. Process ...

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

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