---
title: "ShopMy Integration for Rig: Query ShopMy Data in Plain English"
description: "Connect ShopMy to Rig and query your ShopMy data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse."
canonical: "https://rig.so/integrations/shopmy"
format: markdown
---

Browse integrations

![ShopMy logo](https://img.logo.dev/shopmy.us?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true)

Marketing & email Supported

# ShopMy integration for Rig

## The easiest way to connect ShopMy to Claude and other AI tools

ShopMy is a creator commerce platform where influencers build shoppable storefronts and earn commission on the sales they drive.

[Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo)

## What Rig syncs from ShopMy

Once connected, Rig models these objects so questions resolve to the right tables and joins:

- Affiliate orders
- Commissions
- Creator attribution
- Order values

## How ShopMy connects to Rig

Give Rig an API key. Rig syncs the partner order report, covering affiliate and influencer orders together with the commissions attached to them, so creator performance can be measured against real order data rather than inside the platform's own dashboard.

## Work out which creators actually pay off

Creator programmes are usually assessed on reach and gifted product, because the sales data lives somewhere else. With ShopMy orders and commissions in the warehouse beside your store data, each creator can be measured on net contribution after commission.

Ask Rig

- Which creators drive the most revenue net of commission?
- What is the average order value from creator-driven orders?
- Which creators bring customers who buy again?

## Compare affiliate against your other channels

Affiliate is often excluded from blended reporting because it is measured differently. Held in the same warehouse and modelled the same way, it takes its place next to paid and organic on cost per acquisition and contribution.

Ask Rig

- How does affiliate cost per acquisition compare with paid social?
- What share of revenue comes through creator commerce?
- Is affiliate growing as a share of new customers?

## Check commission spend against margin

Commission is a real cost and rarely appears in margin analysis. With commissions joined to orders and product costs, you can see which products can carry the rate and which are being sold at a loss once commission is counted.

Ask Rig

- What is our contribution margin after commission by product?
- Which products are unprofitable at the current commission rate?
- How much did we pay in commission last quarter, and on what?

## Ask your ShopMy data in Claude, ChatGPT or Cursor

Rig serves your ShopMy data to AI assistants over MCP. Once ShopMy is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

- [Claude](https://rig.so/integrations/claude)
- [Claude Code](https://rig.so/integrations/claude-code)
- [Cursor](https://rig.so/integrations/cursor)
- [ChatGPT](https://rig.so/integrations/chatgpt)
- [Codex](https://rig.so/integrations/codex)
- [Gemini](https://rig.so/integrations/gemini)

## Frequently asked questions

What does Rig sync from ShopMy?

The partner order report: affiliate and influencer orders with the commissions attached to them.

Can I join creator orders to my store data?

Yes. Once ShopMy and your ecommerce platform are in one warehouse, creator-driven orders sit alongside every other order and can be compared on the same terms.

What do I need to connect ShopMy?

An API key, used as a bearer token.

How often can it sync?

ShopMy caps requests per day, so Rig paces itself accordingly. For most brands a daily sync is comfortably within the limit.

## Related integrations

[![ActiveCampaign logo](https://img.logo.dev/activecampaign.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)ActiveCampaignContacts, deals, campaigns and automations from ActiveCampaign.](https://rig.so/integrations/activecampaign)[![Alia logo](https://img.logo.dev/alia.me?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)AliaPopup and quiz capture funnels, with attributed orders and quiz answers.](https://rig.so/integrations/alia)[![Apollo.io logo](https://img.logo.dev/apollo.io?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Apollo.ioOutbound sequence and reply-rate analytics from your Apollo.io data.](https://rig.so/integrations/apollo)[![Beam (Lightmeter) logo](https://img.logo.dev/lightmeter.io?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Beam (Lightmeter)Cold outbound deliverability and reply-rate analytics from your Beam by Lightmeter data.](https://rig.so/integrations/beam)[![GoAffPro logo](https://img.logo.dev/goaffpro.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)GoAffProAffiliate revenue and commission analytics from your GoAffPro data.](https://rig.so/integrations/goaffpro)[![HeyReach logo](https://img.logo.dev/heyreach.io?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)HeyReachLinkedIn outreach and acceptance-rate analytics from your HeyReach data.](https://rig.so/integrations/heyreach)

## Connect ShopMy data to AI tools like Claude

Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust.

[Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo)

---

- [This page as HTML](https://rig.so/integrations/shopmy)
- [Site map for language models](https://rig.so/llms.txt)
- [API and agent documentation](https://rig.so/developers)
