`sale_price` in the feed is incorrect if the Magento's datadase mistakenly contains a `special_price` value for a configurable product

[dmitrii-fediuk]

We have had an issue with the Google shopping feed, I know you created a dynamic feed so prices and product should update but some products are showing incorrectly as a result of this shopping feed;https://www.tradefurniturecompany.co.uk/tfc-google-shopping

Can you advise if this is the correct feed to use? And if so why there are sale prices in products that are not listed with a sale price in the catalogue and how we can change them? This is what we are seeing;

These seem to be old delivery prices and also incorrect sale prices so I am not sure if the incorrect feed is being used but I cannot find this feed so cannot correct it, please advise!

upwork.com/ab/messages/rooms/room_8e141f0c39ea3e5091cd334db37aaef0/story_0e797632ae5bbb4fb0b7267aad9257f3?companyReference=711981728333447169&atTimestamp=1669829206117&sidebar=true

[dmitrii-fediuk]

[dmitrii-fediuk]

1) If a configrable product does not have the special_price set in the database (it can not be set via UI), and its child has a special_price:

{
    "base_price": 0,
    "catalog_rule_price": false,
    "configured_price": 0,
    "configured_regular_price": 0,
    "custom_option_price": [],
    "final_price": 333,
    "msrp_price": 0,
    "regular_price": 939.95,
    "special_price": false,
    "tier_price": false
}

2) If the same configrable product has the special_price set in the database (it can not be set via UI), and its child has a special_price:

{
    "base_price": 0,
    "final_price": 333,
    "regular_price": 939.95,
    "special_price": 479.95,
    "tier_price": false
}

Please note that other keys are absent in the hash.

3) If the same configrable product does not have the special_price set in the database (it can not be set via UI), and its children do not have a special_price:

{
    "base_price": 0,
    "final_price": 939.95,
    "regular_price": 939.95,
    "special_price": false,
    "tier_price": false
}