✨ 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 Square for WooCommerce

Square for WooCommerce writes transaction IDs and location IDs to order meta. SleekView reads wc_orders_meta and renders Square-paid orders as a queryable audit grid that splits POS from online sales.

♾️ Lifetime License available

SleekView table view for Square for WooCommerce

Move per-location reconciliation out of the spreadsheet and into one table

Square's official WooCommerce extension persists each paid order's Square transaction ID and location ID in WooCommerce order metadata. Location ID is the channel signal: a Berlin POS register, a Hamburg POS register, and the online store each carry distinct values. The default WooCommerce orders screen treats them identically, with no column for location, no filter to split POS from online and no saved per-store view.

SleekView reads wp_wc_orders joined with wc_orders_meta and exposes Square location ID, transaction ID and refund references as columns on every row. Filter to a single POS location for a monthly per-store finance review. Sort by Square transaction ID to match against Square settlement reports. Saved views per location replace the CSV export per store the finance team used to do every month.

The plugin keeps owning the Square API and product sync. The table view owns the audit surface, so the location signal Square already writes stops hiding inside per-order panels and becomes a sortable, filterable workspace.

Workflow

How SleekView surfaces Square for WooCommerce data

1

Point at Square-paid orders

Pick wp_wc_orders filtered to payment_method square, joined with wc_orders_meta. Square location ID, transaction ID and refund meta all land as columns automatically.
2

Compose the columns

Drag in Order, Status, Total, Square location, Square transaction ID, Customer and Date. Reorder, hide or rename without a custom filter on manage_edit-shop_order_columns.
3

Filter and sort like a database

Filter to a single Square location ID for per-store reviews, sort by total descending to triage high-value POS sales, or filter by refund state to find chargeback clusters.
4

Save and gate the view

Name the view ("Berlin POS this month", "Hamburg refunds", "Online vs POS audit") and gate by capability so per-store managers, finance and support land on their slice.

Sample columns

A typical Square for WooCommerce order view

Rows from wp_wc_orders joined with wc_orders_meta, exposing Square location ID and transaction ID per order so the POS-versus-online split lives next to the row.
Source: wp_wc_orders
Order Status Total Square location Square ID Date
#48134 Completed $42.00 Berlin POS Lt9k...3a 2025-12-04 14:08
#48133 Completed $128.50 Online Lt9k...mZ 2025-12-04 13:51
#48132 Completed $18.00 Hamburg POS Lt9k...qV 2025-12-04 13:42
#48131 Refunded $74.00 Berlin POS Lt9k...8e 2025-12-04 12:09
#48130 Completed $254.00 Online Lt9k...rN 2025-12-04 11:30

Comparison

Default Square for WooCommerce admin vs SleekView

Default WooCommerce orders (Square plugin)

  • Square location ID lives in order meta but never appears as a column
  • POS-versus-online split requires manual CSV export per location
  • Square transaction ID surfaces only inside each order panel
  • No saved per-location view for monthly finance reviews
  • Reconciling Square's settlement reports needs the Square dashboard open alongside

SleekView

  • Every Square-paid order rendered as a queryable row
  • Square location ID, transaction ID and refund meta as real columns
  • Filter to a single POS location, online channel or specific date range
  • Saved views per role: per-store manager, finance reconciliation, support triage
  • Same dataset the Square charts dashboard aggregates

Features

What SleekView gives you for Square for WooCommerce

Location on the row

Square location ID lands as a column, so POS registers and the online store sit side by side on a single audit table.

Reconciliation-ready

Square transaction IDs render next to amount and date, so the row matches one-to-one against a Square settlement report line.

HPOS and legacy

Reads wc_orders_meta on HPOS or postmeta on legacy with the same column setup, so the view survives the HPOS migration unchanged.

Audience

Who uses SleekView for Square for WooCommerce

Multi-location retailers

Saved per-location view replaces the monthly CSV export per store the finance team used to do by hand.

Finance teams

Filter by date range and Square location ID, then export the matching rows for the monthly Square settlement reconciliation.

Support teams

Saved "Refunded Square orders" view turns POS dispute triage into a row-level workflow instead of an order-by-order crawl.

The bigger picture

Why Square's per-location signal deserves a real table

Square for WooCommerce is unusually rich about writing per-order metadata, including location IDs that distinguish each POS register from the online store. That signal is exactly what multi-location retailers need for finance and operations work, but the standard orders screen leaves it inside per-order panels with no column, no filter and no saved view. SleekView reads the same wc_orders_meta the gateway writes and renders Square location ID, transaction ID and refund state as audit columns, so the Berlin POS, the Hamburg POS and the online store stop competing for the same row.

The plugin keeps owning the Square API, refunds and product sync, while finance, store managers and support each land on the slice their work actually needs.

Questions

Common questions about SleekView for Square for WooCommerce

In WooCommerce order metadata: transaction ID, location ID and refund references. SleekView reads wc_orders_meta on HPOS or postmeta on legacy.

 

Yes. Each POS register and the online store have distinct Square location IDs, so a filter or a column-level split surfaces both channels in one view.

 

Refund order rows in WooCommerce carry the parent Square meta, so a saved "Refunded Square orders" view works without extra configuration.

 

No. SleekView reads wc_orders_meta on HPOS stores and postmeta on legacy stores, with the same column setup.

 

If the gateway writes card brand to order meta (some Square versions do, some do not), that meta becomes a filterable column. If absent, the column hides automatically.

 

No. SleekView only renders in the admin and reads existing tables. Checkout still talks to the Square API through the plugin unchanged.

 

No. The Square dashboard owns gateway-side data: payouts, fees and POS device management. SleekView audits what WooCommerce stores about each Square-paid order.

 

Yes. Saved views are gated by capability, so per-store managers see only their location, finance sees all, and contributors see nothing.

 

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