We need to parse [url removed, login to view] and import their products into our database with details such as:
1) product photo
2) item description
3) item price
4) item availability
With respect to "Availability":
a) if there is "No ETA" in 'Availaibility' or "CALL FOR AVAILABILITY" or "Restocking Soon" or "Out of Stock" or "Estimated Shipping Date: UNKNOWN" then ask customers to email us (we should be able to specify an email address that customers can use)
b) if MDD shows availability 'Ships in 5-10 business days" we would show "Ships in 12-17 business days", ie. we add 7 business days of our own (we should have a setting in our Control Panel where we can change the amount of days added by us)
c) if "EARLY APRIL" then "MID APRIL" << easy swap
d) if "MID APRIL" then "LATE APRIL" << easy swap
e) if "LATE APRIL" then "EARLY MAY" << here we have to check what month follows next
f) if "Ships in 1 week" then change to "Ships in 2 weeks"
g) if "Ships in 2 weeks" then change to "Ships in 3 weeks"
h) if "Ships in 3 weeks" then change to "Ships in 4 weeks"
As our current product fields do not have an "Availability" parameter, one would have to be added in for all products imported.
We need to be able to control the price margins so we'll need a "MDD Margin" setting somewhere in our Control Panel. ie. add 25% to MDD Price
Frequency of updates:
We need to be able to have a setting in our Control Panel where we can specify when to run the script for an update ie. once a day, once every 3 days, once every 7 days etc and to be able to force the script manually if necessary ie. "Update Now"
Please let us know if more info is needed.