VedronERP · Marketplace Integrations
Amazon Integration
The Amazon integration imports your financial settlement data and allows you to supplement customer address information. Understanding what is and is not available helps you get the most out of the integration.
What Is Available
- Financial statement import — Amazon settlement reports are downloaded automatically via the SP-API Reports API and imported into the M1 financial pipeline.
- Customer address import — You can upload an order report (TSV) exported from Seller Central to import full shipping addresses and buyer names.
What Is Not Available
- Live order sync — Amazon's Restricted Data Token (RDT) policy restricts real-time customer data access. Full addresses are not available via the SP-API for most sellers.
- Automatic customer address sync — Addresses must be imported manually via the TSV order report workaround described below.
Step 1: Configure LWA Credentials
The integration requires Login with Amazon (LWA) credentials obtained from the Amazon Developer Console.
- Go to Credentials → Amazon in the ERP.
- Enter your LWA Client ID (lwa_client_id).
- Enter your LWA Client Secret (lwa_client_secret).
- Enter the Refresh Token (refresh_token) for the Selling Partner API.
- Save the credentials. The ERP will use these to authenticate all SP-API requests.
Tip: To obtain a Refresh Token, you must complete the Selling Partner API onboarding in Seller Central and authorize your developer application. Select the "Finance" report type permission at minimum.
Step 2: Import Amazon Financial Statements
Once credentials are configured, the ERP automatically downloads and imports Amazon settlement reports (flat-file settlement V2) for all closed settlements not yet imported.
- Go to Financial Statements → Amazon tab.
- Click "Run M1 Import" to trigger the settlement report download.
- The ERP fetches all closed settlements from Amazon and imports transactions into M1.
- Run M2 → M5 as normal to process the financial data through the pipeline.
Step 3: Import Customer Address Data (TSV Workaround)
Amazon's EU privacy (RDT) policy restricts customer address data in the SP-API for most sellers. To import full shipping addresses, download an order report from Seller Central and upload it to the ERP.
- Log in to Amazon Seller Central.
- Navigate to Reports → Fulfillment or Orders → Order Reports.
- Download the order report as a TSV (tab-separated) file for the relevant period.
- In the ERP, go to the Amazon Integration page.
- Click "Import Customer Data" and upload the file.
- The ERP reads buyer name, email, and full shipping address from each row and stores them linked to the corresponding order.
Tip: The TSV file from Seller Central contains columns like buyer-name, recipient-name, ship-address-1, ship-city, ship-postal-code, and ship-country. These are read automatically — no column mapping is needed.
Note: If you have PII (Personally Identifiable Information) data access role enabled in Seller Central, the SP-API may return addresses directly. Contact Amazon Seller Support to check your account's PII access status.
Amazon Offers Tab — Listing Sync
The Offers tab inside the Amazon integration shows your active Amazon listings and lets you view and update prices and quantities inline.
- Go to Marketplace → Amazon → Offers tab.
- Click "Sync Offers" to fetch your current listings from Amazon Seller Central.
- Each row shows ASIN, SKU, title, marketplace, current price, and quantity.
- Click a price or quantity cell to edit it inline and push the change to Amazon.
ASIN Analytics — Page Views & Sessions
The Analytics tab shows daily page views and unique sessions per ASIN across all your marketplaces, fetched from the Amazon SP-API.
- Go to Marketplace → Amazon → Analytics tab.
- Click "Sync Analytics" to pull the latest traffic data from Amazon.
- Filter by marketplace (e.g., amazon.de, amazon.co.uk) or ASIN.
- The table shows page views, sessions, and buy-box percentage per ASIN per day.
- Click "Enrich" to automatically link ASINs to ERP products via EAN/GTIN matching.
Tip: Run "Enrich" after syncing offers so that ASIN analytics rows display your internal article number alongside the ASIN. This makes cross-referencing with inventory much easier.