Perlshop 4 - Order CSV File Format

Overview

This document describes the field format for the Customer and Order CSV (Comma Separated Value) data files generated by Perlshop 4.

Customer Files

Each customer file contains a single line of text. This line is broken up into the following fields:

Field Number Field Name Description

Order Information Fields

1 Perlshop Invoice Number

2 Customer IP Address

3 Order Date Day, month, and year.
Format is set by the $date_format setting in the ps.cfg file.

4 Order Time Hours, minutes, and seconds.
Format is HH:MM:SS.

Customer Information Fields

5 Title

6 First Name

7 Last Name

8 Company

9 Street 1

10 Street 2

11 City

12 State

13 Zip/Postal Code

14 Country

15 Email

16 Day Phone

17 Day Extension

18 Night Phone

19 Night Extension

20 Fax

Shipping Selection Fields

21 Selected Shipper

Payment Information

22 Payment Mode

23 Payment Data 1 The meaning of this field depends on the Payment Mode.

If the payment mode is Credit Card, this field holds the card type (Visa, MasterCard, etc).
If the payment mode is Virtual Check, this field holds the ABA number.

24 Payment Data 2 The meaning of this field depends on the Payment Mode.

If the payment mode is Credit Card, this field holds the card number. If entered, the card security code will be appended to the card number separated by a single space.
If the payment mode is Purchase Order, this field holds the purchase order number.
If the payment mode is Virtual Check, this field holds the account number.

25 Expiration Month

26 Expiration Year

Customer Input

27 Source This field records what the customer entered into the "tell us where you heard about our site" box.

28 Suggest This field records what the customer entered into the "Suggestions and Comments" box.

Unused

29 FVPIN Once used to hold the PIN number for a First Virtual Bank account. First Virtual Bank is no longer in business.

Shipping Destination

30 Shipping Address is Same as Billing Address This field is set to "true" if the shipping address is the same as the billing address.

31 Shipping Title

32 Shipping First Name

33 Shipping Last Name

34 Shipping Company

35 Shipping Street 1

36 Shipping Street 2

37 Shipping City

38 Shipping State

39 Shipping Zip/Postal Code

40 Shipping Country

Financial Information

41 Item Subtotal

42 Shipping Fee

43 Grand Total

44 Total Discount

45 COD Fee

46 Handling Fee

47 Total Rebate

Field Number	Field Name	Description
Order Information Fields
1	Perlshop Invoice Number
2	Customer IP Address
3	Order Date	Day, month, and year. Format is set by the $date_format setting in the ps.cfg file.
4	Order Time	Hours, minutes, and seconds. Format is HH:MM:SS.
Customer Information Fields
5	Title
6	First Name
7	Last Name
8	Company
9	Street 1
10	Street 2
11	City
12	State
13	Zip/Postal Code
14	Country
15	Email
16	Day Phone
17	Day Extension
18	Night Phone
19	Night Extension
20	Fax
Shipping Selection Fields
21	Selected Shipper
Payment Information
22	Payment Mode
23	Payment Data 1	The meaning of this field depends on the Payment Mode. If the payment mode is Credit Card, this field holds the card type (Visa, MasterCard, etc). If the payment mode is Virtual Check, this field holds the ABA number.
24	Payment Data 2	The meaning of this field depends on the Payment Mode. If the payment mode is Credit Card, this field holds the card number. If entered, the card security code will be appended to the card number separated by a single space. If the payment mode is Purchase Order, this field holds the purchase order number. If the payment mode is Virtual Check, this field holds the account number.
25	Expiration Month
26	Expiration Year
Customer Input
27	Source	This field records what the customer entered into the "tell us where you heard about our site" box.
28	Suggest	This field records what the customer entered into the "Suggestions and Comments" box.
Unused
29	FVPIN	Once used to hold the PIN number for a First Virtual Bank account. First Virtual Bank is no longer in business.
Shipping Destination
30	Shipping Address is Same as Billing Address	This field is set to "true" if the shipping address is the same as the billing address.
31	Shipping Title
32	Shipping First Name
33	Shipping Last Name
34	Shipping Company
35	Shipping Street 1
36	Shipping Street 2
37	Shipping City
38	Shipping State
39	Shipping Zip/Postal Code
40	Shipping Country
Financial Information
41	Item Subtotal
42	Shipping Fee
43	Grand Total
44	Total Discount
45	COD Fee
46	Handling Fee
47	Total Rebate

Order Files

Each customer file contains one or more lines of text. Each line represents one item that has been ordered. These lines are broken up into the following fields:

Field Number Field Name Description

1 Perlshop Invoice Number

2 Item ID

3 Item Name

4 Item Price

5 Quantity

6 Weight

7 Tax Type

8 Option Value 1

9 Option Value 2

10 Option Value 3

11 Minimum Allowed Quantity

12 Maximum Allowed Quantity

13 Item Ship Type

Field Number	Field Name	Description
1	Perlshop Invoice Number
2	Item ID
3	Item Name
4	Item Price
5	Quantity
6	Weight
7	Tax Type
8	Option Value 1
9	Option Value 2
10	Option Value 3
11	Minimum Allowed Quantity
12	Maximum Allowed Quantity
13	Item Ship Type