How do I inject multiple table items (indexed) in the Ingestion Pipelines ?

We have developed an open search service in Ohio. We have attached a screenshot of our service details (IngestionPipelines.png).

In that open search, we are inserting data from the Ohio region table (ProductsList-mrnq4x7gv5hn7kahw7x63evkaq-dev).

At the time, the table item structure was linked to another table item with an index, and we have included the model JSON.

{
    "ProductCategoryId": "150",
    "ProductCategoryName": "Software Products",
    "ProductId": "A01398",
    "ProductName": "Talkabout T8367",
    "ProductPrice": 15.7,
    "id": "A01398",
    "ProductsDiscounts": {
        "items": [
            {
                "Customer": "CP100140",
                "ProductDiscount": -5,
                "id": "00000000-0001-1DDF-BA84-90CC8386DCE3-A01398",
                "productID": "A01398"
            }
        ]
    },
    "ProductsPrices": {
        "items": [
            {
                "ProductPrice": "1400$",
                "ProductPriceCurrencyCode": "USD",
                "id": "00000000-0001-1DDF-BA84-90CC8386DCE3-A01398",
                "productID": "A01398"
            }
        ]
    },
    "UserFavouriteProducts": {
        "items": [
            {
                "FavouriteStatus": "active",
                "id": "ecc8381f-3775-48fd-a10f-b9dd5c148eaa",
                "productID": "A01398"
            }
        ]
    }
}

The two tables are product price (ProductPrices-mrnq4x7gv5hn7kahw7x63evkaq-dev) and product discount (ProductDiscounts-mrnq4x7gv5hn7kahw7x63evkaq-dev).

We created those tables within the Amplify application. We have attached screenshots of that amplify schema.

Following injection, just the initial table elements were uploaded to the open search, not the related table items. We have included the JSON file.

{ "ProductCategoryId": "150", "ProductCategoryName": "Software Products", "ProductId": "A01398", "ProductName": "Talkabout T8367", "ProductPrice": 15.7, "id": "A01398", "ProductsDiscounts": "00000000-0001-1DDF-BA84-90CC8386DCE3-A01398", "ProductsPrices": "00000000-0001-1DDF-BA84-90CC8386DCE3-A01398", "UserFavouriteProducts":"ecc8381f-3775-48fd-a10f-b9dd5c148eaa", }

We now need instructions on how to set up an open search with Serverless and upload many table elements.