How to Mass Update Item Master's Bin No/Pick Sequence

Release Date: 08/06/2020

Version: 8.0 & up

Q - I need to change bin#/pick sequence on all inventory items. What is the best method to export, then import back in after changes are made in Excel.

A - The best way to accomplish it is to go to I/M -> Utility -> Change Existing Item Import. Create a CSV file with the following layout:

n this case, you just need data in column A (Item No) and Column Q (Bin#/Pick Seq). Leave all other columns in your CSV blank, which means "do not change."  Then perform the import. You should do a “Pre-Interface” to make sure there’s no error before you do the actual interface. Have a backup of your <ElliottRoot>\DATA\IMITMFIL.BTR file first before you start mass changes. Do it at time when no users are in the system to avoid update locking conflicts. Import and update a few items first before you update all items. It’s important to be always on the safe side.

You can create the initial CSV file by using Elliott’s “Export Processor.” If you have other tools that can access Elliott’s data, that will be fine too.  

EMK

• Related Articles

• Feature - Pick Ticket Printing Supports Bin Records in Delimited File Format Exports

  Release Date: 4/12/2024 Version: 8.5 and Up Background This feature is a continuous running update to the 3rd Party Logistic Warehouse Management System. For more details on the main article, click here. Pick ticket printing is a critical feature in ...

• Feature - Mass Billing by CSV Multi-Bin Support

  Release Date: 5/28/24 Version: 8.5 and Above Currently when a user chooses COP -> Billing Selection -> Mass-billing -> by CSV File and the multi-bin enhancement is enabled, the user will receive the error message "Multi-bin is not supported with this ...

• Dynamically Set Primary Bins

  Q: What does the new Multi-Bin Global Setup Option 34. Update Item/Inventory Location Primary Bin do? A: This option allows the user to choose if a receipt or issue of inventory from a bin will cause the item to have a new primary stocking bin. If ...

• Can the 'Design Your Own Picking Ticket' Feature Print in Pick Sequence?

  Q - I use the Design Your Own (DYO) Picking Ticket feature because I need the pick ticket format to be different from the standard pick ticket layout. When I print the DYO Pick Ticket, it always prints by the line item sequence order instead of the ...

• Feature - Support Bill Of Lading Shipping Label by Item Sequence

  Article Transfer Tracker Article Transfer Tracker 100% C658 Release Date - 2/15/19 In the past, when you tried to print shipping labels (UCC-128) from the Bill of Lading Maintenance application, the system printed the labels order by order for the ...