[SOLVED]Integrating Products via ETL

[epartida]

Hello friends.

I´m integrating prestashop with and erp via an etl, I tested inserting products into ps_product and ps_product_lang tables and works fine,
the insertion is good and I can see the items in the tables.

Iḿ using from ps_product

id_product
ean13
quantity
price
reference

and from ps_product_lang

id_lang
name

But I can not see the products from prestashop, there is some another table to be use so can see the products?

Thanks

[rocky]

You must put the products in categories using the ps_category_product table.

[epartida]

OK, thanks, let me try.

What means the position in that table?

[rocky]

It is used to define the order that products will appear in the category. It should be 1 for the first product in the category, 2 for the second, etc.

[epartida]

OK

Thanks for your help Rocky

Greetings