This program scrapes data from my supplier's sites and puts into a csv. I need the output of one supplier modified to look like sample csv.
The program has a 2nd mode where it only downloads limited info, at the moment it has sku, stock status and price columns. Need a qty column added, and if supplier has a special price, have this added along with the date too. At the moment this mode only works for awhile before failing.
Also want another 6 sites added to this mode, they all use the same site system so format should be the same between them. Please see pic for format, if stock is enabled, qty =5 otherwise 0. Special price = (RRP - W/S + SPEC). If it has special, add a date to next column
This program is an executable and can be run from the command line.
Source code and sample csv is attached.