Important Order Fields



Order ID

An orders  ID is its unique identifier. No matter what status an order is in, its ID will remain the same. For example if an order starts out as a quote and is changed to an order, it’s order ID will remain the same throughout. You cannot edit the ID of an order.

Popular Order Fields

The fields listed below are popular fields that are typically populated when importing an order or when adding an order through the user interface. In addition to these fields you will find a list of other fields available in the order database at the end of this document.

 

Field Name

Field Type

Field Description

Field Restrictions

Example Input

Order ID

Text

The Order ID. If not defined, an Order ID will be automatically generated when importing order data.

Max Length: 15

ABC1234567

Order Status

Text

Order order status the order will be imported as. Options: Quote, New, Pick, Pack, Dispatched, On Hold, Cancelled.

Order Status Name (eg: New, Pick, Pack etc)

New

Approved

Boolean

Only approved orders can be shipped. Set this to "Yes" to approve an order on import.

Yes | No

Yes

Username

Text

The username of the orders related customer in Neto. Username is the unique identifier of the customer in Neto.

Max Length: 25

sample

Email

Text

The email address of the order (order receipts etc sent here).

Max Length: 50

johnsmith@neto.com.au

Ship First Name

Text

Shipping first name.

Max Length: 50

John

Ship Last Name

Text

Shipping last name.

Max Length: 50

Smith

Ship Company

Text

Shipping company name.

Max Length: 50

Acme Co Pty Ltd

Ship Address Line 1

Text

Shipping address Line 1

Max Length: 50

Unit 10

Ship Address Line 2

Text

Shipping address line 2

Max Length: 50

12 Lilly Street

Ship City

Text

Shipping city or suburb

Max Length: 50

Capalaba

Ship State

Text

Shipping state

Max Length: 50

QLD

Ship Post Code

Text

Shipping post code

Max Length: 15

4157

Ship Country

Text

Shipping country code (eg: AU)

Country

AU

Ship Phone

Text

Shipping phone number

Max Length: 30

07 3214 5236

Ship Fax

Text

Shipping fax  number

Max Length: 30

07 3214 5237

Bill First Name

Text

Billing first name.

Max Length: 50

John

Bill Last Name

Text

Billing last name.

Max Length: 50

Smith

Bill Company

Text

Billing company name.

Max Length: 50

Acme Co Pty Ltd

Bill Address Line 1

Text

Billing address Line 1

Max Length: 50

Unit 10

Bill Address Line 2

Text

Billing address line 2

Max Length: 50

12 Lilly Street

Bill City

Text

Billing city or suburb

Max Length: 50

Capalaba

Bill State

Text

Billing state

Max Length: 50

QLD

Bill Post Code

Text

Billing post code

Max Length: 15

4157

Bill Country

Text

Billing country code (eg: AU)

Bill Country

AU

Bill Phone

Text

Billing phone number

Max Length: 30

07 3214 5236

Bill Fax

Text

Billing fax  number

Max Length: 30

07 3214 5237

Payment Method

Text

The name of the payment method used for the order. Must match the name of a payment method already setup in the system.

Name of payment method.

Visa

Shipping Method

Text

The orders shipping method. Must match the name of a  shipping method already setup in the system.

Shipping Method

Standard

Shipping Cost

Decimal

The total shipping cost to apply to the order.

Price

20

Shipping Discount Amount

Decimal

The total shipping discount to apply to the order.

Price

10

Customer Instructions

Text

The customers order instructions. These will print on shipping labels and other print docs.

 

Leave at front door

Internal Notes

Text

Internal notes for staff usage. Not visible to customers.

 

Sample internal notes

Amount Paid

Decimal

The amount paid to the order.

Price

5

Date Paid

Date

The date the payment was made.

 

9/20/2014

Order Line SKU

Text

The SKU of the order line. Used to identify the product. This must match the SKU of a product already setup in the system.

Max Length: 25

SAMPLE_P1

Order Line Qty

Integer

The qty of a SKU on order.

Order Line Qty

2

Order Line Description

Text

The description of  SKU on order. If not defined, the products name will be used.

Max Length: 255 - Name of product on order.

Sample Product Name

Order Line Warehouse Name

Text

The warehouse assigned to fulfill the order line. This must match the name of a warehouse already setup in the system.

 

Secondary Warehouse

Order Line Unit Price

Decimal

The unit price of each SKU on the order line.

Price

19.95

Order Line Discount Amount

Decimal

The discount amount to apply to the order line.

Price

1


  • Last Modified: 03/11/2015