Cost prices in Inventory Planner are used in purchase orders and analytics. By adding them to your catalog, profitability metrics can be calculated in the many Reports that Inventory Planner has to offer.
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.
For a full list of integrations and details that are pulled from every system, visit https://inventory-planner.com/integrations.
Overview
Update Cost Prices
Manage vendor attributes for variants by selecting Catalog > Vendor Attributes.
In this section you can Manage Cost Prices, Associate Variants with Vendors, and apply Vendor Rules (eg. minimum order quantity, units of measurement) to variants.
Select 'Save Changes' to finish updating Vendor Attributes.
Note: You can also 'Set Vendor' from the Replenishment screen by selecting items > Bulk Actions > Set Vendor. Learn more about associating variants with vendors. You can also do it from Account>Import.
Reset Manually Edited Attributes
Editing attributes directly in the Catalog section overrides the synced attributes information from your platform (if applicable). These can be easily filtered and adjusted at any time to refresh the synced data.
For Example: if Cost Price has been manually edited, in Catalog > Vendor Attributes you can add a Filter for "Cost Price Assigned" to see items that have been manually updated. They will be marked with "Assigned in Inventory Planner" under the Vendor column. To refresh the synced data, you can select the cost price displayed in purple text under each cost price field (displayed with red arrows below).
Select Variant > Bulk Actions (at the bottom) > Clear Attributes Assigned in Inventory Planner to reset manually edited data and restore values from your synced platform.
Tiered Pricing
When your supplier offers discounts based on bulk purchasing, you can use tiered pricing to enter the price breaks.
Note: Tier Prices can only be set by Variant.
Select Catalog > Vendor Attributes
Enable the 'Tier Prices' column using the gear icon on the right side.
Select 'none' in the Tier Prices column to add detail about price breaks.
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.
You can always Import Tiered Costs as well. The section below is great explaining how to Import and how to import Tiered Costs. Remember to use the following format:
"qty1:price1;qty2:price2;...".
Comparing Vendor Costs
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.
Import Cost Price Data
Importing cost prices can also be done through vendor attributes. You can always import as well from Account > Import.
To import cost prices you need to upload a CSV file with SKUs and costs.
In the Replenishment screen, select Import > Vendor Attributes:
You can see the available columns listed on the bottom of the import section.
(We also offer the ability to download a CSV template, with the available columns for adjustment)
When your CSV file is prepared and ready, you can drag the file to the import section, or click to select your file.
Once Uploaded, proceed using the option to Map Columns.
You will be taken to a field mapping screen, where you can check and confirm the columns on the file are mapped to the desired settings.
Click 'Import' to complete the import.
You will then see an import summary screen, that will confirm changes or if any errors were experienced during the import.
If you have any concerns, please reach to us using the in-app support chat.