Hi,
I need an Excel capability (assuming VBA function/s) which will access my Seller Central account, using my Seller Central credentials and AWS to bring over data on items I want to look up.
Look up term could be any UNIQUE identifier Amazon uses: ISBN, UPC, ASIN etc.
Returned info could be any FIELD Amazon provides, which I identify by name.
A general function return value would be number of items found (0, 1, 2, any...)
Generically, it may look as follows:
XYZFunction with the following Parameters:
(LookupTermType, LookupTerm, ReturnValuesRequestedVector, ReturnValuesReturnedVector, ReturnsLimitor, LandingPointer)
Where:
LookupTermType, Could be cell with "ASIN", "UPC", "UPC", etc. Assume "UPC" for this example
LookupTerm, Could be a cell "681131001908" (which is a UPC value)
ReturnValuesRequestedVector, Could be a range of cells with ["Description","Price",'ASIN"] assuming these are valid Amazon data fields
ReturnValuesReturnedVector, Could be a range of cells with [
"2012 Radio shack team harness long-sleeved cycling clothing / bike clothing breathable perspiration / 11 Columbia",
"128.00",
'B007G0TDC8"]
ReturnsLimitor, could be a cell with number like 5 which will limit the number of returned items to 5
LandingPointer could be a cell reference pointing to the top/left cell of an array where the retrieved information is going to be stored by the function, required fields at top line (column headers) and multiple items found underneath, number limited to ReturnsLimitor.
The project deliveries shall include:
- Above functionality as specified
- List of CURRENT possible lookup terms and link to original resource
- List of CURRENT possible return terms and link to original resource
- A release allowing me to use this functionality in an UNLIMITED fashion for my business and related activities
An interim project deliverable would be a design paper outlining the proposed solution.
Thanks to all professional bidders.