✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView for Amazon Pay for WooCommerce: orders & charge IDs as tables

Amazon Pay for WooCommerce writes Amazon charge IDs, reference IDs, and authorization state into WooCommerce order meta. SleekView reads wc_orders joined with wc_orders_meta and renders Amazon Pay orders as one queryable audit grid.

♾️ Lifetime License available

SleekView table view for Amazon Pay for WooCommerce

Amazon Pay audit without per-order drilldown

The official Amazon Pay extension persists each transaction's amazon_charge_id, amazon_charge_permission_id, amazon_reference_id, and capture state on the order row via WooCommerce order meta. With HPOS enabled, that data lives in wc_orders_meta against wc_orders; on legacy stores it sits in wp_postmeta against shop_order posts.

The default WooCommerce orders screen shows none of those IDs as columns. Reconciling Amazon settlement reports against the store currently means exporting orders, joining the CSV against the Amazon dashboard, and chasing mismatches one order at a time. There's no built-in filter for "authorized but not yet captured" or "declined by Amazon".

SleekView reads wc_orders joined with wc_orders_meta and surfaces amazon_charge_id, amazon_charge_permission_id, and capture status as first-class columns. Inline edits to order status route through the WooCommerce CRUD layer so capture, refund, and notification hooks fire exactly as the gateway expects.

Workflow

Compose an Amazon Pay audit view in minutes

1

Pick the order source

Point at wc_orders (HPOS) or shop_order posts and filter payment_method to amazon_payments_advanced. SleekView detects HPOS automatically.
2

Add Amazon meta columns

Drag amazon_charge_id, amazon_charge_permission_id, amazon_reference_id, and capture state from the column picker. Each is sortable and filterable from the column header.
3

Save the audit views

Build named views for authorized-not-captured, captured-this-week, refund-pending, and declined-by-Amazon. Each is one filter combination saved per role.
4

Edit through the CRUD layer

Inline status changes route through WooCommerce order CRUD so Amazon Pay's gateway hooks fire as expected. Bulk capture or refund runs row-by-row through the same path.

Sample columns

A typical Amazon Pay order view

Joins wc_orders with wc_orders_meta to expose amazon_charge_id and amazon_charge_permission_id as sortable columns.
Source: wp_wc_orders + wp_wc_orders_meta (HPOS) or wp_posts (post_type=shop_order) + wp_postmeta
Order Status Customer Total Amazon charge ID Date
#48214 Completed alex@studio.co $84.00 S01-1234567 Apr 24
#48213 Authorized ria@design.io $132.50 S01-1234566 Apr 24
#48212 Completed tom@hello.dev $48.00 S01-1234565 Apr 23
#48211 Declined mia@brew.coop $76.00 S01-1234564 Apr 23

Comparison

Default Amazon Pay for WooCommerce admin vs SleekView

Default Amazon Pay for WooCommerce admin

  • Amazon charge IDs and reference IDs are hidden inside per-order meta boxes
  • No column or filter for amazon_charge_permission_id in the WooCommerce orders screen
  • Authorized-but-not-captured orders aren't a default filter
  • Reconciling against Amazon settlement reports requires CSV export plus manual joins
  • Refund references from Amazon aren't surfaced inline

SleekView

  • Read amazon_charge_id, amazon_charge_permission_id, and capture state as real columns
  • Filter to authorized-not-yet-captured orders for daily capture sweeps
  • Sort by Amazon charge ID to match Amazon settlement reports row-for-row
  • Inline-edit order status with gateway hooks intact
  • Save per-team views (finance, fulfilment, support) with capability gates

Features

What SleekView gives you for Amazon Pay for WooCommerce

Charge IDs as first-class columns

Pivot amazon_charge_id, amazon_charge_permission_id, and amazon_reference_id from wc_orders_meta into named columns. Sorting and filtering by Amazon ID becomes one click instead of a custom SQL query.

Capture state filters

Build a saved view for authorized-but-not-captured orders so capture sweeps run from one screen. Mirror the same pattern for refund-pending and declined-by-Amazon.

Inline edits through the CRUD layer

Status changes route through WooCommerce's order CRUD so Amazon Pay's capture, refund, and notification hooks fire as expected. Bulk operations iterate per row through the same path.

Audience

Who uses SleekView for Amazon Pay for WooCommerce

Finance

Reconcile Amazon settlement reports against wc_orders sorted by amazon_charge_id. Filter by date range and currency for monthly close without exporting CSVs.

Fulfilment

Filter to captured-and-paid Amazon Pay orders ready to ship, with shipping address and line items visible inline. No per-order click-through for the daily pick list.

Support

Look up a customer's Amazon-paid orders by email with the charge ID and capture status on the row. Refund references surface inline during the call.

The bigger picture

Why BNPL and wallet gateways need joined order views

Amazon Pay sits in a category of WooCommerce gateways that record their own external transaction IDs against each order, and the operational question for every store running one is the same: which orders did the gateway actually take money for, and which are still in an in-between state. With Amazon Pay specifically, the authorize-then-capture flow creates a window where an order is authorized but not yet captured, and that window is exactly when finance needs to act before the authorization expires. The default WooCommerce orders screen surfaces none of that on the row, so finance teams export CSVs, join them against Amazon's settlement report by hand, and chase exceptions in a spreadsheet.

SleekView's job here is to put amazon_charge_id and capture state on the row so the same audit becomes one filtered table. Inline edits route through the gateway's CRUD path so captures, refunds, and webhook fires behave exactly like manual admin actions. The merchant still has the standard Orders screen if they prefer it; the audit surface is what changes.

Questions

Common questions about SleekView for Amazon Pay for WooCommerce

Yes. With HPOS enabled, Amazon Pay writes to wc_orders plus wc_orders_meta; without HPOS it writes to wp_posts (shop_order) plus wp_postmeta. SleekView reads whichever store is active and keeps the column mapping identical so views survive the HPOS migration.

 

amazon_charge_id, amazon_charge_permission_id, amazon_reference_id, and the capture-state flags the extension writes per order. The column picker lists every Amazon-prefixed meta key actually present in your data.

 

Bulk status changes route through WooCommerce's order CRUD, so each row triggers Amazon Pay's capture hook exactly like a manual capture in the order screen. No special bulk-mode that skips gateway side effects.

 

Yes. Refund records linked to the parent order via the standard WooCommerce refund relationship appear as a joinable child table. Filter to orders with refunds in the last 30 days for the dispute queue.

 

Yes, when the extension writes those fields to order meta. SleekView exposes any meta key with values present in your data, so multi-merchant configurations get a filterable column without code.

 

Currency lives on each order row. Filter or group by currency to keep Amazon Pay reconciliation in EUR, USD, and GBP separate instead of mixed into one total.

 

Yes. Saved views are gated by WordPress capability, so finance lands on a reconciliation view with Amazon IDs and totals, fulfilment on a captured-ready-to-ship view, and support on a customer-rooted lookup.

 

Queries hit indexed columns on wc_orders (id, status, date_created_gmt). Joined meta filters use wc_orders_meta indexes; keep heavier aggregates on detail views and lighter columns on triage views for fast pagination.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView