Changeset 3763005

Timestamp:

10/24/2026 09:26:11 AM (6 hours ago)

Author:

cinghaman

Message:

Release 0.7.2: fast Woo catalog search on large shops, published-only SKU search, require PHP 8.0

Location:

agentmatica-mcp-connector

Files:

• tags/0.7.2 (copied) (copied from agentmatica-mcp-connector/trunk )
• tags/0.7.2/agentmatica.php (modified) (2 diffs)
• tags/0.7.2/includes/class-ucp-catalog.php (modified) (7 diffs)
• tags/0.7.2/includes/modules/woocommerce/class-cart.php (modified) (1 diff)
• tags/0.7.2/includes/modules/woocommerce/class-catalog-search.php (modified) (1 diff)
• tags/0.7.2/readme.txt (modified) (3 diffs)
• trunk/agentmatica.php (modified) (2 diffs)
• trunk/includes/class-ucp-catalog.php (modified) (7 diffs)
• trunk/includes/modules/woocommerce/class-cart.php (modified) (1 diff)
• trunk/includes/modules/woocommerce/class-catalog-search.php (modified) (1 diff)
• trunk/readme.txt (modified) (3 diffs)

agentmatica-mcp-connector/tags/0.7.2/agentmatica.php

@@ -4 +4 @@
  * Plugin URI: https://agentmatica.com/docs/integrations/wordpress
  * Description: Free MCP connector for Agentmatica.com. Expose WordPress content and optional WooCommerce tools to Agentmatica visitor chat.
- * Version: 0.7.1
+ * Version: 0.7.2
  * Requires at least: 6.9
- * Requires PHP: 7.4
+ * Requires PHP: 8.0
  * Author: Thought Bulb
  * Author URI: https://thoughtbulb.dev
@@ -23 +23 @@
 }
 
-define( 'AGENTMATICA_VERSION', '0.7.1' );
+define( 'AGENTMATICA_VERSION', '0.7.2' );
 define( 'AGENTMATICA_PLUGIN_FILE', __FILE__ );
 define( 'AGENTMATICA_PLUGIN_DIR', plugin_dir_path( __FILE__ ) );

agentmatica-mcp-connector/tags/0.7.2/includes/class-ucp-catalog.php

@@ -44 +44 @@
 
                 if ( $query !== '' ) {
-                        $products = self::query_published_products_by_search( $query, $limit );
+                        $found    = self::query_published_products_by_search( $query, $limit );
+                        $products = $found['products'];
+                        $total    = $found['total'];
                 } else {
-                        $products = self::query_all_published_products( $limit );
-                }
-
-                $total_count = self::count_catalog_products();
-                $payload     = array();
+                        $found    = self::query_all_published_products( $limit );
+                        $products = $found['products'];
+                        $total    = $found['total'];
+                }
+
+                $payload = array();
 
                 foreach ( $products as $product ) {
@@ -73 +76 @@
                 }
 
-                return self::catalog_response( $payload, $total_count, $limit );
+                return self::catalog_response( $payload, $total, $limit );
         }
 
@@ -166 +169 @@
                         : $arguments;
                 $raw_id  = isset( $catalog['id'] ) ? (string) $catalog['id'] : '';
+                if ( $raw_id === '' && isset( $arguments['id'] ) ) {
+                        $raw_id = (string) $arguments['id'];
+                }
 
                 $product = self::load_product_by_identifier( $raw_id );
                 if ( ! $product ) {
+                        $name = '';
+                        if ( isset( $catalog['name'] ) ) {
+                                $name = sanitize_text_field( (string) $catalog['name'] );
+                        } elseif ( isset( $arguments['name'] ) ) {
+                                $name = sanitize_text_field( (string) $arguments['name'] );
+                        } elseif ( isset( $catalog['query'] ) ) {
+                                $name = sanitize_text_field( (string) $catalog['query'] );
+                        }
+
+                        if ( $name !== '' ) {
+                                return self::search_catalog(
+                                        array(
+                                                'query'      => $name,
+                                                'pagination' => array( 'limit' => 5 ),
+                                        )
+                                );
+                        }
+
                         return self::catalog_response( array() );
                 }
