The ProductDetails.xlsx workbook is an Excel Template I use to keep track of all the details of my company’s products.
Description of the columns:
This is simply the cost you’re paying for the product. You may also choose to make this the landed cost of your product (i.e. including shipping from China) or simply the the FOB China cost.
This is the total cost of duties we pay for each product. Generally ranges from 0-15% of the product cost.
Our company uses a third party fulfillment company for many of our products. This include the cost of Pick and Packing, including packaging.
Simply 10% of the total cost.
In our case, 2.2% of the total sale price
Estimated Shipping Cost (Est. Ship)
This is our estimated shipping cost to ship the product to a customer in the USA (our main market). This an interesting field because shipping cost will always be an estimate. We ship from Washington State and therefore the cost to ship something from Seattle opposed to Miami is vastly different. A good starting point is to take the cost to ship your product to four geographically dispersed cities, say Seattle, Los Angeles, New York, and Miami and take the average shipping cost of those four cities. Once you have 100+ sales, you can look at the historical shipping costs and calculate the average price to ship per pound and times this by the weight of your item.
Estimated shipping will always be an estimate and it’s not perfect. However, it’s far better than doing what most people do and having no estimate whatsoever.
This tells us the total profit we make for each item we sell on eBay.
This is the profit margin, which is simply eBay profit divided by selling price. I like to have both an actual dollar figure for profit (eBay profit) and a percentage.
DimWidth DimHeight DimDepth
The dimensions of the actual product itself. Useful for determining shipping rates.
Master Carton Dimensions
The dimensions of the Master Carton, in other words, the box that holds the individual item boxes. A typical Master Card will hold several individual products. Useful to know if sending products to Amazon FBA, vendors, etc.