List products with stock, prices, and SEO data. Search by name. Optionally filter by category_id. Set include_description=True to include full HTML descriptions.

Get full details for a single product including images, options, and attributes.

Get recent orders. Filter by status name (e.g. 'Complete', 'Pending'). Default: last 30 days, 20 orders.

Get full order details including line items and totals.

Search customers by name or email.

Get category tree. Set parent_id=0 for top-level categories.

Get OpenCart settings. Filter by group (e.g. 'config') and/or key pattern (SQL LIKE).

Get Journal3 theme settings. Filter by setting_name pattern (SQL LIKE).

Get Journal3 skin settings. Filter by setting_name pattern (SQL LIKE).

List Journal3 modules. Filter by type (e.g. 'products', 'slider', 'product_tabs'). Search module_data content with search parameter.

Get full Journal3 module data for a single module by ID. Returns full JSON config — can be large for complex modules.

List all order statuses with their IDs.

Get all attributes for a product (e.g. CAS number, molecular weight, storage).

Get sales summary: total revenue, order count, top selling products. Covers the last N days. Excludes cancelled/failed/refunded orders.

List all OCMOD modifications with status.

List installed OpenCart extensions.

Execute a read-only SQL query. Only SELECT statements allowed. Use this for custom queries not covered by other tools.

Show columns for an OpenCart table. The install's prefix (e.g. 'oc_') is added automatically if missing.

List database tables matching pattern. Default: all OpenCart tables (using detected prefix).

Read a file from the VPS. Path is relative to OpenCart root unless absolute.

By default returns the first max_lines lines (head). Set from_end=True for the last max_lines (tail) — preferred for large logs such as error.log. Optional grep is a fixed substring filter (not a regex). With from_end=True, grep only searches the last ~50k lines so huge logs stay fast; with from_end=False, grep scans the whole file then takes the first max_lines matches (can be slow on very large files). max_lines is capped at 2000. Requires SSH or DDEV.

Update product fields. Only specified fields are changed.

Update an OpenCart setting.

Update a Journal3 theme setting.

Update a Journal3 skin setting.

Update text within a Journal3 module's JSON data using find/replace. Safer than rewriting the entire module — only changes the matched text. Use get_j3_module first to see the current content.

Update or create an SEO URL mapping. Query is e.g. 'product_id=123' or 'category_id=45'. Keyword is the URL slug (e.g. 'bpc-157-5mg').

Update category fields. Only specified fields are changed.

Write content to a file on the VPS via SFTP. Path is relative to OpenCart root unless absolute. Creates parent directories if needed. Use with caution. Requires SSH or DDEV.

Clear OpenCart and Journal3 caches on VPS. Requires SSH or DDEV.

Execute a write SQL statement (INSERT/UPDATE/DELETE). Use with caution — changes the database directly.

Clear the OCMOD modification cache so OpenCart serves unmodified files. Run Admin > Extensions > Modifications > Refresh afterwards for the full recompile — this tool cannot do that step.

List CMS/information pages (About Us, FAQ, T&Cs, etc.) with title and content preview. Search by title text.

Get full content of a single information/CMS page by ID.

Update text within an information/CMS page using find/replace. Works on the HTML description field. Use get_information_page first to see current content.

Get SEO URL mappings. Filter by query pattern (e.g. 'product_id=%').

Get stock levels for active products, sorted by quantity (lowest first).

Change an order's status and append an order-history entry — the same thing the admin status dropdown does. notify=True marks the history row as customer-notified but does NOT send the email itself. Use get_order_statuses to look up status IDs.

List discount coupons with usage counts. Search by code or name. Default: enabled, unexpired coupons only.

Create a discount coupon, enabled and valid from today. type: 'P' = percentage, 'F' = fixed amount. uses_total=0 = unlimited total uses; uses_per_customer=0 = unlimited per customer.

Update a coupon: enable/disable (status 1/0), change discount, extend date_end (YYYY-MM-DD), adjust total-use limit, or rename. Only specified fields are changed.

List gift vouchers with amount, sender/recipient, and status.

One-call store overview: revenue today / 7 days / 30 days, order status breakdown, stock alerts, and the latest orders. The 'give me a store summary' tool. Excludes cancelled/failed/refunded orders from revenue.