@@ -260 +284 @@
         }
 
-        private static function count_catalog_products(): int {
-                if ( ! function_exists( 'wc_get_products' ) ) {
+        /**
+         * Published product count from post counts (no product hydration).
+         */
+        private static function count_published_products(): int {
+                $counts = wp_count_posts( 'product' );
+                if ( ! is_object( $counts ) || ! isset( $counts->publish ) ) {
                         return 0;
                 }
 
-                $count = 0;
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
-                        if ( self::is_catalog_available( $product ) && self::format_product( $product ) ) {
-                                ++$count;
-                        }
-                }
-
-                return $count;
+                return (int) $counts->publish;
         }
 
@@ -308 +329 @@
          * Load published products for catalog browse (available to buy only).
          *
-         * @return list<WC_Product>
+         * @return array{products: list<WC_Product>, total: int}
          */
         private static function query_all_published_products( int $limit ): array {
+                $query = new WP_Query(
+                        array(
+                                'post_type'              => 'product',
+                                'post_status'            => 'publish',
+                                'posts_per_page'         => $limit,
+                                'paged'                  => 1,
+                                'orderby'                => 'date',
+                                'order'                  => 'DESC',
+                                'fields'                 => 'ids',
+                                'no_found_rows'          => false,
+                                'ignore_sticky_posts'    => true,
+                                'update_post_meta_cache' => false,
+                                'update_post_term_cache' => false,
+                                'meta_query'             => array( // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query -- instock browse only, paged.
+                                        array(
+                                                'key'   => '_stock_status',
+                                                'value' => 'instock',
+                                        ),
+                                ),
+                        )
+                );
+
                 $products = array();
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
+                foreach ( $query->posts as $product_id ) {
+                        $product = wc_get_product( (int) $product_id );
+                        if ( ! $product instanceof WC_Product ) {
+                                continue;
+                        }
                         if ( ! self::is_catalog_available( $product ) ) {
                                 continue;
                         }
-
                         $products[] = $product;
-                        if ( count( $products ) >= $limit ) {
-                                break;
-                        }
-                }
-
-                return $products;
-        }
-
-        /**
-         * @return list<WC_Product>
-         */
-        private static function load_published_product_objects( int $limit ): array {
-                $ids = get_posts(
-                        array(
-                                'post_type'      => 'product',
-                                'post_status'    => 'publish',
-                                'posts_per_page' => $limit,
-                                'orderby'        => 'date',
-                                'order'          => 'DESC',
-                                'fields'         => 'ids',
-                        )
-                );
-
-                if ( ! is_array( $ids ) ) {
-                        return array();
-                }
-
-                $products = array();
-                foreach ( $ids as $product_id ) {
-                        $product = wc_get_product( (int) $product_id );
-                        if ( $product instanceof WC_Product ) {
-                                $products[] = $product;
-                        }
-                }
-
-                return $products;
-        }
-
-        /**
-         * Named search — may include unavailable matches so the agent can explain stock status.
+                }
+
+                $total = (int) $query->found_posts;
+                if ( $total < 1 ) {
+                        $total = self::count_published_products();
+                }
+
+                return array(
+                        'products' => $products,
+                        'total'    => $total,
+                );
+        }
+
+        /**
+         * Named search — SQL/Woo search plus a capped PHP re-rank. Never hydrates the full catalogue.
          *
-         * @return list<WC_Product>
+         * @return array{products: list<WC_Product>, total: int}
          */
         private static function query_published_products_by_search( string $search, int $limit ): array {
                 $normalized = strtolower( trim( preg_replace( '/\s+/', ' ', $search ) ) );
                 if ( $normalized === '' ) {
-                        return array();
-                }
+                        return array(
+                                'products' => array(),
+                                'total'    => 0,
+                        );
+                }
+
+                $candidate_limit = min( 100, max( $limit * 5, 40 ) );
+                $found           = self::search_published_product_ids( $normalized, $candidate_limit );
+                $ids             = $found['ids'];
+                $total           = $found['total'];
 
                 $scored = array();
-
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
+                foreach ( $ids as $product_id ) {
+                        $product = wc_get_product( $product_id );
+                        if ( ! $product instanceof WC_Product ) {
+                                continue;
+                        }
+
                         $score = Agentmatica_Catalog_Search::product_match_score( $product, $search );
                         if ( $score <= 0 ) {
-                                continue;
+                                $score = 10;
                         }
 
                         $scored[] = array(
                                 'score'   => $score,
+                                'id'      => $product_id,
                                 'product' => $product,
                         );
@@ -384 +418 @@
                         $scored,
                         static function ( array $left, array $right ): int {
-                                return $right['score'] <=> $left['score'];
+                                $cmp = $right['score'] <=> $left['score'];
+                                if ( 0 !== $cmp ) {
+                                        return $cmp;
+                                }
+
+                                return $left['id'] <=> $right['id'];
                         }
                 );
@@ -396 +435 @@
                 }
 
