Skip to main content

UPS WorldShip ODBC integration

  • September 7, 2022
  • 1 reply
  • 0 views

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

1 reply

Brian Cram
Forum|alt.badge.img+3
  • Rocketeer
  • September 9, 2022
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
------------------------------
Hi, Jeremy. I reached out to another D3 guy who is using UPS WorldShip. I sent you his email address via email ( he's not in this forum ). I spoke with him just now and he said he'd love to answer a few of your questions. So please reach out.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------