Import UPS tracking number

[elockard]

How do I import a UPS tracking number into AC 7 using the Data Port? I was able to export to worldship with some manipulation of data.

Eric.

[mazhar]

In order to import the tracking number you must have the orders CSV in the following format.

Code: Select all

CSV Column Headers are given below

"Shipment_ID","Order_ID","D_Name","D_Attention","D_Address1","D_Address2","D_City","D_Province","D_PostalCode","D_Country","D_Phone","D_Fax","D_Email","O_Name","O_Warehouse","O_Address1","O_City","O_Province","O_PostalCode","O_Country","ServiceType","BillingOption","PackageType","PackageWeight","PackageDesc","QVN","QVN_Subject","QVN_FailedEmail","QVN_1Type","QVN_1S","QVN_1E","QVN_1D"

so create a CSV having above format with the available data. The QVN_Subject column will be used for tracking number. After creating the CSV import it to the store using DataClient.

[Rick J]

I've tried the method above just as you had stated, but when using the dataport utility to upload the csv file the fields on the Able side are unable to coordinate with the csv file.

Is there a difference between dataclient/dataport?

Any suggestions?

[kbeazer]

Hi.

I am trying to use the UPS Worldship download in DataPort 7.4.236 to get the orders out of Able Commerce. I am then using a shipping software to import that data and get labels printed etc. I then am exporting that data (has the tracking number and a flag telling that it was shipped) to import back to Able Commerce to update the orders.

My question is... Using the UPS Worldship upload in DataPort, what fields are required? What do I need to include in that file? Is there a template for this?

I have everything figured out with the whole process except for what fields must I include in the file that I will be uploading using the WorldShip Data port feature to set the status to "Shipped" and insert the tracking number etc.

Any help is greatly appreciated.

Thanks,
Kevin

[kwikstand]

I have yet been able to figure this one out too. I can't get tracking numbers back in to AC. Also, it changes that status of ALL orders to shipped regardless of whether labels were printed or not.

What is it that I can't seem to figure out?

[jotsgroup]

I'm having similar troubles with 7.4.238
I can export no problem, but import doesn't work, even with the suggested headers above and tracking# in QVN_SUBJECT

The error I'm getting is

Code: Select all

Error processing record: "45","","False"; Error was Cannot insert the value NULL into column 'TrackingNumberData', table 'PrimizieAC.dbo.ac_TrackingNumbers'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Processing complete.

which seems to indicate that I've put the tracking # in the wrong column.

What Am I missing here?

-Tom

[jmestep]

Someone else has been posting about Worldship/Dataport problems. You might want to add on to that post. Maybe there is a bug.
viewtopic.php?f=61&t=13815