script.sh

# Construct query with first column as STOREID, and rest of the columns are inside an WHERE IN list
awk 'BEGIN{FS=",";OFS=",";}{gsub(/[[:blank:]]+/,","); storeid=$1; $1=""; print "UPDATE STOREITEM SET replenish_status = \"N\" WHERE COMPANYID = 1795 AND STOREID = "storeid" AND ITEMID IN ("substr($0, 2)");"}' file.csv

# Example Output Queries
# UPDATE STOREITEM SET replenish_status = 'N' WHERE COMPANYID = 1795 AND STOREID = 1749 AND ITEMID IN (118469,117677,118233,.....);