We're developing several automated sends that are going to use copy that's populated to certain criteria. The user data is indicated in the main sendable Data Extension, but based on a pre sale or post sale flag in Salesforce we will populate copy that exists in a separate Data Extension.
Person buys shoes and the color is red. Their purchase ID is tied to their Subscriber ID, but the SKU details are in a separate Data Extension. The Purchasing Data Extension contains only the Sub ID, the Purchase ID, purchase date and transaction details, email, and SKU. No details though of the product (as those live in the SKU DE)
How can I tie the SKU from that Data Extension into details for a send? I've seen a lot of examples of having data that's all tied to the Subscriber ID or Email but not to a different identifier that isn't system specific.