Migration from Flat File Template to JSON_LISTINGS_FEED Format

[isarzhan]

Hello,

We are currently using the following template:

TemplateType=fptcustomcustom Version=2021.0703 TemplateSignature=Q0hPQ09MQVRFX0NBTkRZ settings=contentLanguageTag=en_US&feedType=113&headerLanguageTag=en_US&metadataVersion=MatprodVkxBUHJvZC0xMDg4&primaryMarketplaceId=amzn1.mp.o.ATVPDKIKX0DER&templateIdentifier=89c2f7e7-66e0-4381-bade-cbd73f8659fb&timestamp=2021-07-03T21%3A37%3A19.625Z Use ENGLISH to fill this template.The top 3 rows are for Amazon.com use only. Do not modify or delete the top 3 rows
Product Type Seller SKU Product ID Product ID Type Product Name Item Type Keyword Unit Count Unit Count Type Is the Item Heat Sensitive? Is Product Expirable Main Image URL Quantity Your price Minimum Advertised Price Release Date Currency Manufacturer's Suggested Retail Price Product Expiration Type Restock Date Number of Items Fulfillment Center Shelf Life Handling Time Is Gift Wrap Available Package aQuantity Offer End Date Launch Date Max Order Quantity Merchant Shipping Group Offer Start Date Product Tax Code Offering Can Be Gift Messaged Condition Condition Note Sale Price Sale Start Date Sale End Date
feed_product_type item_sku external_product_id external_product_id_type item_name item_type unit_count unit_count_type is_heat_sensitive is_expiration_dated_product main_image_url quantity standard_price map_price merchant_release_date currency list_price product_expiration_type restock_date number_of_items fc_shelf_life fulfillment_latency offering_can_be_giftwrapped item_package_quantity offering_end_date product_site_launch_date max_order_quantity merchant_shipping_group_name offering_start_date product_tax_code offering_can_be_gift_messaged condition_type condition_note sale_price sale_from_date sale_end_date

We would like to convert this format into valid JSON.
Could you please show us an example of what the corresponding JSON structure would look like?
Thank you in advance!
Looking forward to your guidance.

[BrunnoPigatto]

Hello @isarzhan,

Thank you for your question. You can use the Listing Management Workflow Migration for the migration.

For understanding how to build the JSON payload, you can check the Product Type Definitions API v2020-09-01 Use Case Guide and a both tutorials:

1. How to Use Product Type Definitions API to Create Product JSON Payload - Part I
2. How to Use Product Type Definitions API to Create Product JSON Payload - Part II

Also, there are some other useful content you can use that covers the Listing Workflow through JSON:

1. Youtube Playlist - Listings API: Tutorials, Best Practices and Migration Guides
2. Sample Application

Thanks,
Brunno M.
Selling Partner API Developer Services

[isarzhan]

@BrunnoPigatto
We are currently experiencing an issue where the restock_date field is being successfully updated through the API and reflected correctly in the backend systems. However, this update does not appear on the frontend product detail pages on Amazon.
The body of request
"messages": [
{
"messageId": 1,
"sku": "777777",
"operationType": "PATCH",
"productType": "PRODUCT",
"patches": [
{
"op": "replace",
"path": "/attributes/fulfillment_availability",
"value": [
{
"fulfillment_channel_code": "DEFAULT",
"quantity": 7,
"restock_date": "2025-08-04",
"lead_time_to_ship_max_days": 1
}
]
},
{
"op": "replace",
"path": "/attributes/merchant_shipping_group",
"value": [
{
"value": "XXXX"
}
]
}
]
}
]