A batch item update allows you to make changes to existing items, including edits to recurring storage rates, UOM, dimensions, billing, track-by's, and more. This article reviews how to perform a batch item update using the new and improved experience from the Manage Items page.

Qualifiers are not supported in batch item updates. If you need to make changes to an SKU's qualifier, please manually do so under Items > Manage Items.

Guidelines

First, navigate to Items > Manage Items in 3PL Warehouse Manager, then select a customer from the drop-down menu.

There are three options within the Manage menu that are used for batch item updates: Export All, Export Selected, and Update Items. Each of these is further detailed below.

• Export All: Allows you to export all items for a customer, regardless of the grid selection
• Export Selected: Allows you to export only items selected from the grid
• Update Items: Allows you to import item updates, regardless of the grid selection

Once you're familiar with each of these options, use the following steps to update your items.

Step 1: Export items

The first step in performing a batch item update is exporting a master file of your configured items so that you can make changes using this file.

1. Decide whether you need to update all items.
   • If you need to update all items, select Manage > Export All.
   • If you do not need to update all items, select the relevant items from the grid (using < Ctrl > or < Shift > to multi-select), then select Manage > Export Selected.
2. Select whether you wish to Include inactive items, then click Export to download the item information.
3. Once the exported file downloads, open the file and continue to the next section below.

Step 2: Update items

Once you export your items and format the text as needed in Excel, you can update your items. Each available column is detailed in the table below, including where the associated field is located in an item's setup via Items > Manage Items.

Please note that most of these fields are alphanumeric and do not accept special characters. Dashes are accepted and commonly used for SKU, UPC, and Description values—however, we do not support carats, commas, or pound signs.

1. Update each column value for each SKU as needed. Use the table below for guidance.

*For Column BL, please use the following format:
Warehouse Name:BillingUOM:#ofUnits:SplitPeriodFullRate:SplitPeriodHalfRate:FreeDays:
ReceivingHandlingRate:ShippingHandlingRate|RepeatSameFormatForAdditionalWarehouses
(e.g., Central Warehouse:CuFt:5:1:1:0:0:0|3PL Warehouse:Each:10:2:2:0:2:2)

2. After you make the necessary changes to your items, click File > Save a Copy (or Save as).

3. Enter a new name for the file and select a recognizable location on your device so you can easily recognize the updated version, select the format as Text (Tab delimited), then click Save.

Step 3: Import items

Now that you've made your changed and saved your file, it's time to import.

1. Return to the Manage Items page in 3PL Warehouse Manager, then select Manage > Update Items.
2. Click Select Import File (txt), then double-click the file on your device.
   

   The 'Download Current SKU List' button is an alternate way to export all items.

    
3. All changes populate in the Expected Data Changes container. Verify that these are accurate, then click Confirm to update your items and receive a confirmation message.