Operations Diagnostic Tool (Web Edition) User Guide

Version V1.0

1. Supported Marketplaces & Quick Start

1.1 Supported Marketplaces

Currently supports the following 11 marketplaces:

Marketplace	Code	Currency
United States	`US`	USD
Canada	`CA`	CAD
Mexico	`MX`	MXN
Japan	`JP`	JPY
United Kingdom	`UK`	GBP
Germany	`DE`	EUR
France	`FR`	EUR
Spain	`ES`	EUR
Italy	`IT`	EUR
Netherlands	`NL`	EUR
Sweden	`SE`	SEK

Transaction reports from different marketplaces use the local language to describe order types, so you must select the correct marketplace. Mixing marketplaces in a single analysis is not recommended (different currencies, report format variations, potentially merged cross-marketplace inventory data, timezone differences, etc.).

1.2 Report Header Language Support

Report Name	English	Chinese	Japanese	Spanish	German	French	Italian
Business Report	✓	✓	✓	✗	✗	✗	✗
Transaction Report	✓	/	✓	✓	✓	✓	✓
Daily Inventory Report	✓	/	✗	/	/	/	/
Monthly Storage Fee Report	✓	/	✗	/	/	/	/
FBA Orders Report	✓	✓	✗	✗	✗	✗	✗
SP Advertised Product Report	✓	✓	✗	✗	✗	✗	✗
SB Bulk Template	✓	✓	✗	✗	✗	✗	✗
SB Campaign Report	✓	✓	✗	✗	✗	✗	✗
SD Advertised Product Report	✓	✓	✗	✗	✗	✗	✗

/ indicates that the report obtained from the Chinese or English Seller Central environment for that marketplace is still in English.

For first-time users, we recommend downloading all reports from Seller Central in the English interface to reduce compatibility issues.

1.3 Quick Start

Open the Upload Page

Visit the home page and click "Get Started" to go to the upload configuration page

Upload Files and Configure

Use "Batch Upload" to drag in all files — the system will automatically identify report types. Configure marketplace, dates, and other parameters.

View Analysis Results

Click "Start Analysis" to automatically navigate to the Dashboard with summary cards, data tables, and trend charts

Supported file formats:.csv, .xlsx, .xls, .txt

2. Recommended Use Cases

There are three primary use cases: Profit Monitoring, Break-Even Analysis, and Action Impact Analysis.

2.1 Profit Monitoring

Filter for high-profit and negative-profit products to prioritize optimization, and combine with related data to identify opportunities and risks in real time.

Analysis Timing	Early to mid-month
Data Period	Previous full month of data
Analysis Purpose	Overview or Advertising
Analysis Target	SKU or Parent_ASIN (when there are many child variations)

2.2 Break-Even Analysis (BEP)

Use as much historical data as possible (from product launch) to evaluate whether a target product still has the potential to be profitable.

Analysis Timing	Every quarter or after peak season
Data Period	As much historical data as available for the product
Analysis Purpose	BEP_Monthly or BEP_Weekly
Analysis Target	SKU or Parent_ASIN

BEP analysis automatically splits data by week or month, adding Cumulative Input (sum of all costs) and Cumulative Output (sum of all transaction amounts) columns to visualize the break-even trend.

2.3 Action Impact Analysis

When optimizing listings, adjusting ads, or running promotions, analyze 3-6 weeks of data before and after the action to evaluate its effectiveness.

Analysis Timing	3-6 weeks after a major action
Data Period	3-6 weeks before and after the action
Analysis Purpose	BEP_Weekly or Overview
Analysis Target	SKU or Parent_ASIN

3. Detailed Description of All 13 Reports

Report Overview

No.	Report Name	Source	Required
#1	#1 Business Report	Seller Central	✓
#2	#2 Daily Inventory Report / Inventory Ledger	Seller Central	✓
#3	#3 Transaction Report	Seller Central	✓
#4	#4 Monthly Storage Fee Report	Seller Central	✓
#5	#5 FBA Orders Report / Amazon Fulfilled Shipments	Seller Central	✓
#6	#6 SP Advertised Product Report	Seller Central	✓
#7	#7 SD Advertised Product Report	Seller Central	Optional
#8	#8 SB Bulk Template	Seller Central	Optional
#9	#9 SB Campaign Report	Seller Central	Optional
#10	#10 Purchase Data (User-provided)	User-provided	Optional
#11	#11 Inbound Shipments (User-provided)	User-provided	Optional
#12	#12 Inbound Shipping Details (User-provided)	User-provided	Optional
#13	#13 Other Fees (User-provided)	User-provided	Optional

We recommend using CSV format whenever possible. TXT files may have parsing issues, and XLSX files may have encoding problems in some environments.

