USER GUIDE BetterShop Analytics
A complete reference for managing Amazon operations — connecting Amazon SP-API data, supplier/seller analytics, VAT compliance, and advanced reporting in one unified platform.
Platform Overview
BetterShop is a central command hub for Amazon operations, consolidating supplier and seller data into a real-time view of your business. It connects directly to Amazon's SP-API to deliver insights into sales, costs, inventory, tax, and more.
The platform is organized in three main areas depending on user type:
CHAPTER 2Login & Interface
Accessing the Platform
Once you click Login on the BetterShop homepage, you are redirected to the sign-in page:
https://dashboard.bettershopanalytics.com/login
You can sign in using:
- Credentials provided by the BetterShop team (email + password)
- Google account
- Microsoft account
To switch between Seller and Vendor environments, use the Seller / Vendor toggle at the bottom-left of the sidebar. Then go to Settings to select the target account.
CHAPTER 4.0Users Module
The Users Table lists all users with access to BetterShop Analytics. Administrators can assign Roles and Permissions per user, control which accounts and brands each user can view, and enable two-factor authentication.
New users can only be created via an invitation request sent to the BetterShop team. Use the three-dot menu on each user row to edit roles, accounts, and brand permissions.
CHAPTER 4.1Accounts Module
The Accounts Module is where you manage all Amazon accounts connected to your BetterShop workspace. Each account can be a Seller Central, Vendor Central, or Advertising account.
Account Listing Table
The main view shows all connected accounts with the following columns:
| Column | Description |
|---|---|
| Account Name | Name assigned within the platform |
| Amazon Vendor Account Number | ID of the Amazon Vendor account (if applicable) |
| Account Type | Vendor, Seller, or Advertising |
| Management | Internal, External, or Partner |
| Region | EU, UK, US, etc. |
| Discount % | Vendor only — co-op / contractual discounts for margin calculation |
| Margin BS | BetterShop margin configuration |
| Marketplaces | Linked marketplaces |
| Actions | Edit, delete, configure |
Filters
- Search by Account – Filter by name
- Account Type – Seller / Vendor / Advertising
- Management – Ours / Partner / New
Actions (Three-dot Menu)
- Edit – Opens the side panel to update name, region, discount, margin, marketplaces
- Delete – Permanently removes the account
Manual Sync Jobs (Seller Accounts)
| Action | Description |
|---|---|
| Add Inventory Sync Job | Manual refresh of FBA + FBM inventory |
| Add Sales and Traffic Job | Forces refresh of Business Reports data |
| Settlement Report Sync Job | Imports Settlement reports for fees/financial data |
| Add Tax Sync Job | Manual sync of VAT/tax reports |
| Subscribe | Enables automatic continuous synchronization |
Vendor Accounts
- Start Retail Analytics Job – Manual refresh of Retail Analytics
- Subscribe – Enables automatic Vendor data sync
For the Seller Orders module, you must configure warehouse information via Manage Warehouse Address in the Account actions panel.
CHAPTER 4.3Catalog Module
The Catalog Module is the central area for all product-related information. Many BetterShop features (Buy Box, margin calculations, Page Quality, pricing, inventory) depend directly on the data stored here.
The Catalog contains five subsections:
CHAPTER 4.3.1Products
The Products section is the core catalog area storing all items for connected Amazon accounts. It feeds margin calculations, Buy Box monitoring, Page Quality, pricing, inventory, and brand mapping.
Product Listing Columns
| Column | Description |
|---|---|
| SKU | Imported from Amazon or created manually |
| ASIN | Unique Amazon product identifier |
| Brand | Brand assigned to the product |
| Category | Amazon category mapping |
| Title | Title from Amazon datasets |
| Sub Category | Custom 1/2/3-level subcategory |
| Product Cost | Used for margin and price evaluations |
| Active | Whether the product is tracked by the system |
The Active Flag
Active = Yes → product is included in Buy Box, pricing tools, margin calculations, and Page Quality checks.
Active = No → product is ignored by all these modules.
Three Ways to Add Products
Manual Creation – Click the Create Product button and fill in details.
Bulk Import / Update – Export the current list (Actions → Export), edit the Excel file, then re-upload (Actions → Upload). Used for mass cost updates, category mapping, brand normalization.
Automatic Ingestion from Amazon – The system syncs daily with Amazon APIs. For Seller: daily sync from the Seller Product Catalog API. For Vendor: products are created from Purchase Orders (last 6 months) and Retail Analytics (last 4 years / 2 years of missing ASINs).
Editing a Product
The three-dot menu on each row gives access to Edit, Delete, and View Details. The edit panel is structured in three tabs:
- Product Tab – Name, account, brand, SKU, ASIN, cost, category, subcategories
- Tech Information Tab – Co-op recharge, chargebacks, dimensions, weight, for margin simulation and Page Quality
- Expense by Country Tab – VAT, margin, expected revenue, shipping cost, retail price per marketplace
CHAPTER 4.3.2Campaigns
The Campaigns section manages the link between Amazon Advertising campaigns and brands defined in the Product Catalog. This mapping is critical because it enables brand-level filtering in Amazon Ads → Advertising Overview.
Why Brand Mapping Matters
If a brand name differs across modules (e.g., BETTERSHOP in Products vs BETTERSHOP 1 in Campaigns), the Advertising Overview will fail to recognize the connection and data will appear under "Non Brand".
Bulk Upload Mapping
Click Upload Bulk in the top-right corner.
Select Download Sample to export a CSV with all campaigns.
Fill in the Sub Brand column using exact brand names from Catalog → Products → Brand.
Save and re-upload the CSV via Upload File.
Daily Synchronization
BetterShop automatically syncs campaigns daily. New campaigns are added automatically. Unmapped campaigns appear under Non Brand in Advertising Overview. First activation fetches the last 6 months of history.
Best Practices
- Use brand names exactly as they appear in the Product Catalog
- Regularly check for unmapped campaigns
- Use Bulk Upload for large-scale updates, manual mapping for individual corrections
- Verify new campaigns after each daily sync
- Also verify the Products table mapping to ensure alignment between Seller/Vendor Analytics and Ads metrics
CHAPTER 4.3.3Categories
Categories in BetterShop are user-defined and used for internal reporting, margin evaluations, price analysis, and product segmentation. They are independent of Amazon categories.
Creating a Category
Click Create Category and configure:
- Name – Internal label
- Commissions – Per marketplace: Referral Fee (%) and Minimal Fee (€)
Categories and commissions are used for Seller profitability calculations. Vendor accounts do not use Amazon referral fees since Amazon acts as the retailer.
CHAPTER 4.3.4FBA Fees Seller Only
FBA Fees manage the dimensional categories used to calculate Amazon fulfillment costs. These are essential for margin calculations, profitability analysis, and cost simulations.
Fee Listing Columns
| Column | Description |
|---|---|
| Name | Dimensional tier label (e.g., "Standard Envelope") |
| Longest / Median / Shortest Side | Maximum allowed dimensions per side |
| Is Oversize | Whether this tier is classified as oversize |
| Marketplace Fees | Base fee per marketplace, weight threshold, tier type |
BetterShop automatically matches products to fee tiers based on their dimensions and weight stored in the Product tab. If no matching tier is found, FBA cost cannot be calculated.
CHAPTER 4.4Advertising Overview
The Advertising Overview provides a complete analytical dashboard for monitoring Amazon Ads performance across accounts, profiles, and brands.
Access Path
Amazon Ads → Advertising Overview
Available Filters
- Account Selector – One or more Amazon Ads accounts
- Profile (Marketplace) – IT, ES, FR, UAE, etc.
- Brand Selector – Filter by brand (linked to Campaign mapping)
- Date Range – Auto-compares with previous equivalent period
KPI Summary Cards
| KPI | Description |
|---|---|
| Ad Spend | Total advertising investment |
| Ad Revenue | Revenue attributed to ads |
| ACOS | Ad Spend / Ad Revenue |
| ROAS | Return on Ad Spend |
| TACOS | Ad Spend / Total Revenue (organic + paid) |
| Impressions / Clicks | Visibility and traffic metrics |
| CTR / CVR | Click-through and conversion rates |
| Organic Sales | Total Product Sales – Ad Revenue |
Reading the Trend Chart
| Scenario | Interpretation |
|---|---|
| Ad Spend ↑ + Ad Revenue ↑ | Campaigns scaling correctly |
| Ad Spend ↑ + Ad Revenue flat | Potential inefficiency — optimize campaigns |
| Total Sales ↑ + Ad Spend flat | Organic sales improving — strong brand performance |
| TACOS ↓ | Ads becoming more efficient relative to total revenue |
| TACOS ↑ | Ads costing more relative to sales — review budgets/targeting |
Campaign Performance by Type
| Campaign Type | Description |
|---|---|
| SB AUTO / MANUAL | Sponsored Brands – automatic or manual targeting |
| SD AUTO / MANUAL | Sponsored Display campaigns |
| SBV AUTO / MANUAL | Sponsored Brands Video |
CHAPTER 4.4.2Search Term
The Search Term page provides metrics based on actual customer queries that triggered ads. It supports analysis by brand type, match type, and individual search terms.
Key Sections
- Brand vs Non-Brand – Spend, revenue, and ACOS split between branded and generic terms
- Match Type – Exact, Phrase, Broad performance comparison
- Search Term is NOT Keyword – Terms generating traffic but not actively targeted (harvest opportunities)
- Search Term Summary – Full granular table with campaign, ad group, and match type context
CHAPTER 4.4.3Advertising Audit
The Advertising Audit module provides diagnostic segmentation tabs for evaluating performance by campaign type, brand/non-brand, keyword match type, and spend allocation.
Available Tabs
- Campaign Type Segmentation – Performance breakdown by SB, SD, SBV, SP
- Brand vs Non-Brand Segmentation – Budget and revenue split for SP and SB
- Match Type Segmentation – Exact, Phrase, Broad for SP and SB
- Gaps in Keyword Match Type – Keywords used in only some match types (scaling opportunities)
CHAPTER 5Vendor Reports Vendor Only
The Vendor Reports menu is the administrative and financial core for Vendor Central accounts. It includes:
Use the Vendor/Seller toggle at the bottom-left of the sidebar to activate the Vendor panel.
CHAPTER 5.2Administration – Purchase Order Reconciliation
The Administration page consolidates all Purchase Orders and calculates the actual net margin after accounting for discounts, COOP, chargebacks, accepted quantities, and shipping costs.
PO Table Columns
| Column | Description |
|---|---|
| Purchase Order | PO identifier |
| Vendor Code / Brand | Vendor and brand reference |
| Ordered / Accepted Quantity | Volumes ordered vs accepted by Amazon |
| Delivery Window | Shipment period |
| Unit / Total Discount Price | Discounted amounts |
| Product Cost / Total Product Cost | Internal cost values |
| Unit Margin / Total Margin / Margin % | Calculated profitability |
Monthly Margin Summary Chart
Below the PO table, a summary chart shows month-by-month profitability with:
- Margin (purple bars) – Gross margin before shipping costs
- Net Margin (green bars) – Effective profit after shipment costs
- Discount Price (light purple) – Discounted invoice amount after co-op
- Shipment Cost (negative bars) – Monthly shipping expenses
- Margin % (line) – Profitability ratio on right axis
Hover over any bar to see a tooltip with complete monthly values. Use the Year Selector (top-right) to switch financial years.
CHAPTER 5.3Invoicing Module
The Invoicing module is the core workspace for monitoring issued invoices, reconciling Amazon payments, identifying discrepancies, and determining which open invoices require accounting action.
Invoice Table Key Columns
| Column | Description |
|---|---|
| Invoice Date / Payment Date | Dates of issuance and payment |
| Invoice Number / PO | Invoice reference and linked Purchase Order |
| Invoice Amount | Total amount billed to Amazon |
| Amount Paid | Amount Amazon has paid so far |
| NC Amount / NC Number | Credit note reference and value |
| Discrepancies ⚠️ | Most important field — unpaid difference (0 = fully reconciled) |
| SC / SC- / SCR / SCRSC | Amazon shortage claim audit workflow stages |
How Amazon Payment Cycles Work
Amazon receives the invoice and may withhold the full amount (shortage claim).
Amazon progressively adds back partial amounts, applies corrections and counter-corrections.
Cycles repeat: payment → retention → correction → retention → correction…
When Amazon stops adjusting, the remaining discrepancy is calculated.
If Discrepancy ≠ 0, the invoice requires action (dispute, credit note, or escalation).
CHAPTER 5.3.4Payment Cycle
The Payment Cycle provides the most detailed view of how Amazon manages each invoice's payment lifecycle — initial payment, retentions, shortage claims (SC/SCR), adjustments, and final settlement.
Use the search bar to isolate a specific invoice, then expand the row to see the full historical payment breakdown including each SC/SCR event with its amount, description, and date.
Invoice 5371: Amazon initially withholds €8,845 → corrects → re-withholds €8,296 → corrects → finally withholds €8,287 with no further correction → final discrepancy: –€8,287.12
CHAPTER 5.4Recap Costi Extra
Provides a monthly summary of all cost categories extracted from Amazon payment remittances, organized by cost type and month for the full year.
Cost Categories
Chargeback, Invoice, Return, C2FO, Provision, Audit, Coop, PQD, PQV, PPV, DFP/Advertising, AVS, Uncategorized — each shown with monthly totals and a year total.
Used for monthly closure, variance analysis, deduction trend monitoring, and identifying unusual cost peaks.
CHAPTER 5.5Remittance
Remittance exposes every payment event processed by Amazon — the raw remittance rows from which all upstream dashboards and reconciliation tools are built. It is the foundation layer of the entire Vendor reconciliation system.
Key Columns
| Column | Description |
|---|---|
| Payment Number | Unique payment identifier |
| Invoice Number | Invoice, SC, or Amazon internal reference |
| Description | Amazon's description (basis for Category Mapping) |
| Net Amount Paid | Final impact of the payment event |
| Type (Mapped Category) | INVOICE, CHARGEBACK, RETURN, PROVISION, etc. |
| Pattern | Keyword rule used to classify the row |
| Present in Invoicing | Whether this line is linked to an invoice in the Invoicing tab |
Remittance feeds all other Vendor modules: Invoicing (shortage/correction detection), Payment Cycle (SC/SCR events), and Recap Costi Extra (monthly category totals).
CHAPTER 5.6Category Mappings
Category Mappings transforms Amazon's raw remittance descriptions into structured financial data by defining pattern-matching rules.
Creating a Mapping Rule
Select Type: Invoice (Vendor remittances) or Settlement Report (Seller settlements)
Enter a Pattern — text to find in Amazon's description (e.g., fattura)
Select the Category to assign (INVOICE, CHARGEBACK, RETURN, PROVISION, etc.)
Toggle Is Regex for advanced pattern matching (start/end anchors, format patterns)
Enable Is Active and click Save
Without regex: if the description contains the pattern anywhere, the category is applied. With regex: you can require the pattern to be at the start, end, or in a specific format.
CHAPTER 5.7Return Remittance Payment Cycle
A dedicated version of the Payment Cycle, pre-filtered exclusively for VRET (Vendor Return) lines. It shows which VRET invoices were generated, how they were paid, and in which payment cycle they were settled.
Clicking the expand arrow on each row opens a detail panel with: Invoice Number, Total Invoice Amount, Total Amount Paid, and a full payment breakdown with dates and net paid amounts.
CHAPTER 5.8Payment Recap
The Payment Recap shows a summary of every Amazon Vendor payment — total amount paid, payment date, currency, and type (EFT). Each row represents one Amazon payment number.
To understand what makes up a payment total, copy the Payment Number and search for it in Remittance Listing to see the full invoice-level breakdown.
CHAPTER 5.9 – 5.10Disputes & Disputed PO
Disputes
The Disputes module tracks all Amazon Vendor disputes (Vendor Returns, Shortage Claims, Invoice disputes). Each row shows Dispute ID, Type, Status (Open/Closed), Total Dispute Amount, and Approved Amount.
Approved Amount = Total → fully won · Approved Amount = 0 → fully rejected · Status = Closed, Approved < Total → closed but not fully reimbursed
Disputed PO
Links disputes to their associated Purchase Orders, creating a complete chain: PO → Invoice → Dispute → Outcome. Shows which PO lines are referenced, how much was disputed, and how much was approved.
CHAPTER 5.11Chargeback Dashboard
Provides a complete visual overview of all chargeback-related financial activity from Amazon Vendor Central.
KPI Strip
| KPI | Meaning |
|---|---|
| Dispute Approved | Amounts won back from Amazon |
| Dispute Denied | Amounts lost after dispute |
| Charged | Amounts Amazon charged directly |
| Notification Only | Amazon notifications — no financial impact |
| Dispute in Review | Amounts under review |
| Pending Invoice | Chargebacks appearing on a future invoice |
Common Issue Types
ASN Accuracy, PO On-Time Accuracy, Carton Information Compliance, Carton Content Accuracy, Labeling Accuracy, Packaging Accuracy, Delivery Appointment Issues
Total Calculation Rule
Total = Charged + Dispute Denied + Dispute in Review. Notification-only statuses are excluded from the Total — they have no financial impact.
CHAPTER 5.15COOP Module
The COOP module centralizes all Cooperative Marketing data from Amazon Vendor Central, enhancing it with VAT logic, agreement classification (ORDINARY vs DEAL), and full audit capabilities.
COOP Navigation Path
Vendor → Reports → COOP → Dashboard / Invoices / Agreement / Agreement PO / Remittance
COOP Workflow (Step by Step)
Import COOP Excel from Amazon Vendor Central (Payments → CoOp → Deductions) into COOP → Invoices via the Actions button.
Click Perform Calculation (yellow button) to trigger the calculation engine — this populates the Dashboard, Agreement, and Agreement PO views.
For each invoice, go to Amazon Vendor Central, search by Invoice ID, and download the backup Excel report.
Return to COOP → Invoices and click Upload on the invoice row to attach the backup report. This enables the Agreement PO breakdown.
Verify cash deduction in COOP → Remittance — confirm the Debit Note was actually deducted from an Amazon payment.
COOP Invoice Key Columns
| Column | Description |
|---|---|
| Invoice ID | IDs starting 5800 = Debit Notes (no VAT); 222/203 = Fiscal Invoices (VAT included) |
| VAT Included | Auto-detected based on invoice numbering |
| Agreement ID | Primary key linking invoice → agreement → PO → Dashboard |
| Funding Type Category | ORDINARY (recurring) or DEAL (one-off promotional) |
| Net Original Balance | Net value after VAT separation |
| Child Report Uploaded | Yes/No — backup report attached for audit |
Without completing the COOP Invoices page correctly (COOP Excel import + backup report uploads + Perform Calculation), the Dashboard, Agreement Listing, and Agreement PO views will be empty or incorrect.
CHAPTER 6.2Seller Tax Report Seller Only
An API-generated fiscal report extracted directly from Amazon, used for tax validation, VAT reconciliation, accounting audits, and regulatory compliance.
Access: Seller Panel → Reports → Tax → Report
Data Tabs
The report is organized into tabs representing different fiscal views of each transaction: Account Details, Transaction Info, Product Info, Net Amounts, VAT Info, Gross Amounts, Shipping Info, Tax Registration, Invoice Info, Supplier Information.
Shipping Info – Privacy Notice
No private personal data of final consumers is stored or displayed. Only geographical and logistical information required for tax reporting is shown.
CHAPTER 6.3Tax Dashboard
The Tax Dashboard aggregates fiscal activity into a central control panel, separating Invoices and Receipts. All data is controlled by a Month / Year selector at the top right.
Dashboard Sections
- Daily Sales Chart – Day-by-day orange (invoices) and yellow (receipts) bars
- Tax Report Summary – Sales and Refunds with Gross, Net, and VAT for both document types
- Revenue by Marketplace – Country-level gross revenue for VAT allocation
- VAT Declarations – Local VAT vs OSS VAT breakdown per country
CHAPTER 6.4Invoices Listing
Detailed list of all fiscal invoices for the selected month, organized via quick-filter tabs:
| Tab | Contents |
|---|---|
| All | All categories combined |
| Italy | VAT jurisdiction = Italy |
| Local EU | Sales within one EU country (DE→DE, FR→FR) |
| Local Ext EU | Local sales outside EU (e.g., GB→GB) |
| Internal EU | Cross-border EU movements (IT→DE, DE→DK, etc.) |
| External EU | Exports outside EU (e.g., GB→JE) |
| B2B | Business customers only |
| B2C | Final consumers only |
| Refund | Returns and credit notes (negative values in red) |
Departure / Arrival = physical movement of goods. Jurisdiction = where VAT is actually applied. These may differ depending on the fiscal regime.
CHAPTER 6.5 – 6.7Receipts, Local VAT & OSS VAT
Receipts
- Regular – Daily receipts per VAT rate (e.g., Italy 22%, 10%, 4%). One row per day with per-rate totals.
- Union OSS – One Stop Shop transactions. One row per day per OSS jurisdiction with Gross, Net, and VAT.
Local VAT
Cards per country (UK, IT, FR, ES, DE…) showing B2C and B2B rows split by VAT rate — Net, Gross, and VAT per rate, with a country total. Used by tax advisors for local VAT returns.
OSS VAT
Cards per OSS country with VAT rates, Net, Gross, and VAT to be paid via OSS. The bridge between Amazon transactions and your quarterly OSS return.
Transfers
Shows inbound/outbound stock movements between FBA countries. Only available after the full monthly Amazon report download. During the month, the tab shows "No Data Found" — this is expected.
CHAPTER 6.8Settlement
Collects and normalizes all Amazon payment remittances for the Seller account. Settlement data bridges Amazon operational transactions with actual cash movements.
Transactions are grouped into macro categories: Gross Sales Revenue, Sales Taxes, Amazon Commissions and Fees, Adjustments, FBA Reimbursements, Customer Returns/Refunds, Third-Party VAT, Promotions, and more.
Settlement is primarily an internal reconciliation layer. The primary user-facing financial output is Profit & Loss.
CHAPTER 6.9Profit & Loss
Restructures Amazon settlement data into a financial statement view — macro financial groups, monthly comparisons, and clear profitability indicators.
Macro Categories
| Category | Contents |
|---|---|
| Gross Sales Revenue | Principal + Shipping + Gift Wrap (customer-facing revenue) |
| Sales Taxes (Own VAT) | All VAT amounts collected by Amazon |
| Amazon Commissions and Fees | Selling fees, per-item fees, commissions |
| FBA Logistics Costs | Fulfillment, returns, storage, disposal, prep |
| FBA Reimbursements | Inventory reimbursements from Amazon |
| Customer Returns / Refunds | All refund components |
| MF Taxes / Third-party VAT | Marketplace facilitator withheld taxes |
| Sales Discounts / Promotions | Discount and promotion adjustments |
| COGS | Cost of goods sold (order and refund level) |
| EPR Eco-contribution | Environmental contribution charges |
Every macro category can be expanded to reveal micro-level transaction types, and clicking any micro line opens a right-side drawer with full SKU-level transaction detail, search, and export.
CHAPTER 6.11Workflow & Report Export
The Workflow mode generates the Settlement Report as an Excel file (rather than on-screen table) using the same data, calculations, and filters.
Generated Excel Sections
- Orders Report – All order transactions with full column set
- Refunds Report – Refund transactions mirroring the Orders structure
- Invoicing / Billing Report – Pivot by product and country: quantities, net revenue, average price
- Credit Notes Report – Aggregated credit-related movements
CHAPTER 8Seller Inventory Seller Only
The Inventory module is built on Amazon Inventory Ledger data. Each row represents a daily snapshot of a specific SKU in a specific Amazon warehouse with a specific disposition (SELLABLE, DEFECTIVE, etc.).
Key Balance Columns
| Column | Description |
|---|---|
| Starting Warehouse Balance | Opening inventory for the day |
| Receipts | Units received into Amazon warehouses |
| Customer Shipments | Units shipped to customers (negative) |
| Customer Returns | Units returned by customers |
| Found / Damaged / Disposed | Inventory events and adjustments |
| Ending Warehouse Balance | Final inventory at end of day |
| Location | Country code of the warehouse (DE, FR, GB…) |
CHAPTER 8.2Reorders
The operational replenishment table consolidating sales velocity, stock levels, in-transit quantities, open reorders, and replenishment suggestions into one view.
Color Code
- 🟧 Orange columns – Units leaving (shipped to customers)
- ⬜ Grey columns – Stock on hand
- 🟩 Green columns – Units entering (POs, returns)
- 🟨 Yellow columns – Calculated indicators (totals, averages, coverage)
Recommendation Logic
The system calculates average sales velocity over 7/14/30/60 days, compares with current stock + transit + open reorders, and outputs a suggested reorder quantity per country. Positive values = reorder suggested; Negative/zero = no reorder needed.
CHAPTER 8.3Warehouse Check
Reconciles Amazon inventory accounting data over a selected time range. Cross-checks inventory data against Orders and Refunds from Settlement reports.
When a date range is selected (e.g., 01/01/2025–31/12/2025), the Start Stock is automatically calculated as the ending stock of the day before (31/12/2024).
The Check Total column validates: Calculated End Stock vs Amazon End Stock. If they match → reconciliation is correct. If not → discrepancy detected.
CHAPTER 11.1Buy Box – Vendor Vendor
Monitors Buy Box ownership at ASIN level for Vendor accounts. Data is refreshed daily (~24-hour intervals).
Vendor Buy Box Logic: If Amazon is the Buy Box winner → Buy Box is considered WON.
Key Metrics
| Metric | Description |
|---|---|
| BuyBoxWinner % | % of time Amazon held the Buy Box in the selected window |
| BB / Cost Diff | Buy Box Price ÷ Product Cost (margin pressure indicator) |
| BB / Gross Diff | Buy Box Price ÷ Gross Price (competitive aggressiveness) |
| 30d Acc Turnover | Accepted sell-in turnover last 30 days |
CHAPTER 11.2Buy Box – Seller Seller
Seller Buy Box Logic: Buy Box is WON only if won by the Seller Account's own Seller ID. Amazon winning = LOST for Seller analysis.
The 30-day history chart shows daily Buy Box price with Seller ID resolved to Store Name. Clicking the Seller counter opens an offer comparison panel showing price, shipping, fulfillment type (FBA/MFN), and Prime eligibility.
CHAPTER 11.3Block Products Vendor
Displays listing/offer issues (blocked listings) extracted from Amazon for Vendor accounts.
Setup Requirements
Go to Accounts → Account Details and enter the Vendor Code for the account.
Go to Jobs → Add Job. Set Queue: catalog-job-queue, Job Name: blocked-products. Submit.
Verify execution in Monitoring → Bull Board (catalog-job-queue → Completed tab).
Return to Vendor → Tools → Block Products and refresh until the table populates.
The Reason field is the key operational element — it explains exactly why an offer/listing is blocked (e.g., profitability reasons, multipack requirements).
CHAPTER 11.3.3Page Quality
Checks product page content against expected content, focusing on title length, bullet point character limits, and completeness. Navigate via Tools → Quality → Page Quality.
Workflow
Click Manage Product Page Quality and download current Amazon content for the target account.
Click Download Template from Check Product Page Quality, fill in expected content (Title + 5 Bullet Points per ASIN/Marketplace).
Upload the filled template via the CSV upload modal.
Review results: Green = content matches expected. Red = discrepancy detected.
Also Available Under Quality
- Page Variations – Upload Parent ASINs to count and inspect child ASIN variations
- A+ Content – Check A+ Content availability and images per product
- Reviews – Historical review and rating counts
CHAPTER 11.3.5Pricing Analytics – Vendor Vendor
Provides a line-by-line cost and pricing breakdown. Key calculated columns:
- Dimensional Weight = (Longest + Median + Shortest Side) ÷ 5000 kg
- Net Cost Amount = (Product Cost + Chargeback + Fee BS + Shipping + Logistic Prep) × (1 + COOP Markup)
- Net Selling Price = Net Cost Amount + Amazon Markup
- Gross Selling Price = Net Selling Price × VAT
- Amazon Margin % = Amazon Margin ÷ Net Selling Price
CHAPTER 11.3.6Pricing Analytics – Seller Seller
Similar structure to Vendor Pricing Analytics but uses Seller-specific data sources: FBA fee tiers from Catalog, Amazon referral fees from Categories, and Catalog-defined costs.
The Price Optimization action calculates the minimum consumer price to cover product cost + Amazon fees + FBA fees + VAT + target margin. Results are displayed without overwriting existing data.
Blue metric values link directly to the Product edit page for quick updates to dimensions, costs, and expense-by-country configuration.
CHAPTER 9Seller Orders (FBM) Seller
Centralizes Amazon Seller FBM orders. Used internally to manage shipping workflows via:
- Asendia app (MyLogsolution) – via Excel upload
- Amazon carrier – sending order info directly to supplier
Each order row shows: Amazon Order ID, Address, Marketplace, Items Shipped, Is Edited, Sent to Supplier, Tracking ID, Total Amount. The Shipments modal shows shipment status, carrier, shipping service, tracking, and packing slip options.
CHAPTER 7Vendor Inventory – Forecasting Vendor
Provides a monthly inventory coverage and reorder validation view. BetterShop calculates total shipped units, available inventory, open PO units, and customer returns to derive a 1-Month Stock Target Coverage.
Color Code
- 🟧 Orange – Units leaving the warehouse (monthly shipped)
- ⬜ Grey – Stock on hand
- 🟩 Green – Incoming units (open POs, customer returns)
- 🟨 Yellow – Calculated aggregates (Net Consumption, Stock Target)
Although labeled "Forecast Inventory", this module currently provides average reorder logic and monthly stock coverage control. True predictive forecasting is still under development.
CHAPTER 10Vendor Orders (Purchase Orders) Vendor
Displays all Amazon Vendor purchase orders. Access via Vendor → Orders → Purchase Orders.
PO Table Columns
Purchase order number, state, date, state change date, type, vendor code, fulfillment center, delivery window start/end, ordered/accepted/rejected/received quantities, net cost amount, ordered/accepted revenue.
PO Synchronization
Purchase orders sync automatically every day. Click SYNCHRONIZE for a manual refresh. First load retrieves 6 months of PO history.
Available Exports
- Export All (Excel / CSV)
- Export To Ship (Excel / CSV) – Internal operational export
CHAPTER 13.1Vendor Analytics – Performance View Vendor
The main Vendor dashboard providing a Year-over-Year comparison of all key Vendor metrics: sell-in, sell-out, traffic, inventory, advertising, and profitability.
Always select a complete full year for accurate YoY comparison. Partial periods produce misleading deltas. The system automatically compares the selected year vs the same period of the previous year.
KPI Groups
| Group | KPIs |
|---|---|
| Retail (Sell-Out) | Shipped Revenue, Shipped Units, Average Selling Price (ASP) |
| Sell-In (to Amazon) | Total Sell-In Value, Sell-In Volume |
| Shipped COGS | Shipped COGS, ASP Shipped COGS (margin pressure) |
| Traffic & Conversion | Glance Views, Conversion Rate = Shipped Units / Glance Views |
| Inventory & POs | Inventory Available, Open Purchase Orders |
| Advertising | Ad Spend, Ad Sales |
| Profitability | PPM, Net PPM = Revenue – Shipped COGS |
CHAPTER 13.13Vendor Order Analytics
Analyzes sell-in data (brand → Amazon), not final customer sales. Access via Vendor → Analytics.
Dashboard Charts
- Ordered Quantity & Turnover – Volume and revenue trend
- Accepted Quantity & Turnover – What was actually accepted
- Ordered vs Accepted Comparison – Gap identification with acceptance rate %
Products Table – Orders vs Turnover Toggle
The toggle switches between Quantities (Orders view: Ordered Qty, Accepted Qty, Net Cost) and Monetary Values (Turnover view: Ordered €, Accepted €, Net Cost). The table structure stays the same — only the meaning of the values changes.
CHAPTER 12.1Retail Analytics – Dashboard Seller
Time-based visual analysis of sales and advertising metrics. Use the Week / Month / Year aggregation toggle for different views.
Dashboard Contents
- Total Sales and Units trend charts
- Ad Spend and Ad Revenue over time
- % of Total Sales from advertising
- ACOS and TACOS trend
- Average CPC and Conversion Rate
- Monthly APV summary table (Sales, Units, Orders, ASP, MoM variation)
CHAPTER 12.2Retail Analytics – Performance
Year-over-year comparison of sales metrics. Select complete years for correct comparisons.
KPIs: Product Sales, Units Ordered, Ordered Items, Sessions, Session Conversions, Ad Spend, Ad Sales — all with YoY delta values and percentages. The table lists products with per-year values and deltas for each metric.
CHAPTER 12.3Retail Analytics – Products
Product-level pivot view organized by SKU/ASIN. KPI strip shows B2C and B2B metrics with period-over-period variations. View tabs: Performance Overview (B2C), Performance Overview (B2B), MoM Delta (B2C), MoM Delta (B2B).
CHAPTER 12.4Retail Analytics – Marketplaces
Marketplace-level (country) pivot view. Same KPIs as Products but aggregated by Amazon country marketplace. Useful for identifying geographical strengths and weaknesses and country-level VAT allocation.
CHAPTER 12.6Retail Analytics – Brands
Brand-level pivot view. Each row = one brand. Same KPI structure as all Retail Analytics sections. Use the Select Countries filter when brands are sold across multiple marketplaces to limit analysis to specific countries.
CHAPTER 12.7Retail Analytics – Sub Categories
The most granular aggregation level in Retail Analytics. Switch between Sub Category 1, 2, or 3 using the level selector. Supports B2C and B2B tabs and MoM delta analysis.
CHAPTER 12.7.6Returns Seller
Focuses exclusively on FBA customer returns. Three sub-sections:
- Returns Overview – Time chart of Ordered Qty, Total Returns, Return Rate %; pie chart by disposition (Customer Damaged, Sellable, Defective); bar chart by reason
- Products (Returns) – Top products by return volume with Return Rate % per SKU/ASIN
- Product Returns – Transaction-level table showing each return reason per product — used for root-cause analysis