We need a system to download our orders from the Pixmania API and insert them into one of our databases.
We then need a front end which allows us to view the orders and add comments in a text box, or change the status to shipped or refunded. Depending on the status selected it will need to update the Pixmania website with the status.
We currently use an excel spreadsheet for this data so a similar layout would be fine:
order-id COMMENTS (Blank text box) sku1 Email purchase-date SoldPrice item-name recipient-name ship-address-1 ship-zip ship-address-2 ship-city Shipped Shipdate ship-country payments-status
Payment status to be updated to Pixmania - Refunded, Delivered, alternative status On Hold.
It would be best if we can update all of the status in the system and then click a button to submit the refunds or shipped updates to the api, this gives us some time to ensure everything is correct rather than an automatic update after each order is changed in the system.
I have attached the help file and some sample upload files.