AvklarePlan Help Sign in Start a free trial

Help ›

Import your items

Load your item list into AvklarePlan from your own system's export: one row per item, with its number, name, unit and the groupings you plan by (supplier, brand, package and so on). Sales and plans can only use items AvklarePlan knows, so import items first, and again whenever new items appear.

You need to be an Owner or Admin of the workspace to import.

Before you start

Steps

  1. Open Imports, set The file contains to Items, choose your file and click Upload.

    You should see the file's page: its columns, a few sample values from each, and a guessed mapping. For a recognised export, a message names the layout, such as Business Central items, and the mapping is already filled in: check it in step 2 rather than set it up.

  2. Under Columns, check what each column is used as:

    • Item key: the item number your sales file also uses.
    • Name: the item's description.
    • Name if empty, optional: a second description to use when Name is blank, for example a short description beside a long one.
    • Unit of measure: the unit the item is sold in.
    • Dimension: each grouping you plan by, with the name to show for it (Supplier, Brand, Package). A status column (Active, Discontinued) is worth mapping too: the grid can then hide inactive items (see Filter the plan grid).
    • Equivalent factor or Ounces per unit, optional: for planning in a common unit.
    • Price and Cost, optional but recommended: the price and cost you plan with, list prices or landed prices after discounts and promotions, your choice. Any column name works. If your file has several price or cost columns, map one of each and set the others to Ignore. New plans can start from these, or from last year's sales (see Create a plan).

    Set every other column to Ignore.

  3. Click Validate. Validating checks every row and changes nothing.

    You should see how many items are ready to load, rejected and skipped, with the reasons.

  4. If items were rejected, read Rejected rows, fix the mapping, and click Validate again.

  5. Click Load into AvklarePlan.

    You should see a message with the number of items added and updated. An item already in AvklarePlan is updated, so importing the same list again is safe. New items also join every working plan, at zero, with this file's price and cost; the message names the plans, for example 2 added to "FY2027 plan". To give them volume, see Start new items in a plan.

  6. Optional: click Save mapping and give it a name, so next time you can choose it and click Apply saved mapping.

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