-                return $products;
+                if ( $total < count( $products ) ) {
+                        $total = count( $products );
+                }
+
+                return array(
+                        'products' => $products,
+                        'total'    => $total,
+                );
+        }
+
+        /**
+         * @return array{ids: list<int>, total: int}
+         */
+        private static function search_published_product_ids( string $search, int $limit ): array {
+                $ids   = array();
+                $total = 0;
+
+                $sku_id = function_exists( 'wc_get_product_id_by_sku' ) ? wc_get_product_id_by_sku( $search ) : 0;
+                if ( $sku_id ) {
+                        $sku_product = wc_get_product( $sku_id );
+                        if ( $sku_product instanceof WC_Product_Variation ) {
+                                $sku_id = (int) $sku_product->get_parent_id();
+                        }
+                        // wc_get_product_id_by_sku() matches drafts and private products too.
+                        if ( $sku_id > 0 && get_post_status( $sku_id ) === 'publish' ) {
+                                $ids[] = $sku_id;
+                        }
+                }
+
+                $query = new WP_Query(
+                        array(
+                                'post_type'              => 'product',
+                                'post_status'            => 'publish',
+                                'posts_per_page'         => $limit,
+                                's'                      => $search,
+                                'fields'                 => 'ids',
+                                'no_found_rows'          => false,
+                                'ignore_sticky_posts'    => true,
+                                'update_post_meta_cache' => false,
+                                'update_post_term_cache' => false,
+                        )
+                );
+
+                foreach ( $query->posts as $product_id ) {
+                        $ids[] = (int) $product_id;
+                }
+                $total = max( $total, (int) $query->found_posts, count( $ids ) );
+
+                $title_found = self::search_product_ids_by_title_tokens( $search, $limit );
+                $ids         = array_merge( $title_found['ids'], $ids );
+                $total       = max( $total, $title_found['total'] );
+
+                $ids = array_values( array_unique( array_filter( array_map( 'intval', $ids ) ) ) );
+
+                return array(
+                        'ids'   => $ids,
+                        'total' => $total,
+                );
+        }
+
+        /**
+         * Title AND-match for all query tokens (older fixtures WP `s=` ranking can drop).
+         *
+         * @return array{ids: list<int>, total: int}
+         */
+        private static function search_product_ids_by_title_tokens( string $search, int $limit ): array {
+                global $wpdb;
+
+                $words  = preg_split( '/\s+/', $search );
+                $tokens = array();
+                foreach ( false === $words ? array() : $words as $word ) {
+                        $word = trim( (string) $word );
+                        if ( strlen( $word ) < 3 ) {
+                                continue;
+                        }
+                        $tokens[] = $word;
+                }
+                $tokens = array_values( array_unique( $tokens ) );
+                if ( $tokens === array() ) {
+                        return array(
+                                'ids'   => array(),
+                                'total' => 0,
+                        );
+                }
+
+                $posts      = $wpdb->posts;
+                $conditions = array( "post_type = 'product'", "post_status = 'publish'" );
+                $values     = array();
+                foreach ( $tokens as $token ) {
+                        $conditions[] = 'post_title LIKE %s';
+                        $values[]     = '%' . $wpdb->esc_like( $token ) . '%';
+                }
+
+                $where    = implode( ' AND ', $conditions );
+                $values[] = $limit;
+
+                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare -- `$posts` is `$wpdb->posts`; `$where` is LIKE %s placeholders.
+                $ids = $wpdb->get_col(
+                        $wpdb->prepare(
+                                "SELECT ID FROM {$posts} WHERE {$where} ORDER BY ID ASC LIMIT %d",
+                                ...$values
+                        )
+                );
+
+                $count_values = array_slice( $values, 0, -1 );
+                $count        = $wpdb->get_var(
+                        $wpdb->prepare(
+                                "SELECT COUNT(ID) FROM {$posts} WHERE {$where}",
+                                ...$count_values
+                        )
+                );
+                // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
+
+                return array(
+                        'ids'   => array_map( 'intval', is_array( $ids ) ? $ids : array() ),
+                        'total' => (int) $count,
+                );
         }
 

