Skip to content
DataSync by DataGem logo

DataSync

by DataGem · Amazon connector

Your Amazon seller reports, in your own BigQuery, every day.

DataSync is DataGem Consulting's data platform: it syncs a business's data sources into BigQuery in its own Google Cloud project. Its connector for businesses that sell on Amazon is free. Once you authorize it in Seller Central, it requests your order, seller-fulfilled return and FBA shipment reports through Amazon's Selling Partner API and writes them to your BigQuery dataset every day, ready for SQL, Looker Studio or any BI tool.

  • Free connector
  • Read-only
  • No buyer names or contact details

What the connector does

Your seller reports, delivered to your warehouse.

  • Orders, returns and FBA shipments

    Three Seller Central reports, synced every day: all orders by last update, returns of seller-fulfilled orders by return date, and Amazon-fulfilled (FBA) shipments. FBA customer returns are not included.

  • Into your own BigQuery

    Rows land in tables in a BigQuery dataset in your own Google Cloud project. The data is yours: you decide who can query it, and DataSync's service accounts use their access only to run the sync, until you remove them.

  • Every region you sell in

    North America, Europe and the Far East, with one authorization per region and the marketplaces you choose. The Japan marketplace is not supported yet.

  • Daily and hands-off

    Each day, a scheduled job reloads your tables with your recent activity: the last 7 days by default, up to 30 days. On request, we set your tables to build up history instead, merging each update by key.

  • Read-only

    The connector only requests and downloads reports. It never changes your listings, prices, inventory or orders.

  • Ready for any BI tool

    Query the tables with SQL, or connect Looker Studio, Google Sheets or the BI tool you already use.

How it works

Three steps, set up with you.

  1. 01

    Prepare your Google Cloud project

    DataSync normally runs in your own Google Cloud project, so you need one with billing enabled. We set it up with you: DataSync's service accounts, with administrator roles in that project, and a sync job that writes to BigQuery there, started each day by a schedule that DataGem runs.

  2. 02

    Authorize the connector in Seller Central

    For each region you sell in, you open the consent link we send you and approve DataSync on Amazon's own consent page, signed in with your seller account. DataSync never sees your password: Amazon issues it a token limited to the access you approved. Amazon asks you to renew this approval every 365 days. Before it expires, we send you a new consent link for each region, and you renew through that link.

  3. 03

    Use your data

    Each day, the job reloads your tables with your recent activity. Connect Looker Studio, Google Sheets or any BI tool to the dataset.

Data access

Exactly what the connector reads.

ReportWhat it containsSelling Partner API report type
All ordersOrders updated in the period, with their current status: order and item IDs, dates, products (SKU, ASIN), quantities, prices, taxes and promotions, fulfillment and sales channel, and the ship-to city, state or region, postal code and country.GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL
ReturnsReturns of seller-fulfilled orders, by return date: order, product, quantity, return reason, status, refund and return-label details. FBA returns are not included.GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE
FBA shipmentsShipments fulfilled by Amazon: shipment, order and item IDs, dates, products, quantities, prices, carrier, tracking number, fulfillment center, and the ship-to (and, where Amazon provides it, billing) city, state or region, postal code and country.GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL

The connector requests a single Selling Partner API role, Inventory and Order Tracking, and no restricted role. Amazon therefore leaves buyers' names, street addresses, email addresses and phone numbers out of these reports. They can still include each order's ship-to city, state or region, postal code and country, which Amazon treats as buyer personal information. The connector only reads: it never changes your listings, prices, inventory or orders.

Pricing

The Amazon connector is free.

Amazon connector

Free

The connector costs nothing: no subscription, no per-order fee, and DataGem never asks for your payment details for it.

Your Google Cloud project needs its own billing account with Google, which bills the project directly for what the sync uses: mainly a daily Cloud Run job, BigQuery storage and queries, and a few stored secrets.

DataSync platform

Paid, quoted

Access to the rest of the DataSync platform, with connectors for other sources such as storefronts, advertising platforms, marketplaces and 3PLs, is a paid service, quoted for each business.

Dashboards or custom pipelines built on top of your data are quoted separately as consulting. Both are optional: the Amazon connector stays free either way.

