Deficient Orders

Deficient Orders

The concept of the deficient order is central to MarginDriver's mission of helping ecommerce sellers achieve their optimal price points and increase their gross profit margins and overall profitability. MarginDriver's definition of a deficient order is any order that falls below the user's minimum acceptable gross profit dollar amount, gross profit margin percentage or product markup. The Deficient Orders feature provides the user with an analytical tool designed to identify these orders as soon as possible. Early identification of these deficiencies provides the opportunity to correct them before they can become a significant drag on the company's overall profitability.



Below is a description of the four individual deficient order criteria available to users. Since a significant percentage of deficient orders are a function of weight and shipping cost, each of these four criteria can be combined with selected weight criteria.


Gross Profit Less Than $ - This criteria will identify all orders with a gross profit dollar amount that is below the value entered. For example, if the user enters $0.00 all orders with a gross profit less than zero (showing a loss) will be displayed. If the user enters $1.50 all orders with a gross profit less than $1.50 will be identified and displayed.


Gross Profit Less than % - This criteria Margin Driver will search for and display all orders with a gross profit margin percentage less than the percentage entered.


Markup Less Than – This criteria will uncover the orders that had a product marked up over its cost less than the markup entered. If the user entered 1.4, all orders with a product marked up less than 1.4 over its respective cost will be displayed. As an example if a products cost was $10.00 and its sales price in an order was $14.50 such an order would not be included in the results for this analysis as its markup is not less than 1.4. But if a product with a cost of $10.00 was sold to a customer for $13.99 or lower then such orders would be included. This is an excellent tool for monitoring the profitability of products sold on Amazon with the help of an automated repricer.


Product Sales Price Less Than – Only orders with a product sales price less than the amount entered by the user will be included in the results for this analysis. As an example, if the user wants to see all orders in which a product was sold for less than $4.50 the user would simply enter $4.50 after selecting this criteria. This can be helpful in determining if the gross profit generated by low priced products is meeting certain minimum profitability thresholds.   


Weight Between (oz)  As stated above, all four of the provided criteria can be combined with a weight criteria by entering the minimum and maximum weight to be included in the deficient order search.


Finally, as with most MarginDriver reports, Deficient Orders results are capable of being filtered by sales channel(s) and date range, and the option exists to add or remove KPI metrics as desired. All Deficient Orders reports can be exported in Excel (.xlxs) format for further filtering and manipulation.


    • Related Articles

    • Order Analytics

      The MarginDriver Order Analytics page is the most advanced tool in the app for digging deep into your order data and identifying orders by just about any criteria you would like. Users are provided the typical MarginDriver suite of top-level filters ...
    • Refund Analytics

      MarginDriver currently pulls in refunds from Amazon, eBay, Walmart and Shopify (if payment and refund are processed by Shopify Payments). The MarginDriver Refund Analytics page tracks these refunds and their impact on the user's gross profit. In ...
    • Shipping Metrics

      The Shipping Metrics feature offers users a quick glance at how one of the great variables in ecommerce - shipping and fulfillment costs - are impacting their company's profitability. It is important to understand and remember that the data in the ...
    • Products and Categories

      The products and categories page gives MarginDriver users an in-depth look at their profitability by SKU, brand and supplier. All results can be filtered by sales channel(s) and custom date range. Top Products/Top Brands/Top Suppliers The Top ...
    • Decision Model

      In an attempt to increase their bottom line, internet retailers can make the mistake of focusing solely on trying to drive revenue higher assuming elevated profits will automatically follow. Lowering sales prices in an attempt to push revenue higher ...