Receiving Containers with a Spreadsheet Upload

This article outlines how to receive Containers via an excel upload sheet directly in cieTrade.net. This is the recommended method if you have a Supplier packing list with the container details that you can copy and paste from directly. 

Before you start these steps, you will need:

-  An open Booking

- A Purchase Order

- Container numbers, seal numbers, and weights

1. Go to the Containers tab on the left-hand menu.

2. Click Tasks> Import Container.

3. Select the Supplier, Purchase Order, and Booking Number.

NOTE: Once the Supplier & Purchase Order is Selected, only the contracted grade will pull through to the container import.

4. If you have a single Product, it will populate in the Product drop-down. If you have multiple products, you can toggle between them on the Product drop down as you enter them. 

NOTE: the VGM will automatically calculate based on the Net Weight and EQ Tare Wt. 

NOTE: Check the box "Apply Budgeted Items" if you would like to apply the budgets from the PO to these containers.

5. Once you have copied and pasted the columns, click Import Data. This will create one new Receiving Worksheet per upload, with each container as a separate line item on the Receiving Worksheet. If you need to upload photos, print documents, or pay expenses, you can go directly to the Worksheet. 

NOTE: The weight fields will only allow numbers. If you have any punctuation like commas or periods they will have to be removed in order to upload successfully.

NOTE: You will not be able to copy and paste in data using the right click option on your computer mouse.  In order to paste in container details, click within a data field and EITHER select the paste icon on the top of the inquiry, OR use CTRL V on your keyboard.

6. You can access this Worksheet either from the  Container Manager or from Inventory> Receiving Inquiry. 

If you have additional questions, please contact the Support Team via email to  support@cietrade.net.