Security

How the connector handles seller data.

  • Amazon's own authorization

    You approve DataSync on Amazon's consent page. We never receive your Seller Central password, and you can revoke access at any time.

  • One non-restricted role

    DataSync holds one Selling Partner API role, Inventory and Order Tracking, and uses it only to request and download the three reports above. It cannot see buyers' names, street addresses, email addresses or phone numbers.

  • Encrypted credentials

    The tokens Amazon issues, and the key DataSync uses for your Google Cloud project, are encrypted with AES before DataSync stores them in its database. All API traffic uses HTTPS (TLS).

  • Report rows go to your dataset only

    The sync job writes your report rows to your BigQuery dataset and nowhere else. DataSync's own database stores no report rows.

  • Staff access, disclosed

    DataGem employees who operate DataSync can access your account details, authorization records, including tokens, and run records, and, through DataSync's service accounts, everything their administrator roles cover in your Google Cloud project. They use this access only to set up DataSync, fix failed runs and answer your requests.

  1. 1. Who we are

    The DataSync Amazon connector ("the connector") is provided by DataGem Consulting, 4 Rue Principale, Linstroff, 57660 Grostenquin, France ("DataGem", "we"). DataGem is a separate company from your business and works only through the permissions you grant. This policy covers the information the connector handles when you connect an Amazon seller account. Visits to our website are covered by our general Privacy Policy.

  2. 2. Information we collect

    • Account and contact details: the names and email addresses of the people who set up DataSync for your business, and your Google Cloud project ID and number.
    • Google Cloud access: a key for a DataSync service account in your Google Cloud project, which DataSync uses to run the sync job and write to your BigQuery dataset.
    • Authorization data: your selling partner ID, the regions and marketplace IDs you connect, and the OAuth tokens Amazon issues when you authorize DataSync.
    • Report data: the rows of the three reports listed on this page, which DataSync requests from Amazon's Selling Partner API on your behalf. DataSync requests no restricted role, so Amazon leaves buyers' names, street addresses, email addresses and phone numbers out of these reports. They can still include each order's ship-to city, state or region, postal code and country, which Amazon treats as buyer personal information.
    • Operational records: the status, start and end times and any error message of each sync run, plus the sync job's logs, which record row counts.
  3. 3. How we use it

    Only to provide the connector to you: to authorize access, run the scheduled syncs, write your data to your BigQuery dataset, detect and fix failed runs, and answer your support requests. For the contact details of the people who set up DataSync, and any other personal data in your account and authorization data, we rely on our legitimate interest in providing DataSync to your business and keeping it secure (Article 6(1)(f) GDPR), or on our agreement with you where you contract with us in your own name (Article 6(1)(b) GDPR). For buyer data in the reports, we act only as your processor, as set out in the terms below.

    We do not sell or rent this information, use it for advertising, share it with other sellers, or use it for any purpose other than providing the connector to you.

  4. 4. Where it is stored and how it is protected

    • Report rows are written only to BigQuery in your own Google Cloud project, where you control access and retention. DataSync's database does not store them.
    • The sync job normally runs in your Google Cloud project, and its logs stay there. If it cannot run there, DataSync can run it in DataGem's Google Cloud project instead: it still writes only to your dataset, and that run's logs are kept in DataGem's project. Logs record row counts and, when a value fails to load, can include that value.
    • Account details, encrypted credentials and run records are stored in DataSync's database, hosted by Neon on Amazon Web Services in the United States. DataSync's services run on Google Cloud. Transfers outside the European Economic Area are covered by our providers' data processing terms, which include the European Commission's standard contractual clauses.
    • Tokens and keys are encrypted with AES before storage, all traffic uses HTTPS (TLS), and our hosting providers encrypt stored data at rest.
    • DataGem employees who operate DataSync can access your account details, authorization records, including tokens, and run records. Through DataSync's service accounts, they can also reach everything those accounts' administrator roles cover in your Google Cloud project, including the DataSync job, its logs and all BigQuery datasets, Cloud Storage buckets and secrets there. They use this access only to set up DataSync, fix failed runs and answer your requests. We recommend a Google Cloud project used only for DataSync.
  5. 5. Sharing

    We share this information only with the providers that host DataSync and process data on our behalf (Google Cloud, and Neon on Amazon Web Services); with Amazon, when its Data Protection Policy requires it, for example to report a security incident or during a security audit; or where the law requires it. We never pass Amazon information to third parties for their own use.

  6. 6. Retention and deletion

    • We keep account details, authorization data and run records while DataSync is connected to your account.
    • When you revoke DataSync in Seller Central, when you ask us to stop, when Amazon asks us to, or when our access to your account otherwise ends (for example, an authorization you do not renew), we stop all syncs. Within 30 days, we permanently delete everything DataSync holds about your account: account and contact details, authorization data including tokens, the Google Cloud key and any copies of your service-account keys, and run records. We also remove the DataSync job and DataGem's access to your Google Cloud project. When you revoke DataSync in Seller Central, please also tell us, so we can act straight away.
    • Report data in your BigQuery dataset belongs to you and stays under your control. You can delete it at any time. Until we remove the DataSync job, a run that receives no data from Amazon, for example after you revoke access, empties the tables it reloads; tables set up to build up history keep their rows.
  7. 7. Security incidents

    If we detect an actual or suspected security incident affecting your data, we contain it, notify you without undue delay, and notify Amazon at security@amazon.com within 24 hours, as Amazon's Data Protection Policy requires.

  8. 8. Your rights

    You can ask us to access, correct, export or delete your personal data, or to restrict or object to its processing, by writing to contact@datagem-consulting.com. If you are in the EU, the EEA or the UK, you can also lodge a complaint with your data protection authority; in France, the CNIL.

  9. 9. Changes to this policy

    We will post any change on this page with a new date, and email connected sellers about significant changes.

  1. 1. The service

    The DataSync Amazon connector lets a business that sells on Amazon copy the reports listed on this page into BigQuery in its own Google Cloud project. DataGem Consulting provides the connector free of charge. Access to the rest of the DataSync platform is a separate, paid service, and these terms do not cover it.

  2. 2. Your responsibilities

    • You must be authorized to act for the seller account you connect.
    • You need a Google Cloud project with its own billing account with Google. Google bills that project for the resources the sync uses, and you control who can access it.
    • You use the connector for your own business and in line with Amazon's policies, and you do not try to disrupt or misuse it.
  3. 3. Your data

    Your data remains yours. You allow DataGem to access and process it only to run the connector for you, as described in the privacy policy above.

    Where the reports contain personal data of your buyers, you are its controller and DataGem processes it as your processor under Article 28 GDPR: only on your documented instructions to run DataSync, under confidentiality, and with the security, deletion and assistance commitments on this page. Our sub-processor for this data is Google Cloud. We tell you before adding or replacing a sub-processor so that you can object, we bind each sub-processor to equivalent data protection terms, and we give you the information you need to demonstrate compliance, including for audits.

  4. 4. Availability and changes

    We aim to complete every scheduled sync, but the connector is provided as is, without warranties. Amazon and Google can change their APIs, and a sync can be delayed. We may change or discontinue the connector with reasonable notice to connected sellers.

  5. 5. Liability

    To the extent permitted by law, DataGem is not liable for indirect losses, or for losses caused by the services of Amazon or Google. Nothing in these terms limits liability that the law does not allow to be limited.

  6. 6. Ending the service

    You can stop at any time by revoking DataSync in Seller Central (Apps and Services, then Manage Your Apps) and telling us, or by writing to us. We can suspend access in case of misuse. When the service ends, we stop syncing and delete your data as set out in the privacy policy.

  7. 7. Governing law

    These terms are governed by the laws of France. Any dispute is subject to the jurisdiction of the competent courts of France.

Support and contact

Questions? Write to us.

Company
DataGem Consulting
Address
4 Rue Principale, Linstroff, 57660 Grostenquin, France

Amazon and all related marks are trademarks of Amazon.com, Inc. or its affiliates. DataSync is an independent app from DataGem Consulting and is not affiliated with, sponsored by or endorsed by Amazon. See also our website Privacy Policy and Terms of Use.