agentmatica-mcp-connector/tags/0.7.2/includes/modules/woocommerce/class-cart.php

@@ -20 +20 @@
 
         public static function init(): void {
-                add_action( 'init', array( __CLASS__, 'register_checkout_redirect_route' ) );
-                add_action( 'init', array( __CLASS__, 'register_sync_storefront_cart_route' ) );
-                add_action( 'init', array( __CLASS__, 'register_read_storefront_cart_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_checkout_redirect_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_sync_storefront_cart_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_read_storefront_cart_route' ) );
                 add_action( 'template_redirect', array( __CLASS__, 'maybe_handle_checkout_redirect' ) );
         }

agentmatica-mcp-connector/tags/0.7.2/includes/modules/woocommerce/class-catalog-search.php

@@ -123 +123 @@
                 if ( str_contains( $title, $normalized ) ) {
                         return 90;
+                }
+
+                $words = preg_split( '/\s+/', $normalized );
+                $words = false === $words ? array() : array_values(
+                        array_filter(
+                                $words,
+                                static function ( string $word ): bool {
+                                        return strlen( $word ) >= 2;
+                                }
+                        )
+                );
+                if ( $words !== array() ) {
+                        $title_hits = 0;
+                        foreach ( $words as $word ) {
+                                if ( self::word_matches_haystack( $word, $title ) ) {
+                                        ++$title_hits;
+                                }
+                        }
+                        if ( $title_hits === count( $words ) ) {
+                                return 85;
+                        }
                 }
 

agentmatica-mcp-connector/tags/0.7.2/readme.txt

@@ -4 +4 @@
 Requires at least: 6.9
 Tested up to: 7.1
-Requires PHP: 7.4
-Stable tag: 0.7.1
+Requires PHP: 8.0
+Stable tag: 0.7.2
 License: GPLv2 or later
 License URI: https://www.gnu.org/licenses/gpl-2.0.html
@@ -97 +97 @@
 == Changelog ==
 
+= 0.7.2 =
+* WooCommerce `search_catalog` no longer loads the entire catalogue on each chat search (SQL + capped re-rank). Fixes timeouts on large shops.
+* `get_product` can resolve by product name when `id` is missing.
+* Checkout and storefront-cart REST routes register on `rest_api_init`.
+* An exact SKU search only returns published products.
+* Requires PHP 8.0. Earlier versions already needed it to load.
+
 = 0.7.1 =
 * Fixed: order attribution was sent to an address that does not exist, so sales made through the chat were not counted in Agentmatica Insights.
