How I can insert directly into a product database prestashop?

[faccr]

I need to share data from a firebird's DB to prestashop.

I do all the functions in the php (outside prestashop) and imported to prestashop's DB.
Although the data are entered into the database, the products do not appear in the "BO". When I click tracking, the products appear as out of stock.
How I can insert directly into a product database prestashop?
Another question: how to create a "url-rewrited"to be inserted directly into the database?
Thanks!

[sam.bengtson]

Yeah I have the same question..products not showing up in the back office after manually inserting products in the database. Anyone have an answer?

[faccr]

I found out what the problem is. You must fill in all fields of the tables "product", "product_lang"and "category_product. Studying a product already on the prestashop you will see the required fields.

If you do not create the link in the table "category_product"your product does not appear anywhere.

For the search function, you should consider two more tables: "search_index"and "search_word.

Just not yet discovered the function of the column "weight"on table "search_index. I'm using the value 6 as my default.