| Where is this feature? | | 1. | Log In | | 2. | Extra Features | | 3. | QuickBooks File | | 4. | File Format Details |
|
|
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:
- The file will always be a simple CSV format.
- 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:
| Invoice | char(30) | | Day | tinyint | | Month | tinyint | | Year | smallint | | Price | double(10,2) | | Shipping+Handling | float(9,2) | | Sales_Tax | float(9,2) | | Item_Price_Total | float(9,2) | | PartName | char(255) | | PartNu | char(100) | Please note that some external programs have much smaller limits, for example QuickBooks only allows 31 characters | | Quantity | float(9,2) | | ShippingMethod | char(30) | | ShippingName | char(65) | | ShippingAddr | char(75) | | ShippingCity | char(26) | | ShippingState | char(20) | | ShippingCountry | char(40) | | ShippingZip | char(20) | | BillingName | char(65) | | BillingAddr | char(75) | | BillingCity | char(26) | | BillingState | char(20) | | BillingCountry | char(40) | | BillingZip | char(20) | | CCNu | char(20) | | CCType | char(20) | | CCExp | date | | Day_Phone | char(25) | | Night_Phone | char(25) | | Fax | char(25) | | Email | char(25) | | AVS_Match | char(10) | | Special_Order_Instructions | text | | Auth_code | char(10) | | Ship Address Line 2 | char(55) | | Bill Address Line 2 | char(55) | | BillingCompany | char(50) | | ShippingCompany | char(50) | | CustomQuestion1 | char(255) | | CustomQuestion2 | char(255) | | CustomQuestion3 | char(255) | | ShippingEmail | char(60) | | ShippingPhone | char(25) | | PaymentID | char(40) | | PaymentMethod | char(30) | | ShippingName1 | char(30) | | ShippingName2 | char(30) | | BillingName1 | char(30) | | BillingName2 | char(30) | | LoginUsername | char(50) | | CustomerIP | char(15) | | Order_Weight_Total | float(8,3) | | Item_Weight_Total | float(8,3) | | CustomerID | char(255) | | OrderStatus | char(20) | | Recurring | unsigned int | | ProductDiscount | float(9,2) | | RushOrderAmount | float(9,2) | | Coupons | text | | CustomQuestion4 | char(255) | | ProductMisc_1 | char(255) | | ProductMisc_2 | char(255) | | ProductMisc_3 | char(255) | | ProductMisc_4 | char(255) | | ProductMisc_5 | char(255) | | ProductMisc_6 | char(255) | | ProductMisc_7 | char(255) | | ProductMisc_8 | char(255) | | ProductMisc_9 | char(255) | | ProductMisc_10 | char(255) | | MarketingAllowed | char(1) | N | | DateTime | datetime | 2011-04-18 13:54:58 | | GiftCert | text | "giftName1","4.95","giftName2","10.95" | | Lot | text | "Lot1","Lot2","Lot3" |
You can automatically download all non-downloaded orders by going to this URL:
https://username:[email protected]/orders/USERNAME/AllOrder.db
You can specify a list of invoice numbers to download using this URL:
https://username:[email protected]/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? |