Discount Analysis

You can use Easy Insight to pull over discount and promotion codes from your e-commerce channels and match back to orders in your inventory management system. You can use this reporting to understand:

How much has the discount cost you?
How many orders have used this discount?
How many new customers has the discount brought in?
How many repeat customers made another purchase using the discount?
What are the lifetime sales of customers who came in with this discount?

Discount codes typically live in the e-commerce channel, such as Shopify or Amazon.

For each inventory management connection in Easy Insight, a set of prebuilt reports under the 'Margins' section shows you the number of orders by gross margin range, the number of orders by net margin range, the margins by channel, and the net profit by sales channel and month. You can use these reports to identify which particular sales channels or orders might be coming in at a negative net margin or find which particular combinations of products and channels are the most lucrative for your business.

We break up costs by the following categories:

Discounts -- how much of a discount was applied to the sale?
Credits/Returns -- how much has been credited back to customers?
COGS -- how much has it cost to purchase or build the sold products?
Shipping -- how much has it cost to ship orders?
Channel Fees -- how much has it cost to sell on e-commerce channels?
Variable Expenses -- what other variable costs such as warehouse salaries, advertising, and sales commission are affecting your bottom line?

In general, discounts, credits/returns, and COGS can come out of the inventory management system itself. Shipping costs are typically pulled from the shipping system such as ShipStation or StarshipIt. Channel fees are pulled from the e-commerce channels such as Shopify, Amazon, Walmart, or Etsy. Variable expenses are pulled from the accounting system such as QuickBooks Online or Xero. For more information on connecting external costs to your inventory management system, please see Extending Inventory Data.

Across the different inventory management system prebuilt dashboards in Easy Insight, we've tried to show the same general set of reports:

The Margin Breakdown provides a sankey chart starting with gross sales and shipping charged to the customer, then subtracting discounts, COGS, shipping, channel fees, and variable expenses to get your end contribution profit.

The Margin Breakdown List a table of the same data, but with the ability to compare profit details between source channel, product category, or other fields.

# of Orders by Gross Margin Range and # of Orders by Contribution Margin Range give you the # of orders in each profit range. You can click to drill in and find orders with < 0% or other less than ideal ranges to try and figure out what needs to change in your business.

The final displays of profit by sales channel and and profit by category let you visually compare gross and contribution profit across sales channels and category.