Import a line planAll guides
Import your line plan into Tr3e
Already planned the season in a spreadsheet? Give Tr3e the file. It reads every product, colour, size and price, shows you what it found, and saves only the products you approve.
Where to start
| From | Choose |
|---|---|
| A collection | Add product → Import a line plan. An empty collection also shows Import a line plan in its list. |
| Setup, in a new Workspace | Its products → Import a line plan |
| Ask Tree, while it sets you up | Import a line plan on the Add products card |
The products go into that collection. In setup, that's your newest collection.
Which files work
An Excel file (.xlsx), a CSV, a PDF, or a picture of the plan (PNG, JPEG or WebP), up to 20 MB. Any layout works: the columns can be in any order or language, and one tab can hold several blocks.
Working in Numbers? Save the plan as an Excel file first, then pick that one.
Tr3e keeps the file only to read it. It isn't added to the Library's Files, and it's deleted once it has been read.
Read the file
Drop the file in, or choose it. Reading takes a minute or two, so keep the window open while it runs. Stop reading asks before it stops, since reading again starts from the beginning.
Check what Tr3e found
The top line counts the products and their variants, and how many are ready, need a fix or are skipped. Check how Tree read this file shows how the file was understood as a whole, such as which tab it read and which column it took as the WSP.
Each product is one row. Click it to see its colours, sizes, Target Price, WSP, RRP and where it sits in the file.
| A product that | Shows | Gets imported |
|---|---|---|
| Is ready | A ticked box. One already in the collection says Updates and its name. | Yes, unless you untick it |
| Needs a fix | Needs a fix and why, such as a WSP that isn't a number | No. Fix it in the file and import it again. |
| The file itself cancels | Skipped | No |
Not imported lists what the file holds that isn't a product, such as budgets, totals and targets. Click one to see the file's own words and why it was left out.
Import
Choose Import 23 products (the button counts the ticked ones). A message says how many were imported, with a link to the collection. If some couldn't be saved, the window stays open and says which and why. The rest are saved.
Closed the window before importing? Import a line plan opens the same review again without reading the file twice, until you import, choose Use another file or reload the page.
What comes in
Each product's name, style number, category, colours, sizes, Target Price, WSP, RRP and notes, and each size's SKU, barcode and planned units. A category the collection doesn't have yet is created.
Materials, components, companies, purchase orders and dates stay out. So do prices in another currency than your Workspace's, and the review tells you when that happens.
Import the same file again
Changed the plan? Import it again. Tr3e updates the products it already has instead of copying them, matching each by its style number, or by its name when it has none. A product gains the file's new colours, sizes and prices and keeps everything else. Nothing is removed.
Good to know
Reading a file counts towards the Workspace's daily AI allowance, the same one Ask Tree uses. A file takes only a small part of it.
Owners, admins and members can import a line plan. Viewers can't.
Next
Stuck on something? Book a 15-minute support call. Pick the topic when you book and we come ready.
Book a support callEmail us