@@ -134 +141 @@
 == Upgrade Notice ==
 
+= 0.7.2 =
+Woo catalog search no longer times out on large inventories. Update recommended for Agentmatica chat.
+
 = 0.7.1 =
 Fixes order attribution so chat sales appear in Insights. Update recommended.

agentmatica-mcp-connector/trunk/agentmatica.php

@@ -4 +4 @@
  * Plugin URI: https://agentmatica.com/docs/integrations/wordpress
  * Description: Free MCP connector for Agentmatica.com. Expose WordPress content and optional WooCommerce tools to Agentmatica visitor chat.
- * Version: 0.7.1
+ * Version: 0.7.2
  * Requires at least: 6.9
- * Requires PHP: 7.4
+ * Requires PHP: 8.0
  * Author: Thought Bulb
  * Author URI: https://thoughtbulb.dev
@@ -23 +23 @@
 }
 
-define( 'AGENTMATICA_VERSION', '0.7.1' );
+define( 'AGENTMATICA_VERSION', '0.7.2' );
 define( 'AGENTMATICA_PLUGIN_FILE', __FILE__ );
 define( 'AGENTMATICA_PLUGIN_DIR', plugin_dir_path( __FILE__ ) );

agentmatica-mcp-connector/trunk/includes/class-ucp-catalog.php

@@ -44 +44 @@
 
                 if ( $query !== '' ) {
-                        $products = self::query_published_products_by_search( $query, $limit );
+                        $found    = self::query_published_products_by_search( $query, $limit );
+                        $products = $found['products'];
+                        $total    = $found['total'];
                 } else {
-                        $products = self::query_all_published_products( $limit );
-                }
-
-                $total_count = self::count_catalog_products();
-                $payload     = array();
+                        $found    = self::query_all_published_products( $limit );
+                        $products = $found['products'];
+                        $total    = $found['total'];
+                }
+
+                $payload = array();
 
                 foreach ( $products as $product ) {
@@ -73 +76 @@
                 }
 
-                return self::catalog_response( $payload, $total_count, $limit );
+                return self::catalog_response( $payload, $total, $limit );
         }
 
@@ -166 +169 @@
                         : $arguments;
                 $raw_id  = isset( $catalog['id'] ) ? (string) $catalog['id'] : '';
+                if ( $raw_id === '' && isset( $arguments['id'] ) ) {
+                        $raw_id = (string) $arguments['id'];
+                }
 
                 $product = self::load_product_by_identifier( $raw_id );
                 if ( ! $product ) {
+                        $name = '';
+                        if ( isset( $catalog['name'] ) ) {
+                                $name = sanitize_text_field( (string) $catalog['name'] );
+                        } elseif ( isset( $arguments['name'] ) ) {
+                                $name = sanitize_text_field( (string) $arguments['name'] );
+                        } elseif ( isset( $catalog['query'] ) ) {
+                                $name = sanitize_text_field( (string) $catalog['query'] );
+                        }
+
+                        if ( $name !== '' ) {
+                                return self::search_catalog(
+                                        array(
+                                                'query'      => $name,
+                                                'pagination' => array( 'limit' => 5 ),
+                                        )
+                                );
+                        }
+
                         return self::catalog_response( array() );
                 }
@@ -260 +284 @@
         }
 
