Current job is only Stage 1. If it goes well, we would move to the other stages. Thanks!
STAGE 1:
I manually download the 'All Listings' report from Amazon Seller Central, import and run it through my Access Tool, then upload the output CSV to Amazon, in order to update my quantities. I need a developer with experience in VBA / Access to handle replacing the manual spreadsheet import / export portions of my tool.
IMPORT: I would like the tool to connect to Amazon MWS, import the 'All Listings' report into my table. Then kickstart the update Sub that does all of the update work.
EXPORT: When the tool is done updating qty's (which it already does fine), then connect to MWS and upload the updated quantities back to Amazon.
STAGE 2 (next project):
1. Connect to MWS and import the Unshipped Orders report into my table.
2. Run through the table, querying an easy XML service to get the tracking codes.
3. Correlate to the correct shipping service from the XML.
4. Connect to MWS and update the orders with tracking, completing the order.
STAGE 3:
(possibly deprecated)
If still able to, download order information, and forward to an XML service.
About the recuiterMember since May 20, 2018 Varsha Somaiya
from Kalatura, Sri Lanka