Blog from January, 2022

A really helpful feature in our order generation tool is the ability to set up custom store attributes. By utilizing this you can easily add custom data to your order results to allow filtering of stores based on common user-specific values such as: rank, sales rep, corral, or any other attribute that might be important to you. 

Features:

  • Link stores with up to 5 unique attributes (ABC Rank, Hardiness, Size, etc.)

  • Appears as a column in order generation tool output

  • User-specific (not shared)

  • Easy Excel upload - just format the data in Excel with the store number as the first column (like a vlookup) and paste it into the system

You can then run any templates and get this data infused into the output. They’re custom to you and you can change the values or criteria as often as you like.

If you would like to learn more about this feature, you can send a request to Support@avantalytics.com.


Many customers have asked that we add category inventory to the order generation tool to allow them to better manage store-level inventories. We are excited to announce that we have added this feature along with 2 additional features showing warehouse inventory information!

The new Category OH column shows the current category inventory in a location. This shows you have much inventory of each product category is on hand in this location, so you can adjust your orders to keep the proper amount of category inventory in that location.

We have also added 2 new columns to the Order Template:

Warehouse On Hand (WH)

Warehouse Comments 

The WH OH column shows the remaining inventory inline in the order results. It updates as users add or subtract order units. As the WH amount gets near zero, the field will turn yellow, and then red when all the inventory is consumed. Now you can always see exactly how much inventory you have in the warehouse.

The WH Comments column allows inventory comments from production to be integrated and viewed along with the on hand quantities while ordering an item, to help with ordering. For customers who manage the warehouse inventory availability manually, it can be integrated with this standard upload in the website. For automated inventory availability feeds, it can be populated automatically.

You can add these new columns to your order templates by selecting them in the Order Preferences section of the Order Generation tool.