Filter: {{(accountList | filter : {ID : account})[0].SellerName }} {{(accountList | filter : {ID : id})[0].SellerName}} {{(marketplaceList | filter : {Value : marketplace})[0].URL}} {{(groupList | filter : {ID : group})[0].GroupName}} {{(feeList | filter : {Value : fees})[0].Name }} {{(subUserList | filter : {ID : subUser})[0].FirstName + ' ' + (subUserList | filter : {ID : subUser})[0].LastName}} {{fulfillment == 1 ? 'FBM' : 'FBA'}} {{active == '1' ? 'Active' : 'Inactive'}} Refund Order Only cost not setup Only not grouped Only not SKU Only OOS Only Changed Fee {{strFilter}} {{feeName}} {{startDateView + "-" + endDateView}} Reset
Loading . . .

Download
Grouped by
 Total Orders：{{OrderNumber.toLocaleString()}} Total Sales：{{attributeMapping.CurrencyNumberView(LocalCurrency,TotalSales)}} Total Profit：{{attributeMapping.CurrencyNumberView(LocalCurrency,TotalProfit)}}

Order ID Product Date
Units
Sales
{{item.LabelName}} Cost
Gross Profit
Order ID Product Date Units Sales {{item.LabelName}} Cost Gross Profit
{{order.order_id}}
({{order.original_amazon_order_id}})
(Refund) (Return) (Replacement)
{{order.item_name}} {{order.Country}} | {{order.amazon_asin}} | {{order.seller_sku}} | {{order.fulfillmentView}} | {{attributeMapping.CurrencyNumberView(order.Currency,order.ProductPrice)}}
{{orderChildren.item_name}} {{orderChildren.Country}} | {{orderChildren.amazon_asin}} | {{orderChildren.seller_sku}} | {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.ProductPrice)}}
{{order.DateView}}
{{order.quantity}}
{{orderChildren.quantity }}
{{attributeMapping.CurrencyNumberView(order.Currency,order.SalesPrice)}}

Sales

{{sales.name}} {{attributeMapping.CurrencyNumberView(order.Currency,sales.value)}}

{{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.SalesPrice)}}

Sales

{{sales.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,sales.value)}}

{{attributeMapping.CurrencyNumberView(order.Currency,order.AmazonFeeList|getValue:item.AmountName)}}
{{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren[item.AmountName])}}
{{attributeMapping.CurrencyNumberView(order.Currency,order.Fees)}}

COGS

{{cogs.name}} {{attributeMapping.CurrencyNumberView(order.Currency,cogs.value)}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(order.Currency,fees.value)}}

Promotion {{attributeMapping.CurrencyNumberView(order.Currency,order.PromotionList[0].value)}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(order.Currency,promotion.value)}}

Advertising Cost {{attributeMapping.CurrencyNumberView(order.Currency,order.AdvertisingList[0].value)}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(order.Currency,ad.value)}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(order.Currency,refund.value)}}

VAT {{attributeMapping.CurrencyNumberView(order.Currency,order.VatList[0].value)}}

{{vat.name}} {{attributeMapping.CurrencyNumberView(order.Currency,vat.value)}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(order.Currency,expense.value)}}

{{orderChildren.Fees|currency:orderChildren.Currency:2}}

COGS

{{cogs.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,cogs.value)}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,fees.value)}}

Promotion {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.PromotionList[0].value)}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,promotion.value[0].value)}}

Advertising Cost {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.AdvertisingList[0].value)}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,ad.value)}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,refund.value)}}

VAT {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.VatList[0].value)}}

{{vat.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,vat.value)}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,expense.value)}}

{{attributeMapping.CurrencyNumberView(order.Currency,order.NetProfit)}}

Sales

{{sales.name}} {{attributeMapping.CurrencyNumberView(order.Currency,sales.value)}}

COGS

{{cogs.name}} {{attributeMapping.CurrencyNumberView(order.Currency,cogs.value)}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(order.Currency,fees.value)}}

Promotion {{attributeMapping.CurrencyNumberView(order.Currency,order.PromotionList[0].value)}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(order.Currency,promotion.value)}}

Advertising Cost {{attributeMapping.CurrencyNumberView(order.Currency,order.AdvertisingList[0].value)}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(order.Currency,ad.value)}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(order.Currency,refund.value)}}

VAT {{order.VatList[0].value|currency:order.Currency:2}}

{{vat.name}} {{vat.value|currency:order.Currency:2}}

Other Expense

{{expense.name}} {{expense.value|currency:order.Currency:2}}

Gross Profit {{order.NetProfit | currency : order.Currency}}

{{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.NetProfit)}}

Sales

{{sales.name}} {{sales.value|currency:orderChildren.Currency:2}}

COGS

{{cogs.name}} {{cogs.value|currency:orderChildren.Currency:2}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,fees.value)}}

Promotion {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.PromotionList[0].value)}}

{{promotion.name}} {{promotion.value|currency:orderChildren.Currency:2}}

Advertising Cost {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.AdvertisingList[0].value)}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,ad.value)}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,refund.value)}}