#1 Business Report

Download Path: Menu > Reports > Business Reports (SKU-level report — name should not contain parent/child)

Required Fields:

Field	Description
`(Parent) ASIN`	Parent ASIN
`(Child) ASIN`	Child ASIN
`Title`	Product Title
`SKU`	Product SKU
`Sessions - Total`	Total Sessions
`Units Ordered`	Units Ordered
`Ordered Product Sales`	Ordered Product Sales

Core Function: Extracts the SKU ↔ Parent_ASIN ↔ Child_ASIN mapping, which serves as the ID mapping foundation for all subsequent reports. Amazon Business data can be imported directly if present.

If the ASIN-SKU mapping has changed, the system defaults to the mapping from the first row of the report.

#2 Daily Inventory Report / Inventory Ledger

Download Path: Menu > Reports > Fulfillments > Inventory Ledger

Download Options: Type=Summary View, Location=Country, Period=Daily

Required Fields: Date, FNSKU, ASIN, MSKU, Disposition, Starting Warehouse Balance, Ending Warehouse Balance

Calculated Metrics:

Metric	Calculation Method
In-Stock Days	Number of days within the period where ending inventory > 0
Out-of-Stock Days	Total days - In-stock days
In-Stock Rate	In-stock days / Total days × 100%
Ending Inventory	Ending Warehouse Balance on the last day

Only inventory with Disposition = SELLABLE is counted. We recommend importing a full year of data — the system will automatically extract the relevant time period based on your settings.

#3 Transaction Report

Download Path: Menu > Payments > Reports Repository (Account Type: All, Report Type: Transaction)

Required Fields: date/time, type, sku, quantity, marketplace, fulfillment, product sales, selling fees, fba fees, promotional rebates, and all other fee columns

Row-by-Row Processing Logic:

#	Description
1	Skip rows where SKU is empty
2	Skip rows outside the configured date range
3	Extract SKU and automatically map to Parent/Child ASIN based on settings
4	Liquidation/FBA Return types are converted via FNSKU
5	Order/Refund types record quantity; other types do not
6	Order types capture all detailed fees
7	Japan marketplace: points fees are also captured
8	Refund type → Refund fees
9	Adjustment type → Adjustment fees
10	All other types → Other fees

Order Fee Categories: Tax items → Taxes | Shipping/Gift Wrap/FBA Fees → Shipping | Promotional Rebates → Promotions | Selling Fees → Commission | Other → Other

Multi-Channel Fulfillment (MCF) order fees are recorded normally, but sales quantities are not counted (to avoid double-counting with external channels). Transaction Report language is determined by the marketplace, not the Seller Central interface language.

#4 Monthly Storage Fee Report

Download Path: Menu > Reports > Fulfillments > Monthly Storage Fee Report

Required Fields: fnsku, average_quantity_on_hand, estimated_monthly_storage_fee

Processing Logic: Maps via FNSKU→SKU (Inventory Report) → Parent/Child ASIN (Business Report), aggregates warehouse inventory and monthly storage fees, and calculates the final storage fee based on the configured storage months and Transaction Report sales volume.

#5 FBA Orders Report / Amazon Fulfilled Shipments

Download Path: Menu > Reports > Fulfillments > Amazon Fulfilled Shipments

Required Fields: Amazon Order Id, Purchase Date, Buyer Email, Merchant SKU, Shipped Quantity, Item Price

Core Function: Calculates Repeat Purchase Rate (buyers with >1 order / total buyers) and Average Repeat Purchase Cycle. We recommend analyzing at least 3 months of data.

#6 SP Advertised Product Report

Download Path: Menu > Advertising > Campaign Manager > Measurement & Reporting > Sponsored Ads Report

Download Options: Select Daily data. We recommend saving the previous month's complete data no earlier than the 9th (7-day attribution window).

