Export
- Expand Files on left navigation bar of Logicbroker
- Select Advanced Export
- In Profile section, select the profile OrderExportForShipment from the dropdown menu
- In Document Filter section, change Start Date and End Date to preferred date range
- In Output Format section, select XLSX format
- Click DOWNLOAD
The OrderExportForShipment filter defaults to include all order statuses less than 600. The status code 600 is “Ready to Invoice”, so this default filter will include all orders that have not fully shipped yet. This will allow you see all orders available to ship. Once the file is exported, you can remove the line items that did not ship.
Here’s a list of the main Status Codes. These codes are also available in Logicbroker Help Center.
- New = 0
- Submitted = 100
- Ready to Acknowledge = 150
- Acknowledged = 200
- Ready to Ship = 500
- Ready to Invoice = 600
- Complete = 1000
- Cancelled = 1100
Update the File
- Open the downloaded file
- Expand columns to be able to read all headers
- PartnerPO (column A) = our PO number
- ShipmentNumber (column B) = our PO number
- ShipmentDate (column C) = The date of shipment
- Must be formatted as YYYY-MM-DD in text
Hint: Format column as text first before adding dates
- Must be formatted as YYYY-MM-DD in text
- LineNumber (column D) = Order Line Number on PO
- Must be formatted as number
- ItemIdentifier.SupplierSKU (column E) = Model Number
- ItemIdentifier.PartnerSKU (column F) = Partner Sku
- ShipmentInfo.Qty (column G) = qty on PO
- Must be formmated as number
- Adjust the qty in this column to reflect the numbers of items shipped. If you are not shipping this item, then remove the line item from the spreadsheet (do not adjust qty to 0)
- ShipmentInfo.TrackingNumber (column H) = Enter the Tracking Number here. (See notes below on how to format tracking)
- ShipmentInfo.ClassCode (column I) = Ship Method (this is auto populated)
- Fill in the dimensions of the box/pallet under ShipmentInfo.Height (column J), ShipmentLine.ShipmentInfo.Width (column K), ShipmentLine.ShipmentInfo.Length (column L) and the unit of measurement in ShipmentLine.ShipmentInfo.DimensionUnit (column M).
- Since the items have already shipped, the actual dimensions are not required. These columns (columns J-L) can be filled out with the number 1 (needs be formatted as number)
- The unit of measurement (column M) needs to be text (Ex: in).
- Enter the weight of the box/pallet under ShipmentLine.ShipmentInfo.Weight (column N) and the unit of measurement under ShipmentLine.ShipmentInfo.WeightUnit (column O)
- The weight (column N) does not have to be the actual weight - this can be filled out with the number 1 (needs to be formatted as number)
- The unit of measuremnt (column O) needs to be formatted as text (Ex: lb)
- ShipmentInfo.ContainerType (column P) - Enter in the word Box (needs to be formatted as text)
- Columns Q-Y will be autopopulated with the customers ship to information.
- Enter in your shipping address under columns Z-AF.
- Save file
How to Format Tracking Numbers
The examples below can also be found on BBQGuys Expectations
- FedEx tracking numbers should have a series of 12-20 digits. There are no letters or any special characters with FedEx Small Parcel tracking numbers.
- R&L Carrier tracking numbers should have a capital I (“eye”) followed by 9 digits. There should be no spaces, dashes, or other special characters.
- How R&L Tracking should be entered:
- I241985862
- Examples of how R&L Tracking should not be entered:
- I24198586-2
- #24198586-2
- 241985862
- 24198586-2
- How R&L Tracking should be entered:
- Estes Freight tracking numbers have 10 digits with no spaces, dashes, or other special characters.
- How Estes Tracking should be entered:
- 1540359760
- Example of how Estes Tracking should not be entered:
- 154-03597
- How Estes Tracking should be entered:
Import
- Expand Files on left navigation bar of Logicbroker
- Select Advanced Import
- Select Shipments
- Click CONTINUE
- Drag file into box or choose file name
- Click CONTINUE
- Click CONTINUE through the Map Columns and Validate Screens
- Once completed, you’ll receive confirmation of the shipping documents created
Alternate File Export Options
- From the search bar at the top right, enter the model number or Purchase Order numbers that you need to update.
- If you search the model number, narrow your search further by clicking on the Status you want (“Ready to Ship”). To search multiple numbers at once, enter a Pipe (vertical bar) “ | ” between each model number.
- To search multiple purchase orders at once, enter a Pipe (vertical bar) “ | ” between each PO number
- Check the boxes on the left to select the orders
- Select Export in the top action bar
- Select OrderExportForShipment under the Export profile
- Select XLSX as the File type
- Click DOWNLOAD
- Follow the above Update File and Import steps
