We require a web based system to upload our stock to the Pixmania.co.uk website. They operate a web services API which allows this.
From my understanding there are two procedures, firstly we submit the barcodes to the Pixmania system and it will generate a report with the Pixmania Unique product ID (FUPID). This FUPID then needs to be submitted to Pixmania with stock quantities and prices.
I have attached the help file provided by Pixmania, please look in the "Use webservice to automate the integration's procedures" directory for the details on the two processes.
I would suggest using a database to store the FUPIDS matched to the barcodes, which can be updated once per week via cron job. Then each day the quantity/price file can be uploaded to Pixmania using stock levels from our csv stock files and the stored FUPIDS.
There will be the requirement to set any items which are no longer in stock to 0 quantity, I think the most secure way of doing this would be to upload the original stock file again, with all the quantities set to 0. This way there will never be any stray products on the system and then the new stock can be uploaded. It would be best to do this during a quiet period such as 4AM.
There will also be the requirement for a blacklist, which can exclude products from uploading via FUPID or barcode.
The system will need to be used with multiple source files, they are in the same format.
There will need to be a config/settings file to set a profit value to add to cost prices from the source file (both fixed profit and %). Also we need to set quantity and exchange rate in this same file.
If you have experience of working with APIs and are capable of doing the work please place a bid.