Finding Michiu's reviews across platforms
Where the reviews live, what they're listed under, and how to get them out as data the system can ingest.
Important historical context: Michiu hasn't always been called "Michiu". Before late 2024 the same address operated under several names — "Michiu Lounge", "Michiu Restaurant", "Michiu BV" — and aggregator platforms often still list the place under the older name (or have orphan review pages from the old listing). Search every platform under all four names before concluding it's not there.
Owner-controlled (you have admin access)
These are platforms where Michiu has a verified owner account. You log in,
export, drop in imports/, run pnpm import:csv.
| Platform | Where to log in | Has CSV export? | Notes |
|---|---|---|---|
| https://business.google.com | API only — use pnpm import:google | Pending Business Profile API approval | |
| TheFork | https://manager.thefork.com | yes (recent reviews dashboard → export) | NL+EU bookings + reviews |
| Iens | (Iens redirects to TheFork manager since the merger) | via TheFork | "iens" reviews still get tagged on the source |
| OpenTable | https://restaurant.opentable.com | yes | small NL volume |
| Quandoo | https://restaurant.quandoo.com | yes | small NL volume |
| Thuisbezorgd | https://restaurants.thuisbezorgd.nl | export reviews via dashboard | delivery reviews — different audience than dine-in |
| Sitedish | https://admin.sitedish.shop (or your custom storefront admin) | check admin dashboard | takeaway storefront on sitedish.shop |
| Socialdeals | https://verkoper.socialdeals.nl | reviews tied to past deals | usually has reviews from each deal redemption |
Aggregator-only (no owner account, manual or third-party)
These sites scrape or aggregate from elsewhere. Michiu may not have a verified owner profile, so reviews must be pulled manually.
| Platform | Listing URL pattern | Notes |
|---|---|---|
| TripAdvisor | https://www.tripadvisor.com/Restaurant_Review-g188590-d5794434-Reviews-Michiu-Amsterdam_North_Holland_Province.html | verified listing; ~113 reviews per Wanderlog crawl. Strict scrape ToS — copy-paste only |
| Yelp | https://www.yelp.com/biz/michiu-amsterdam | verified listing; usually tiny EU volume |
| RestaurantGuru | https://restaurantguru.com/Michiu-Amsterdam | verified — aggregator that re-hosts Google/TripAdvisor reviews. Beware double-counting if you've already imported from Google or TripAdvisor |
| Dinestar | dinestar.nl/restaurant/... | small NL directory |
| Spontaan | spontaan.nl/.../michiu | last-minute booking; light review volume |
| Whynot | whynot.com or whynot.nl | confirm exact platform |
| Foursquare / Swarm | https://foursquare.com/v/michiu/5224add911d2bd75848790ee | verified, listed since 2013. Tips (≈mini-reviews) require login to scrape; copy-paste only |
Facebook — needs consolidation BEFORE importing
Web research surfaced four separate Michiu pages on Facebook, almost certainly orphan duplicates from pre-2024 brand changes:
| URL | Listed name | Notes |
|---|---|---|
| https://www.facebook.com/michiu102/ | "Michiu Lounge | Amsterdam" | likely the active page; keep this one |
| https://www.facebook.com/people/Restaurant-Lounge-Michiu/100043262305921/ | "Restaurant-Lounge Michiu" | orphan duplicate — merge or delete |
| https://www.facebook.com/pages/category/Sushi-Restaurant/Restaurant-Lounge-Michiu-508308612612685/ | "Restaurant-Lounge Michiu" | second orphan duplicate — merge or delete |
| https://m.facebook.com/profile.php?id=579630392108669 | "Michiu" sushi restaurant | third orphan profile — investigate, claim or report |
Action before importing Facebook reviews:
- Log in to Meta Business Suite as the verified owner
- Determine which of the 4 pages has the most followers / reviews / authentic activity
- Use Facebook's "Merge duplicate pages" tool (Settings → Page Info) to consolidate
- Once merged, export the recommendations + reviews via Meta Business Suite (no native CSV — copy-paste each, or use Meta Graph API)
- Then import via
pnpm import:csvwithsource=facebook
This is high-leverage operational work — orphan pages dilute review counts, fragment SEO, and make Facebook ad targeting less effective.
CSV format for non-Google imports
All imports use the unified schema in imports/example.csv:
source,external_id,review_url,author_name,author_email,rating,review_text,
language,review_date,reply_text,reply_date,internal_notes
The source column must match one of the slugs in src/lib/reviews/types.ts
(REVIEW_SOURCES const). All 15 platforms above are valid as of migration
0003_extend_review_sources.sql.
If the platform's CSV doesn't have a review id, leave external_id blank —
the importer derives a stable id from source + date + author_slug so
re-runs dedupe.
Practical workflow
- Pick a platform from the owner-controlled table.
- Log in to the owner dashboard, export reviews to CSV.
- Open in Excel / Numbers / LibreOffice. Map the columns to the unified
schema (rename headers, fill in
sourceandreview_datecolumns, YYYY-MM-DD format). - Save as
imports/<platform>-2026-05.csv(any name, just keep.csvand notexample.csv). - Run
pnpm import:csv. - Repeat for the next platform.
Files in imports/ (other than example.csv) are gitignored — they contain
guest PII and don't belong in version control.
Edge cases
- Same review on two platforms. RestaurantGuru re-hosts Google and
TripAdvisor reviews. If you import from both Google and RestaurantGuru,
you'll get duplicates with different
external_ids. Either skip RestaurantGuru after Google is wired up, or use theinternal_notescolumn to mark the duplicate for filtering later. - Old-name reviews. Reviews from 2020-2024 may show authors who reviewed "Michiu Lounge" — they're still your reviews. Import them at face value.
- Owner replies imported. If the platform's export includes the
merchant's existing reply (TheFork, Thuisbezorgd both do), use the
reply_textandreply_datecolumns. The importer marks themstatus='posted',prompt_version='imported',model_used='human'— preserved as historical record, never regenerated by the LLM.