{"product_id":"product-profit-calculator-product-pricing-worksheet","title":"Product Profit Calculator - Product Pricing Worksheet in Sheets and Excel","description":"\u003cp data-start=\"554\" data-end=\"804\"\u003eWant confident pricing before busy season? This \u003cstrong data-start=\"602\" data-end=\"632\"\u003eProduct Profit Spreadsheet\u003c\/strong\u003e (Google Sheets \u003cstrong data-start=\"648\" data-end=\"655\"\u003eand\u003c\/strong\u003e Excel) shows your \u003cstrong data-start=\"674\" data-end=\"697\"\u003etrue product profit\u003c\/strong\u003e \u003cstrong\u003eand profit\u003c\/strong\u003e \u003cstrong data-start=\"699\" data-end=\"711\"\u003emargin --\u003c\/strong\u003e so you can price smarter, set discounts safely, and stop guessing.\u003c\/p\u003e\n\u003cp data-start=\"806\" data-end=\"894\"\u003ePerfect for \u003cstrong data-start=\"819\" data-end=\"840\"\u003ehandmade products\u003c\/strong\u003e and small e-commerce shops, it includes \u003cstrong data-start=\"881\" data-end=\"893\"\u003etwo tabs\u003c\/strong\u003e:\u003c\/p\u003e\n\u003cul data-start=\"895\" data-end=\"1247\"\u003e\n\u003cli data-start=\"895\" data-end=\"1090\"\u003e\n\u003cp data-start=\"897\" data-end=\"1090\"\u003e\u003cstrong data-start=\"897\" data-end=\"910\"\u003eEtsy Tab:\u003c\/strong\u003e builds in the \u003cstrong data-start=\"925\" data-end=\"946\"\u003e$0.20 listing fee\u003c\/strong\u003e + \u003cstrong data-start=\"949\" data-end=\"973\"\u003e6.5% transaction fee\u003c\/strong\u003e and \u003cstrong data-start=\"978\" data-end=\"1000\"\u003epayment processing\u003c\/strong\u003e. Handles \u003cstrong data-start=\"1010\" data-end=\"1048\"\u003eshipping charged vs. free shipping\u003c\/strong\u003e, and shows \u003cstrong data-start=\"1060\" data-end=\"1089\"\u003enet shipping contribution\u003c\/strong\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1091\" data-end=\"1247\"\u003e\n\u003cp data-start=\"1093\" data-end=\"1247\"\u003e\u003cstrong data-start=\"1093\" data-end=\"1115\"\u003eShopify\/Other Tab:\u003c\/strong\u003e without Etsy’s per-item fees—perfect for Shopify and other platforms.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-start=\"1249\" data-end=\"1288\"\u003e\u003cstrong data-start=\"1249\" data-end=\"1288\"\u003eWhat it calculates (automatically):\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul data-start=\"1289\" data-end=\"1565\"\u003e\n\u003cli data-start=\"1289\" data-end=\"1343\"\u003e\n\u003cp data-start=\"1291\" data-end=\"1343\"\u003e\u003cstrong\u003eProfit per item\u003c\/strong\u003e (with or without charged shipping)\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1344\" data-end=\"1385\"\u003e\n\u003cp data-start=\"1346\" data-end=\"1385\"\u003e\u003cstrong data-start=\"1346\" data-end=\"1358\"\u003eMargin %\u003c\/strong\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1344\" data-end=\"1385\"\u003e\n\u003cp data-start=\"1346\" data-end=\"1385\"\u003e\u003cstrong data-start=\"1346\" data-end=\"1358\"\u003e\u003c\/strong\u003eImpact of \u003cstrong data-start=\"1453\" data-end=\"1462\"\u003eads %\u003c\/strong\u003e and \u003cstrong data-start=\"1467\" data-end=\"1478\"\u003eadmin %\u003c\/strong\u003e on pricing\u003cbr\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-start=\"1567\" data-end=\"1587\"\u003e\u003cstrong data-start=\"1567\" data-end=\"1587\"\u003eWhat’s included:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul data-start=\"1588\" data-end=\"1836\"\u003e\n\u003cli data-start=\"1588\" data-end=\"1632\"\u003e\n\u003cp data-start=\"1590\" data-end=\"1632\"\u003e\u003cstrong data-start=\"1590\" data-end=\"1612\"\u003eGoogle Sheets file\u003c\/strong\u003e (share\/copy link)\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1633\" data-end=\"1663\"\u003e\n\u003cp data-start=\"1635\" data-end=\"1663\"\u003e\u003cstrong data-start=\"1635\" data-end=\"1661\"\u003eExcel workbook (.xlsx)\u003c\/strong\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1664\" data-end=\"1754\"\u003e\n\u003cp data-start=\"1666\" data-end=\"1754\"\u003e\u003cstrong data-start=\"1666\" data-end=\"1690\"\u003eStep-by-step example\u003c\/strong\u003e showing exactly which numbers to gather and where to put them\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-start=\"1838\" data-end=\"1854\"\u003e\u003cstrong data-start=\"1838\" data-end=\"1854\"\u003ePerfect for:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul data-start=\"1855\" data-end=\"2066\"\u003e\n\u003cli data-start=\"1855\" data-end=\"1904\"\u003e\n\u003cp data-start=\"1857\" data-end=\"1904\"\u003e\u003cstrong data-start=\"1857\" data-end=\"1865\"\u003eEtsy\u003c\/strong\u003e sellers and \u003cstrong data-start=\"1878\" data-end=\"1889\"\u003eShopify\u003c\/strong\u003e store owners\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1905\" data-end=\"1974\"\u003e\n\u003cp data-start=\"1907\" data-end=\"1974\"\u003eHandmade product businesses, makers, crafters, POD\/light assembly\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"1975\" data-end=\"2066\"\u003e\n\u003cp data-start=\"1977\" data-end=\"2066\"\u003eAnyone who wants clear \u003cstrong data-start=\"2000\" data-end=\"2019\"\u003eproduct pricing\u003c\/strong\u003e and \u003cstrong data-start=\"2024\" data-end=\"2034\"\u003eprofit\u003c\/strong\u003e visibility \u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-start=\"2068\" data-end=\"2094\"\u003e\u003cstrong data-start=\"2068\" data-end=\"2094\"\u003eHow it works (simple):\u003c\/strong\u003e\u003c\/p\u003e\n\u003col data-start=\"2095\" data-end=\"2626\"\u003e\n\u003cli data-start=\"2095\" data-end=\"2159\"\u003e\n\u003cp data-start=\"2098\" data-end=\"2159\"\u003eStart with your \u003cstrong data-start=\"2114\" data-end=\"2131\"\u003eregular price\u003c\/strong\u003e and \u003cstrong data-start=\"2136\" data-end=\"2156\"\u003edirect materials\u003c\/strong\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2160\" data-end=\"2246\"\u003e\n\u003cp data-start=\"2163\" data-end=\"2246\"\u003eAutomatically adds Etsy platform selling fees \u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2247\" data-end=\"2360\"\u003e\n\u003cp data-start=\"2250\" data-end=\"2360\"\u003e\u003cspan data-start=\"2256\" data-end=\"2280\"\u003eAutomatically calculates \u003c\/span\u003e\u003cstrong data-start=\"2256\" data-end=\"2280\"\u003epayment processing %\u003c\/strong\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2247\" data-end=\"2360\"\u003e\n\u003cp data-start=\"2250\" data-end=\"2360\"\u003eHelps you calculate your \u003cstrong data-start=\"2302\" data-end=\"2311\"\u003eads %\u003c\/strong\u003e, and \u003cstrong data-start=\"2317\" data-end=\"2328\"\u003eadmin %\u003c\/strong\u003e costs\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2361\" data-end=\"2525\"\u003e\n\u003cp data-start=\"2364\" data-end=\"2525\"\u003e\u003cstrong data-start=\"2388\" data-end=\"2408\"\u003eShipping\u003c\/strong\u003e (tracks shipping revenue, label cost, and fees) \u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2526\" data-end=\"2626\"\u003e\n\u003cp data-start=\"2529\" data-end=\"2626\"\u003eReview \u003cstrong data-start=\"2536\" data-end=\"2566\"\u003eProfit and Profit Margin \u003c\/strong\u003eper product—then tweak price, materials, or ads.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp data-start=\"2628\" data-end=\"2645\"\u003e\u003cstrong data-start=\"2628\" data-end=\"2645\"\u003eWhy it works:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul data-start=\"2646\" data-end=\"2895\"\u003e\n\u003cli data-start=\"2646\" data-end=\"2740\"\u003e\n\u003cp data-start=\"2648\" data-end=\"2740\"\u003eBuilt for \u003cstrong data-start=\"2658\" data-end=\"2688\"\u003ereal-world e-commerce math\u003c\/strong\u003e (fees on shipping, per-order listing fees, etc.).\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli data-start=\"2741\" data-end=\"2823\"\u003e\n\u003cp data-start=\"2743\" data-end=\"2823\"\u003eGives you \u003cstrong data-start=\"2753\" data-end=\"2772\"\u003einstant clarity\u003c\/strong\u003e on what you can discount without killing profit.\u003cbr\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-start=\"3158\" data-end=\"3301\"\u003e\u003cstrong data-start=\"3158\" data-end=\"3205\"\u003eFAQ\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp data-start=\"3158\" data-end=\"3301\"\u003e\u003cstrong data-start=\"3158\" data-end=\"3205\"\u003eQ: Does this work if I offer free shipping?\u003c\/strong\u003e\u003cbr data-start=\"3205\" data-end=\"3208\"\u003eA: Yes\u003c\/p\u003e\n\u003cp data-start=\"3303\" data-end=\"3444\"\u003e\u003cstrong data-start=\"3303\" data-end=\"3355\"\u003eQ: Can I use this for Amazon ?\u003c\/strong\u003e\u003cbr data-start=\"3355\" data-end=\"3358\"\u003eA: No—this  spreadsheet is not designed to calculate Amazon selling fees\u003c\/p\u003e\n\u003cp data-start=\"3446\" data-end=\"3581\"\u003e\u003cstrong data-start=\"3446\" data-end=\"3499\"\u003eQ: Can I edit and reuse it for multiple products?\u003c\/strong\u003e\u003cbr data-start=\"3499\" data-end=\"3502\"\u003eA: Absolutely—comes ready with room for 20 products, but simply drag the last column further to create additional columns with the same formula\u003c\/p\u003e\n\u003cp data-start=\"3583\" data-end=\"3664\"\u003e\u003cstrong data-start=\"3583\" data-end=\"3608\"\u003eQ: Beginner friendly?\u003c\/strong\u003e\u003cbr data-start=\"3608\" data-end=\"3611\"\u003eA: Very. The example tab walks you through each step.\u003c\/p\u003e\n\u003cp data-start=\"3583\" data-end=\"3664\"\u003e \u003c\/p\u003e\n\u003cp data-start=\"3583\" data-end=\"3664\"\u003eAs this is a digital product there are no refunds or returns.\u003c\/p\u003e","brand":"Small Business Sarah Shop","offers":[{"title":"Default Title","offer_id":51229087269166,"sku":null,"price":5.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0875\/7444\/6382\/files\/ProductProfitSpreadsheet.jpg?v=1762117135","url":"https:\/\/shop.smallbusinesssarah.com\/products\/product-profit-calculator-product-pricing-worksheet","provider":"Small Business Sarah Shop","version":"1.0","type":"link"}