Warning: Delete Order - Shopify GDPR

Issue

The following warning appears with a list of order IDs:

Delete Order - Shopify GDPR. You are requested to delete the following orders and related information from your warehouse.

Environment

Connector: Shopify

Resolution

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:

• TRANSACTION
• ORDER_DISCOUNT_CODE
• DISCOUNT_APPLICATION
• ORDER_SHIPPING_LINE
• ORDER_NOTE_ATTRIBUTE
• ORDER_URL_TAG
• ORDER_TAG
• ORDER_RISK
• ORDER
• ORDER_LINE
• FULFILLMENT
• FULFILLMENT_EVENT
• ORDER_ADJUSTMENT
• REFUND
• FULFILLMENT_ORDER_LINE
• DRAFT_ORDER
• GIFT_CARD

Cause

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. See Shopify's mandatory webhooks documentation for more information.

We soft delete records by updating the row in the destination with _fivetran_deleted = TRUE. 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.