Why is my order material cost incorrect?
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.
To find which of your orders are zero costed, see the this article: How can I find my uncosted orders?
To troubleshoot why your order material cost is zero, please see the guidance below.
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?
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).
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.