Hello Everyone,
I am implementing a custom flow to sync items from NetSuite to Amazon.
Current progress:
Step 1: Able to retrieve item data from NetSuite using a saved search
Step 2: Using the productType, I can fetch the corresponding product schema link
Step 3: Using that link, I am able to retrieve the full schema JSON of ProductTypes
Reason for this approach:
The API I am using (PUT /listings/2021-08-01/items/{sellerId}/{sku}) does not provide a fixed request body in the documentation. It appears that the request structure varies by product type. To handle this, I am dynamically fetching the schema to understand the required attributes.
Challenge:
The schema JSON is very large and complex. I am unsure how to dynamically construct the request body in Celigo for different product types based on this schema.
OR
Is there any other alternative approach to create items into Amazon with parent-child relationship scenarios?
Is there a way if i can only add basic and mandatory fields to one request body which should works for all productTypes?
Just wanted to clarify are you also using our Amazon integration app? because our IA uses POST /feeds/2021-06-30/documents which could help you if you are uploading files in a bulk items, in which you can also mimic this setup.
For your question of the parent-child relationship, If you use the Listings API (PUT) for a Parent and 4 Children, you have to make 5 separate API calls. if the Parent call fails but the Children succeed, your Amazon catalog becomes a mess of "orphaned" items.
With the Feeds API, you put the Parent and all Children into one single JSON file. Amazon processes them as a single logical unit. This ensures the relationship is "stitched" together correctly in one go.
If you wanted to continue using the PUT /listings/2021-08-01/items/{sellerId}/{sku} a lookup to fetch the schema is ideal to find the exact product type required for the item. I believe it should be /definitions/2020-09-01/productTypes/{{productType}}