# Amazon Seller Central Item Listing

**URL:** <https://connective.celigo.com/t/amazon-seller-central-item-listing/3032>\
**Category:** Integration Apps\
**Tags:** amazon-seller-central, ftp, export, import, netsuite\
**Created:** [March 1, 2024, 9:40am UTC](https://connective.celigo.com/t/amazon-seller-central-item-listing/3032 "2024-03-01T09:40:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lakhanbhagnani](https://avatars.discourse-cdn.com/v4/letter/l/ce7236/32.png) [@lakhanbhagnani](https://connective.celigo.com/u/lakhanbhagnani)\
**Post date:** [March 1, 2024, 9:40am UTC](https://connective.celigo.com/t/amazon-seller-central-item-listing/3032/1 "2024-03-01T09:40:53Z")

</div>

### **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](https://sell.amazon.in/sell-online/list-your-products)).

**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](https://docs.google.com/spreadsheets/u/0/d/1r-jLvVk9k-zvmGRUZDR4-WXuZOuLoS2ABn-U4HNkyAA/edit)
- 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"] } ]}
```

 |