Pending SAP Uploads

Objects staged and ready or blocked for SAP sync.
Object type Pending Failed Responsible worker Last run Count criteria
Customers
Staging to SAP customer sync
0 0 Open worker 25 Aug 00:48 (Success) Staged customers where IsProcessed = 0.
Invoices
Staging to SAP invoice sync
0 1 Open worker 25 Aug 00:50 (Warning) Active non-test orders without an SAP document/import status.
Payments
Staging to SAP payment sync
3080 5 Open worker 25 Aug 00:28 (Success) Successful payment transactions where PaymentSyncStatus is not set.
Credit notes
Staging to SAP returns sync
56 0 Open worker 25 Aug 00:33 (Warning) Shopify returns where SapSyncedAt is blank and a successful refund transaction exists.
Amendments
Staging to SAP amendment sync
110 0 Open worker 25 Aug 00:32 (Warning) Shopify order total exceeds current SAP invoice total.

Shopify to Staging Workflows

These streams pull Shopify data into the staging database.
Workflow Data Flow Status Watermark Last Success Source Message
Shopify customers ingest
Pulls changed Shopify customers into staging.
Shopify -> Staging
Ingest
Success 24 Aug 14:46 25 Aug 00:48 ShopifySyncCursor - Open
Shopify orders ingest
Pulls changed Shopify orders into staging.
Shopify -> Staging
Ingest
Success 24 Aug 15:18 25 Aug 00:48 ShopifySyncCursor - Open
Shopify transactions ingest
Pulls Shopify payment and refund transactions into staging.
Shopify -> Staging
Ingest
Success 24 Aug 15:18 25 Aug 00:48 ShopifySyncCursor - Open
Shopify returns ingest
Pulls Shopify returns and return-linked refund details into staging.
Shopify -> Staging
Ingest
Success 24 Aug 15:18 25 Aug 00:48 ShopifySyncCursor - Open
Shopify deleted-order reconciliation
Checks currently-open staged orders against Shopify and flags any that no longer exist (deleted in Shopify).
Shopify -> Staging
Ingest
Success 25 Aug 00:48 25 Aug 00:48 ShopifySyncCursor - Open
Shopify orders force resync
Manual-only: full pass over every order, bypassing the payload-hash skip. Run this after adding a new mapped field to ProcParams.OrderHeader/OrderLine so existing orders whose Shopify JSON hasn't changed still pick it up.
Shopify -> Staging
Ingest
Success 01 Jan 00:00 24 Aug 21:21 ShopifySyncCursor - Open

Staging to SAP Workers

These workers read staging data and create or update SAP documents.
Worker Data Flow Status Last Run Duration Success / Failed Next Run Message
Staging to SAP invoice sync
SapInvoiceImport
Staging -> SAP
SAP Sync
Enabled 25 Aug 00:50 Warning 0m 4s 0 / 1 25 Aug 01:05 Open
Staging to SAP customer sync
CustomerSync
Staging -> SAP
SAP Sync
Enabled 25 Aug 00:48 Success 0m 0s 0 / 0 25 Aug 01:03 No customers. Open
Staging to SAP amendment sync
AmendmentDetection
Staging -> SAP
SAP Sync
Enabled 25 Aug 00:32 Warning 0m 17s 0 / 50 25 Aug 01:03 Open
Staging to SAP payment sync
PaymentSync
Staging -> SAP
SAP Sync
Disabled 25 Aug 00:28 Success 0m 0s 0 / 0 25 Aug 01:28 No payments. Open
Staging to SAP returns sync
ReturnsSync
Staging -> SAP
SAP Sync
Enabled 25 Aug 00:33 Warning 0m 0s 0 / 3 25 Aug 01:33 Open
Credit note correction
RefundCorrection
SAP -> SAP
Correction
Unknown 25 Aug 00:56 Success 0m 0s 0 / 0 25 Aug 00:57 Credit note correction queue checked. Open
Invoice customer correction
InvoiceCorrection
SAP -> Staging -> SAP
Correction
Unknown 25 Aug 00:56 Success 0m 0s 0 / 0 25 Aug 00:57 Invoice correction queue checked. Open