Order cost troubleshooting
Learn how to troubleshoot issues with your order material costs.
Having trouble with your material costs calculating incorrectly for an order? Here's a few things you can try yourself to get your orders costing correctly!
- Order material costs are zero
- Order costs are lower or higher than expected
Before we begin:
Order material costs are automatically calculated when your order is shipped and are calculated from your stock adjustments for each product in the order.
It is important to note that any manufactures associated with the order will not be used directly to calculate the material cost - this is because manufactures can produce stock for more than one order.
An order can be costed as zero (0.00) for a number of reasons, we'll cover each one below.
To firstly find which of your orders are zero costed, see the this article: How can I find my uncosted orders?
1. Is the shipped date set for the order?
The material cost for the order is automatically costed when the order is marked as shipped, so if your order does not yet have a shipped date then it will display as either a dash (-) or a zero value. To fix this, ensure that your order has been set with the correct shipped date.
Instructions on how to set the order shipped date can be found here: How do I mark an order as shipped?
2. Do you have enough stock on hand?
If the order is marked as shipped, then it may be an issue with stock levels. If there was not enough stock of this product on the date that the order was shipped then it will be costed as zero until this is rectified.
To identify if this is the issue with your order:
1. Navigate to the product or variation page ( How do I find my product page?)
2. Click on the tab called Adjustments
3. Look through the list of adjustments that appears until you find the adjustment created by the order. The adjustments are in date order, and you'll want to be looking for the shipped date of the order here.
You'll want to be now looking at what appears in the column under Stock. If this is a red clipboard, then there was not enough stock on hand for the shipped date to fulfil the order - this is why the order line item has been costed as $0.00.
Tip: You'll also find guidance on the probable reason for the issue when you hover your mouse over the yellow warning triangle next to the calculated material cost.
To fix, you'll want to review the manufactures and starting adjustment before this adjustment to see if you are missing any that would account for the missing stock.
Adding the missing stock via manufactures will automatically recalculate all stock levels after the manufacture date, so this will automatically recalculate the order costing for you. The recalculation may take a couple of minutes to process if you have a large number of adjustments for the product / variation.
Note: Adding stock via manual adjustments is not recommended as it will be added to your inventory with a zero value. You'll want to ensure that all stock is costed correctly via adding manufactures or a starting adjustment value (if you have brought stock forward from a previous system).
3. Are your manufactures correctly costed?
If the clipboard is green in the adjustment history for the product / variation, then this issue is most likely due to previous manufactures being calculated as zero: this is passing the value up to the products that were sold.
To find out if this is the cause, review the manufactures before the order adjustment and look in the Material Cost column to see what they were costed as. If they are zero, you'll want to now move onto the troubleshooting guide for zero costed manufactures to rectify the issue. Once you have fixed the issue with the manufacture(s) then the adjustments and order costings will automatically recalculate for you.
Note: the recalculation may take a couple of minutes to process if you have a large number of adjustments for the product / variation.
If you find that your material cost for an order seems incorrect, please follow the steps below to troubleshoot the problem:
1. Check that your Order has a Shipped Date
The material cost calculations now only occur when an order has been marked as Shipped.
When the Order is marked with a Shipped Date, it is this date that is used to pinpoint the cost of manufacture which is then assigned as a cost to your order line item. While the order is unshipped, the material cost will always be zero as it is up to this point included in your raw material inventory totals.
2. Check your manufacture history
If an order item does not yet have a manufacture history, then it will have a material cost of zero until the adjustment history is added. Adding in the missing backdated manufactures will automatically recalculate all adjustments and thus all order material costs relating to it. You can review your manufacture history for each product by clicking on the Adjustments tab on your products page.
3. Ensure the relevant manufactures are dated before the shipped date for the order
As the weighted average cost calculation uses your adjustment history to determine the cost of the manufactured goods sold, dates are extremely important: if your order has a shipped date before your manufacture, then the manufacture cost will not be included into the calculation.
4. Review your Manual Product Adjustments
Any positive manual inventory adjustments you have added to the product will have increase your stock on hand at that point in time, but as no cost will be associated with the adjustment your real costs will be "diluted" by these adjustments.
If you wish to use our material costing / COGS features, it is recommended that you:
a) avoid adding positive inventory adjustments and instead create manufactures to account for the stock increase so that they are fully costed in the system.
5. Review your Starting Quantity Adjustments
As you may be moving to CB from a different system it is possible to set a unit price for any product stock you begin with: these adjustments are fully costed into your rolling averages. If you bring a large quantity of stock into Craftybase without a cost attributed (i.e. zero) then this will dilute and affect your cost calculations going forward.
It is recommended that you review all Starting Adjustments and either:
a) add an accurate unit cost for any stock brought forward into the system or
b) if you are tracking back to the date of manufacture, set your starting quantity as 0.00 and add a manufacture to account for the creation of all products.