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 [url removed, login to view] web marketplace to connect in to our internal business systems.
Primarily, we need middleware “blackbox” api interface that will allow us to interact with [url removed, login to view]’s Marketplace Webservice ([url removed, login to view]) 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. 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).
Update Sku Function – this would be nice to have but unsure Amazon’s api (or any other interface) allows this. Would like to be able to update (change) the seller’s sku on individual items (associated with Merchant Id and Marketplace Id again XML format for submission is fine. Would need a return stream for success or not.
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.
Would prefer all coding to be done in Visual [url removed, login to view], 2008 version.
The code must be well documented with a general description of the class/module/function (at the beginning) including what it does. Code should be well documented with logical variable names and a comment describing what the variable is used for (obvious variables such as iCounter are exempt from this requirement). Failure to document code properly will result in poor feedback.