Are you ready to get your stores properly stocked and ready for the spring season? . Fortunately, our reporting can help you see the inventory levels you need to ship with the intention to be ready for the initial sales.
Insight Panel 106 under ‘Sales Insights’ will show you what inventory you had on hand by week last year. You can use this as a model for building your inventory this year. Use this in combination with your daily sales panel to plan exactly when you need to ship product to support your initial sales this season.
To set up this panel, choose the Daily Sales Trend panel under the Sales Insights drop down menu. Choose the retailer you want, and then under Sales Metric choose Cost Inventory $$. Under Time Period choose Previous / Next 4 Weeks. Save the panel.
You can also choose a specific region for this report, and set up a panel for each of your regions.
If you want help with setting up this panel, you can send an email to Support@Avantalytics.com and we'll be happy to help you!
As you start receiving new MP files from Lowe’s and 531 reports from Home Depot, with new items being activated, it can be a lot to keep up with. Luckily, we have an “Easy” button that can highlight item setup data you may have missed before you get deep into writing an order and ask yourself, “Where is the item I want to order?”
A helpful feature of the order generation tool is the ability to check for maintenance errors before you start ordering. Look for the “Check for Errors” button on the bottom of the main order template screen.
If you click this button, the system will automatically check for any errors that would prevent you from being able to order an item. You will then have the opportunity to fix these errors prior to ordering.The errors will always fall into one of the situations below and we’re happy to help you straighten them out:
Is the item set up in Report 21? Only items set up here will appear in the Order Generation Tool (and in your reporting).
Is the item listed and active in Report 53 - Market Availability? If not, you will need to submit a new MP/531 file that lists the item with the correct ordering status.
Is the item set up in the pack type you are attempting to order - Report 107? If not, you will need to add the item to the pack type used for ordering.
Is the item available in the warehouse that you are ordering from - Report 141? If not, you will need to add the item to the available inventory at the warehouse.
Is the item set up on an active store exception (meaning that at some point you did not want to order it) - Report 129. If it is, you will need to remove the exception for the item.
We recommend that you check for errors every time you start an order. Nothing is more frustrating than spending time on an order only to discover that there are items you cannot order due to maintenance issues.
If you have questions about this feature, or want to see a demonstration of how it can help you, you can send an email to Support@avantalytics.com, and we'll be happy to help you!