Our suppliers keeps a file in .xls or CSV format in a password protected directory that is updated every day and is periodically assigned a new password to access it. The products in the list and in our product database need to be synchronized every day to disable discontinued products and adjust price changes that take effect from the .xls or CSV file. We also will have a margin table lookup file that will have to be cross referenced in order to determine the correct pricing. Below is an example of the process:


Get file from supplier directory -> Apply prices based on margins set in lookup file -> Set prices accordingly and disable discontinued items in Magento Cart.

Example 1: After automatically logging in and moving the .xls or CSV file to our server, the synch process should begin. A product is listed in the .xls or csv file, and has a base price set at $ 19.99. It has a product number of