...

Orderspec 2.0

Panel

borderColor	#dbdbdb

This is a description of the template for excel file order creation for multi customer orders. This template is called "Multikundorder - orderspec 2.0".

Image Added

Parameters

Description

Example

Mandatory

ClientId

The short name of the client that owns the order.

Client name: "Stjärna"

Client short name: "STJ"

Note
You must be sure of which short name to write so the order ends up in the right client system.

Yes

Orderno

...

The customer number of the customer that has ordered the products.

"17"

Info
If entering a customer number that don not exists, the customer will be created. (Duplicates are not allowed). Do not mix and create new customers with existing ones.

Yes

DeliveryMethod

...

Info
You can find the short name of the delivery method you desire under the gearwheel in Extend Commerce Backend > Generel settings > Transport settings.

No

DeliveryName1

Name for delivery adress, row 1.

Yes

DeliveryName2

Name for delivery adress, row 2.

No

DeliveryAddress1

Adress for delivery adress, row 1.

Yes

DeliveryAddress2

Adress for delivery adress, row 2.

No

DeliveryAddress3

Adress for delivery adress, row 3.

No

DeliveryPostalCode

Postal code for delivery adress.

"12345"

Note
Postal code must be without spaces.

Yes

DeliveryCity

City, for delivery adress.

Stockholm

Yes

DeliveryState

Delivery state.

Type the state if needed or leave empty.

No

DeliveryCountry

County for delivery adress.

Type the state as "SE" or "NO"

Yes

PhoneNumber

Telephone number of recipient or notification service if such is included with the mode of transport.

Type the phone number if needed or leave empty

Info
Telephone numbers are also saved on the customer for new customer arrangements. On orders, they are saved by telephone and printed on orders under your reference. (in ConsumerOrder as Phone in ShipTo).

No

InvoiceName

Name for invoice adress.

Yes

InvoiceAddress1

Adress for invoice adress, row 1.

Yes

InvoiceAddress2

Adress for invoice adress, row 2.

No

InvoiceAddress3

Adress for invoice adress, row 3.

No

InvoicePostalCode

Postal code for invoice adress.

Yes

InvoiceCity

City for invoice adress.

Yes

InvoiceState

State for invocie adress.

No

InvoiceCountry

Country for invoice adress.

Yes

AskedDeliverydate

...

Yes

VATno

VAT number.

Note
Only to be filled in for new layouts by a new customer.

No

OrgNo

Organisation number.

Note
Only to be filled in for new layouts by a new customer.

No

GoodsNotification

Goods notification.

Printed as Freight Marking on orders. (In ConsumerOrder as MKS on head)

No

PaymentType

Type of payment. Entered as:

INV: BILLING

AUTO: AUTOGIRO

ADV: ADVANCEPAYMENT

FAC: FACTORING

CAS: CASHPAYMENT

LAS: LASTSCHRIFT

CC: CREDITCARD

MOH: MANUALONHOLD

FAM: INVOICEME

Yes

FreightFree

Freight free or not.

0: Freight

1: Freight free

Yes

RowCounter

Number of rows in the order.

Info
If there are 3 lines with the same order number, a 3 is written on each line for the order.

Yes

Orderposition

Order line position.

Fill in if you want a special order on the rows.

No

Item

Product numer.

Note
Product must be stored in

...

Extend Commerce Backend and linked to price list, warehouse and supplier agreement.

Yes

ItemName

Product name.

Info
This will overwrite existing description.

No

Quantity

Ordered quantity.

Always written in integers.

Yes

Unit

Sales unit.

Note
The unit must be set in

...

Extend Commerce Backend and connected to the product and a price list.

Yes

PriceexVAT

Price ex VAT per unit.

Note
If price is indicated on a row, all rows in the column must be registered with price.

No

VATPercentRow

VAT in percent.

Note
If VAT is entered on a row, all rows in the column must be registered with VAT.

No

Currency

Currency as in ex. SE, DKK or NOK.

Note
The currency must be on an active price list for the customer.

Yes

Notes

Notes for order.

Info
Written as order line listing on order document. (In ConsumerOrder as MKS)

No

OrderEmail

Email for order confirmation.

"anders.andersson@andersson.se"

No

InvoiceEmail

Email for invoice.

No

Warehouse

Warehouse that's connected to the product.

No

OrderReviewReasonNotes

No

CustomerGroup

Customer Group column is always empty when exporting the template because this is only used/required if creating new customer.

Yes/No

This is only used/required if creating new customer.

Info
Detta är en tjänst som går att beställa från Extend Commerce Support. Kontakta Extend Commerce Support för mer information eller beställning.

På denna sida:

Table of Contents

Relaterade artiklar:

Versions Compared

Old Version 5

New Version Current

Key

Orderspec 2.0

Page Comparison

Versions Compared

Old Version 5

New Version Current

Key

Orderspec 2.0