Jax Music Supply is an online based guitar and accessories retailer. Started in 2007, we market on a variety of web based platforms including eBay, Amazon, and our website. We are in the process of upgrading our tools to allow easier automation. To that end, we need some middleware functions interacting with our [login to view URL] web marketplace to connect in to our internal business systems.
Primarily, we need middleware “blackbox” api interface that will allow us to interact with [login to view URL]’s Marketplace Webservice ([login to view URL]) in a more user friendly manner for use in our applications. We really only need a subset of the functions in their API available. The ideal solution would be coded in Visual Basic. C# is acceptable but must be able to be called (service/DLL?) from a Visual Basic Program. We will need a copy of the source code when complete.
General function list
1. Inventory maintenance and update functions
2. Order Processing Functions
Inventory Maintenance Functions
Current Inventory Function - would accept our (or any) Amazon Merchant ID and Marketplace Id (may also require our AWS access keys) and send a request to receive our selling item list of SKU, ASN, price and quantity from the Amazon marketplace for the submitted Merchant and Marketplace id. The submission could be in XML format. The output could be a collection of objects containing this information or an XML feed.
Update Inventory Function - accept our (or any) Amazon Merchant Id and Marketplace id as well as a collection of object with sku, price and quantity and update our Amazon inventory with the new price and quantity. We can submit in an XML format if necessary. We would need an output of any unsuccessful changes (XML is ok).
Order Processing Functions
Download Amazon Orders Function – Download all unprocessed orders (unshipped orders) from Amazon for the associated merchant id and marketplace id. Would need order id, sku, ASIN,quantity, shipping name, shipping address, etc.
Update Orders Function – function would accept collection of objects containing order id, shipping information (carrier, shipping service, and tracking id) and update Amazon with that information as well as marking item shipped.
Other requirements:
The code must be well documented with a general description of the class/module/function (at the beginning) including what it does. Code should use logical variable names and a comment describing what the variable is used for (obvious variables such as iCounter are exempt from this requirement).