1ShoppingCart - Revision history

Russ horton at 00:09, 19 December 2012

2012-12-19T00:09:53Z

← Older revision		Revision as of 00:09, 19 December 2012
Line 18:		Line 18:
	#Open the file in Notepad and confirm the the file is comma delimited		#Open the file in Notepad and confirm the the file is comma delimited
	##Look for the presence of the field "Bundle-1" in the header. The export file should contain a header record but the presence of the header "Bundle-1" may indicate that the wrong option was selected in the first combo when exporting (see screenshot link above.)		##Look for the presence of the field "Bundle-1" in the header. The export file should contain a header record but the presence of the header "Bundle-1" may indicate that the wrong option was selected in the first combo when exporting (see screenshot link above.)
			##Resaving the file after opening in Notepad can remove unwanted/invisible characters that are known to be able to cause problems with the CMS import (Access Violation error)


	Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart		Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart

Russ horton at 18:03, 6 November 2012

2012-11-06T18:03:23Z

← Older revision		Revision as of 18:03, 6 November 2012
Line 11:		Line 11:

	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.		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.

			=Troubleshooting=
			If your file will not import, try the following steps:
			#make sure that the order source you've selected when importing is setup to have a "Type" of 1ShoppingCart
			#Verify that the export options selected match those described above
			#Open the file in Notepad and confirm the the file is comma delimited
			##Look for the presence of the field "Bundle-1" in the header. The export file should contain a header record but the presence of the header "Bundle-1" may indicate that the wrong option was selected in the first combo when exporting (see screenshot link above.)


	Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart		Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart

Russ horton at 17:55, 6 November 2012

2012-11-06T17:55:19Z

← Older revision		Revision as of 17:55, 6 November 2012
Line 13:		Line 13:


	Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart		Additional search terms: 1Shopping Cart, 1 ShoppingCart, 1 Shopping Cart

Russ horton: 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…'

2012-11-06T17:53:59Z

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…'

New page

=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