When should I use an item link?
- A product is being replaced. Customers will buy the new model instead of the old one. Use Replacement to move the relevant demand to the new item.
- A new product needs a starting point. An existing equivalent item is a useful guide, and you will continue selling it too. Use Reference to plan the new item from that demand without taking it away from the existing product.
Choose Replacement or Reference
In the link form, Source is the item demand comes from. Target is the item demand goes to.
For example, 100% Replacement moves all of the old item’s demand to the
new item. 50% Replacement moves half and leaves half with the old item,
which can help when demand is expected to split during a transition.
With 50% Reference, the new item uses half of the reference item’s demand
as its planning history. The reference item still keeps all of its demand.
Review this choice as the new product develops its own sales pattern.
Link items with the same unit of measure. The percentage controls how much
demand to use; it does not convert packs into individual units.
Create a link
If Item Links is missing from your sidebar, ask your Lantern admin to add the page to your account.1
Choose the two items
Open Item Links and select Add Link. Search for the Source
item with the useful history, then the Target item you want to plan.
For a replacement, the old item is the source and the new item is the target.
2
Choose where the link applies
Use All locations for a product relationship that applies throughout
your business. Use Specific locations to choose the Source location
and Target location for a local change.A location-specific link takes priority over all-location links for the
same source item at that source location.
3
Choose the relationship and percentage
Select Replacement or Reference, then enter Percentage moved
or Percentage copied. Use 100% for the full demand or a smaller
percentage for a share. If one source has several replacements, their
combined percentage cannot exceed 100%.
4
Record why you are linking the items
Choose Permanent or End date under Duration. Enter a Link
reason that another buyer will understand, such as the model transition
or why this product is a useful reference.
5
Review and create
Check the items, locations, direction, and percentage in Live Preview.
Resolve any message about an incompatible or conflicting link, then select
Create link.
Import links from a file
Use a CSV or Excel file when you have many links to add or update together, such as a product line moving to new item numbers. Drop the file on the Item Links table, or on the empty page before you have any links. See file imports for matching columns, checking the result, and correcting failed rows.
Each row adds a link, or updates the active link with the same source item and
location and target item and location. Both items must exist in Lantern with
the same unit of measure.
Lantern checks the whole file against your existing links, using the same rules
as Add Link. A source item’s Replacement links from one source location,
including the ones already in Lantern, cannot move more than 100% of its demand
in total. If rows would take a source over 100%, those rows fail and the rest of
the file still applies. Lower or remove an existing link first when you want to
move that share to a new target.
To change many existing links, select Export, edit the rows you want to
change, and import the workbook. Before exporting, make sure Source
Location, Target Location, Relationship, Weight, Reason, and
Expiration are visible, because the export includes only visible columns. Delete rows for
expired links, which fail because their date has passed.
A row that matches an existing link exactly changes nothing, though it is
counted as Updated, so re-uploading an unedited export leaves your links
as they are.
Links from your ERP
Links imported from your ERP show ERP as their Origin. In a file:- A row that matches an ERP link exactly leaves it as an ERP link.
-
A new or changed row replaces these ERP links from its source item, as
Add Link does:
- the ERP link between the same two items and locations;
- for a Replacement, the source’s other ERP Replacement links at that source location;
- when the row’s source location is all locations (the default), every location-specific ERP link from that source item, including References.
- To keep one of those other ERP links, include its row unchanged in the same file. Lantern keeps it as a manual link with the changed row’s reason.