If your website platform does not have a cost field or you need enter product or vendor information in bulk, you can do this by importing the data from a CSV or Excel document.
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.
Import Cost Price Data
You can begin importing data from Replenishment, Catalog > Vendor Attributes, Purchase Orders, or Overstock. To import cost prices you need to upload a CSV file with SKUs and costs.
- Select Import > Cost Prices;
- Select CSV file to upload.
- Use the dropdowns to match with column headers in your spreadsheet. Most of the columns are optional, if they are not selected, their value does not change
Use the dropdown options for each field to make sure the correct information is matched. Finally, click Upload.
You will then see the results of your import, including information that successfully imported and an error log. Click on 'Download all errors as CSV' to see issues that need to be corrected. The number in the 'Line' column indicates the row in your spreadsheet where the error occurred.
Update Other Vendor Catalog Data
To update other attributes that cannot be imported from your website platform or inventory management system, visit our Update Vendor Catalog article.