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.

Average unit costs are unique to Stocky and don't appear in Shopify.

Calculating average unit costs

Stocky uses the following formula to calculate the average unit cost on a purchase order:

((Current Average Cost x Current Stock Quantity) + (Receiving Stock Cost x Receiving Stock Quantity)) / (Current Stock Quantity + Receiving Stock Quantity)

For example, if you have 30 units of a product that costs $10 per unit, and are ordering another 15 units at only $8 per unit, the formula would be((10 x 30) + (8 x 15)) / (30 + 15)which totals an average unit cost of $9.33.

There are two cases when this formula isn't used:

  • When a purchase order is created for a variant that currently has a negative stock quantity. In this case, the average unit cost will be updated to theReceiving Stock Costvalue.
  • When a purchase order is created that has a negativeReceiving Stock Quantitywhich is greater than theCurrent Stock Quantity, resulting in an overall negative stock level. In this case, the average cost doesn't change.

Enable or disable automatic unit cost syncing

To have the cost per item in your Shopify admin update automatically with the value in Stocky, enable automatic updates for average unit costs. Enabling automatic average unit cost syncing overwrites the existing cost per item value in your Shopify admin and can't be undone.

Steps:

  1. From your Shopify admin, clickSettings>Apps and sales channels.

  2. From theApps and sales channelspage, clickStocky.

  3. ClickOpen app.

  4. In Stocky, clickPreferences.

  5. ClickCOGS.

  6. In theAutomatic Cost Price Syncingsection, take one of the following actions:

    • To turn on automatic syncing, clickEnable.
    • 关闭自动同步,点击Disable.

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. From your Shopify admin, clickSettings>Apps and sales channels.

  2. From theApps and sales channelspage, clickStocky.

  3. ClickOpen app.

  4. In Stocky, clickPreferences.

  5. ClickCOGS.

  6. ClickImport Initial Average Unit Costs.

  7. Choose a CSV file to import and clickNext.

  8. An import preview of the first rows of the CSV displays. Assign the following columns:

    1. ForWhich column is the identifier?, selectVariant BarcodeorVariant SKU.
    2. ForWhat type of identifier is this column?, selectBarcodeorSKU根据你的previous selection.
    3. ForWhich column is the Average Cost?, selectCost per item.
  9. ClickNext.

From the SKU/Variant report

  1. From your Shopify admin, clickSettings>Apps and sales channels.

  2. From theApps and sales channelspage, clickStocky.

  3. ClickOpen app.

  4. In Stocky, clickReports

  5. Select theSKU/Variantsreport.

  6. Select theColumns, and then selectAverage Cost.

  7. ClickUpdate.

  8. A report showing each of your product variants with the associated average cost is now displayed. Enter the average cost into theAverage costcolumn.

  9. Optional: ClickSave Reportto save this SKU/Variant Report.

Apply the average unit costs to historical sales orders

If you want to cost of goods sold (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. From your Shopify admin, clickSettings>Apps and sales channels.

  2. From theApps and sales channelspage, clickStocky.

  3. ClickOpen app.

  4. In Stocky, clickPreferences

  5. ClickCOGS, and then selectBackdate Average Unit Costs.

Enable the average unit cost on in-progress purchase orders

  1. From your Shopify admin, clickSettings>Apps and sales channels.

  2. From theApps and sales channelspage, clickStocky.

  3. ClickOpen app.

  4. In Stocky, clickPreferences>Purchase orders.

  5. ClickSettings for draft PO.

  6. SelectAverage Unit Cost.

  7. ClickUpdate.

  8. ClickSave changes.

Ready to start selling with Shopify?Try it free