Description
PAC Order Bridge for WooCommerce connects WooCommerce directly to Claris FileMaker Server through the FileMaker Data API.
It is designed for FileMaker developers who want WooCommerce integration without having to write PHP, learn WordPress hooks, configure custom WooCommerce webhooks or add middleware.
The free edition provides a complete, usable workflow:
- listens only for the WooCommerce Completed order status;
- authenticates with the FileMaker Data API;
- executes a FileMaker script;
- passes only the WooCommerce order ID as
script.param; - closes the FileMaker Data API session;
- includes guided setup progress plus connection, script and end-to-end order tests;
- explains exactly what the FileMaker script receives through
Get ( ScriptParameter ); - provides actionable error messages and copyable support diagnostics;
- records the first successful live delivery locally in WordPress;
- uses HTTPS with certificate verification;
- stores the FileMaker password encrypted using WordPress security salts;
- supports WooCommerce HPOS.
The FileMaker script remains under your control. PAC handles the WooCommerce and FileMaker Data API plumbing; your FileMaker script receives the selected parameter and continues with your own business logic.
Official product page:
https://pacage.it/pac-order/
Technical documentation:
https://pacage.it/pac-order-documentation
Professional edition
PAC Order Bridge Professional turns the WooCommerce order lifecycle into a configurable FileMaker workflow. For each selected status, you can enable or disable delivery, choose a dedicated FileMaker script and choose its own payload. It supports Pending payment, Processing, On hold, Completed, Cancelled, Refunded and Failed, with immediate or background delivery, automatic retries, manual resend and diagnostics.
Each status can send the legacy order ID, the displayed order number, a compact JSON value, the complete order JSON or a custom template. The complete payload includes addresses, products, SKU and variation data, taxes, shipping, fees, coupons, refunds and metadata, so a FileMaker script can process the order without a second WooCommerce lookup. A status row with no custom script or payload inherits the global setting, while the order ID remains available for existing FileMaker scripts.
The Full order JSON option sends the WooCommerce order snapshot through script.param, including order fields, billing and shipping addresses, product lines, taxes, shipping lines, fees, coupons, metadata and refunds. It may contain personal or custom metadata from the order. It is available in Professional and is intended for FileMaker scripts that want the order data in one structured value.
Free is the focused Completed → order ID connector. Professional adds the per-status orchestration and structured payloads needed when FileMaker must react differently to payment, fulfilment, cancellation, refund or failure.
The free edition does not require a paid license and continues to work if Freemius usage opt-in is skipped.
5-minute setup
- Install and activate WooCommerce and PAC Order Bridge for WooCommerce.
- Open WooCommerce > Settings > Integrations > PAC Order Bridge.
- Enter the HTTPS FileMaker Server URL, Data API version, database, layout, script, username and password.
- Ensure the FileMaker account has the
fmrestextended privilege and access to the configured file, layout and script. - In FileMaker, create a field to store the WooCommerce order ID. Treat that ID as the stable external key for the WooCommerce order.
- In the FileMaker script, read the incoming value with
Get ( ScriptParameter )and store/use it in your workflow. - Run Test connection.
- Run Script test.
- Enter an existing WooCommerce order ID and run End-to-end order test.
- Enable PAC Order Bridge. When WooCommerce reports that the order has reached Completed, its WooCommerce order ID is sent to the configured FileMaker script.
The plugin settings page shows setup progress and tells you which step still needs attention.
External services
This plugin connects to external services only for the functions described below.
FileMaker Data API
When the administrator configures a FileMaker Server and runs a test or when a WooCommerce order reaches Completed, the plugin sends requests directly to that administrator-configured FileMaker Server. Authentication credentials, database/layout/script names and the WooCommerce order ID are transmitted to that server over HTTPS. PAC Age does not receive or proxy these requests.
Claris legal information: https://www.claris.com/company/legal/
Claris privacy policy: https://www.claris.com/company/legal/privacy.html
Freemius
The plugin includes the Freemius SDK for optional usage opt-in and for purchasing/managing the Professional edition. The free connector remains usable if the administrator skips the Freemius opt-in. When an administrator explicitly opts in, Freemius may receive the administrator’s name/email, site URL, product/version state, WordPress/PHP versions, site language and optional plugin/theme environment data as described by Freemius.
Freemius data practices: https://freemius.com/privacy/data-practices/
Freemius privacy policy: https://freemius.com/privacy/
Privacy
PAC Order Bridge does not send WooCommerce customer/order content to PAC Age. FileMaker communication goes directly to the FileMaker Server configured by the administrator. Freemius communication follows the opt-in and licensing behavior described in the External services section.
Trademarks
WooCommerce is a trademark of Automattic Inc. Claris and FileMaker are trademarks of Claris International Inc. PAC Order Bridge is not affiliated with or endorsed by Automattic or Claris.
FAQ
Do I need to know PHP, WordPress hooks or WooCommerce webhooks?
No. PAC Order Bridge handles the WordPress/WooCommerce and FileMaker Data API side. You configure the connection and write the FileMaker script that should run.
What does my FileMaker script receive?
In the free edition, it receives the WooCommerce order ID as the FileMaker script parameter. In Professional, you can choose the order ID, displayed order number, basic JSON, full order JSON or a custom template. For full order JSON, read the parameter with Get ( ScriptParameter ) and extract values with JSONGetElement, for example JSONGetElement ( $pacOrder ; "order_id" ).
Should I store the WooCommerce order ID in FileMaker?
Yes. Create a dedicated field for it and keep it as the external key that identifies the WooCommerce order. Do not rely on the displayed order number as the only technical identifier.
Does the free edition work without a paid license?
Yes. The free edition is fully functional for the documented Completed-status / order-ID workflow.
What happens if setup fails?
The settings page provides connection, script and end-to-end tests, actionable error messages and copyable diagnostics. Passwords, FileMaker session tokens and WooCommerce order/customer data are not included in the support diagnostics.
Does PAC Age receive my WooCommerce order data?
No. The connector communicates directly from your WordPress site to the FileMaker Server URL you configure. PAC Age does not proxy that connection.
Does it require HTTPS?
Yes. The free edition requires HTTPS and verifies the FileMaker Server certificate. Professional provides additional certificate-chain options for environments that need them.
Can I use a different WooCommerce trigger or send JSON?
Those are Professional features. Professional supports per-status WooCommerce triggers, a separate FileMaker script and payload for each enabled status, immediate or background delivery, order ID/number, basic JSON, full order JSON and custom templates, plus retries, manual resend and diagnostics. The free edition deliberately focuses on one predictable production path: Completed status, immediate delivery and WooCommerce order ID.
Does the plugin send setup progress or diagnostics to PAC Age automatically?
No. Setup progress, runtime status and the first successful delivery marker are stored locally in WordPress. Diagnostics are only copied when an administrator explicitly clicks the copy button.
Changelog
1.2.0
- Locked the Free production delivery path to the WooCommerce Completed status and the WooCommerce order ID as
script.param. - Added Professional order status synchronization for Pending payment, Processing, On hold, Completed, Cancelled, Refunded and Failed orders.
- Added a per-status enable switch, FileMaker script override and payload selection.
- Kept order ID delivery available for legacy FileMaker scripts while allowing different scripts and full JSON payloads for each status.
- Added per-status duplicate protection and retry routing for immediate and background delivery.
1.1.7
- Added the Professional Full order JSON parameter, delivering the complete WooCommerce order snapshot through
script.param. - Full order JSON includes order fields, billing and shipping addresses, product lines with SKU and variation data, taxes, shipping, fees, coupons, refunds and order metadata.
- Added FileMaker guidance for reading the complete payload with
Get ( ScriptParameter )andJSONGetElement. - Promoted the complete Professional payload capability in the Free-edition documentation and upgrade path.
1.1.6
- Added guided four-step onboarding from FileMaker configuration to the first successful order test.
- Added an in-plugin explanation of
Get ( ScriptParameter )so FileMaker developers can see exactly how the incoming value is received. - Added clearer, actionable setup and connection error messages.
- Added copyable Free-edition support diagnostics that exclude passwords, session tokens and WooCommerce order/customer content.
- Added a local first-successful-live-delivery marker and visible setup progress.
- Added direct documentation links to the PAC Age product page.
- Added Plugin URI and Author URI metadata.
- Professional receives the same onboarding improvements while retaining background delivery, retries, manual resend and advanced diagnostics.
- Fixed Professional background/retry Action Scheduler cleanup hook names on plugin deactivation.
- Fixed the Professional public-CA diagnostics lookup used by the diagnostics panel.
1.1.5
- Renamed to PAC Order Bridge for WooCommerce.
- Added WordPress.org-compliant prefixed identifiers and enqueued admin JavaScript.
- Unified Free and Professional into one Freemius deployment source.
- Free: paid order event → immediate FileMaker script call with WooCommerce order ID.
- Professional: additional triggers, order ID/number/basic JSON/full order JSON/custom template payloads, background delivery, retries, manual resend, custom CA support and diagnostics.
1.1.4
- Uses Freemius anonymous mode in the Free edition: no opt-in activation or email confirmation is required.
- Removes the voluntary Freemius opt-in/reconnect link from the Plugins screen.
- Renames the generic Freemius Upgrade action to the clearer “Upgrade to Professional”.
- Freemius manages the Professional pricing and checkout page directly.
- Added a clear Professional upgrade path while keeping the Free edition fully functional without registration.
- No changes to the WooCommerce-to-FileMaker delivery engine.
1.1.3
- First WordPress.org-ready free edition.
- Real-time payment-complete to FileMaker order-ID delivery.
- Connection, script and end-to-end tests.
- HTTPS certificate verification and encrypted FileMaker password storage.
- WooCommerce HPOS compatibility.