Skip to main content

Updating Distribution in Your Forecast

How to update expected distribution for existing SKUs within a Planning Group in your forecast

M
Written by Max McLaughlin
Updated over 3 weeks ago

If you are looking to add a new SKU to a Planning Group, see guide here.

If you are looking to leverage Confido Forecast Recommendations, see guide here.

There are three options for updating expected distribution changes for existing products within a given planning group: Directly in the forecast, Via the Update Distribution Quick Action, or using the Bulk Update feature

How to Update Distribution via Quick Actions:

  1. Navigate to the Home page in Confido via the left-hand navigation bar

  2. Click on the Update Distribution quick action button

  3. Input the required key information into the pop-up window, including

    1. Retailer (based on your Planning Groups in Confido)

    2. Product(s) that you are expecting a change on distribution for at the selected Retailer

    3. Number of Stores that you now expect to carry the product

    4. Effective date (when will the change in distribution take place)

  4. After inputting all information, Confido will show you a draft view of the proposed changes to allow you to review before saving

    Screen Recording 2025-08-15 at 9.15.17 AM.mov [video-to-gif output image]
  5. After reviewing, click Update Stores and the changes will be automatically implemented in your Confido forecast

How to Update Distribution Directly in the Forecast:

  1. Within your forecast, navigate to the specific Retailer and drill down to the forecast drivers for the product you want to update

  2. Click on the Stores field in the week that you expect distribution to change and input the new store count

  3. After entering the new store count, the Apply Change Through window will appear. You can choose Apply to All to update the store count for all future weeks after the one you are adjusting, or use the dropdown to select a specific week through which the change will apply

  4. Click Accept to apply the changes

How to Make Bulk Updates to Distribution in the Forecast:

Caution: Making bulk updates is not often recommended as Product velocities/store counts can often differ within or across Planning Groups. Only leverage this feature if your confident changes will be aligned across the dimensions you select (i.e., a full product family is getting into the same number of stores at a retailer).

  1. Click on the Bulk Update button above the forecast

    Screen Recording 2025-08-15 at 10.04.58 AM.mov [video-to-gif output image]
  2. Input the Filter Rows you want to bulk update, which should include:

    1. Product Matching Type: Do you want to bulk update by product name, product family, or product attribute?

    2. Products that you want to update based on the Matching Type selected

    3. Customer Matching Type: Do you want to update by Planning Group, Global Customer, or Planning Group Attribute?

    4. Planning Groups you want to update based on the Matching Type selected

  3. Input the Update Settings, which should include:

    1. Effective Date (the date the changes will take effect in the forecast)

    2. Update Stores: Select the check box and input the new number of stores (this will apply to all products/planning groups selected)

      1. You can also update Base Velocities via this menu

  4. Update Impact

    1. An Update Impact window will appear after all information is inputted

    2. Confido will provide a view of the projected unit impact based on the changes outlined

    3. To apply the changes, select the box next to the rows you want to accept and click the Apply button in the bottom right

      Screen Recording 2025-08-15 at 10.44.46 AM.mov [video-to-gif output image]
Did this answer your question?