Bulk Link Cases / Cans links case items to their single-unit (can) items from one spreadsheet, so you no longer edit each item one at a time. It is available in FieldStack version 12.2026.1023 and later.
Before you start
You need permission to edit items to save links. Anyone can open the screen and preview a file, but only users with item admin rights can apply the links.
Both the case item and the can item must already exist in FieldStack. This screen links items; it does not create new ones.
Prepare an Excel file (.xlsx) with these three columns:
Column | What to enter | Example |
|---|---|---|
Case UPC | The UPC of the full case | 012345678905 |
Can UPC | The UPC of one single unit inside the case | 012345678912 |
Units Per Case | How many units are in one case (optional) | 24 |
Open the screen
Go to the Options tab and click Bulk Link Cases/Cans in the Catalog Management group.
Or search for it from any tab:
- In FieldStack, click the Search Ribbon Items box at the top of the window.
- Type case.
- Under Catalog Management, click Bulk Link Cases/Cans.
The screen opens in a new tab called Bulk Link Cases / Cans.
Link your items
- Click Choose File and select your Excel file.
- Review the preview. Each row shows the UPCs from your file, the matching Case Item and Can Item names, and a Result. Nothing is saved yet.
- Fix any rows marked in red. You can correct a UPC or units value directly in the grid.
- Click Apply Links to save.
- To confirm, open the case item or the can item in Item Edit. The link shows on both items.
Reading the Result column
Result | What it means | What to do |
|---|---|---|
Ready | Both items were found and the row will be linked | Nothing |
Case UPC not found | No item in FieldStack has that case UPC | Check the UPC, or add the case item first |
Can UPC not found | No item in FieldStack has that can UPC | Check the UPC, or add the can item first |
A case cannot contain itself | The same UPC is in both columns | Correct one of the two UPCs |
Good to know
- Blank Units Per Case keeps the quantity the case item already has. It does not reset it to 0.
- Linked cases break automatically. Each linked case is set to break into its units when needed, for example at the register or in receiving.
- Re-running a file is safe. Loading the same file again re-links the same items with no duplicates.
- No permission? Clicking Apply Links shows "You do not have permission to link items." and nothing is saved.
- You need to be online. Offline, the file loads but the preview and Apply Links need a connection.
- Wrong columns? If the file is missing the Case UPC or Can UPC column, the screen tells you which columns are required.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article