VAT {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.VatList[0].value)}}

{{vat.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,vat.value)}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(expense.value))}}

Gross Profit {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.NetProfit)}}

*
{{orderSKU.item_name}} {{orderSKU.SKU}}
* {{orderSKU.Quantity}} {{attributeMapping.CurrencyNumberView('$',orderSKU.Sales)}} {{attributeMapping.CurrencyNumberView('$',orderSKU.Cost)}} {{attributeMapping.CurrencyNumberView('$',orderSKU.NetProfit)}}
{{order.order_id}}
({{order.original_amazon_order_id}})
(Refund) (Return) (Replacement)
{{order.item_name}} {{order.Country}} | {{order.amazon_asin}} | {{order.seller_sku}} | {{order.fulfillmentView}} | {{attributeMapping.CurrencyNumberView(order.Currency,order.ProductPrice)}}
{{orderChildren.item_name}} {{orderChildren.Country}} | {{orderChildren.amazon_asin}} | {{orderChildren.seller_sku}} | {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.ProductPrice)}}
{{order.DateView}}
{{order.quantity}}
{{orderChildren.quantity }}
{{attributeMapping.CurrencyNumberView(order.Currency,order.SalesPrice)}}

Sales

{{sales.name}} {{attributeMapping.CurrencyNumberView(order.Currency,sales.value)}}

{{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.SalesPrice)}}

Sales

{{sales.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,sales.value)}}

{{attributeMapping.CurrencyNumberView(order.Currency,order[item.AmountName])}}
{{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren[item.AmountName])}}
{{attributeMapping.CurrencyNumberView(order.Currency,order.Fees)}}

COGS

{{cogs.name}} {{cogs.value|currency:order.Currency:2}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(order.Currency,fees.value)}}

Promotion {{attributeMapping.CurrencyNumberView(order.Currency,align(order.PromotionList[0].value))}}

{{promotion.name}} {{align(promotion.value) |currency:order.Currency:2}}

Advertising Cost {{attributeMapping.CurrencyNumberView(order.Currency,align(order.AdvertisingList[0].value))}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(order.Currency,align(ad.value))}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(order.Currency,align(refund.value))}}

VAT {{attributeMapping.CurrencyNumberView(order.Currency,align(order.VatList[0].value))}}

{{vat.name}} {{align(vat.value)|currency:order.Currency:2}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(order.Currency,align(expense.value))}}

{{attributeMapping.CurrencyNumberView(order.Currency,align(expense.value))}}

COGS

{{cogs.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(cogs.value))}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(fees.value))}}

Promotion {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren.PromotionList[0].value))}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(promotion.value))}}

Advertising Cost {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren.AdvertisingList[0].value))}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(ad.value))}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(refund.value))}}

VAT {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren.VatList[0].value))}}

{{vat.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(vat.value))}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(expense.value))}}

{{attributeMapping.CurrencyNumberView(order.Currency,order.NetProfit)}}

Sales

{{sales.name}} {{align(sales.value)|currency:order.Currency:2}}

COGS

{{cogs.name}} {{align(cogs.value)|currency:order.Currency:2}}

Fees

{{fees.name}} {{align(fees.value)|currency:order.Currency:2}}

Promotion {{align(order.PromotionList[0].value)|currency:order.Currency:2}}

{{promotion.name}} {{align(promotion.value)|currency:order.Currency:2}}

Advertising Cost {{align(order.AdvertisingList[0].value)|currency:order.Currency:2}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(order.Currency,align(order.AdvertisingList[0].value))}}

Refund

{{refund.name}} {{align(refund.value)|currency:order.Currency:2}}

VAT {{align(order.VatList[0].value)|currency:order.Currency:2}}

{{vat.name}} {{align(vat.value)|currency:order.Currency:2}}

Other Expense

{{expense.name}} {{align(expense.value)|currency:order.Currency:2}}

{{expense.name}} {{attributeMapping.CurrencyNumberView(order.Currency,align(expense.value))}}

{{orderChildren.NetProfit | currency : orderChildren.Currency}}

Sales

{{sales.name}} {{align(sales.value)|currency:orderChildren.Currency:2}}

COGS

{{cogs.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(sales.value))}}

Fees

{{fees.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(cogs.value))}}

Promotion {{align(orderChildren.PromotionList[0].value)|currency:orderChildren.Currency:2}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(fees.value))}}

Promotion {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren.PromotionList[0].value))}}

{{promotion.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(promotion.value))}}

Advertising Cost {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren..AdvertisingList[0].value))}}

{{ad.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(ad.value))}}

Refund

{{refund.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(refund.value))}}

VAT {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(orderChildren.VatList[0].value))}}

{{vat.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(vat.value))}}

Other Expense

{{expense.name}} {{attributeMapping.CurrencyNumberView(orderChildren.Currency,align(expense.value))}}

Gross Profit {{attributeMapping.CurrencyNumberView(orderChildren.Currency,orderChildren.NetProfit)}}

Load More
DEFAULT
APPLY
SAVE