Database Script
$25-30 USD
Paid on delivery
Hello,
We need a script written to work with our website to update stock figures from files that we receive from our supplier, they are updated every 2 minutes from the supplier through ftp and a file is placed for us to do the following:
1. Get all files in the directory in filename order (order is important
as 2 files might both update the same product, the more recent one needs
to be processed 2nd to get an accurate result). Files are named by a
date stamp so are easy enough to order.
2. Loop through each file and update the database accordingly. The
format of the file is pretty simple, each line of the file will contain
something like:
10077|65.00|0.00|30/07/2008|0.00|2.30
where 10077 is the sku, 65.00 is the stock level, 30/7/2008 is when we
expect to receive more and 2.30 is the trade price of the item (you can
ignore to 2 0.00 fields - these might have a number in but this doesn't
matter).
3. Archive/Delete the files that have been processed
Project ID: #3101478