updated retailer id ref