Hello all,
Each day we receive a report (MM.xlsx), listing all products available from our manufacturer. The file often has some new products, some amended product descriptions and some products have been deleted from the file compared to previous files. The list is very long, approximately 13000 products.
I would like to be able to update my products table based on any changes in the new file using a form with an update button.
When clicking the button I would like the following to take place:
- ask user to select an excel file to compare current products with those in the excel file.
- using code, insert any new products to my table
- mark any products in my table as not available (uncheck the OnMM field in the products table), if the product is no longer on the manufacturers list (Not deleting from my table)
- Make changes to the product description if any changes exist.
I have attached example files with examples of each of the above points.
I must add the excel file is generated from SAP so should never change.
Any help or pointer in the right direction will be appreciated.