Required Fields: Date, Advertised SKU, Impressions, Clicks, Spend, 7 Day Total Sales, 7 Day Total Orders (#), 7 Day Advertised SKU Units (#), 7 Day Other SKU Units (#), 7 Day Advertised SKU Sales, 7 Day Other SKU Sales

#7 SD Advertised Product Report

Download Options: Same path as SP. Select Daily data. We recommend saving no earlier than the 16th (14-day attribution window).

Required Fields: Date, Advertised SKU, Impressions, Clicks, Spend, 14 Day Total Orders (#), 14 Day Total Units (#), 14 Day Total Sales

#8 SB Bulk Template

Download Path: Menu > Advertising > Campaign Manager > Sponsored Ads > Bulk Operations

Make sure to check Sponsored Brands when downloading. The system will automatically extract the Sponsored Brands Campaigns sheet.

Required Fields: Entity, Campaign Id, Campaign Name, Creative ASINs

Uploading the SB Bulk template enables precise Campaign→ASIN→SKU allocation. Without it, SB advertising data can only be distributed using average/weighted methods.

#9 SB Campaign Report

Download Options: Same path as SP. Select Daily data. We recommend saving no earlier than the 16th (14-day attribution window).

Required Fields: Date, Campaign Name, Impressions, Clicks, Spend, 14 Day Total Sales, 14 Day Total Orders (#)

SB Distribution Methods:

Method	Description	Best For
Exact Allocation	Requires SB Bulk Campaign→ASIN mapping	Recommended, most accurate
Average	Distributed evenly across all SKUs	General use
Sessions_Weighted	Weighted by sessions	Significant traffic differences
Units_Weighted	Weighted by units sold	Significant sales volume differences
Sales_Weighted	Weighted by sales revenue	Profit allocation

#10 Purchase Data (User-provided)

Required Fields: SKU, Quantity, Unit_Cost, Total_Cost

Two ways to fill in: (1) One row per SKU, quantity 1, enter unit cost (simpler); (2) Enter all purchase records in full, and the system will automatically calculate the average unit price (more precise).

#11 Inbound Shipments (User-provided)

Required Fields: Shipment_ID, Weight, Spend

Record the total cost for each inbound shipping shipment.

#12 Inbound Shipping Details (User-provided)

Required Fields: Shipment_ID, SKU, Quantity, Total_SKU_Cost

Can be used with #11 for automatic weight-based allocation, or you can enter a custom per-unit inbound cost directly in Total_SKU_Cost (with quantity = 1).

#13 Other Fees (User-provided)

Required Fields: SKU, Value_Change, Type (optional)

Enter all expenses as positive numbers and all income as negative numbers. Only fees within the configured date range are counted.

Common fee types: Coupons, Deals, overseas warehousing, off-Amazon promotions, liquidation costs, intellectual property fees, etc.

4. Parameter Settings

4.1 Marketplace

Supports US, CA, MX, JP, UK, DE, FR, ES, IT, NL, SE. You must select the correct marketplace to accurately parse fee types in the Transaction Report.

4.2 Date Range (Start Date / End Date)

Format: YYYY-MM-DD. End date must not be earlier than start date.

Recommendations: Use month/quarter/year intervals for routine analysis; use 3-8 weeks before and after for action impact analysis; use at least quarterly intervals for BEP, ideally starting from product launch.

4.3 Analysis Purpose

Option	Description
Overview	Comprehensive Diagnostics. One row per SKU/ASIN with all data aggregated.
Advertising	Advertising Diagnostics. Same as Overview — we recommend enabling detailed ad data display.
BEP_Weekly	Break-Even Analysis (one row per 7-day period)
BEP_Monthly	Break-Even Analysis (one row per month)

4.4 Primary ID

Option	Description
SKU	Analyze by SKU (default)
Parent_ASIN	Analyze by Parent ASIN (ideal for listings with many variations)
Child_ASIN	Analyze by Child ASIN

4.5 Storage Months

Options: 1-12 months. Approximate formula: Avg months in storage ≈ Avg inventory level / Avg monthly sales × 0.5

Scenario	Recommended Months
Primarily air freight / fast shipping	2 months
Sea freight / 3-6 months of stock	3-4 months
In storage for 4-6+ months	Consider optimizing your restocking cadence first

4.6 SB Distribution Method

Average (default, recommended), Sessions_Weighted, Units_Weighted, Sales_Weighted. If an SB Bulk template is uploaded, the system prioritizes exact mapping — this parameter only applies when exact mapping is unavailable.

4.7 Display Options

Parameter	Description	Default
Detailed Ads	Show SP/SB/SD ad data by type	No
Fees by Unit	Show per-unit fee breakdown	Yes
Fees by ID	Show fee totals per SKU/ASIN	Yes
Skip Missing ID	Skip IDs without a matching mapping	Yes

5. Analysis Results & Export

5.1 Dashboard Overview

After analysis, you are automatically redirected to the Dashboard page, which includes summary cards (total sales, total profit, profit margin, etc.) and tabbed data tables:

Tab	Included Metrics
Sales	Total Units, Total Sales, Shipped Units, Payment Amount, Sessions, Conversion Rate
Inventory / Returns	In-Stock Days, Out-of-Stock Days, In-Stock Rate, Ending Inventory, Refund Units, Refund Rate, Repeat Purchase Rate
Advertising	Impressions, Clicks, Ad Orders, Ad Spend, CTR, CPC, ACOS
Ad Details	Detailed data for each SP/SB/SD type (requires Detailed Ads enabled)
Fees / Unit	Commission/Unit, Shipping/Unit, Promo/Unit, Ad Cost/Unit, Storage/Unit, COGS/Unit, Inbound/Unit
Fee Totals	Selling Commission, FBA Shipping, Promotions, Ad Fees, Storage Fees, Refund Fees, COGS, Inbound Shipping
Profit	Total Sales, Total Cost, Gross Profit, Profit Margin, Total ACOS

5.2 Core Calculation Formulas

Total ACOS = Total Ad Spend / Total Payment Amount (Payment Sales)

Total Cost = See Total Cost Breakdown below

Gross Profit = Total Payment Amount - Total Cost

Profit Margin = Gross Profit / Total Payment Amount × 100%

5.3 Total Cost Breakdown

Cost Item	Data Source
Taxes (Sale Tax + Shipping Tax + Gift Wrap Tax + Marketplace Tax)	Transaction Report
Shipping Fees (Shipping + Gift Wrap + FBA Fees)	Transaction Report
Promotion Fees (Promotional Rebates + Points)	Transaction Report
Selling Commission (Selling Fees)	Transaction Report
Other Transaction Fees (Other Transaction + Other)	Transaction Report
Refund Fees (Total of Refund-type entries)	Transaction Report
Adjustment Fees (Total of Adjustment-type entries)	Transaction Report
Monthly Storage Fees	Monthly Storage Fee Report
SP Ad Spend	SP Ad Report
SD Ad Spend	SD Ad Report
SB Ad Spend	SB Campaign Report
COGS (Cost of Goods Sold)	Purchase Data (User-provided)
Inbound Shipping	Inbound Shipping Details (User-provided)
Other Fees	Other Fees (User-provided)

5.4 Advertising Metrics

Metric	Calculation Method
CTR	Clicks / Impressions × 100%
CPC	Ad Spend / Clicks
ACOS	Ad Spend / Ad Sales × 100%
Total ACOS	Total Ad Spend / Total Payment Amount × 100%

5.5 BEP Analysis Results

When BEP_Weekly or BEP_Monthly is selected, the results page shows time-series data for each SKU broken down by week or month: Units Sold, Sales, Total Cost, Gross Profit, Profit Margin, and Cumulative Profit. When Cumulative Profit first reaches ≥ 0, it is marked as break-even achieved.

5.6 Export Features

Excel Export: Click the "Export to Excel" button on the Dashboard to download a formatted .xlsx file.

Template Download: Click "Download Template" to get the standard template for purchase data, inbound shipping, and other fees.

6. FAQ

Upload Issues

Q: What file formats are supported?

A: Supported formats: .csv, .xlsx, .xls, .txt. We recommend using CSV whenever possible.

Q: I see a "file type unrecognized" error after uploading?

A: The system identifies report types by their column headers. If headers have been modified or an unsupported language is used, identification may fail. Try re-downloading the report from Seller Central in English.

Q: Some files were not correctly identified during batch upload?

A: Make sure each file contains only one report type. The SB Bulk template is a multi-sheet Excel file — the system will automatically extract the "Sponsored Brands Campaigns" sheet.

Q: Japanese report shows garbled characters?

A: Create a new blank Excel spreadsheet, use "Import Data > From Text File", and select the correct encoding (UTF-8 or Shift-JIS) to re-import.

Data Analysis Issues

Q: Some SKU data is missing?

A: Possible causes: The Business Report is missing the ASIN mapping for that SKU; the SKU falls outside the configured date range; or Skip Missing ID is enabled and SKUs without a mapping are excluded.

Q: SB advertising data is not precise?

A: Sponsored Brands targets ASINs, not SKUs. Without the SB Bulk template, the system can only distribute data using average/weighted methods. We recommend uploading the SB Bulk template as well.

Q: Storage fee calculations seem inaccurate?

A: Make sure you have uploaded the Monthly Storage Fee Report and Daily Inventory Report (needed for FNSKU→SKU mapping), and that the Storage Months parameter is set appropriately.

Q: Repeat purchase rate seems low?

A: Repeat purchase rate is closely tied to the time range analyzed. We recommend analyzing at least 3 months of FBA order data.

Results & Export

Q: Advertising data shows decimal numbers?

A: This is normal. When SB advertising data is distributed via average/weighted methods, impressions, clicks, and other metrics may have decimals.

Q: The exported Excel file won't open?

A: Make sure to open it with Microsoft Excel or WPS Office. The file format is .xlsx.

Q: Calculation results don't match expectations?

A: Please verify that uploaded files are complete and parameter settings are correct. Minor discrepancies may result from floating-point precision or subtle date parsing differences. For larger discrepancies, try re-uploading files and double-checking your settings.

Operations Diagnostic Tool (Web Edition) User Guide · V1.0

Built by the AmzDiag Team