{"_id":"591a551885b2570f00e42f6a","user":"55b17309b3a7e037008ac294","version":{"_id":"55b17318ae3b7621003e65a0","project":"55b17318ae3b7621003e659d","__v":6,"createdAt":"2015-07-23T23:04:56.991Z","releaseDate":"2015-07-23T23:04:56.991Z","categories":["55b17319ae3b7621003e65a1","55b1f85bbd0ec92d002227d3","5643ca63c6e9600d006bd71d","57985b0417ced017003c4c25","57e9c03b0691d50e007bee6d","58842626cdbc3c0f00175638"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"parentDoc":null,"project":"55b17318ae3b7621003e659d","__v":0,"category":{"_id":"55b17319ae3b7621003e65a1","version":"55b17318ae3b7621003e65a0","pages":["55b1731aae3b7621003e65a3","55b1e600ae3b7621003e6674","55b1ed35ae3b7621003e669d","55b1f894fa4acb1700910e90","55b1f8d1bd0ec92d002227d6","55b72baa2764c20d008d7cc6","55c598635c5d9f0d00496a26","5643d31cc92c470d002decf1","564bbb340cbcc91700b81719","5668a03006039e0d00c4ed5f","5668a36132fe4e0d0084f52b","56b83ffeb1e03e0d00105627","56d7d14d7a04df0b00ddefb5"],"project":"55b17318ae3b7621003e659d","__v":13,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-07-23T23:04:57.528Z","from_sync":false,"order":1,"slug":"documentation","title":"Documentation"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2017-05-16T01:25:44.421Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":10,"body":"The profit reporting is largely based on the Shopify reporting feature but with the addition of COGS and profit margin.\n\nYou may notice a small difference in the Discounts field. This is due to an issue with the Shopify API where all line item discounts are reported as 0.00 meaning we have to work backwards from the order discount which can cause a rounding error. We have reported the issue to Shopify and will update our code once this is corrected.\n[block:parameters]\n{\n \"data\": {\n \"0-0\": \"**Net Quantity** \",\n \"1-0\": \"**Gross Sales\\t** \",\n \"2-0\": \"**Discounts** \",\n \"3-0\": \"**Returns** \",\n \"4-0\": \"**Net Sales** \",\n \"5-0\": \"**Tax** \",\n \"6-0\": \"**Total Sales** \",\n \"7-0\": \"**COGS** \",\n \"8-0\": \"**Gross Profit** \",\n \"9-0\": \"**Gross Margin** \",\n \"0-1\": \"Total number of units sold within the selected date range with refunds deducted.\",\n \"1-1\": \"Product price x quantity (before taxes, shipping, discounts, and returns)\\n\\nNote: currently excludes cancelled but should to match with Shopify\",\n \"2-1\": \"Line item discount + order level discount share for a collection of sales.\\n\\nOrder based discounts are proportionally applied.\\n\\nDiscounts are applied before taxes.\\n\\nDiscounts are created using discount codes, not the compare at price.\",\n \"3-1\": \"The value of the goods returned within the selected date range.\",\n \"4-1\": \"Gross sales - discounts - returns\",\n \"5-1\": \"The total amount of taxes collected on these orders.\",\n \"6-1\": \"Gross sales - discounts - returns + taxes + shipping charges\",\n \"7-1\": \"Currently this is the net quantity x current cost price of the product.\\n\\nNote: We are working on a way to record average unit price so this will be updated soon.\",\n \"8-1\": \"Gross sales - COGS\",\n \"9-1\": \"((Gross sales - COGS) / Gross sales) x 100\"\n },\n \"cols\": 2,\n \"rows\": 10\n}\n[/block]","excerpt":"","slug":"profit-reporting","type":"basic","title":"Profit Reporting"}

Profit Reporting

The profit reporting is largely based on the Shopify reporting feature but with the addition of COGS and profit margin.
You may notice a small difference in the Discounts field. This is due to an issue with the Shopify API where all line item discounts are reported as 0.00 meaning we have to work backwards from the order discount which can cause a rounding error. We have reported the issue to Shopify and will update our code once this is corrected.
[block:parameters]
{
"data": {
"0-0": "**Net Quantity** ",
"1-0": "**Gross Sales\t** ",
"2-0": "**Discounts** ",
"3-0": "**Returns** ",
"4-0": "**Net Sales** ",
"5-0": "**Tax** ",
"6-0": "**Total Sales** ",
"7-0": "**COGS** ",
"8-0": "**Gross Profit** ",
"9-0": "**Gross Margin** ",
"0-1": "Total number of units sold within the selected date range with refunds deducted.",
"1-1": "Product price x quantity (before taxes, shipping, discounts, and returns)\n\nNote: currently excludes cancelled but should to match with Shopify",
"2-1": "Line item discount + order level discount share for a collection of sales.\n\nOrder based discounts are proportionally applied.\n\nDiscounts are applied before taxes.\n\nDiscounts are created using discount codes, not the compare at price.",
"3-1": "The value of the goods returned within the selected date range.",
"4-1": "Gross sales - discounts - returns",
"5-1": "The total amount of taxes collected on these orders.",
"6-1": "Gross sales - discounts - returns + taxes + shipping charges",
"7-1": "Currently this is the net quantity x current cost price of the product.\n\nNote: We are working on a way to record average unit price so this will be updated soon.",
"8-1": "Gross sales - COGS",
"9-1": "((Gross sales - COGS) / Gross sales) x 100"
},
"cols": 2,
"rows": 10
}
[/block]