-        private static function count_catalog_products(): int {
-                if ( ! function_exists( 'wc_get_products' ) ) {
+        /**
+         * Published product count from post counts (no product hydration).
+         */
+        private static function count_published_products(): int {
+                $counts = wp_count_posts( 'product' );
+                if ( ! is_object( $counts ) || ! isset( $counts->publish ) ) {
                         return 0;
                 }
 
-                $count = 0;
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
-                        if ( self::is_catalog_available( $product ) && self::format_product( $product ) ) {
-                                ++$count;
-                        }
-                }
-
-                return $count;
+                return (int) $counts->publish;
         }
 
@@ -308 +329 @@
          * Load published products for catalog browse (available to buy only).
          *
-         * @return list<WC_Product>
+         * @return array{products: list<WC_Product>, total: int}
          */
         private static function query_all_published_products( int $limit ): array {
+                $query = new WP_Query(
+                        array(
+                                'post_type'              => 'product',
+                                'post_status'            => 'publish',
+                                'posts_per_page'         => $limit,
+                                'paged'                  => 1,
+                                'orderby'                => 'date',
+                                'order'                  => 'DESC',
+                                'fields'                 => 'ids',
+                                'no_found_rows'          => false,
+                                'ignore_sticky_posts'    => true,
+                                'update_post_meta_cache' => false,
+                                'update_post_term_cache' => false,
+                                'meta_query'             => array( // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query -- instock browse only, paged.
+                                        array(
+                                                'key'   => '_stock_status',
+                                                'value' => 'instock',
+                                        ),
+                                ),
+                        )
+                );
+
                 $products = array();
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
+                foreach ( $query->posts as $product_id ) {
+                        $product = wc_get_product( (int) $product_id );
+                        if ( ! $product instanceof WC_Product ) {
+                                continue;
+                        }
                         if ( ! self::is_catalog_available( $product ) ) {
                                 continue;
                         }
-
                         $products[] = $product;
-                        if ( count( $products ) >= $limit ) {
-                                break;
-                        }
-                }
-
-                return $products;
-        }
-
-        /**
-         * @return list<WC_Product>
-         */
-        private static function load_published_product_objects( int $limit ): array {
-                $ids = get_posts(
-                        array(
-                                'post_type'      => 'product',
-                                'post_status'    => 'publish',
-                                'posts_per_page' => $limit,
-                                'orderby'        => 'date',
-                                'order'          => 'DESC',
-                                'fields'         => 'ids',
-                        )
-                );
-
-                if ( ! is_array( $ids ) ) {
-                        return array();
-                }
-
-                $products = array();
-                foreach ( $ids as $product_id ) {
-                        $product = wc_get_product( (int) $product_id );
-                        if ( $product instanceof WC_Product ) {
-                                $products[] = $product;
-                        }
-                }
-
-                return $products;
-        }
-
-        /**
-         * Named search — may include unavailable matches so the agent can explain stock status.
+                }
+
+                $total = (int) $query->found_posts;
+                if ( $total < 1 ) {
+                        $total = self::count_published_products();
+                }
+
+                return array(
+                        'products' => $products,
+                        'total'    => $total,
+                );
+        }
+
+        /**
+         * Named search — SQL/Woo search plus a capped PHP re-rank. Never hydrates the full catalogue.
          *
-         * @return list<WC_Product>
+         * @return array{products: list<WC_Product>, total: int}
          */
         private static function query_published_products_by_search( string $search, int $limit ): array {
                 $normalized = strtolower( trim( preg_replace( '/\s+/', ' ', $search ) ) );
                 if ( $normalized === '' ) {
-                        return array();
-                }
+                        return array(
+                                'products' => array(),
+                                'total'    => 0,
+                        );
+                }
+
+                $candidate_limit = min( 100, max( $limit * 5, 40 ) );
+                $found           = self::search_published_product_ids( $normalized, $candidate_limit );
+                $ids             = $found['ids'];
+                $total           = $found['total'];
 
                 $scored = array();
-
-                foreach ( self::load_published_product_objects( -1 ) as $product ) {
+                foreach ( $ids as $product_id ) {
+                        $product = wc_get_product( $product_id );
+                        if ( ! $product instanceof WC_Product ) {
+                                continue;
+                        }
+
                         $score = Agentmatica_Catalog_Search::product_match_score( $product, $search );
                         if ( $score <= 0 ) {
-                                continue;
+                                $score = 10;
                         }
 
                         $scored[] = array(
                                 'score'   => $score,
+                                'id'      => $product_id,
                                 'product' => $product,
                         );
@@ -384 +418 @@
                         $scored,
                         static function ( array $left, array $right ): int {
-                                return $right['score'] <=> $left['score'];
+                                $cmp = $right['score'] <=> $left['score'];
+                                if ( 0 !== $cmp ) {
+                                        return $cmp;
+                                }
+
+                                return $left['id'] <=> $right['id'];
                         }
                 );
@@ -396 +435 @@
                 }
 
-                return $products;
+                if ( $total < count( $products ) ) {
+                        $total = count( $products );
+                }
+
+                return array(
+                        'products' => $products,
+                        'total'    => $total,
+                );
+        }
+
+        /**
+         * @return array{ids: list<int>, total: int}
+         */
+        private static function search_published_product_ids( string $search, int $limit ): array {
+                $ids   = array();
+                $total = 0;
+
+                $sku_id = function_exists( 'wc_get_product_id_by_sku' ) ? wc_get_product_id_by_sku( $search ) : 0;
+                if ( $sku_id ) {
+                        $sku_product = wc_get_product( $sku_id );
+                        if ( $sku_product instanceof WC_Product_Variation ) {
+                                $sku_id = (int) $sku_product->get_parent_id();
+                        }
+                        // wc_get_product_id_by_sku() matches drafts and private products too.
+                        if ( $sku_id > 0 && get_post_status( $sku_id ) === 'publish' ) {
+                                $ids[] = $sku_id;
+                        }
+                }
+
+                $query = new WP_Query(
+                        array(
+                                'post_type'              => 'product',
+                                'post_status'            => 'publish',
+                                'posts_per_page'         => $limit,
+                                's'                      => $search,
+                                'fields'                 => 'ids',
+                                'no_found_rows'          => false,
+                                'ignore_sticky_posts'    => true,
+                                'update_post_meta_cache' => false,
+                                'update_post_term_cache' => false,
+                        )
+                );
+
+                foreach ( $query->posts as $product_id ) {
+                        $ids[] = (int) $product_id;
+                }
+                $total = max( $total, (int) $query->found_posts, count( $ids ) );
+
+                $title_found = self::search_product_ids_by_title_tokens( $search, $limit );
+                $ids         = array_merge( $title_found['ids'], $ids );
+                $total       = max( $total, $title_found['total'] );
+
+                $ids = array_values( array_unique( array_filter( array_map( 'intval', $ids ) ) ) );
+
+                return array(
+                        'ids'   => $ids,
+                        'total' => $total,
+                );
+        }
+
+        /**
+         * Title AND-match for all query tokens (older fixtures WP `s=` ranking can drop).
+         *
+         * @return array{ids: list<int>, total: int}
+         */
+        private static function search_product_ids_by_title_tokens( string $search, int $limit ): array {
+                global $wpdb;
+
+                $words  = preg_split( '/\s+/', $search );
+                $tokens = array();
+                foreach ( false === $words ? array() : $words as $word ) {
+                        $word = trim( (string) $word );
+                        if ( strlen( $word ) < 3 ) {
+                                continue;
+                        }
+                        $tokens[] = $word;
+                }
+                $tokens = array_values( array_unique( $tokens ) );
+                if ( $tokens === array() ) {
+                        return array(
+                                'ids'   => array(),
+                                'total' => 0,
+                        );
+                }
+
+                $posts      = $wpdb->posts;
+                $conditions = array( "post_type = 'product'", "post_status = 'publish'" );
+                $values     = array();
+                foreach ( $tokens as $token ) {
+                        $conditions[] = 'post_title LIKE %s';
+                        $values[]     = '%' . $wpdb->esc_like( $token ) . '%';
+                }
+
+                $where    = implode( ' AND ', $conditions );
+                $values[] = $limit;
+
+                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare -- `$posts` is `$wpdb->posts`; `$where` is LIKE %s placeholders.
+                $ids = $wpdb->get_col(
+                        $wpdb->prepare(
+                                "SELECT ID FROM {$posts} WHERE {$where} ORDER BY ID ASC LIMIT %d",
+                                ...$values
+                        )
+                );
+
+                $count_values = array_slice( $values, 0, -1 );
+                $count        = $wpdb->get_var(
+                        $wpdb->prepare(
+                                "SELECT COUNT(ID) FROM {$posts} WHERE {$where}",
+                                ...$count_values
+                        )
+                );
+                // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
+
+                return array(
+                        'ids'   => array_map( 'intval', is_array( $ids ) ? $ids : array() ),
+                        'total' => (int) $count,
+                );
         }
 

