Insert new product in ps_product_shop in mySql

[kentcheung2000]

I successfully insert the new item in mysql using the following:

 

INSERT INTO cfpr_product_shop(id_product,id_shop, id_category_default, id_tax_rules_group, date_add, date_upd ) values('100', '1', '14', '0', '0000-00-00 00:00:00', ' 0000-00-00 00:00:00')

 

I check the mysql the product is there.  However, it is not showing up in the prestashop web site for products.  Is there anything I new to do other then that?

[tdr170]

You also need to insert into ps_product_lang, ps_product_shop, ps_category_product, and possibly others, it is easier to just enter from BO.

If you don't do lang you would need to enter the info from BO.

[Teapot Creative]

Hi there,

 

Is there any reason you are looking to add products via SQL queries?

 

Prestashop does have the capabilities of importing products via CSV which is both a quick and efficient means of adding products.

 

Ant.

[kentcheung2000]

Thank you for your reply.  My client would like to control everything from FileMaker, because the users are more used to the FileMaker interface.