DECLARE @locale AS VARCHAR(25);

SET @locale = 'User!Language'

DECLARE @lcid AS INT;

SET @lcid = dbo.fn_LShortNameToLCID(@locale)

DECLARE @Machine_Class AS VARCHAR(25);

SET @Machine_Class = 'Server'

DECLARE @Vendor AS VARCHAR(25);

SET @Vendor = 'Microsoft'

DECLARE @Assignee AS VARCHAR(25);

SET @Assignee =...

you had better replace 'productID IN ' clause with 'exist ()', the performace will be better if so.

you must add  records which have been deleted at the subscriber server . because when running replication,  if have update operation or delete operation for some records at publish server and these records...