1ShoppingCart
From NewHaven Software Wiki
Russ horton (Talk | contribs) (Created page with '=Export Options= When exporting orders from 1ShoppingCart you'll need to select the proper export options and fields to ensure the file will work with CMS. The top two combo opti…') |
Russ horton (Talk | contribs) |
||
| Line 13: | Line 13: | ||
| - | Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart | + | Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart |
Revision as of 17:55, 6 November 2012
Export Options
When exporting orders from 1ShoppingCart you'll need to select the proper export options and fields to ensure the file will work with CMS. The top two combo options are critically important to have selected correct as it defines how the file will handle orders with multiple items and ensure the file is in the expected .CSV (comma delimited) format.
Here is a screenshot of the proper export options: http://screencast.com/t/F8vzhTyA
Choosing the right fields to export
The following is a list of fields that CMS supports for importing orders from 1ShoppingCart:
OrderDate
Total
Tax
ShippingPrice
Discount
OrderId
FirstName
LastName
Company
Address2
Address1
City
State
Zip
Country
Email
Phone
ShipToName
ShipToAddress2
ShipToAddress1
ShipToCity
ShipToState
ShipToZip
ShipToCountry
SKU-1...SKU-N
P1...PN
price1...priceN
qty1...qtyN
CardType
CardHolder
CCnum
ExpireDate
TransID
ApproveStatus
ShippingMethod
The fields that show '...' can have multiple entries differentiated by an integer (SKU-1, SKU-2, etc). When selecting fields for export we recommend you select all of the fields listed above, as illustrated in the linked screenshot. You may select additional fields as well but they will be ignored by the CMS import.
Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart
