Exporting Goods-out Notes

Goods-out notes can be exported one-by-one as a CSV file.

There is currently no way to export batches of goods-out notes as a CSV file.

Note that if you are sending goods-out notes to your 3PL company they can be sent in batches via email.

Goods-out note CSV columns

The exported file doesn't contain column headers, so here is a list of what will be exported:

Download sample file

 ColumnDescription
A OrderID This is the sales order number
B Goods-out note ID This is a Brightpearl reference for the goods-out note
C Shipping method ID This is a Brightpearl reference for the shipping method
D Shipping method code This is the code for the shipping method, used for adding to templates
E Shipping method name This is the name of the shipping method on the order
F Created by This is a Brightpearl reference for the staff member
G Created on This is the date the goods-out note was created
H Order status ID This is a Brightpearl reference to the order status
I Order status name This is the status of the order
J Customer ID This is a Brightpearl reference for the customer who made the order
K Customer name The name of the customer who made the order
L Customer company The company name from the order record
M Customer email address The email address from the order record
N Customer telephone The telephone number from the order record
O Delivery name The delivery name from the order record
P Delivery street The delivery street from the order record
Q Delivery suburb The delivery suburb from the order record
R Delivery city The delivery city from the order record
S Delivery state The delivery state from the order record
T Delivery postcode The delivery postcode from the order record
U Delivery country The delivery country from the order record
V Delivery email The delivery email from the order record
W Delivery telephone The delivery telephone from the order record
X Goods-out note sequence When using split/partial fulfilment it is possible to create multiple goods-out notes where some items are shipped later
Y Warehouse ID This is a Brightpearl reference for the warehouse from which the stock is being taken
Z Warehouse name This is the name of the warehouse from where the stock is being taken
AA Product ID This is the Brightpearl reference for the product
AB Product name This is the product name
AC Product SKU This is the product SKU
AD Quantity to ship now This is the quantity of the product being shipped on this goods-out note
AE Total quantity This is the total quantity ordered on the same order ID
AF Total weight This is the total weight of the product being delivered, calculated by the weight of an individual item on the product record multiplied by the quantity to be shipped now
AG Quantity to follow This is the quantity that will follow in another delivery
AH Stocked tracked item This identifies whether the item is a stock-tracked product or not; 0 = no, 1 = yes
AI Product options This field lists out the product options. Each option value is separated by /
Note: Further variants of a product will be listed on separate lines
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.