#!/bin/bash for i in $(cat codigosyreferencia.csv) do referencia=$(echo $i | awk -F, '{print $1}') codigobarras=$(echo $i | awk -F, '{print $2}') echo "update public.product_product SET barcode='$codigobarras' where default_code='$referencia';" done
As postgres:
psql alejandrogomez < product_barcode.sql
Change product type:
update product_template SET type = 'product';
Enable available in POS:
update product_template SET available_in_pos = true;