Cgs Mcp Zort

Showing 25 of 44 from the live probe.

• Cgs Mysql Query

  Run read-only SQL against Aiven MySQL. Accepts SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, and WITH only.

• Cgs Mysql Execute

  Run mutating SQL against Aiven MySQL. Intended for approved CREATE, INSERT, UPDATE, DELETE, or ALTER operations.

• Cgs Mysql Tables List

  List tables in the configured Aiven MySQL database.

• Cgs Mysql Table Describe

  Describe one Aiven MySQL table, including columns and CREATE TABLE statement.

• Cgs Zort Stock Get

  Get current stock levels from Zort warehouses. Optionally filter by warehouse code or product code. Returns quantity on hand, reserved, and available stock.

• Cgs Zort Order List

  List orders from Zort back-office system. Filter by status, date range, and sales channel. Returns order ID, status, channel, total amount, and item count.

• Cgs Zort Product Get

  Get product information from Zort catalog. Look up by product code, search by keyword, or filter by category. Returns product name, SKU, barcode, price, and stock summary.

• Cgs Zort Create Sale Order

  Create a new sale order in Zort. Specify customer, warehouse, and product list with quantities and prices. Returns the created order number and ID.

• Cgs Zort Create Purchase Order

  Create a new purchase order (PO) in Zort to restock inventory. Specify warehouse, products with quantities and purchase prices. Returns the created PO number and ID.

• Cgs Zort Create Quotation

  Create a new sales quotation in Zort. Specify products with quoted prices for a customer. Returns the created quotation number and ID.

• Cgs Zort Transfer Stock

  Create a stock transfer between two Zort warehouses. Moves specified product quantities from source to destination warehouse. Returns the created transfer number and ID.

• Cgs Zort Create Product

  Create a new product in the Zort product catalog. Requires product name and unique SKU. Optionally set pricing, barcode, category, dimensions, and initial stock. Returns the created product ID.

• Cgs Zort Contact Get

  Search or retrieve contacts (customers/suppliers) from Zort. Use keyword to search, or id to get a single contact. Returns name, code, phone, email, address, and social media fields.

• Cgs Zort Contact Create

  Create a new contact (customer or supplier) in Zort. Required: code and name. Returns the created contact ID.

• Cgs Zort Contact Update

  Update an existing contact in Zort by ID. Only provided fields are updated. Returns success status.

• Cgs Zort Get Merchant Profile

  Get CGS store profile from Zort: name, phone, email, address, tax ID, website.

• Cgs Zort Get Sales Channels

  List all sales channels configured in Zort (e.g. shopee, lazada, manual). Use these values in the saleschannel field when creating orders.

• Cgs Zort Get Payment Methods

  List all payment methods configured in Zort (e.g. cash, transfer, credit card). Use these values in the paymentmethod field when creating orders.

• Cgs Zort Get Shipping Channels

  List all shipping channels configured in Zort (e.g. Kerry, Flash, J&T). Use these values in the shippingchannel field when creating orders.

• Cgs Zort Return Order Get

  Get return orders from Zort. Fetch by ID, document number, or date range. Returns return order details including products, amounts, and status.

• Cgs Zort Return Order Create

  Create a return order in Zort when a customer returns products. Link to original sale order via reference field. Returns the created return order number and ID.

• Cgs Zort Return Order Update Status

  Confirm/complete a return order in Zort (change status to Success). Requires return order ID or document number.

• Cgs Zort Bundle Get List

  List all bundle products in Zort. A bundle is a set of products sold together as one item. Returns bundle name, SKU, sell price, and item count.

• Cgs Zort Bundle Get Detail

  Get detail of a specific bundle including all products inside it and their quantities. Provide bundle ID or SKU.

• Cgs Zort Bundle Create

  Create a new bundle product in Zort. A bundle groups multiple SKUs and sells them as one item at a fixed price. Returns the created bundle ID.