BML Script to be able to get the duplicate product in the data table
Is there a way for me to be able to get the duplicate product in the data table and update the data in the row like its price using a BML script?
Currently I have this script:
results = bmql("SELECT item FROM Costs GROUP BY item HAVING COUNT(*) > 1; ");
for result in results {
update_count_integer = get(result, "records_updated");
}
return ""
// Retrieve items that need to be updated (where more than one product exists) but this script is not working when I try to check it in the BML Editor.
0