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 - 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 ...

• 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 ...

• Quick Installation Guide for Audit Master

  Release Date: 09/12/2018 Introduction Audit Master is an invaluable tool to diagnose problems with Elliott Business Software -- the types of problems that can happen due to users' mistakes or Elliott software bugs. While Elliott does provide auditing ...

• IMCHGBIN Inventory Management Change Bin No/Pick Seq

  Change Bin No/Pick Seq Application Overview The Change Bin No/Pick Seq application allows the user to quickly and easily change the Bin Number/Picking Sequence field in the Item File. This corresponds to field 19 in Item Maintenance. Run Instructions ...

• Installation of ElliottService, NETcellent’s Web Services for Elliott

  Installation to New Server 1. Server Location: Decide if you are going to install the web services on the same machine running Elliott, or a separate server on your network. The machine must reside on your network. 2. Set Up Server: If your ...