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
- Export your item list as CSV or Excel, with every column you have. Columns you don't use are ignored; nothing is lost.
- From Business Central or QuickBooks Online? AvklarePlan recognises these exports and fills in the mapping for you:
- Business Central: the Items list, exported with Open in Excel. Only items of type Inventory are loaded; services and non-inventory items are skipped. Vendor No. becomes the Vendor grouping, and Item Category Code the Category grouping if you've added that column to the list.
- QuickBooks Online: Products and Services, exported to Excel. Only Inventory items are loaded. QuickBooks has no unit of measure, so items are counted in each.
- Check the units. Each item is planned in its own unit (case, keg, each). If you plan in a common unit such as case equivalents, the file needs a factor or an ounces column (see Equivalent units).
Steps
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.
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.
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.
If items were rejected, read Rejected rows, fix the mapping, and click Validate again.
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.
Optional: click Save mapping and give it a name, so next time you can choose it and click Apply saved mapping.
Common mistakes
- "Item … has no name." The Name column is blank for that item. If your file has a second description column, map it as Name if empty; then only items with neither are rejected.
- The same column as Name and Name if empty. They must be different columns; the second is only a fallback.
- Items with 0 ounces or a 0 factor. That's read as "no equivalent": the item is kept and planned in its own unit, which suits glassware, tap handles and merchandise.
- Cells reading NULL. Exports straight from a database often write NULL for an empty value. AvklarePlan reads it as empty, so it never becomes a group called "NULL".
- "This file's rows were deleted…". AvklarePlan keeps an uploaded file's rows for 7 days after it is loaded, or after upload if it never is. To validate or load it after that, upload it again.