get_product_by_id
Retrieve detailed product information from a Magento 2 store by specifying the product ID to access inventory data, pricing, and specifications.
Instructions
Get detailed information about a product by its ID
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The ID of the product |
Implementation Reference
- mcp-server.js:671-725 (registration)Registration of the 'get_product_by_id' tool using server.tool(), including description, input schema, and handler function.// Tool: Get product by ID server.tool( "get_product_by_id", "Get detailed information about a product by its ID", { id: z.number().describe("The ID of the product") }, async ({ id }) => { try { // First we need to search for the product by ID to get its SKU const searchCriteria = `searchCriteria[filter_groups][0][filters][0][field]=entity_id&` + `searchCriteria[filter_groups][0][filters][0][value]=${id}&` + `searchCriteria[filter_groups][0][filters][0][condition_type]=eq`; const searchResults = await callMagentoApi(`/products?${searchCriteria}`); if (!searchResults.items || searchResults.items.length === 0) { return { content: [ { type: "text", text: `No product found with ID: ${id}` } ] }; } // Get the SKU from the search results const sku = searchResults.items[0].sku; // Now get the full product details using the SKU const productData = await callMagentoApi(`/products/${sku}`); const formattedProduct = formatProduct(productData); return { content: [ { type: "text", text: JSON.stringify(formattedProduct, null, 2) } ] }; } catch (error) { return { content: [ { type: "text", text: `Error fetching product: ${error.message}` } ], isError: true }; } } );
- mcp-server.js:678-723 (handler)The handler function executes the tool logic: searches products by entity_id to retrieve the SKU, fetches full product details by SKU using Magento API, formats the product data, and returns it as JSON text content.async ({ id }) => { try { // First we need to search for the product by ID to get its SKU const searchCriteria = `searchCriteria[filter_groups][0][filters][0][field]=entity_id&` + `searchCriteria[filter_groups][0][filters][0][value]=${id}&` + `searchCriteria[filter_groups][0][filters][0][condition_type]=eq`; const searchResults = await callMagentoApi(`/products?${searchCriteria}`); if (!searchResults.items || searchResults.items.length === 0) { return { content: [ { type: "text", text: `No product found with ID: ${id}` } ] }; } // Get the SKU from the search results const sku = searchResults.items[0].sku; // Now get the full product details using the SKU const productData = await callMagentoApi(`/products/${sku}`); const formattedProduct = formatProduct(productData); return { content: [ { type: "text", text: JSON.stringify(formattedProduct, null, 2) } ] }; } catch (error) { return { content: [ { type: "text", text: `Error fetching product: ${error.message}` } ], isError: true }; }
- mcp-server.js:675-677 (schema)Input schema using Zod: requires a numeric 'id' parameter for the product ID.{ id: z.number().describe("The ID of the product") },
- mcp-server.js:337-361 (helper)Helper function to format product data from Magento API response into a readable structure with flattened custom attributes.function formatProduct(product) { if (!product) return "Product not found"; // Extract custom attributes into a more readable format const customAttributes = {}; if (product.custom_attributes && Array.isArray(product.custom_attributes)) { product.custom_attributes.forEach(attr => { customAttributes[attr.attribute_code] = attr.value; }); } return { id: product.id, sku: product.sku, name: product.name, price: product.price, status: product.status, visibility: product.visibility, type_id: product.type_id, created_at: product.created_at, updated_at: product.updated_at, extension_attributes: product.extension_attributes, custom_attributes: customAttributes }; }