cotera

Shopify Product Catalog Lookup

Answer product questions in seconds. No more opening Shopify admin to check prices, variants, or availability.

Product searchPricing lookupVariant checkCustomer context

The Challenge

A customer asks if the blue hoodie comes in XL. You open Shopify admin, type the product name in search, click into the product, scroll through variants, check inventory levels, then type the answer. Five minutes for a question the catalog already knows the answer to. Multiply that by the 20 product questions your team gets every day.

What This Prompt Does

Search the Catalog

Find products by name, type, vendor, or keyword without opening Shopify admin

Pull Full Details

Get pricing, variants, descriptions, and images for any product

Check Availability

See which variants are in stock and suggest alternatives if something is sold out

Add Customer Context

Look up the customer to see if they have ordered this product before

The Prompt

The Prompt

Task

Answer customer product questions by searching the Shopify catalog. Use @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products to find matching products and @Shopify/Get ProductName it "Shopify/Get Product" and call it with @Shopify/Get Product for detailed info on a specific item. If the customer is known, use @Shopify/Search CustomersName it "Shopify/Search Customers" and call it with @Shopify/Search Customers to pull their profile for context.

Example: "Customer asks if the blue version of the Classic Hoodie is in stock in size L."

Input

The user will provide:

  1. The customer's question about a product (name, variant, price, availability, etc.)
  2. Optionally, the customer's name or email for personalized context

Context

Product Lookup Workflow

Steps to follow:

  1. Search for the product by name or keyword using @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products
  2. If multiple results, identify the best match based on the customer's question
  3. Pull full product details with @Shopify/Get ProductName it "Shopify/Get Product" and call it with @Shopify/Get Product for pricing, variants, images, and description
  4. If a customer email or name is provided, look them up with @Shopify/Search CustomersName it "Shopify/Search Customers" and call it with @Shopify/Search Customers to see their order history
  5. Compose a clear answer addressing the specific question

Response Guidelines

  • Always include the current price and available variants
  • If a product is out of stock, suggest similar alternatives from the search results
  • If the customer has ordered this product before, mention it
  • Keep the response conversational and ready to paste into a support reply

Output

Answer for the support agent:

  • Product name and current price
  • Available variants (size, color, etc.)
  • Stock status
  • Product description (if relevant to the question)
  • Customer context (if looked up)
  • Suggested response to paste into the support ticket

Example Usage

Try asking:

  • →"Does the Classic Hoodie come in blue? What sizes are available?"
  • →"How much is the Organic Cotton T-Shirt? Customer john@example.com is asking"
  • →"Find all products from the vendor "EcoWear" and list their prices"