Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Current »

Orderspec 2.0

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


ParametersDescriptionExampleMandatory
ClientIdThe short name of the client that owns the order. 

Client name: "Stjärna"

Client short name: "STJ"

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

Yes
Orderno

An a available order number. 

It is not possible to enter the same order number again, the registrant must check for available order numbers and prefix in Extend Commerce Backend.

"OC-111222"

"12345678"

Yes
OrderDateOrderdateÅÅÅÅ-MM-DD hh:mmNo
Orderreference

Order reference.

Printed as "Your Reference" on order header. 

"Anders Andersson"
CustomerNo

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


"17"

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

The short name of the available mode of transport for the client and customer. 


"SCHPAR"

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

No
DeliveryName1Name for delivery adress, row 1. 
Yes
DeliveryName2Name for delivery adress, row 2.
No
DeliveryAddress1Adress for delivery adress, row 1. 
Yes
DeliveryAddress2Adress for delivery adress, row 2. 
No
DeliveryAddress3Adress for delivery adress, row 3. 
No
DeliveryPostalCode

Postal code for delivery adress. 




"12345"

Postal code must be without spaces.

Yes
DeliveryCityCity, for delivery adress. StockholmYes
DeliveryStateDelivery state. Type the state if needed or leave empty. No
DeliveryCountryCounty 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

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
InvoiceNameName for invoice adress. 
Yes
InvoiceAddress1Adress for invoice adress, row 1. 
Yes
InvoiceAddress2Adress for invoice adress, row 2. 
No
InvoiceAddress3Adress for invoice adress, row 3. 
No
InvoicePostalCodePostal code for invoice adress. 
Yes
InvoiceCityCity for invoice adress. 
Yes
InvoiceStateState for invocie adress. 
No
InvoiceCountryCountry for invoice adress.
Yes
AskedDeliverydate
ÅÅÅÅ-MM-DD hh:mmYes
VATno

VAT number. 

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


No
OrgNo

Organisation number. 

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.

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. 

Product must be stored in Extend Commerce Backend and linked to price list, warehouse and supplier agreement.


Yes
ItemName

Product name. 

This will overwrite existing description.


No
Quantity

Ordered quantity. 

Always written in integers.


Yes
Unit

Sales unit.

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. 

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


No
VATPercentRow

VAT in percent. 

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. 

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


Yes
Notes

Notes for order. 

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


No
OrderEmailEmail for order confirmation. "anders.andersson@andersson.se"No
InvoiceEmailEmail for invoice. 
No
WarehouseWarehouse 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.

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:

Relaterade artiklar:



  • No labels