Help Search our knowledge base:

Index - FAQ - Cart Help Buttons - Extra Features - QuickBooks File - File Format Details

 Where is this feature?
1. Log In
2. Extra Features
3. QuickBooks File
4. File Format Details

 Related Items
1. How do I download orders into my database?
2. Download "QuickBooks", "CSV File (Excel)", "UPS WorldShip" or other formats
3. Save the CustomerID Value With Recurring Products
4. Fields 20-29: Misc Product Information (optional)

 Details
Frequently Asked
Question (FAQ)

Document Number: 970

Optimize for Printing
E-Mail This Link

 Feedback
This document ...
helps resolve my question or problem.
does not apply to my question or problem.
is inaccurate for my question or problem.
CSV Format Details

CSV files are standard comma-delimited quote encapsulated files that can be easily imported into most database/spreadsheet programs.

Note: The CSV file format will change as upgrades are added to the shopping cart. Changes will follow these simple rules:
  1. The file will always be a simple CSV format.
  2. The file will only have new information added to the end of the existing file format.
Please keep this in mind when creating your import/export tools.

Below is a list of current field names and data types:

Invoicechar(30)
Daytinyint
Monthtinyint
Yearsmallint
Pricedouble(10,2)
Shipping+Handlingfloat(9,2)
Sales_Taxfloat(9,2)
Item_Price_Totalfloat(9,2)
PartNamechar(255)
PartNuchar(100)Please note that some external programs have much smaller limits, for example QuickBooks only allows 31 characters
Quantityfloat(9,2)
ShippingMethodchar(30)
ShippingNamechar(65)
ShippingAddrchar(75)
ShippingCitychar(26)
ShippingStatechar(20)
ShippingCountrychar(40)
ShippingZipchar(20)
BillingNamechar(65)
BillingAddrchar(75)
BillingCitychar(26)
BillingStatechar(20)
BillingCountrychar(40)
BillingZipchar(20)
CCNuchar(20)
CCTypechar(20)
CCExpdate
Day_Phonechar(25)
Night_Phonechar(25)
Faxchar(25)
Emailchar(25)
AVS_Matchchar(10)
Special_Order_Instructionstext
Auth_codechar(10)
Ship Address Line 2char(55)
Bill Address Line 2char(55)
BillingCompanychar(50)
ShippingCompanychar(50)
CustomQuestion1char(255)
CustomQuestion2char(255)
CustomQuestion3char(255)
ShippingEmailchar(60)
ShippingPhonechar(25)
PaymentIDchar(40)
PaymentMethodchar(30)
ShippingName1char(30)
ShippingName2char(30)
BillingName1char(30)
BillingName2char(30)
LoginUsernamechar(50)
CustomerIPchar(15)
Order_Weight_Totalfloat(8,3)
Item_Weight_Totalfloat(8,3)
CustomerIDchar(255)
OrderStatuschar(20)
Recurringunsigned int
ProductDiscountfloat(9,2)
RushOrderAmountfloat(9,2)
Couponstext
CustomQuestion4char(255)
ProductMisc_1char(255)
ProductMisc_2char(255)
ProductMisc_3char(255)
ProductMisc_4char(255)
ProductMisc_5char(255)
ProductMisc_6char(255)
ProductMisc_7char(255)
ProductMisc_8char(255)
ProductMisc_9char(255)
ProductMisc_10char(255)
MarketingAllowedchar(1)N
DateTimedatetime2011-04-18 13:54:58
GiftCerttext"giftName1","4.95","giftName2","10.95"
Lottext"Lot1","Lot2","Lot3"


You can automatically download all non-downloaded orders by going to this URL:
https://username:password@rtcart.net/orders/USERNAME/AllOrder.db

You can specify a list of invoice numbers to download using this URL:
https://username:password@rtcart.net/orders/USERNAME/AllOrder.db?Invoice=1,4,1009,12

If you wish to automatically update your order status please see this FAQ
Is there an automated way I can update my order status?