get_products
Search products with stock, prices, SEO data. Filter by category
How to use it
get_products is exposed by the Opencart MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the get_products tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Opencart MCP
pip install -e .Other tools in Opencart MCP (39)
Flush OpenCart + Journal3 caches
One-call store overview — revenue, order statuses, stock alerts, latest orders
Category tree with product counts and SEO URLs
List discount coupons with usage counts
Search by name/email with order count and total spent
Installed extensions list
Read files from the server (path traversal blocked)
Full HTML content of a single CMS/information page
List CMS pages (About Us, FAQ, T&Cs) with content preview
Full module JSON data for any J3 module
Journal3 theme settings
Journal3 skin/layout settings per skin
OCMOD modifications with status
Journal3 modules by type — search content within modules
Full order with line items, totals, status history
All order status mappings with IDs
Recent orders filtered by status and date range
Full product details — images, options, categories, attributes
Product attributes (weight, storage conditions, etc.)
SEO URL mappings with filtering
OpenCart core settings by group/key
All products sorted by stock level (lowest first)
Column definitions for any table
List gift vouchers
List tables matching a pattern
Custom read-only SQL (SELECT/SHOW/DESCRIBE/EXPLAIN only)
Clear OCMOD modification cache
Execute INSERT/UPDATE/DELETE (DDL blocked)
Revenue, top sellers, daily stats for any period
Update category name, meta, status
Find/replace text within CMS page HTML (About Us, T&Cs, etc.)
Find/replace text within J3 module JSON (banners, FAQ, sliders)
Change Journal3 theme settings
Change Journal3 skin settings
Change order status + append order history
Update price, stock, name, SEO title, meta description
Create or update SEO URL mappings
Change OpenCart core settings
Write files to server via SFTP