Looking to see if anyone has successfully integrated D3 with UPS WorldShip using ODBC -
When voiding a shipment/package in WorldShip, I receive a duplicate key error because it appears that it's trying to perform an insert instead of an update statement.
On void in WorldShip:
Execute 0F99B418( INSERT INTO ups_packages ( ...., voided, id, shipment_id ) VALUES ( ..., 'Y', 'PACKAGE ID', 'UPS SHIPMENT ID' ) )
Execute 0F99B418( INSERT INTO ups_shipments ( ...., voided, id ) VALUES ( ..., 'Y', 'UPS SHIPMENT ID' ) )
Given that these records already exist, and we're just trying to set the voided flag, it should be an update statement:
update ups_packages set voided = 'Y' where shipment_id = 'UPS SHIPMENT ID'
update ups_shipments set voided = 'Y' where id = 'UPS SHIPMENT ID'
Everything else seems to work.
Did I miss mapping something in WorldShip? Is this a known issue? Any ideas on how to work around this?
Appreciate any help!
------------------------------
Jeremy Lockwood
Awesome
ASE Supply Inc
Portland OR US
------------------------------