Shop_Receipt2 with PK shop_id = XXXXXXXX AND receipt_id = YYYYYYYYYY does not exist

[dikshantniraula-333]

Orders disappear after being fetched via Etsy API (Shop_Receipt2 not found)

Hi Etsy community,

I’m running into an issue across several Etsy shops when fetching orders through the API, and I’d like to know if anyone else has experienced this or has insights into why it happens.

What’s happening

• My app fetches orders for a shop every few minutes.
• The order data is saved successfully in my system when it’s first retrieved.
• However, after some time, the same order no longer seems to exist in Etsy.

API response

When I call getShopReceipt with the correct shop_id and receipt_id, I get this error:

{
  "error": "Shop_Receipt2 with PK shop_id = <actual_shop_id> AND receipt_id = <actual_receipt_id> does not exist"
}

Any input from the Etsy team or from other developers in the community who may have run into this would be extremely helpful.  

Looking forward to your insights and possible workarounds.  
Thanks for your time and support! 🙏