{"uid":"cap_UoqBBvGFE7713CEX9h8lc","slug":"opencart-order-export-reconciliation-654d8d60","name":"OpenCart Order Export Reconciliation","description":"Rebuilds the orders you supply inside a private, non-root OpenCart database and checks your export against what the native code computes. Each export row is matched to a ledger order, and every difference is named: a total that does not add up under the stated arithmetic policy, a currency conversion applied at the wrong point, a localized status that maps to nothing.","url":"https://agent.halowerk.com/v1/oss-opencart-order-export-reconciliation?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType"],"properties":{"type":{"const":"http"},"method":{"const":"POST"},"bodyType":{"const":"json"},"schemaUrl":{"type":"string","format":"uri"},"exampleUrl":{"type":"string","format":"uri"}},"additionalProperties":true}},"additionalProperties":true},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.005","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.005/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_5HKM64fQUG-hOv2pdPI0J","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.005","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Rebuilds OpenCart orders from a supplied export and identifies every discrepancy between your export rows and what the native OpenCart code computes — totals, currency conversions, and status mappings.","exampleAgentPrompt":"Can you reconcile my OpenCart order export against what the native platform computes? I need to find any rows where the totals don't add up under the stated arithmetic policy, currency conversions were applied at the wrong point, or order statuses don't map to anything recognized — here's the export data.","exampleUseCases":[{"title":"Monthly export audit for accounting","prompt":"I've exported all orders from last month's OpenCart store and I need to know which rows have totals that don't match what OpenCart's own code would compute — flag any arithmetic mismatches, bad currency conversions, and statuses that map to nothing."},{"title":"Multi-currency store discrepancy check","prompt":"Our OpenCart store operates in multiple currencies and I suspect some orders in this export had the currency conversion applied at the wrong point — can you rebuild the orders and tell me exactly which rows are wrong and why?"},{"title":"Order status localization validation","prompt":"We localized our OpenCart order statuses and I want to verify that every status in this export actually maps to a recognized native status — flag any that don't resolve and tell me what the nearest valid mapping would be."}],"resultDescription":"A structured reconciliation report listing each export row matched to its rebuilt ledger order, with named discrepancies for every mismatch found: incorrect totals (with expected vs. actual values under the stated arithmetic policy), currency conversions applied at the wrong stage, and localized status strings that resolve to nothing in the native OpenCart code.","failureModes":["Export rows that cannot be matched to any ledger order result in unmatched-row errors","Unsupported arithmetic policy identifiers cause a validation failure on the policy field","Malformed currency conversion metadata causes the conversion check to be skipped or error","Export files with missing required order fields return schema validation errors","Very large exports may exceed processing limits and return a timeout or partial result"],"whenToPreferThis":"Choose this endpoint when you need to audit or validate OpenCart order exports specifically against the native OpenCart codebase's own computation logic — not a generic CSV differ or accounting reconciliation tool. It is purpose-built for OpenCart's arithmetic policies, currency conversion pipeline, and status localization system, so it catches errors that a generic row-diff tool would miss. Prefer it when you need named, categorized discrepancies rather than just a list of differing values.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T00:33:27.948Z","isFirstParty":false,"canonicalSlug":"opencart-order-export-reconciliation-654d8d60"}