is there a current manual on UPS Worldship Integration. I don't want to export/import csv files constantly, I want to connect it directly to my database. I almost have it completely done, but the export of the tracking number back into the DB is giving me this error:
Code:
ODBC ERROR: State = 23000 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OrderNumber', table 'xxxxxx.dbo.ShippingImportExport'; column does not allow nulls. INSERT fails.
Its very odd. I know the error says cannot import into 'OrderNumber', but I swear I am not trying to import into 'OrderNumber', I am trying to import into the 'TrackingNumber' field.