Versions Compared

Version Old Version 5 New Version Current
Changes made by

johanna.fallstrom (Unlicensed)

Kajsa Fransson (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

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


ParametersDescriptionExampleMandatory
ClientIdThe 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

...

An a available order number. 

Info

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:mm

...

No
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"

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

...

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


"SCHPAR"

...

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
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"

Note

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

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
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:mm

...

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
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.


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: