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.
try address.id and address.internalid
Thanks for the help. Good idea. I have tried ‘address.id’ and ‘address.internalid’ and neither of those worked. Any other suggestions?
Address records have 2 ID fields. The one you want is named Address Internal ID in search columns. {shippingaddress.addressinternalid}
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.
Ok, new information: If I run a customer search, then {shippingaddress.
Any ideas why that is?
I’m not sure that you can get the address internal id from transactions. Its not a field in the shipping address join.
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?
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.
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?
