How to approach using and external text doc to update database records.
Client has a desktop software package for their inventory and accounting needs. This server is in-house and not linkable to the internet therefore I cannot simply tie to the two databases together. The client currently uses a script that creates a text file and an excel file that they use to upload 3 other third party websites that list their inventories on a daily basis manually.
They want to use this same approach to update their Powerstore shopping cart.
I need to know what steps I need to take to make this happen.
An example of the excel file they use now is below. I can write a script to retrieve more/different info if needed.
PN QTY_OH CONDITION_CODE
MS24590-6 112 OH
MS20823-6B 1120 NE
MS28720-8 2 NE