Making a Batch Item Update

We've enhanced this functionality! To learn more, see Batch-Updating Items. In the coming weeks, the classic Batch Item Update page will be removed from 3PL Warehouse Manager.

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 process extracts data from the items that have been entered into the system, allows you to make changes to the items through a spreadsheet, and then places the file back into the system to apply the modified settings.

This article reviews how to perform a batch item update in detail.

To update items, you must have the following permission assigned to your user role: Customer Module > Customer Items > Import Item Definitions.

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

Skip Ahead: Use the following links to skip to the relevant guidelines below.

• Step 1: Export items
• Step 2: Update items
• Step 3: Import 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.

 Please note that larger exports can sometimes cause timeouts. If a timeout occurs while exporting, we recommend doing minor edits manually. If you need to make larger edits, please contact 3PL Central Support for assistance.

1. Navigate to Items > Batch Item Update, then select the relevant customer and warehouse from the respective drop-down menus.
   
2. Click Export Master. Once the exported file downloads, open the file and continue to the next section for more details.

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

If you need additional information on any of the mapped fields mentioned below, please refer to our help articles on Creating Items.

Because items are defined by the SKU, a Batch Item Update writes over everything except the SKU—it reads over what has already been entered into the system and only updates items that were previously in 3PL Warehouse Manager. If you add new items or delete any items in the spreadsheet, the system ignores those values.

1. Change the values for each column that needs updating for each SKU. Use the table below for guidance.

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 changes and saved your file, it's time to import.

1. Return to the Batch Item Update page in 3PL Warehouse Manager.
2. Click Browse, doube-click the updated file, then click Import Items.
   
3. A preview of the imported data appears in the bottom text boxes. Once you've verified the data for accuracy, click Update Items to finalize the import.

The items are now updated in 3PL Warehouse Manager and available for viewing or additional editing under Items > Manage Items.

Back to top