All Order Fields



Below is a list of all the order related fields that exist in Neto.

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.

Max Length: 15

ABC1234567

Group Orderlines By

Text

Used to group order lines together. If not defined, Order ID will be used.

Max Length: 255

Order ID

Send Email Notification

Boolean

If Yes, an order receipt email will be sent to the email address defined on the order.

Yes | No

Yes

Parent Order ID

Text

The orders related parent Order. Used to define the order this order was created from.

Max Length: 15

ABC1234564

Purchase Order ID

Text

The customers purchase order number. Used for reference purposes only. Shows on order print docs and in UI.

Max Length: 50

1234567890

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

Order Type

Text

By default an order is a "Sales" order. For orders that are being dropshipped on a customer's behalf and that do not require invoices use the type "Dropshipping". Automatically the system will not allow warehouse users to print invoices for such orders.

Sales|Dropshipping

Sales

Approved

Boolean

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

Yes | No

Yes

User Group

Integer

The user group / price level used for pricing calculations of the order. Use the group ID. Eg: 1,2,3 etc

User Group Name

2

Order Payment Plan

Text

The payment plan assigned to the order (for recurring payments module only). Must match a plan name that has already been setup in the system.

Order Payment Plan Name

Weekly

Document Template

Text

The name of the document template set assigned to the order. Must match the name of a document template set that has already been setup in the system.

Document Template

test

Date Placed

Date & Time

The date and time the order was placed.

YYYY-MM-DD HH:MM:SS

9/20/2014 10:22

Date Required

Date & Time

The date and time the order is required (for shipping purposes).

YYYY-MM-DD HH:MM:SS

9/21/2014 10:22

Payment Due Date

Date & Time

The date and time the order is due to be paid.

YYYY-MM-DD HH:MM:SS

9/22/2014 10:22

Date Completed

Date & Time

The date and time the order was completed (dispatched or cancelled)

YYYY-MM-DD HH:MM:SS

9/23/2014 10:22

Exported To Accounting Software

Boolean

Defines whether of not the order has already been exported to an accounting system.

Yes | No

Yes

Date Invoiced

Date

The date the order was invoiced.

YYYY-MM-DD

9/23/2014 10:22

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 Full Name

Text

The shipping first and last name  separated with spaces.

Max Length: 100

John Smith

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 Full Name

Text

The Billing first and last name  separated with spaces.

Max Length: 100

John Smith

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

BPAY CRN

Text

The Bpay CRN of the order. Leave blank for the system to auto generate a CRN.

Max Length: 20

123456789

Payment Terms

Text

The orders payment terms. Must match the name of payment terms already setup in the system.

Payment Terms

Net 30

Sales Channel

Text

The sales channel that the order was placed through. Eg: Website or eBay

Max Length: 15

Website

Currency Code

Text

The currency code used for order lines. Leave blank to use system default currency. 3 digit currency code.

Currency Code

AUD

Shipping Method

Text

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

Shipping Method

Standard

Signature Required

Boolean

If yes, signature required will print on shipping address labels.

Yes | No

Yes

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

Tax Free Shipping

Boolean

If yes tax will not be applied to shipping.

Yes | No

Yes

Tax Inclusive

Boolean

If yes all pricing on the order will be deemed to be tax inclusive (tax will not be added on top)

Yes | No

Yes

Surcharge Percent

Decimal

The percentage surcharge to apply to the order. Increases the order value by this percentage.

Percentage (%)

2

Payment Notes

Text

Internal notes related to the payment. For reference purposes only.

 

Sample payment notes.

Fraud Score

Decimal

The fraud score associated with the order. For reference purposes only.

 

5.2

Coupon Code

Comma separated list

A list of coupon codes that apply to the order. The system will apply the discount rules of the codes on import.

Coupon codes separated by commas

ABC123

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

Sales Person

Text

The sales person associated with the order. Must match the username of an existing staff member account.

Sales Person

admin

Password For New User

Text

If you select to have the system auto generate a user account for the related customer of the order you are importing, you can use this field to define the customers account password.

*RANDOM* = Create a random password ; Max Length: 25

kvwyc732vf62!

Amount Paid

Decimal

The amount paid to the order.

Price

5

Date Paid

Date

The date the payment was made.

 

9/20/2014

Card Holder

Text

The orders credit card holders name.

Max Length: 50

John Smith

Card Number

Text

The orders credit card number. For PCI compliance reasons do not import full credit card numbers to this field.

Max Length: 30

4950******5

Card Expiry Month

Integer

The orders credit card expiry month.

Month

11

Card Expiry Year

Integer

The orders credit card expiry year.

Year

2014

Card Authorisation Code

Text

The orders credit  card authorisation number returend by the processing bank or gateway at time of payment.

Max Length: 100

AUTH123

Authorisation Message

Text

The transaction number / ID of the payment.

Max Length: 50

TRANS1

Cheque Number

Text

The cheque / check number used to make payment.

Max Length: 20

1235467

Cheque Account Name

Text

The name of the customers cheque / check account.

Max Length: 50

Test Account Name

Cheque Account BSB

Text

The bsb of the customers cheque / check account.

Max Length: 10

123456

Cheque Account Number

Text

The number of the customers cheque / check account.

Max Length: 20

123456789

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 Serial Number

Text

The serial number assigned to the order line. For warranty tracking purposes.

Max Length: 50

1234567889

Order Line Dropship Supplier

Text

The dropship suppplier assigned to fulfill the order line. This must match the name of a supplier already setup in your system.

 

 

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 Options

List

A list of options selected for the order line. These options must already be setup as options on the SKU in the system. Follow the format provided in the example.

[option_name]=[option_value] (for multiple separate with a semi colon (;). You can define the separator under admin > system setup advanced config)

Gift Wrapping=Gold;Warranty=12 Months

Order Line Kitting

List

A list of SKUs and related quantities that make up a kit. For kitted / built products. Follow the format provided in the example.

[component_sku]=[component_qty];[component_sku]=[component_qty]; ...

 

Order Line Unit Price

Decimal

The unit price of each SKU on the order line.

Price

19.95

Order Line Unit Cost

Decimal

The unit cost of each SKU on the order line. Used for profit reporting.

Price

9.95

Order Line Shipping Weight

Decimal

The weight in KG of each SKU on the order line.

Weight (kg)

0.25

Order Line Shipping Cubic

Decimal

The cubic volume (CM) of each SKU on the order line.

Volumn

0.001

Order Line Discount Percent

Decimal

The discount percentage of an order line.

Percentage (%)

5

Order Line Discount Amount

Decimal

The discount amount to apply to the order line.

Price

1

Shipping Discount Percent

Decimal

The discount percentage  to apply to shipping costs.

Percentage (%)

2

Order Line Tax Free

Boolean

If yes, the order line will be tax free. For example if the order line is a food item where tax does not apply.

Yes | No

No

Order Line Delivery Date

Date & Time

The customers chosen delivery date for the order line.

YYYY-MM-DD HH:MM:SS

9/20/2014 10:22

Order Line Job

Text

The job assigned to the order line.  Used or reference or reporting purposes only. The job name must match a job name already setup in the system.

Name of job

Sample Job

Order Line Bin Location

Text

The order lines assigned pick bin. Used for mobile pick'n pack.

Max Length: 10

A-01

Order Line Notes

Text

Notes related to the order line. You can choose to show these to customers or not.

Max Length: 255

Sample order line notes.

Skip Record

Boolean

If yes, the order line will be skipped during import.

Yes | No

No


  • Last Modified: 02/11/2015