Amazon Seller Central Item Listing

[lakhanbhagnani]

Problem Statement

Netsuite-Amazon IA doesn’t support the listing of items that already exist in Amazon’s catalog

Solutions

1. A custom flow in Celigo’s platform.

OR

1. Use the product upload feature on the Amazon portal which is an easier and quicker solution (see link here).

Approach to Solution 1

To tackle the problem statement, solution consultants have built a custom flow to demonstrate how the solution can be created in the platform.

Prerequisites

• Connection to Export System
• Connection to Amazon Seller Portal
• Dummy Connection to Amazon Schema

Technical Details

Export

• Summary: To test the flow, the FTP connection
• Type: FTP
• URL: N/A
• Sample request payload(if any): N/A
• Sample files(if any): AmazonSP-API TestFile
• Response: N/A

Look up 1

• Summary: Check does the item exist in the Amazon catalogue
• Type: Look up additional records (per record)
• URL:

  catalog/2022-04-01/items?marketplaceIds={{record.MarketPlaceID}}&identifiersType={{record.IDType}}&identifiers={{record.ID}}

• Sample request payload(if any): N/A
• Sample files(if any): N/A
• Response:

{ "page_of_records": [ { "record": { "asin": "B00UZ8X9H8", "summaries": [ { "marketplaceId": "ATVPDKIKX0DER", "adultProduct": false, "autographed": false, "brand": "wet n wild", "browseClassification": { "displayName": "Eyeliner", "classificationId": "11058521" }, "color": "Taupe of the Mornin'", "itemClassification": "BASE_PRODUCT", "itemName": "wet n wild Color Icon Kohl Eyeliner Pencil Black, Long Lasting, Highly Pigmented, No Smudging, Smooth Soft Gliding, Eye Liner Makeup, Baby's Got Black", "manufacturer": "Markwins Beauty Brands", "memorabilia": false, "modelNumber": "601A", "packageQuantity": 1, "partNumber": "C601A", "releaseDate": "2022-01-01", "size": "1 Count (Pack of 1)", "tradeInEligible": false, "websiteDisplayGroup": "beauty_display_on_website", "websiteDisplayGroupName": "Beauty" } ] } } ] }

Look up 2

• Summary: Every item in the Amazon catalog has restrictions to sell, this lookup will fetch that restriction
• Type: Look up additional records (per record)
• URL:

  listings/2021-08-01/restrictions?asin={{record.ItemData.asin}}&sellerId={{connection.http.unencrypted.sellerId}}&marketplaceIds={{connection.http.unencrypted.marketplaceId}}

• Sample request payload(if any): N/A
• Sample files(if any): N/A
• Response:

{ "page_of_records": [ { "record": { "restrictions": [ { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "collectible_like_new", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "new_new", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You need approval to list.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "used_acceptable", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "used_like_new", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "collectible_very_good", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "used_very_good", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "collectible_acceptable", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "collectible_good", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "used_good", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] }, { "marketplaceId": "ATVPDKIKX0DER", "conditionType": "refurbished_refurbished", "reasons": [ { "reasonCode": "APPROVAL_REQUIRED", "message": "You cannot list the product in this condition.", "links": [ { "resource": "https://sellercentral.amazon.com/hz/approvalrequest/restrictions/approve?asin=B00UZ8X9H8", "verb": "GET", "title": "Request Approval via Seller Central.", "type": "text/html" } ] } ] } ] } } ] }

Look up 3

• Summary: Fetch Product Type Definitions
• Type: Look up additional records (per record)
• URL:

  /definitions/2020-09-01/productTypes/{{product_type}}?marketplaceIds={{record.ItemData.summaries.0.marketplaceId}}

• Sample request payload(if any): N/A
• Sample files(if any): N/A
• Response: Confidential to the Amazon system(you will get a link to the schema JSON which we will fetch in another lookup

Look up 4

• Summary: Fetch Schema of the Product
• Type: Look up additional records (per record)
• URL: {{confidential}}
• Sample request payload(if any): N/A
• Sample files(if any): N/A
• Response: Contains the JSON Schema to create a payload object of the Product

Import

• Summary: List an Item to Amazon MP from Amazon catalog
• Type: Import Record
• URL:

  listings/2021-08-01/items/{{connection.http.unencrypted.sellerId}}/{{record.SKU}}?marketplaceIds={{record.MarketPlaceID}}

• Sample request payload:

{ "productType": "MAKE_UP", "requirements": "LISTING_OFFER_ONLY", "attributes": { "brand": [{ "value": "wet n wild", "language_tag":"en_US", "marketplace_id": "ATVPDKIKX0DER" }], "bullet_point": [ { "value": "Smudge free", "language_tag":"en_US", "marketplace_id": "ATVPDKIKX0DER" }], "country_of_origin": [ { "value": "United States", "marketplace_id": "ATVPDKIKX0DER" } ], "item_name": [ { "value": "wet n wild Color Icon Kohl Eyeliner Pencil Black, Long Lasting, Highly Pigmented, No Smudging, Smooth Soft Gliding, Eye Liner Makeup, Baby's Got Black", "marketplace_id": "ATVPDKIKX0DER" } ], "item_type_keyword": [ { "value": "eye make up", "marketplace_id": "ATVPDKIKX0DER" } ], "product_description": [ { "value": "this is test description", "marketplace_id": "ATVPDKIKX0DER" } ], "supplier_declared_dg_hz_regulation": [ { "value": "not_applicable", "marketplace_id": "ATVPDKIKX0DER" } ] } }

• Sample files(if any): N/A
• Sample Response:

{ "sku": "wet601A", "status": "INVALID", "submissionId": "17df3de2a76a4d099142269672639d34", "issues": [ { "code": "90220", "message": "'merchant_suggested_asin' is required but not supplied.", "severity": "ERROR", "attributeNames": [ "merchant_suggested_asin" ], "categories": [ "MISSING_ATTRIBUTE" ] }, { "code": "90220", "message": "'condition_type' is required but not supplied.", "severity": "ERROR", "attributeNames": [ "condition_type" ], "categories": [ "MISSING_ATTRIBUTE" ] }, { "code": "90220", "message": "'externally_assigned_product_identifier' is required but not supplied.", "severity": "ERROR", "attributeNames": [ "externally_assigned_product_identifier" ], "categories": [ "MISSING_ATTRIBUTE" ] }, { "code": "90244", "message": "Invalid enumerated value 'United States' for attribute 'country_of_origin'.", "severity": "ERROR", "attributeNames": [ "country_of_origin" ], "categories": [ "INVALID_ATTRIBUTE" ] } ] }