I tested it and this is the error I got when I tried to delete a record in the Sync table.
Error: You are not permitted to perform this operation because the table "table" (tbl~) has been configured to limit who can perform this operation
at main on line 5
Are you specifying the record ID of the product table instead of the record ID of Wholesale Products Sync table? Please check.