# Shopify Product Catalog Lookup

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

Source: https://cotera.co/solutions/support/shopify-product-catalog-lookup

---

- **Team:** Support
- **Tools:** Shopify
- **Difficulty:** easy
- **Setup time:** 5 min
- **Time saved:** 5 min/question

## How it works
1. **Search the Catalog** — Find products by name, type, vendor, or keyword without opening Shopify admin
2. **Pull Full Details** — Get pricing, variants, descriptions, and images for any product
3. **Check Availability** — See which variants are in stock and suggest alternatives if something is sold out
4. **Add Customer Context** — Look up the customer to see if they have ordered this product before

## Example requests
- 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

## Prompt

```markdown
## Task

Answer customer product questions by searching the Shopify catalog. Use @Shopify/List Products to find matching products and @Shopify/Get Product for detailed info on a specific item. If the customer is known, use @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 Products
2. If multiple results, identify the best match based on the customer's question
3. Pull full product details 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 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
```

## Related reading
- [How to Automate Shopify Product Questions with AI](https://cotera.co/articles/automate-shopify-product-questions.md)
- [AI Customer Support for Shopify Stores](https://cotera.co/articles/ai-customer-support-shopify.md)