Skip to main content
All CollectionsGetting Started
Bulk Committing Inventory to Sales Orders
Bulk Committing Inventory to Sales Orders
Mike Banting avatar
Written by Mike Banting
Updated over a month ago

WholeCell's bulk commit page allows you to:

  • Fulfill multiple sales orders from one page by scanning the Order ID or Transaction Number and then scanning IMEIs to fulfill the order.

  • Upload a spreadsheet to commit hundreds of IMEIs to one or multiple sales orders

To commit inventory in bulk, click on 'Sales Orders' on the left menu, then click on the 'Bulk Commit' button above the table.

From this page you can either scan orders and inventory items, or upload a spreadsheet:

Method 1 - Scan items:

On the next page, scan or type the sales order number or the sales order transaction number (if you have one on the sales order). Once you hit 'enter' WholeCell will pull up some basic information about that sales order:

Now you can simply scan all the items that you want to commit to that order. Once complete, scan your next order.

Note: If you have enabled the ShipStation integration and are sending order items (not committed inventory) from WholeCell to Shipstation, you can use ShipStation's packing slips to scan the order number barcode into the Scan Order field on the Bulk Commit page in WholeCell.

(To enable the ShipStation integration, check out this article: Syncing with ShipStation.)

Method 2 - Spreadsheet upload:

Upload a spreadsheet that has only the essential information to commit to the order. Click on the 'Upload Spreadsheet' button in the upper right corner of the page.

A window will pop up where you can drop or browse files to select the spreadsheet. The window shows the instructions on what data to put on the spreadsheet.

Your spreadsheet should have four headers: Order ID, Transaction Number, Hex ID, and ESN. You need to have a value under the Order ID or Transaction Number column (so WholeCell knows which order); you don't need to put values on both columns. You need to have a value under the HEX ID or the ESN column; you don't need to put values on both columns.

Save the file as a .csv file or a .xlsx file and upload it on the 'Upload Spreadsheet' window.

If you have a number of sales orders that you want to commit to, you can put all of them on the spreadsheet, as well as the ESNs or HEX IDs that you want to go to for those respective orders. See the sample below:

After uploading the spreadsheet, hit 'Save' at the bottom.

Note: Errors that you may encounter when bulk committing:

  • The ESN/ID is not in WholeCell or is incorrect

  • The item(s) are sold

  • The sales order indicated is incorrect or not present in WholeCell

Note: The spreadsheet upload method does not use the Direct Commit functionality. As a result, if the committed item does not match any existing order items, a new row will be added to the sales order, creating a new order item with the committed item.

Did this answer your question?