agentmatica-mcp-connector/trunk/includes/modules/woocommerce/class-cart.php

@@ -20 +20 @@
 
         public static function init(): void {
-                add_action( 'init', array( __CLASS__, 'register_checkout_redirect_route' ) );
-                add_action( 'init', array( __CLASS__, 'register_sync_storefront_cart_route' ) );
-                add_action( 'init', array( __CLASS__, 'register_read_storefront_cart_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_checkout_redirect_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_sync_storefront_cart_route' ) );
+                add_action( 'rest_api_init', array( __CLASS__, 'register_read_storefront_cart_route' ) );
                 add_action( 'template_redirect', array( __CLASS__, 'maybe_handle_checkout_redirect' ) );
         }

agentmatica-mcp-connector/trunk/includes/modules/woocommerce/class-catalog-search.php

@@ -123 +123 @@
                 if ( str_contains( $title, $normalized ) ) {
                         return 90;
+                }
+
+                $words = preg_split( '/\s+/', $normalized );
+                $words = false === $words ? array() : array_values(
+                        array_filter(
+                                $words,
+                                static function ( string $word ): bool {
+                                        return strlen( $word ) >= 2;
+                                }
+                        )
+                );
+                if ( $words !== array() ) {
+                        $title_hits = 0;
+                        foreach ( $words as $word ) {
+                                if ( self::word_matches_haystack( $word, $title ) ) {
+                                        ++$title_hits;
+                                }
+                        }
+                        if ( $title_hits === count( $words ) ) {
+                                return 85;
+                        }
                 }
 

