Average unit cost

The average unit costs is the average cost of your current stock. Every time you receive a purchase order, your average unit cost is updated. For example, if you have 10 units of product A in stock, which has a cost price of $10 per unit, then your average unit cost is initially $10. If you then order another 10 units of product A, this time with a cost price of $5 per unit, then your average unit cost is now $7.50.

Set your initial average unit costs

There are a few different ways to set your initial average unit cost:

Import a CSV file into Stocky

  1. In Stocky, click Preferences.
  2. Click COGS.
  3. Click Import initial average unit cost.

From the SKU/Variant report

  1. In Stocky, click Reports
  2. Select the SKU/Variant Report.
  3. Select the Columns, and then select Average Cost.
  4. Click Update.
  5. A report showing each of your product variants with the associated average cost is now displayed. Enter the average cost into the Average cost column.

Applying the average unit costs to historical sales orders

If you want to COGS reports for existing sales orders, then you need to apply your current average cost to those specific orders. This method might not be completely accurate, but it provides you with an approximate cost associated with each product.

Steps:

  1. In Stocky, click Preferences
  2. Click COGS, and then select Backdate Average Unit Costs.

Enable the average unit cost on your purchase orders

  1. In Stocky, select a purchase orders.
  2. Click Preferences > Purchase Orders > Settings for draft/confirmed PO.
  3. Select Average Cost.

Ready to start selling with Shopify?

Try it free