Amazon Seller Central Item Listing

Lakhan Bhagnani Integration Engineer
  • Edited
Answer Pro

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"

      ]

    }

  ]

}

 

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post