A mate of mine is setting up a dropshipping website and has asked me to look into creating something that will help keep his stocklist upto date with his suppliers.
Not ever done it this way before and I'm not even sure its possible (but I'm a strong believer of anything is possible), so thought I'd ask the you lads here on DF.
This is what needs to happen (sort of).
Live CSV with Stock/Cost Price/Product Name
@ http://myuser:mypass@mysupplier.com/stuff.csv----->
----->Conversion Occurs
(Live CSV on SkyDrive or Google Drive Perhaps)----->
----->Required format for his sites Import CSV.
I was thinking 3 Sheets in a live Spreadsheet, the first being imported from the Live CSV (will this change as the Suppliers stock changes though?).
Conversion would be quite simple using the likes of =Sheet1!A2 in the appropriate place to correspond with what's need in the sites backend import.
Sheet 3 would then be the CSV required by his Live rebranded site.
Am I completely off-track, in dreamland and with no idea about how this'll work?
Quite possibly... but does anyone care to point out what and why it won't work and if a better solution is possible?
Still waiting for the Live list from suppliers to find out, but thought you guys might know before I tried to bother.
Social Networking Bookmarks