Not sure where to start with all the different functions of Inventory Planner? Here is a quick guide to get you started!
The lower right corner is the Chat function. You can start a conversation, chat with friendly IP staff, find all metrics, definitions and formulas, as well as the full Help Center.
You will also find drop-downs menus at the top of almost every page.
Catalog View Dropdown: Use this to view your product catalog at a variety of levels. Variants will be selected by default. Clicking the dropdown will display additional dimensions:
- Variants: Shows all your variations, such as colors, flavors, and sizes.
- Bundles: Multipacks (2 pack, 4 pack etc.) or combinations (bundles of flavors, colors, etc). See article on Bundles and Packs.
- Products: This is the parent of the variant. For example: "Floral Dress" is a Product, and the sizes S, M, and L are Variants.
- Vendor: These lists your Suppliers. Learn about configuring vendors here.
- Brand: The name a product is sold under and that you are advertising to the customer. For example, Nike or Underarmour.
- Categories: This displays Product Type.
- Total: Your totals storewide.
Filters: Use filters to narrow down the information you are viewing. You can save filters and set these as defaults.
Edit Columns: Use the Gear Icon on the right lets you pick and choose over 125 metrics to show in your report.
Explanation Metrics and Filters can be found in our Glossary of Terms.
Select any item; it will appear on the righthand side. Then you can drag and drop to arrange the report for customization. You can save it as is, or save the report as a default template. You can also set a default by hovering over the three little dots.
Sales Period for Forecast: This is the default sales period that Inventory Planner is referencing to generate forecasts based on the Recent Sales and Trend Forecast Method*. This date range also affects the Forecast and Replenishment metrics in other tabs as well (eg. Reporting, Overstock). The period is set in the top right of the Replenishment screen.
*Note: Seasonal and Top-Down Forecast Methods refer to the same months in prior years as the sales reference period. This is beneficial for holiday and seasonally driven items with 12+ months of history. Forecast Methods can be set account-wide or customized by item. Learn more about Forecast Methods here.
Details Screen + Replenishment & Forecast Tab
If you hover over the “i” icon under the Details columns, you get a quick look at what is happening on the screen. It can come in different colors and give you a warning at the top saying an item currently out of stock or tell you the time before you get an item back in stock.
Replenishment & Forecast Tab: Forecast details can be seen by clicking the icon, then clicking this tab.
RED: This screen displays details about how the forecast is being calculated by displaying the selected Forecast Method (customize under the "Forecast Settings" tab), Sales Period for Reference, Sales Velocity during the period, and Forecast Sales during the Lead Time and Days of Stock Periods.
BLUE: This table shows the Past Sales (last 12 months) and Forecasted Sales (next 12 months). The data correlates to the Forecast Sales chart. Overrides to the forecast can be inputted here directly in units, or by percent.
ORANGE: These charts provide information on the Past Sales and Forecasted Sales (last/next 12 months), Forecasted Stock and Lost Revenue (due to Stockouts), and Purchase Order recommendations.
Additional Tabs within the Details screen include:
On Order: This tab shows current purchase orders including this item.
Wholesale Orders: if enabled, this will show you the details of current wholesale orders. These are customer orders that are separated & added to your regularly driven demand. Learn more about Wholesale Planning.
- Bundles: This tab displays relationships with Bundles and/or Components. Learn about setting up Bundles and Packs.
Merged Variants: This tab displays Merged Variants and Linked Variants associated with the item.
Merging Variants: This function combines the sales and/or stock of separate items. When a product has an updated style or slightly changes sizes, it may be helpful to merge variants so that the new product has the sales history needed to generate a forecast.
Linking Variants: Variants from different connections (eg. Shopify, Amazon, etc) can be linked together to be displayed as one in a Combined Warehouse using this feature.
- Stock & Sales History: This tab visualized information on Sales, Revenue & Profit, Stock, and Stock Cost for the item.
Adjustments can be made in the Details view at the item level, or by utilizing Bulk Actions. This option appears at the bottom once you check on the boxes to the left of each line. Here is more information on adjustments that can be made, and articles with more information on each action:
- Set Lead Time and Days of Stock
- Set Min/Max Stock (Optional)
- Set Low Stock Alert (Optional)
- Increase or Clear Forecast by Percentage
- Clear Forecast Override
- Recompute Forecast
- Set Vendor or Brand
- Add IP Tags
Adjustments can also be made by importing CSV files. This option appears when no boxes are checked to the left of each line:
Export: Allows you to export from any page in IP. You can export it as an Excel document.
Import: Create a CSV with the required information in separate columns, and include a column title for each. Each column must have a name, otherwise the data in the first row will be ignored. Select your file and attach a spreadsheet.
Once attached, you will see drop-downs of all the column names in the spreadsheet. Match each field with the columns from your spreadsheet to the field in IP. For example, your Vendor column could be called “Suppliers”.
Example: Import > Vendor Catalog