update product display nodes based on sku
I would like to update product display nodes with taxonomy terms based on the sku of the referenced product of each node.
Is that possible programmatically?
1) I know the sku.
2) I need to find the product by sku of a product display.
3) then I update the taxonomy term of the product display accordingly.
I tried to use EntityFieldQuery() to no success.
If someone could possibly give me an idea on the best approach to do this in DrupalCommerce, or provide urls to documentation I have missed, it is greatly appreciated. Lost a day or two asking Google the wrong questions apparently.
Thanks in advance,