Order Import Error

uhga

• May 04, 2016 23:28

Hi,

I am attempting to import orders from an external system into my admin site so customers who place orders over the phone can see their order status.

I am a novice at this stuff so I have no idea what this error means. Any help?

ERROR ROW: 1
UNCAUGHT ERROR: Input string was not in a correct format.: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value, IFormatProvider provider) at AC.ACS.Shared.Helpers.DataImporter.GetColumnDataT in c:\TeamCity\agents\BuildAgent2\work\8b808e8990e4aff3\AC.ACS.Entity\Shared\Helpers\DataImporter.cs:line 1124 at AC.ACS.Shared.Helpers.DataImporter.MapColumnToOrder(Order poOrder, OrderShipping poShipment, OrderItem poOrderItem, Int32 piItemID, String psDestinationColumn, String psSourceColumnName, DataRow poSourceRow, Int32& piChangeOrderStatusIDTo) in c:\TeamCity\agents\BuildAgent2\work\8b808e8990e4aff3\AC.ACS.Entity\Shared\Helpers\DataImporter.cs:line 5124 at AC.ACS.Shared.Helpers.DataImporter.ImportOrder(DataPortSettingCol poMappingAry, CsvReader poReader, Boolean pbPostAfterValidate) in c:\TeamCity\agents\BuildAgent2\work\8b808e8990e4aff3\AC.ACS.Entity\Shared\Helpers\DataImporter.cs:line 4376

0

• 

  Marvin Hankins

  • May 05, 2016 00:31

  Try doing a sample export from Saprk Pay to see how the data you want to import should look. If you don't have any orders in the Spark Pay store yet just manually enter some sample orders so that you'll have something to look at. You can open exported file in Excel or Open Office spreadsheet https://www.openoffice.org/.

  If you modify the file for import be sure to save in original/same format as export (probably CSV) and not Excel or Open Office spreadsheet.

  As far as phone orders we use the shopping cart for ALL transactions including phone orders. That way you don't have to import anything but you're going to export your orders to QuickBooks anyway probably.

  1
• 

  Permanently deleted user

  • May 05, 2016 15:00

  Hello. I have created a ticket from your post so that we can assist you with this error. We generally need to look at your spreadsheet to find where it is erroring. 

  Have a good day,

   

  Brandi

  0

Please sign in to leave a comment.