Follow

Export_orders

The document corresponds to the WinBIZ standard import. This format is not directly compatible (a pre processing is needed on the document).

 

Field Number

Description

 

OsCommerce field

 

Type

 

1

Document Nb.

orders.orders_id

N(5)

2

Document type

12

N(2)

3

Date

orders.date_purchased (parse date)

YYYYMMDD

4

Hour

orders.date_purchased (parse hour)

HH:MM

5

 

 

 

6

Total amount in local currency

orders_total.value

N(10,2)

7

Currency ISO code

orders.currency

C(3)

8 - 13

 

 

 

14

Document format

0

N(1)

15 -16

 

 

 

17

Reserved 2

orders.orders_id

N(5)

18

Reserved 3

 

19

Reserved 4

Order’s comments (orders_status_history.comments)

20

Address code

orders.customers_id

N(5)

21

Civil title

customers.customers_gender (m/f)

C(1)

22

Company name

orders.customers_company

 

23

Last name

determined according to orders.customers_name and customers

C(32)

24

First name

determined according to orders.customers_name and customers

C(32)

25

Address line 1

orders.billing_street_address

C(64)

26

Address line 2

orders.billing_suburb

C(64)

27

ZIP

orders.billing_postcode

C(10)

28

City

orders.billing_city

C(32)

29

Country ISO code

determined according to countries.countries_iso_code_3

C(3)

30

Country name

orders.billing_country

C(64)

31

 

 

C(2)

32

Telephone 1

customers.customers_telephone

C(32)

33

 

 

 

34

Fax

customers.customers_fax

C(32)

35

 

 

 

36

Email

customers.customers_email_address

C(96)

37 - 39

 

 

 

40

Creation date

customers_info.customers_info_date_account_created

YYYYMMDD

41

Birthdate

customers.customers_dob

YYYYMMDD

42

 

 

 

43

 

Delivery address (only if different from the billing address)

 

44-47

 

 

 

48

Line nr.

 

N(4)

49

Line type

1

N(1)

50

Item code

orders_products.products_model or #BOITEM# or #SHIPPINGCOST# or #LOWORDERFEE#

C(12)

51

Description

orders_products.products_name

C(64)

52

 

 

 

53

Quantity

orders_products.products_quantity

N(2)

54

Price in local currency

orders_products.products_price

N(15,4)

55

 

 

 

56

Discount %

discount % for the line. In order to specify an amount, see field 67

N(7,3)

57

Amount

orders_products.final_price

N(15,4)

58 - 60

 

 

 

61

VAT %

orders_products.products_tax

N(7,4)

62

VAT Included/excluded

2

N(1)

63 - 66

 

 

 

67

Discount Amount

amount of the discount for the line. In order to specify a %, see field 56. The amount doesn't need to be negative.

N(7,3)

68 - 73

 

 

 

74

Item update

0

N(1)

75 - 133

 

 

 


 

Remarks:

This data structure is very similar to the one of the standard import of documents.

It is also possible, following the import debtor payments structure to import the payments of each document.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Zambaz Olivier
    Edited by Zambaz Olivier