Hi, Does this code look OK? Basically it checks if the code exists, compares two prices and update a field with the lowest, for all products in the system.

Thanks Matt

do as server
for i in select Products do
let mySKU := i.SKU;
let myAUSale := i.'AU Price Amazon (AUD) Sale';
let myAUNorm := i.'AU Price Amazon (AUD)';
let myAUUpload := i.'AU Price Amazon Import (AUD)';
if first(select Products where text(SKU) = i.mySKU) != null then
if myAUSale > 0 then
myAUUpload := myAUSale
else
myAUUpload := myAUNorm
end
end
end
end