How to add a new category via MySQL

[Project Srl]

Hi All,

 

how can I add a new category via MySQL?

 

I just tried to add a new category manually filling 3 tables: ps_category; ps_category_group; ps_category_lang but in the backend this new manually added category don't have a "position" and i can't modify it and also this new category don't appear in the frontend category list.

 

Have I to modify others tables or fields?

 

Thanks in advance

 

Best Regards

 

 

Filippo

[vekia]

you have to add also entry to ps_category_shop table

[Project Srl]

Hi,

 

thank you for your reply.

 

I've tried to field also the ps_category_shop table but it seems doesn't work.

 

I filled the tables in this way:

 

ps_category_lang

- id_category => 17

- id_shop => 1

-id_lang => 1

 

ps_category_group

- id_category => 17

- id_Group => 1 - 2 - 3

 

ps_category_product

- id_category => 2

- id_product => 6

- position => 5 (I have another 4 categories add from the back end)

 

ps_category_shop

- id_category => 17

- id_shop => 1

- position => 5

 

Do you have any suggestion?

 

Thank you

 

Best regards

 

Filippo

Edited July 20, 2015 by Project Srl (see edit history)

[Project Srl]

Hi,

 

thank you. Now it works.

 

 

Best regards

[Project Srl]

Hi all,

 

I succesfully export categories from MSSQL db to prestashop MySQL db.

 

I have now the necessity to export also the sub-categories. I made a query that export all the necessary data from MSSQL, but when I click on a category in the front end I riceived the error 404 page not found.

 

I filled the tables :

 

- ps_category

- ps_category_shop

- ps_category_group

- ps_category_lang

- ps_category_product

 

Do I have to fill others tables?

 

Thank in advance

 

Filippo