#!/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;