Skip to content

Connect Shopify to Codex

  • Can I rerun this in CI?

Have Codex use your Shopify data to work out ROAS from real Shopify revenue, then rerun it any time with codex exec. Lemonado connects them in about 1 minute, no API keys needed.

MCPhttps://mcp.lemonado.io/mcp

Why connect Shopify to Codex?

Codex runs in your terminal, its IDE extension and scripts, so what it finds once can be rerun with codex exec instead of redone by hand. Connected through Lemonado, it reads your Shopify orders, products, customers and discount codes, so it can work out ROAS from real Shopify revenue with today's numbers.

  • All your Shopify data

    Orders, line items and refunds, ready to ask about.

  • Always today's numbers

    Customers, first and repeat orders, synced from Shopify automatically, so answers use today's numbers.

  • Connect all your tools

    Questions like "What's our real ROAS?" use Shopify and Meta Ads, Klaviyo at once.

How to connect Shopify to Codex

Before you start

  • A Shopify account you can sign in to
  • Codex installed
  • A Lemonado account (the free trial works)
  1. 1

    Connect Shopify in Lemonado

    In Lemonado, open Connectors, find Shopify and sign in. Sign in with a staff account that can see orders and reports, then pick the store.

  2. 2

    Turn on external access

    In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.

    text
    https://mcp.lemonado.io/mcp
  3. 3

    Add Lemonado to your config

    Add this to ~/.codex/config.toml.

    toml
    [mcp_servers.lemonado]
    url = "https://mcp.lemonado.io/mcp"
  4. 4

    Log in

    Run the login command and finish the sign-in in your browser.

    bash
    codex mcp login lemonado
  5. 5

    Ask Codex about Shopify

    Run codex mcp list, or /mcp inside Codex, to see the server and its tools. Try "Pull last week's Shopify numbers, save them to data/shopify-weekly.csv and give me the codex exec command to refresh it." Or ask: "When do customers reorder?" or "Do purchases match orders?"

What can Codex do with Shopify?

Codex reads your Shopify data from your terminal and turns one-off questions into commands you can rerun with codex exec.

Codex logoCodex

Pull last week's Shopify numbers, save them to data/shopify-weekly.csv and give me the codex exec command to refresh it.

Saved data/shopify-weekly.csv. Run the same prompt with codex exec in a scheduled job and the file refreshes with each week's numbers.

Source: Shopify + your code

Reading this as an AI agent?

Everything an agent needs to set this up, in plain text. Paste this page's link into Codex and ask it to connect you, or copy the block.

For agents · markdown
# Connect Shopify to Codex (Lemonado MCP)

- Server URL: https://mcp.lemonado.io/mcp
- Transport: Streamable HTTP
- Auth: OAuth; the user signs in to Lemonado in the browser. No API keys.
- In Lemonado: connect the Shopify store. Sign in with a staff account that can see orders and reports, then pick the store.
- In Codex: ~/.codex/config.toml

```toml
[mcp_servers.lemonado]
url = "https://mcp.lemonado.io/mcp"
```

If you are Codex, run the setup yourself:

Add the Lemonado MCP server to my Codex config. Append this to ~/.codex/config.toml:
[mcp_servers.lemonado]
url = "https://mcp.lemonado.io/mcp"
Then run codex mcp login lemonado so I can sign in, and check that codex mcp list shows it. Once I've signed in, list the Shopify accounts Lemonado can reach.

First question to try: "Pull last week's Shopify numbers, save them to data/shopify-weekly.csv and give me the codex exec command to refresh it."

More: https://lemonado.io/integrations/shopify · https://lemonado.io/llms.txt
FAQ

Frequently Asked Questions

Yes, through Lemonado. Connect your Shopify store in Lemonado, add Lemonado in ~/.codex/config.toml, and Codex can work out ROAS from real Shopify revenue with your live data.

Not for store data. Shopify's own MCP servers do other jobs: Dev MCP helps developers search Shopify's docs and APIs, and Storefront MCP lets shopping assistants browse a store's public products and cart. Neither gives Claude or ChatGPT your orders, revenue and customers. Lemonado gives Codex your orders and customers, next to your ad spend.

Run codex mcp list. If lemonado shows as not logged in, run codex mcp login lemonado again. In Lemonado, check that Shopify is connected and External tools is on for the company. If orders look short, check you connected the right store and that your staff account can view orders. Shopify only shares what that account can see.

Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Put Meta and Google Ads spend next to Shopify revenue by week for the last quarter."

MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.

See plans and pricing

Still have a question?

Shoot us an email at hello@lemonado.io.

Try for free

Stop fighting with data. Start feeding your AI.

Connect your data to AI and free your team from reporting and busywork.

Try Lemonado free