Product Integration

Overview

The Products feature lets you include real product recommendations in your AI-generated articles. This is perfect for creating buyer's guides, product roundups, comparison articles, and affiliate content.

Three product sources are available:

  • AI Discovery — AI researches real products with web search before article generation
  • Manual Products — Add product details by hand or via CSV columns
  • Amazon PA API — Fetch products directly from Amazon's Product Advertising API

All sources inject product data into your workflow via the {'{{products}}'} variable, which your AI prompts can reference to generate product-rich content.

AI Discovery (Recommended)

AI Discovery uses a separate LLM call with web search to research real products for your keyword before article generation begins. The researched product data is then injected into the article generation prompt, giving your AI writer accurate, up-to-date product information to work with.

How It Works

  1. Before article generation, Publish Owl makes an LLM call with web search enabled
  2. The AI researches real products matching your keyword
  3. Product data (names, prices, ratings, links, pros/cons) is collected
  4. This data is injected into the article generation prompt as the {'{{products}}'} variable

Settings

  • Max Products: How many products to research (1-20, default 5)
  • Search Instructions: Optional guidance for the AI on what types of products to look for (e.g., "focus on budget options under $50")
  • AI Provider: Which LLM to use for product research (defaults to the last workflow step's provider)
  • Include Fields: Checkboxes to control which data to research — Pricing, Pros & Cons, Ratings, Links
Requirement: AI Discovery requires web search to be enabled on at least one LLM workflow step. Without web search, the AI cannot look up real product data from the web.

Pre-Research

Research products ahead of time for faster, more reliable results during article generation. Select keywords from your list, research products in bulk, then review and edit the results before running your workflow. Pre-researched product data is cached and reused when the job runs, skipping the research step entirely.

Product Images

Three options for product images with AI Discovery:

  • None: No product images
  • Scrape OG Image: Fetches the Open Graph image from the product page URL
  • Screenshot Product Page: Takes a screenshot of the product page for a visual preview
Tip: AI Discovery is the easiest way to add products — no API keys or manual data entry required. Just enable it and the AI handles the research automatically.

Manual Products

Add product details by hand for full control over exactly which products appear in your articles.

Single Article Mode

When running a single article, add products manually with the following fields:

  • Name: Product name/title
  • Price: Product price
  • Rating: Star rating
  • URL: Product page link
  • Image: Product image URL
  • Description: Short product description
  • Pros: List of advantages
  • Cons: List of disadvantages

Bulk Mode (CSV Variables)

For bulk article generation, use CSV variable columns to supply product data. Name your columns with the product_ prefix and reference them with indexed syntax in your prompts:

CSV columns: keyword, product_name, product_url, product_price

Prompt: Write a review featuring these products:
- {'{{product_1_name}}'} ({'{{product_1_price}}'}) - {'{{product_1_url}}'}
- {'{{product_2_name}}'} ({'{{product_2_price}}'}) - {'{{product_2_url}}'}

Amazon PA API

The Amazon Product Advertising API integration fetches product data directly from Amazon, including prices, ratings, images, and affiliate links. This is ideal for Amazon Associates who want accurate, real-time product data with built-in affiliate tracking.

Amazon integration works in both content modes:

  • Standard Mode: Products are searched based on each job's keyword
  • Template Mode (pSEO): Products can be looked up by ASIN or searched by a column value

Amazon PA API: Prerequisites

Before using Amazon integration, you must configure your own Amazon Product Advertising (PA) API credentials in Settings. This requires an Amazon Associates account with API access.

Step 1: Get Amazon PA API Access

  1. Sign up for the Amazon Associates Program
  2. Once approved, go to Tools → Product Advertising API in your Associates dashboard
  3. Request API access (may require meeting sales thresholds depending on your marketplace)
  4. Generate your Access Key and Secret Key

Step 2: Configure in Publish Owl

  1. Go to Settings from the top menu
  2. Scroll to the Amazon Product Advertising API section
  3. Enter your credentials:
    • Access Key ID: Your AWS-style access key (starts with "AKIA...")
    • Secret Access Key: Your secret key (keep this secure!)
    • Partner Tag: Your Amazon Associates tracking ID (e.g., yourstore-20)
    • Marketplace: Select your Amazon marketplace (US, UK, DE, etc.)
  4. Click Test Connection to verify your credentials work
  5. Click Save Credentials to store them securely
Supported Marketplaces (21): United States, Canada, Mexico, Brazil, United Kingdom, Germany, France, Spain, Italy, Netherlands, Sweden, Poland, Belgium, Turkey, UAE, Saudi Arabia, Egypt, India, Japan, Australia, and Singapore.
Important: Your credentials are encrypted before being stored. The Settings page displays your usage stats including requests used today and your daily limit status.

Amazon PA API: Standard Mode Setup

In standard mode, Amazon products are searched based on each job's keyword. This is ideal for workflows that generate product-focused content like reviews or buying guides.

Step 1: Enable Amazon Products

  1. In your workflow editor, click + Add Amazon Products
  2. The Amazon Product Integration panel will appear

Step 2: Configure Search Settings

Amazon Keyword Template (Optional)

Customize how the job keyword is used for Amazon search. Use {'{{keyword}}'} as a placeholder.

  • Leave empty to search for the exact keyword
  • Example: {'{{keyword}}'} reviews — turns "wireless headphones" into "wireless headphones reviews"
  • Example: best {'{{keyword}}'} 2026 — turns "laptop" into "best laptop 2026"
Words to Exclude (Optional)

Remove specific words from the keyword before searching Amazon.

  • Useful when your keywords contain words that don't help product search
  • Example: If your keyword is "best wireless headphones 2026", exclude "best, 2026" to search for "wireless headphones"
Max Products

How many products to fetch per job (1-100). Default is 10.

Step 3: Add Your Tracking ID (Optional)

Enter your Amazon Associates tracking ID (e.g., yourstore-20) to earn commissions from product links.

How it works: When a job runs, products are fetched based on the keyword and made available to all workflow steps via the {'{{products}}'} variable. Your AI workflow steps can then reference this product data in their output.
Pro Tip: Fetch More, Let AI Curate

Set max products to 15-20 instead of the default 10, then let your AI workflow narrow down to the best 5-10 products. This works especially well when you have a Research Step enabled—it can analyze reviews, ratings, and product details to pick truly relevant products while filtering out:

  • Low-rated products (under 4 stars)
  • Near-duplicates or variations of the same item
  • Products that don't match the article's focus
  • Items with too few reviews to be trustworthy

This approach gives your final article a more curated, researched feel—like a human actually compared options before recommending them.

Amazon PA API: Template Mode (pSEO) Setup

In template mode, Amazon products can be fetched in two ways:

Option 1: From Column (ASIN/URL Lookup)

Best for: Articles about specific products you already know

  • Add a column to your data source with ASINs or Amazon product URLs
  • Supports multiple products per row (comma or newline separated)
  • Example values: B08N5WRWNW or https://amazon.com/dp/B08N5WRWNW

Option 2: Keyword Search

Best for: Roundup articles, "best products for X" content

  • Add a column with search terms (e.g., "wireless headphones", "camping tent")
  • Configure how many products to fetch per article (1-20)
  • Products are returned in Amazon's relevance order

Using Products in Your Prompts

Once products are fetched (from any source), they're available to your AI workflow steps. Here's how to reference them:

Standard Mode (All Product Sources)

In your workflow step prompts, reference the products variable. This works the same regardless of which product source you're using:

Write a buying guide for {'{{keyword}}'}.

Use the following products as the basis for your recommendations:
{'{{products}}'}

For each product, include the title, price, rating, and a brief description
of why it's worth considering. Include product links.

Template Mode (pSEO) — Amazon Variables

These variables are automatically available in your content template once Amazon integration is enabled:

Variable Description
{'{{product_title}}'} Product name
{'{{product_price}}'} Formatted price (e.g., "$29.99")
{'{{product_rating}}'} Star rating (e.g., 4.5)
{'{{product_reviewCount}}'} Number of reviews
{'{{product_imageUrl}}'} Product image URL
{'{{product_affiliateUrl}}'} Affiliate link (includes your tracking ID)
{'{{product_asin}}'} Amazon ASIN
{'{{product_features}}'} Product features list

For multiple products, use numbered variables: {'{{product1_title}}'}, {'{{product2_title}}'}, etc.

Alternative: CSV-Based Product Data

If you use a non-Amazon affiliate program or want full control over product details, you can include product data directly in your CSV instead of fetching from Amazon. In standard mode, any CSV column becomes a template variable usable in your prompts.

Single Product per Article

Add columns for your product data and reference them with {'{{column_name}}'} in your prompts:

CSV columns: keyword, product_name, product_price, product_url, product_box_html

Prompt: Write a review of {'{{product_name}}'} ({'{{product_price}}'}).
Include this product box in the introduction:
{'{{product_box_html}}'}

This works well for pre-built WordPress block HTML, affiliate links, or any custom product markup.

Product Roundups (Multiple Products per Article)

When multiple CSV rows share the same keyword, they are automatically grouped into a single job. All rows' column data is collected and available as:

  • {'{{products}}'} - A formatted text block listing all products and their fields
  • {'{{product_1_product_name}}'}, {'{{product_2_product_price}}'}, etc. - Indexed per-product access (1-based)
keyword,        group,       product_name,     product_price, product_url
best headphones, headphones, Sony WH-1000XM5,  $348,          https://...
best headphones, headphones, AirPods Max,       $549,          https://...
best headphones, headphones, Bose QC Ultra,     $429,          https://...

Add a group column to control grouping explicitly when the same keyword should produce separate articles.

Tip: CSV-based product data and Amazon product data can be used together. The {'{{products}}'} variable combines data from both sources when both are available.

Example Workflows

Here are typical setups for different product source types:

Example 1: AI Discovery — Buying Guide

Let AI research products automatically — no API keys or manual data needed.

  • Product Source: AI Discovery
  • Max Products: 8
  • Search Instructions: "Focus on highly-rated options with good value"
  • Include: Pricing, Pros & Cons, Ratings, Links
You are a product review expert. Write a comprehensive buying guide for "{'{{keyword}}'}".

Use these researched products as the basis for your recommendations:
{'{{products}}'}

Structure your article as follows:
1. Introduction explaining what to look for
2. Top picks with pros/cons for each
3. Comparison table
4. Buying advice and recommendations

Use the actual prices and ratings provided. Make the content helpful and unbiased.

Example 2: Amazon PA API — Affiliate Roundup

Fetch real-time Amazon product data with built-in affiliate tracking.

  • Product Source: Amazon PA API
  • Keyword Template: {'{{keyword}}'} (search exact keyword)
  • Exclude Words: best, top, 2026, review
  • Max Products: 10
  • Tracking ID: mysite-20
You are a product review expert. Write a comprehensive buying guide for "{'{{keyword}}'}".

Here are the top products from Amazon to feature:
{'{{products}}'}

Structure your article as follows:
1. Introduction explaining what to look for
2. Top picks with pros/cons for each
3. Comparison table
4. Buying advice and recommendations

Include affiliate links for each product. Use the actual prices and ratings provided.
Make the content helpful and unbiased.

Sample keywords: "best wireless headphones 2026", "top laptops for students", "best running shoes review". With the exclude words configured, these become searches for "wireless headphones", "laptops for students", and "running shoes".

Example 3: Manual Products — Curated List

Full control over exactly which products appear, with data you provide.

  • Product Source: Manual Products
  • Products: Added by hand or via CSV columns with product_ prefix
Write a curated gift guide for "{'{{keyword}}'}".

Feature these hand-picked products:
{'{{products}}'}

For each product, explain why it makes a great gift and who
it's best suited for. Include prices and purchase links.

Supported ASIN Formats (pSEO)

When using "From Column" mode in pSEO, these formats are all accepted:

  • B08N5WRWNW — Plain ASIN
  • https://www.amazon.com/dp/B08N5WRWNW — Standard product URL
  • https://amazon.com/gp/product/B08N5WRWNW — Alternate URL format
  • B08N5WRWNW, B09XYZ1234 — Multiple ASINs (comma separated)

Amazon API Rate Limits

  • Rate Limits: Publish Owl enforces 1 request per second and a soft cap of 2,000 requests per day to comply with Amazon's API terms.
  • Backoff: If Amazon returns a rate limit error (429), there's an automatic 90-second backoff before retrying.
  • Fresh Data: Product data is always fetched fresh from Amazon to ensure accurate pricing and availability.

You can view your current usage (requests today / daily limit) in Settings under the Amazon PA API section.

Important Notes

All Product Sources

  • Incomplete Data: Some products may not return all fields (e.g., missing price or image). Your prompts should handle incomplete data gracefully.
  • Product Count: The actual number of products returned may be fewer than "Max Products" if not enough matching products are found.

AI Discovery

  • Web Search Required: AI Discovery requires web search to be enabled on at least one LLM workflow step.
  • Result Variability: AI-researched products may vary between runs since web search results change over time. Use Pre-Research to lock in specific products.

Amazon PA API

  • Search Results: Products are returned in Amazon's relevance order — results may vary over time.
  • Marketplace Lock: Your credentials are tied to a specific marketplace. To use a different Amazon marketplace, update the marketplace setting in Settings.

Troubleshooting

General (All Product Sources)

Products not appearing in generated content

Check that product integration is enabled in your workflow settings. View the job logs to see if products were fetched. Make sure your prompt references {'{{products}}'}.

{{products}} variable is empty

Open the job details and check the logs for errors during product fetching. If no products were found, try adjusting your search terms, URLs, or product source settings.

Product data is incomplete (missing price, image, etc.)

Not all product sources return every field. Write your prompts to handle missing data gracefully (e.g., "Include the price if available"). For more complete data, try a different product source or add missing details manually.

AI Discovery

AI Discovery returns no products

Ensure web search is enabled on at least one workflow step — AI Discovery requires it. Check that your keyword is specific enough for the AI to find real products. Try adding search instructions like "find products available for purchase online".

AI Discovery returns irrelevant products

Add search instructions to guide the AI (e.g., "focus on electronics under $100", "only include products with verified reviews"). You can also reduce max products to get more targeted results.

Products differ between runs for the same keyword

Web search results change over time, so AI Discovery may return different products on each run. Use Pre-Research to lock in specific products — pre-researched data is cached and reused during article generation.

Manual Products

CSV product columns not being recognized

Ensure your CSV column names use the product_ prefix (e.g., product_name, product_price). Reference them in your prompts with indexed syntax: {'{{product_1_name}}'}, {'{{product_2_price}}'}, etc.

Amazon PA API

Wrong products being fetched

Adjust your keyword template or exclude words. Sometimes removing common words like "best" or year numbers improves search relevance.

Affiliate links not working

Verify your tracking ID format (e.g., yourstore-20). Ensure your Amazon Associates account is active and approved.

"API credentials not configured" error

You haven't configured your Amazon PA API credentials yet. Go to Settings, scroll to the Amazon Product Advertising API section, and enter your Access Key, Secret Key, Partner Tag, and select your marketplace.

"Rate limit exceeded" error

You've hit the daily request limit (2,000 requests). Wait until the next day for the limit to reset, or reduce the number of products you're fetching per job.

"Invalid credentials" or authentication errors

Double-check your Access Key and Secret Key in Settings. Make sure you're using the correct marketplace for your Amazon Associates account. You can use the "Test Connection" button to verify your credentials.

Common Use Cases

  • Buyer's Guides: "Best [Product] for [Use Case]" with real products and prices — great with AI Discovery or Amazon PA API
  • Product Roundups: "Top 10 [Category]" with automated product data from any source
  • Comparison Articles: Side-by-side product comparisons with current specs
  • Gift Guides: Seasonal recommendations with live pricing — AI Discovery keeps data fresh automatically
  • Review Content: Incorporate ratings and review counts for credibility — Amazon PA API provides verified review data
  • Affiliate Content: Monetize with Amazon Associates tracking IDs (Amazon PA API) or include your own affiliate links (Manual Products)
  • Niche/Non-Amazon Products: Use AI Discovery for products from any retailer, marketplace, or direct-to-consumer brand
Was this helpful?