Amazon Customer phone number anonymization

Follow

Jim

• May 17, 2019 14:57

We were finally hit with this. Amazon is giving a normal phone # but with a 4 digit extension. We are now seeing 999-999-9999 on FedEx labels.

FedEx's website and Ship Manager both seem to allow for extensions. I assume this is a ShipWorks issue.

Any idea of how to fix it?

0

• Official comment

  

  Ryen M.

  • July 23, 2019 18:25

  Hi Eugene, 

  Sorry to hear you are still having issues with this. I am going to create a new ticket for you and reach out directly. Thank you for your patience, talk to you soon!

  Comment actions Permalink
• 

  Joel Parrish

  • May 28, 2019 17:41

  It is actually a 5 digit extension.

  Shipworks is truncating the extension.  Due to the 25 character field limit.

  +1 ##-###-### ext. #####

  If shipworks could ignore the leading +1 and the space.  Then replace the ext. with "x" it would help us out.

  The short term fix for us would be to expand the phone number field from 25 characters to say 30 characters.

  0

  Comment actions Permalink
• 

  Nathan H.

  • May 28, 2019 17:50

  2 simplistic routes (simplistic being relative your knowledge) would be:
  
  

  • create a custom trigger on the table to check any new inserts and run a replace query.

  or

  • create a SQL Query file with the same replace query and run it in the Task Scheduler using a Batch Script.

  0

  Comment actions Permalink
• 

  Nathan H.

  • May 28, 2019 18:03

  Or just increase the size of the column if you believe that will fix it, [BillPhone] is nvarchar(25) by default and ShipPhone is nvarchar(20) by default.
  Increasing this will not hurt anything, you could even change it to MAX if you want.

  0

  Comment actions Permalink
• 

  Joel Parrish

  • May 28, 2019 18:09

  While this would work for our purposes.

  We would have to cross reference the Amazon order ID with a separate order file downloaded from Amazon.

  The issue remains that Shipworks is only pulling in a 25 character string for the phone number field when Amazon is now supplying a 26 character field with their silly Anonymized Phone Numbers that they are now providing.  And I can only imagine that Amazon extension string will outgrow the 5 digit extension that they currently provide.

   

   

   

   

  0

  Comment actions Permalink
• 

  Nathan H.

  • May 28, 2019 18:42

  Just increase the size of the column and that will fix the issue.

  0

  Comment actions Permalink
• 

  Eugene Wright

  • July 23, 2019 18:20

  Amazon phone number extensions do not download correctly. The last digit is missing / cut off.

  0

  Comment actions Permalink
• 

  Joel Parrish

  • July 23, 2019 19:20

  We are still having the same issue as well.

   

  Please help us to fix the issue.  

   

  Thank you.

  0

  Comment actions Permalink

Please sign in to leave a comment.