Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article states the best practice on how to import multiple Shipping Units at once.

Note

Adding multiple shipping units to OneFlo requires the account manager to raise a case to IT Service desk team and can take some time. Please consider whether or not these need to be loaded in bulk or can be done manually.
Bulk Uploads completed by IT are considered on a case by case basis. Minimum number of Shipping Units for IT to upload into OneFlo - 40 
Minimum number for Bulk Import - 40 

  • This is because Bulk Uploads require a custom SQL script to be validated, written and tested internally. Then executed by our developers who must stop existing development to implement into the production database.

    • This is not an automated process that IT just 'run' and can take up to 40 minutes of total IT time.

    • In addition, this process is considered to be high risk. Incorrect implementation(Code/Syntax errors) can bring down ChainIT and OneFlo for all customers and carriers 

      • In no other SAS business would this be even considered as a offered IT service due to the potential for error

 We only offer this is to assist with unmanageable levels of User/Item/DG creation/updates. (multiple hours worth)

This is because it is only at this stage the value add of bulk import is comparable to the cost efm IT and the risk to efm as a whole. 

Instructions

  1. Use attached spreadsheet for best format.

  2. Send excel spreadsheet to account manager for approval and review

  3. Account manager to send reviewed spreadsheet to IT Support to bulk upload

Template

View file
nameShippingUnitTemplate.xlsx

Requirements

Field Name

Example

ChainIT

AM to Provide

Search Code

PLT123

Name

Pallet

Length (cm)

120

Width (cm)

120

Height (cm)

150

Weight (kg)

200

Volume (m3)

2.16

Packaging Type

PLT