Jump to content

How I can insert directly into a product database prestashop?


faccr
 Share

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More