agentmatica-mcp-connector/trunk/readme.txt

@@ -4 +4 @@
 Requires at least: 6.9
 Tested up to: 7.1
-Requires PHP: 7.4
-Stable tag: 0.7.1
+Requires PHP: 8.0
+Stable tag: 0.7.2
 License: GPLv2 or later
 License URI: https://www.gnu.org/licenses/gpl-2.0.html
@@ -97 +97 @@
 == Changelog ==
 
+= 0.7.2 =
+* WooCommerce `search_catalog` no longer loads the entire catalogue on each chat search (SQL + capped re-rank). Fixes timeouts on large shops.
+* `get_product` can resolve by product name when `id` is missing.
+* Checkout and storefront-cart REST routes register on `rest_api_init`.
+* An exact SKU search only returns published products.
+* Requires PHP 8.0. Earlier versions already needed it to load.
+
 = 0.7.1 =
 * Fixed: order attribution was sent to an address that does not exist, so sales made through the chat were not counted in Agentmatica Insights.
@@ -134 +141 @@
 == Upgrade Notice ==
 
+= 0.7.2 =
+Woo catalog search no longer times out on large inventories. Update recommended for Agentmatica chat.
+
 = 0.7.1 =
 Fixes order attribution so chat sales appear in Insights. Update recommended.