Requirements

Database tables

Smart Add-Ons creates 10 custom database tables on activation. All tables use the WordPress table prefix (default wp_) and run automatically — no manual SQL is required.

• wp_saue_addon_groups — addon group definitions
• wp_saue_addon_fields — field definitions per group
• wp_saue_pricing_rules — per-option pricing rules
• wp_saue_conditions — show/hide rules attached to a field or group
• wp_saue_condition_rules — the individual clauses within a condition
• wp_saue_assignments — which product, category, or global scope a group applies to
• wp_saue_analytics_events — storefront interaction events
• wp_saue_analytics_daily — daily rollup aggregates
• wp_saue_license — this site’s license key, plan, and status
• wp_saue_ab_tests — A/B test configurations

Dropdown/radio options live in a JSON column on wp_saue_addon_fields, not a separate table. Customer selections are stored as order-item meta on the WooCommerce order itself, not a Smart Add-Ons table. A/B test variant assignments are not stored in a table either — each visitor’s variant is kept in their WooCommerce customer session, so running a test adds no per-visitor database rows.

PHP extensions required

These are standard PHP extensions bundled with most hosting environments:

• json — for REST API and config handling
• mbstring — for multi-byte string handling in field text
• fileinfo — for MIME type validation on file uploads
• openssl — for JWT license token validation