in odoo 11
i applied a script for importing products list to my database all is fine until now, but when i check articles menu in stock module or purchase i don't find any imported products even are in my database (i checked my db (product_template and product_product) all products exist)
script:
import csv
import psycopg2
conn_string = "dbname= 'db' user='vagrant' password='vagrant'"
conn = psycopg2.connect(conn_string)
cursor = conn.cursor()
reader = csv.reader(open('listArticles.csv', 'r'))
for row in reader:
print(row)
statement = "INSERT INTO product_template (name,default_code,list_price,type,categ_id,sale_ok,uom_id,uom_po_id,responsible_id,tracking,sale_line_warn) " \
"VALUES ('" +row[1]+"','" +(row[0])+"','" +(row[3])+"','" +(row[2])+"',1,True,1,1,1,'serial','no-message') RETURNING id"
cursor.execute(statement)
conn.commit()
templateid = cursor.fetchone()[0]
statement = "INSERT INTO product_product (product_tmpl_id,default_code,active) VALUES \
(" + str(templateid) + ",'" + row[0] + "',True)"
cursor.execute(statement)
conn.commit()