My vendor provides a URL that allows me to query Stock level and price for each item.
The url looks like this
<[url removed, login to view],qty,price&delim=csv&ohtime=1212278400&invtype=stock&id=XXXXXXXXX>
This would return results like this(Field1=sku,field2=stock, field3=price):
10001,1,822.51 10002,1,320.86 10003,2,498.91 10004,1,288.77 10005,1,573.91 10006,21,52.50 10007,0,822.51 10008,3,129.89 10010,2,15.63 10011,38,64.50 10012,3,445.65 10013,1,572.99
I need a script that will? follow the link, get results and update mysql db.
The script needs to run every 4 hours
This is one of many projects I will post that is related to fine tuning my website.
This is not a hard job and shouldn't take more than? 4 hours.