The Data Import module can also be used to update existing data. This only applies when importing products, suppliers or clients to the Megaventory account. The handler to check whether an entity exists is the SKU code (for the Products) and the supplier/client Name (for suppliers/clients). If the handler exists, then, the system does not insert a duplicate entity but updates the attributes of the entity instead.
The update of data using the Data Import module is better illustrated with an example:
In the example of the figure above, the SKU is set to “001”, the Product Description is set to “Some product description”, the Long Description field is empty and the Product Version is set to “Some version”. The spreadsheet template that will be used in this example includes the same SKU of “001”, a different Product Description field of “Another product description”, a new Long Description field of “Adding Long Description to Product” and an empty Product Version field.
After successfully uploading the CSV file, the Data Import module displays the success message that zero (0) products have been imported and one (1) product has been updated:
The product definition has now changed to the one of the following figure:
- An empty field in the spreadsheet file preserves the respective existing field in the Product definition. For example, the empty Product Version field in the spreadsheet template of the figure above did not change the existing Product Version field of “Some version” to the empty one of the spreadsheet file.
The same spreadsheet file can be used to insert new products to the account and also update existing products.