Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
2996 Prikazi

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()
Avatar
Opusti
Best Answer

Hi,

Check and see whats the value in the field active, you  might not see the records as the active field might be set to False.

Go to Products view and select the Archived Filter and see,


Thanks

Avatar
Opusti
Avtor

Hi Niyas

yes i found the products but i want to know why are archived

In your scrypt set active field as True

Avtor

thank you

Related Posts Odgovori Prikazi Aktivnost
1
apr. 25
1050
2
avg. 24
3113
1
avg. 22
2691
0
sep. 18
3429
1
avg. 24
8526