Shopify Warning: Delete Order - Shopify GDPR
You may encounter the following warning, along with a list of order IDs:
Delete Order - Shopify GDPR. You are requested to delete the following orders and related information from your warehouse.
What causes the Delete Order error?
This issue occurs when we receive mandatory webhooks from Shopify containing a list of IDs for orders that you must delete from your destination. This may happen if you delete Personally Identifiable Information (PII) from Shopify but don't delete it from the destination, or if a customer requests that you delete their data. For more information, see Shopify's mandatory webhooks documentation.
We soft delete records by updating _fivetran_deleted = TRUE for the rows in your destination. However, we don't hard delete records. Therefore, to comply with Shopify's GDPR policy, we display the above warning when we receive mandatory webhooks regarding order deletion.
How to resolve the Delete Order error
To resolve this issue, delete all data associated with the orders mentioned in the warning message from your destination. The following tables may contain data related to the applicable orders:
DISCOUNT_APPLICATIONDRAFT_ORDERFULFILLMENTFULFILLMENT_EVENTFULFILLMENT_ORDER_LINEGIFT_CARDORDERORDER_ADJUSTMENTORDER_DISCOUNT_CODEORDER_LINEORDER_NOTE_ATTRIBUTEORDER_RISKORDER_SHIPPING_LINEORDER_TAGORDER_URL_TAGREFUNDTRANSACTION