Amazon Seller Central + Orcabase
Your Amazon sales, next to your own store.
Selling on Amazon and on your own site? Sync Seller Central through Fivetran and ask what sells where, what Amazon’s fees really cost, and when stock runs out, in plain words.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which products sell better on Amazon than on our own store?
Cold brew packs sell 2.4 times as many units on Amazon as on our store.
- Decaf is the only other product that does better there.
- After Amazon’s fees, the sampler earns 31% less there.
- Amazon buyers rarely go on to subscribe.
Amazon’s share of units sold, %
How I got this· 4 steps
- Looked at your Amazon orders and your store’s orders
- Matched products across both
- Worked out Amazon’s share of units
- Took Amazon’s fees off each product
Example answer. Numbers are illustrative.
In plain words
How do I analyze Amazon Seller Central data?
Seller Central has plenty of reports, each in its own corner. Fivetran pulls your orders, fees, inventory and returns into a database Orcabase hosts for you, so you can ask across them, and across your own store too.
Ask “what did Amazon keep in fees on each product last month?” and get the answer with a chart.
Ask in plain words
What you can ask about your Amazon Seller Central data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
What did Amazon keep in fees last month, by product?
Which products will run out at Amazon’s warehouses soon?
How do Amazon sales compare with our own store, week by week?
What’s our return rate on Amazon, and what reasons do buyers give?
Which products make the most after fees?
How many units did we sell in each marketplace?
Which orders are still unshipped?
Show me daily units sold for our top product.
What comes in
Your Amazon Seller Central data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Orders and items
Fees and settlements
Inventory
Returns
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Amazon Seller Central data.
Amazon revenue
Amazon sales minus refunds.
Fee rate
Amazon’s fees as a share of Amazon sales.
Days of stock
Units in stock divided by average daily units sold.
Return rate
Returned units as a share of units sold.
Dashboards to start with
Your Amazon Seller Central numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Amazon
4 charts- Sales by day
- Fees by product
- Days of stock
- Returns by reason
All channels
3 charts- Amazon vs own store
- Units by product and channel
- Margin after fees
Better together
Ask across Amazon Seller Central and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect Amazon Seller Central, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Amazon Seller Central. Pick the database to sync into.
- 2
Connect Amazon Seller Central on Fivetran’s page
Fivetran’s page asks for the app you register in Seller Central (its client ID, secret and refresh token) and your merchant token. Fivetran’s guide walks through each step.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Amazon Seller Central data.
What you’ll need
- A Seller Central account with the Account Administrator role.
- A private developer registration in Seller Central, which Amazon requires before it shares seller data.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Why is there a developer step?
Can Orcabase change my listings or prices?
Do I need a Fivetran account?
How fresh is my Amazon Seller Central data in Orcabase?
What does syncing cost?
Your Amazon Seller Central data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.