Address Ship to Internal ID in saved search

Trying to create a saved search that will include the ‘address ID’ from the Address ship to lines

The saved search will concatenate the customer ID – Address Ship to ID (example customer ID 1234, shipping address 5678. ((1234 – 5678))

Was wondering if anyone knew how to bring in the address ship to ID. I tried {shippingaddress.internalID} and {shippingaddress.exteralID} but that did not work.

Was wondering if someone knows the string text to access this address ID.

Address Ship to Internal ID in saved search

Rookie Asked on March 10, 2020 in Saved Searches.
Add Comment
3 Answer(s)

try and address.internalid

Advanced Answered on March 10, 2020.

Thanks for the help. Good idea. I have tried ‘’ and ‘address.internalid’ and neither of those worked. Any other suggestions?

on March 10, 2020.
Add Comment

Address records have 2 ID fields. The one you want is named Address Internal ID in search columns. {shippingaddress.addressinternalid}

RE: Address Ship to Internal ID in saved search

Advanced Answered on March 11, 2020.

I thought for sure that would work…

I tried {shippingaddress.addressinternalid} and it did not work. I received an ‘ERROR : Field Not Found’ error.

That was a really good idea – and I appreciate your help.

RE: Address Ship to Internal ID in saved search

on March 11, 2020.

Ok, new information: If I run a customer search, then {shippingaddress.addressinternalid} works! Thanks for your help. However, I am running a transaction / sales order search. When I do this, {shippingaddress.addressinternalid} returns an ERROR : Field Not Found.

Any ideas why that is?

on March 11, 2020.

I’m not sure that you can get the address internal id from transactions. Its not a field in the shipping address join.

on March 12, 2020.

You seem really smart on the subject, and I really appreciate your input.

I am writing a sales order/transaction search and {shippingaddress.internalid} returns a value, but it does not appear to be the ‘address internal id’. I was wondering, what field do you think that ties to {shippingaddress.internalid}? Any ideas on how to pull the shipping address internal ID into this order transaction saved search?

on March 12, 2020.
Add Comment

The ID you need is part of the customer record and not the order. So, the option is to look for the orders but from a Customer saved search instead. Are you doing a join in your Transaction saved search? Because you won’t be able to join to the transaction from the customer and then perform another join to another table, that might be a limitation. Once you have the IDs of the addresses you can compare the address 1  from the customer and from the transaction and look for the match, keep the match and the ID.

The other option is to script it. When the shipping is chosen or via a scheduled script, look for the address within the customer and copy the internal ID to the order so you can pull it to your saved search.

Beginner Answered on March 17, 2020.

Thank you for the answer to this posting–I am having the same issue.  What would the script for pulling the ID into the order look like?

on May 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor