We require a web based system to upload our stock to the [url removed, login to view] 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.
16 freelancers are bidding on average $662 for this job
I have made and maintain a number of working solutions to various API's including inventory upload and similar. Have some ideas to make this simpler and better for use but also need a number of answers from you side.
An ISO 9001:2006 certified company, We can fulfill your requirement because we are professional worker, we work for our client satisfaction. for more detail please check private message board. Thanks.