❗It is important that the Excel file must be in CSV format. (Comma-separated) and must not contain any internal formatting (Color, formulas, linked data).
Open the NEX SERVER (red-house icon).
Go to the IMPORT DATA option.
Click on the IMPORT DATA button.
In FILE, browse and select the Excel file on your computer.
Select the type of information you want to import: products, customers or suppliers, and click on NEXT.
Match the source fields 'FROM' and 'DESTINATION'.
Click on NEXT.
Check the configuration options you want and click on NEXT.
The system will perform a backup, click on ACCEPT, then click on OK and wait for the process to finish, finally click on OK again.
Once the procedure is completed, open the Nex Admin.
Go to the STOCK tab, click on the ARROW icon then select TOOLS, and click on REPROCESS STOCK.
Done!👍 You have imported the data from Excel to Nex.
✨Tip: If you want to go back to the settings and information you had before importing the data, you can restore the backup that the system made, click here to access the tutorial.
If you prefer, click here to see the detailed tutorial on how to import data from an Excel file to Nex.