Check out this short tour on tracking and calculating item cost.
Understanding item cost
Configure an item’s cost to calculate for P&L on an order with one of these options in the Client Settings > Order Profit & Loss Calculated Using field:
- Last Cost— Cost of the items in the last purchase order received before the order was created
- Site Cost— The current value entered in the product summary’s Site Cost field
- Average Cost— Cost of the units continually averaged. Costs are averaged from the price on the PO at the time the purchase orders are received
If the Client Setting used is Average Cost, but Average Cost is zero, then Site Cost is used on the order’s P&L tab. Note that the chosen Client Setting is used in Sellercloud’s P&L reports.
Dropship POs will update the order’s item cost to the vendor price on the PO, even though the PO is created after the order.
Dropshipped POs that are set to not count inventory either at the PO or Vendor level (setting on Dropship Preferences on vendor toolbox Default = True) will not create an inventory movement or average cost movement record. This means they will not be factored into average cost.
Factoring in shipping or third-party costs
PO shipping costs or other third-party costs can also be averaged into the cost of an item to give an accurate P&L report by enabling the Client Setting Consider PO Extra Costs when Calculating Product Costs.
Example: If a product costs $50.00 and shipping costs $5.00, average cost on the product’s Purchasing page (Product > Toolbox > Purchasing) will be $55.00. If you ordered 2 units with a total PO shipping cost of $5.00, average cost will be divided between the units ordered, producing an average cost of $52.50.
- Product cost(x) + Shipping cost / Number of units
Priming average cost
Average costs are calculated using the price on the PO at the time the purchase orders are received. However, Sellercloud can prime (reset) average cost on the backend to set the cost to a specified value. This is typically done during the initial account setup, but can be done anytime that reset is needed. Average costs can even be backdated to update existing orders that have incorrect item costs. Please contact Sellercloud Support if average costs need to be primed.