Shopify Okendo Reviews Scraper API

Pull every public Okendo review from any Shopify store into one clean spreadsheet. Every 1-star from a competitor's launch quarter, a catalog-wide rating sweep of your own storefront, or the full review history for a single SKU. Ready to filter, sort, and download in minutes.

🎬 What it does

Paste a Shopify store URL or a product URL. Get back reviews in a spreadsheet.

Two kinds of input:

1. Store URL returns one summary row per public product on the store, including the SKUs sitting at zero reviews. Good for catalog-wide dashboards, launch-week rating sweeps, and finding the quiet products in your own store.
2. Product URL returns every individual review on that exact product. Good for quote pulls, monthly agency reports, and single-SKU deep dives.

Shape the results before you pay for them:

• Free filters and sorts: keep any mix of 1 to 5 stars. Sort by newest, oldest, highest rating, lowest rating, most helpful, least helpful, or media first.
• Paid keyword search: pull only reviews mentioning a phrase like "refund", "sizing", or "gift".
• Paid verified, media, and reply filters: verified buyers only, photos only, videos only, either type of media, or reviews the store publicly replied to.
• Paid date and language filters: narrow to a specific date window, or the set of languages you actually read.
• Paid text or ratings-only: keep only reviews with written text, or only star ratings without text.
• Paid custom sorts: push photo reviews or video reviews to the top of the export.
• Paid enrichments: tag each review with a detected language, run a translation fallback when Okendo has not already translated the review, and archive photo and video files to your run storage.

Duplicate URLs collapse automatically, so a store URL and one of its product URLs in the same run never charges you twice. Status rows like no_products_found are always free.

Good for: Shopify founders watching their own reviews week over week, CMOs auditing a competitor's launch quarter, agencies scoring a client roster monthly, and analysts building review datasets they can actually trust.

📋 How to use it

Step 1: Paste your inputs

Drop any combination into Start URLs, one per line. Duplicates are cleaned up so you never pay twice for the same store or product.

• Store URL: https://speargun.com/
• Product URL: https://speargun.com/products/mahogany-competition-series-riffe-spearfishing-speargun

Minimum input, run as-is:

{
  "startUrls": [
    "https://speargun.com/products/mahogany-competition-series-riffe-spearfishing-speargun"
  ],
  "maxResultsPerUrl": 50
}

maxResultsPerUrl is the only limit you need. Default 50, max 50,000. For a store URL it caps product summaries. For a product URL it caps reviews.

Step 2: Pick filters and add-ons

Free filters and sorts:

• Star rating filter: keep any combination of 1 to 5 stars.
• Sort order: Newest, Oldest, Highest rating, Lowest rating, Most helpful, Least helpful, or Photos and videos first.

Paid add-ons (billed only when they actually deliver a row):

• Keyword search: only reviews whose title or text contains your phrase.
• Verified only: only reviews Okendo marks as verified.
• Media filters: only reviews with a photo, only with a video, or only with either.
• Store-reply only: only reviews the merchant has publicly replied to.
• Date range: only reviews posted between two dates.
• Written vs rating-only: keep only reviews with text, or only star-ratings without text.
• Language filter: only reviews in the languages you pick.
• Pictures-first or videos-first sort: push reviews with photos (or with videos) to the top.
• Language detection: adds a language tag when Okendo did not include one, billed only when detection succeeds.
• Translation: translates reviews into your chosen language, billed only when a translation is returned.
• Media archiving: downloads and stores up to 10 photos or videos per review (3 MB per file cap), billed only per file stored.

Step 3: Run it and get your results

Click Start. Rows stream into the Output tab as they come in. The dataset ships with four ready-made views:

• Overview: high-level shape of every row.
• Products: one row per catalog product from a store scan.
• Reviews: one row per review from a product scan.
• Language & Media: detected languages, translated text, and archived media.

Every row starts with a status field. Success means the row is real data. Anything else is a plain-English message like no_products_found or okendo_not_detected, so you can spot and fix problems without reading the logs. Explanatory rows are never charged.

Download as JSON, CSV, or Excel from the Storage tab, or pull them straight into your app through the Apify API.

💰 Pricing

Pay only for results you actually get back. No subscription, no minimum.

Event	Price	When
Actor Start	$0.00005 per event	one event per GB of memory per run
Review	$1.50 per 1,000 rows	per product summary or review delivered
Add-on: Advanced filter	$0.50 per 1,000 rows	per delivered review a paid filter kept
Add-on: Custom sort	$0.50 per 1,000 rows	per delivered review from a pictures-first or videos-first sort
Add-on: Language detected	$0.50 per 1,000 rows	per delivered review where the Actor detected the language
Add-on: Review translated	$2.00 per 1,000 rows	per delivered review that was actually translated
Add-on: Media downloaded	$1.00 per 1,000 files	per media file archived successfully

Rating filters, native Okendo sorts, source photo and video URLs, Okendo's own translations, and status rows are all free.

💡 Good to know

• Zero-review products are included on store scans. Your catalog view stays complete.
• Dedup is automatic. The same store or product reached through several URL variants is fetched once.
• Not on Okendo? If the store runs a different review widget the Actor recognises, the status row tells you which sibling tool to run.
• Status rows are never charged. Unsupported providers, empty filtered results, and rejected URLs come back with a stable error value that explains the fix.
• Field coverage matches the source. If the storefront did not publish a value, the field comes back null. Fields you toggle off are omitted from the row entirely.
• Runs are independent. No cross-run history is kept. Schedule runs and compare reviewId on your side to track what is new.
• Files and datasets live in your Apify storage. How long they are kept depends on your Apify plan.

❓ FAQ

Do I need an Okendo or Shopify account? No. Only publicly published storefront and review data is read.

What if a store does not use Okendo? You get one uncharged status row that explains it. When the Actor spots a supported sibling widget on the store, the row names the matching tool to run instead.

What if a product has no reviews? On a store scan you still get the product summary row with reviewCount: 0 and empty rating fields. On a product scan pointing at a review-less product you get a status row that says no reviews matched.

Why are some fields null? Not every store publishes every field. null means the field was requested but the storefront did not expose it. Fields you toggle off are omitted entirely.

Can I schedule this? Yes. Use Apify Schedules to run on any cadence and compare reviewId across snapshots to track new reviews.

Can I export to Excel or Google Sheets? Yes. Open the run's Storage tab and pick CSV, Excel, JSON, or one of the other formats.

Which stores work? Any Shopify store whose review widget is powered by Okendo and whose public catalog is reachable.

How long are my results stored? Results live in your Apify dataset. How long they are kept depends on your Apify plan.

🔗 Other tools you might like

• Shopify Yotpo Reviews Scraper API: reviews and product data from any Shopify store using Yotpo.
• Shopify Judge.me Reviews Scraper API: reviews and product data from any Shopify store using Judge.me.
• Shopify Loox Reviews Scraper API: reviews and product data from any Shopify store using Loox.

⚖️ Disclaimer

This tool is intended for personal, research, and educational use. You are responsible for complying with Shopify's and Okendo's Terms of Service and any laws that apply in your jurisdiction. The developer is not liable for misuse. Data availability depends on the storefront's public configuration at run time.

Keywords: shopify reviews, okendo reviews, shopify review scraper, okendo review scraper, product reviews export, shopify product ratings, review dataset, review sentiment data, shopify catalog audit, ecommerce review data