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 of import as below:
1) Supplier import
2) Stock and location import
3) Product / supplier association import
4) Purchase order update

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.



Data Export

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

1) Export Supplier
2) Product / Supplier Export
3) Stock 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.


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

    • 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 * from bms_supplier Then export this query under CSV format and save it in your ...

    • Suppliers Import

      Suppliers import 1. How to access To access the supplier import screen, simply go into menu : Purchasing >> Suppliers There, you will find located at the bottom right corner an "Import" button, allowing you to access the Import screen. 2. Process ...

    • Import serial & lot numbers

      Serial numbers and Lot numbers import There are several ways in myFulfillment to create new sources (serial numbers and lot numbers). You can do it through the New stock movement section, through the Purchase order reception screen, or directly by ...