Cost prices in Inventory Planner are used in purchase orders and analytics. By adding them to your products you enable profits and margins to be calculated in the Inventory KPIs report.
Note: If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Enter Cost Price
You can add cost prices for products in 3 ways:
- in Replenishment report
- By uploading them in a spreadsheet
- On Vendors page
To add cost prices in the replenishment report click at gear icon at the top of the page
and enable "Cost Price" column
Then you can edit them for products and variants. When a cost price is set for a product it's automatically set to all its variants
Then Save Changes.
To import cost prices you need to upload a file with SKUs and costs. Click at Import > Cost Prices button
Then select a file, choose which columns contain SKUs and cost prices and click at Upload.
To set cost prices from Vendors page, click at Vendors > [Vendor Name] > Variants and edit them directly on this page for each variant. (If you do not see the Vendor Cost Price column, click on the gear icon on the right side to enable it.)
When your supplier offers discounts based on bulk purchasing, you can use tiered pricing to enter the price breaks.
Go to the Vendors Page, select a Vendor, then click on Variants. Enable the 'Tier Prices' column using the gear icon on the right side.
Then click 'none' in the Tier Prices column to add detail about price breaks.
The Vendor Cost Price if available will show. To add price breaks, click '+ Add Price Tier'.
Then enter the number of units needed to meet the price tier and the corresponding cost price or discount to the 'Vendor Cost Price'.
Finally, click Save.
Now in the 'Tier Prices' column, you will see the units needed to meet each tier and the corresponding cost price.
On a Purchase Order, you will be prompted to change the quantity ordered when the current quantity and the tiered quantity with discounted cost are within 30% of one another.
If you have different cost prices from different vendors for the same item, then you can view this in reports by enabling the 'Cost Compare' column. Click here to learn more.