RE: 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.

RE: Address Ship to Internal ID in saved search

yoantny Rookie Asked on March 10, 2020 in Saved Searches.
Add Comment
3 Answers

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.