Skip to main content
Raw data only. Yotpo lands as a raw warehouse table, not modeled dashboards or AI analysis. Raw tables are delivered only to organizations on a dedicated warehouse, for the tables picked under Warehouse → Raw data in your SourceMedium workspace. See Foundation and Pro.
Yotpo is a reviews, ratings, and loyalty platform for ecommerce brands. SourceMedium reads your Yotpo product reviews every six hours and lands them in your warehouse.
Sign in to SourceMedium, open your store, then choose Data sources → Connect data source and select the platform. You need an Admin or Editor workspace role.After you connect explains the first sync and connection statuses.

​
Vendor documentation

​
Requirements

  • A Yotpo Reviews Premium or Enterprise plan. Yotpo’s pricing lists API access from Premium up. On a lower plan, Yotpo accepts your credentials but will not serve reviews, and the connection says API access needs Premium or Enterprise. Reconnecting does not fix this.
  • The Yotpo account administrator. Only the administrator can see the API secret; Staff teammates cannot.

​
How to connect

1

Find your Store ID

In Yotpo Reviews, open the account menu at the bottom left, then Account Settings > General Settings. The Store ID (formerly App Key) is at the bottom of that section.
2

Get your API secret

Click Get secret key, enter the verification code Yotpo emails to the account address, and copy the API secret from the next screen.
3

Add them in SourceMedium

Find Yotpo in the connector picker and click Connect. Enter the Store ID and the API Secret in their fields, then click Save.
4

Confirm it is connected

SourceMedium checks the credentials with Yotpo before saving them, so a wrong Store ID or API secret is rejected on the spot. The connection reads Awaiting first data until the first sync lands, then Connected.
SourceMedium only ever reads from your connected platforms. It does not create, change, or delete anything, so create the key with read-only access wherever the platform offers it. Treat it like a password: keep it confidential and avoid sharing it over email or in spreadsheets. If the credential is rotated or revoked, follow this guide’s connection method to update SourceMedium.

​
What data syncs

Each review carries its score, title, content, the reviewer’s name as Yotpo publishes it, up and down votes, sentiment, the product SKU, your own customer reference (user_reference) where Yotpo has one, and its created and updated times. The deleted column is kept exactly as Yotpo returns it. It is not proof that a review was erased. Reviewer email addresses are not imported. Select yotpo__reviews under Warehouse → Raw data in your SourceMedium workspace to receive it in your_project.sm_sources.

​
Refresh and history

  • Refresh: every six hours, reading reviews updated since the previous sync with one day of overlap. Yotpo serves review data with about a one-hour delay.
  • History: the first sync reads every review on the account.

​
Known gaps

  • Very large review counts. The first sync reads all reviews in one pass, and a sync has a fixed time budget that covers about 720,000 reviews. A store with more reviews than that cannot complete its first sync yet. If that applies to you, contact your account manager or integrations@sourcemedium.com.
  • Product catalog. Yotpo’s product records are not imported. Join reviews to your products by SKU.