How can Calculate each products cost and Net Profit
Kindly Help me out for this we will required excel sheet for know each and every products sales cost and profit.
How can Calculate each products cost and Net Profit
Kindly Help me out for this we will required excel sheet for know each and every products sales cost and profit.
6 replies
Seller_TbyT2nBDUAWf3
You can either download the transaction sheets for a particular period you want to analyze or use SP-API to get the same data. I use the latter. Anyways in both cases, you'll get the following set of data for each ASIN that you have sold:
1. Principal
2. Promotion
3. Amazon Fees
4. Total
Sum up the following four for each ASIN and you'll be able to understand which ASINs have been profitable or loss making. I also sum up the total units sold and refunded. Attaching a snapshot of what my analysis looks like
.
Seller_OsB1QIY4kqAgl
Net Sales-Net Expenses-Product Cost-Tax will be paid = Net Profit
