[SOLVED] unique problem regarding catgagories

[aeoufashion]

Hi I have a unique problem coming up please help me am new to prestashop

 

-yesterday i was adding a main catagory on my site

-it was in name of designer dress

-when i was adding it through catalog>catagories

it gave me and error thrice

and then suddenly an existing catagory called apparel got vanished completely.

-Then i went to my shop and a blank page was coming

-I searched for problem on forum and got to know about adding a code which displays error

-from there i came to know about the error was in my topmegamenu module

-I went to that module and deleted the designer dress catagory which gave me error thrice while i -was creating it.

-The site started working again

BUT NOW

my existing catagory called apparel is gone with its sub catagories and while clicking on another catagory the designer dress catagory comes up on product page(on shop/website) as Home>jewelry>designer dress.....

now the products were in the catagory that was gone called apparel and should not be in this catagory and the catagory designer dress is not showing up in Catalog> catagory (in back office)

 

am very much confused i want to remove this designer dress catagory and how can i manage the database in an easy format?????

 

please help

 

my site is http://aeou.x10.mx

i can give access to back office please help me

 

just to avoid any confusion i had again added that apparel catagory from scratch

 

thanks and warm regards

Vaibhav

Edited July 27, 2013 by aeoufashion (see edit history)

[aeoufashion]

somebody help me also !!!!

[aeoufashion]

I am stuck....what to do ???

[vekia]

I checked your website but i don't understand where the problem is. Menu and whole added links to the menu works well

[aeoufashion]

hi vekia thanks for taking out ur precious time and helping me out, i am attaching a screenshot of my problem to pin point it.

 

hope this explains

thanks a lot

[aeoufashion]

and this problem is creating a category called designer dress which dosnt even exist and it is associated with jewellery main category

[aeoufashion]

also i want to remove all the options from this default category menu, as some of the options didnt even exist above

[aeoufashion]

I checked your website but i don't understand where the problem is. Menu and whole added links to the menu works well

 

hi vekia thanks for taking out ur precious time and helping me out, i am attaching a screenshot of my problem to pin point it.

 

hope this explains

thanks a lot

Edited July 29, 2013 by aeoufashion (see edit history)

[swsindonesia]

Hi, I think I get a glimpse of what your problem is. I tried to visit your "Jewelry" category and found apparels products in it.

I think the best way to clean up your messy category structure is to look at your database tables

WARNING: BACKUP your entire database before following my recommendation

 

1. open ps_category_lang (write down all the id_category of all your unwanted categories)

2. delete from ps_category_lang where id_category IN (x,x,x,x)

3. delete from ps_category where id_category IN (x,x,x,x)

4. delete from ps_category_product where id_category IN (x,x,x,x)

5. update ps_product set id_category_default = NULL where id_category_default IN (x,x,x,x)

 

change x to you unwanted id_category

 

those sql commands should clean up all your unwanted culprits by deleting them. Please use with extreme caution if you're not very sure about what you're about to do. AS IS note: I hold no responsibility for any damage that may be caused.

Edited July 29, 2013 by swsindonesia (see edit history)

[aeoufashion]

Hi, I think I get a glimpse of what your problem is. I tried to visit your "Jewelry" category and found apparels products in it.

I think the best way to clean up your messy category structure is to look at your database tables

WARNING: BACKUP your entire database before following my recommendation

 

1. open ps_category_lang (write down all the id_category of all your unwanted categories)

2. delete from ps_category_lang where id_category IN (x,x,x,x)

3. delete from ps_category where id_category IN (x,x,x,x)

4. delete from ps_category_product where id_category IN (x,x,x,x)

5. update ps_product set id_category_default = NULL where id_category_default IN (x,x,x,x)

 

change x to you unwanted id_category

 

those sql commands should clean up all your unwanted culprits by deleting them. Please use with extreme caution if you're not very sure about what you're about to do. AS IS note: I hold no responsibility for any damage that may be caused.

 

Hi SWSINDONESIA

 

thanks for your help , this seems to help me, but i am fairly new to all this so can u please guide me how to reach these database tables and edit them.

 

thanks again

[benjamin utterback]

Hi SWSINDONESIA

 

thanks for your help , this seems to help me, but i am fairly new to all this so can u please guide me how to reach these database tables and edit them.

 

thanks again

 

First to back up! You need to go to your Cpanel, then find phpMyadmin. From there you can see the databases you have installed and named. You can click on that database and find the "Export" tab. Make sure to export all tables.

 

Do you use an FTP program? You should also back up your PrestaShop files.

[aeoufashion]

Hi, I think I get a glimpse of what your problem is. I tried to visit your "Jewelry" category and found apparels products in it.

I think the best way to clean up your messy category structure is to look at your database tables

WARNING: BACKUP your entire database before following my recommendation

 

1. open ps_category_lang (write down all the id_category of all your unwanted categories)

2. delete from ps_category_lang where id_category IN (x,x,x,x)

3. delete from ps_category where id_category IN (x,x,x,x)

4. delete from ps_category_product where id_category IN (x,x,x,x)

5. update ps_product set id_category_default = NULL where id_category_default IN (x,x,x,x)

 

change x to you unwanted id_category

 

those sql commands should clean up all your unwanted culprits by deleting them. Please use with extreme caution if you're not very sure about what you're about to do. AS IS note: I hold no responsibility for any damage that may be caused.

 

Thanks buddy - problem solved!!

 

i went to my hosting's control panel and from php admin i ran sql queries that you gave and it cleared up the mess..

 

Thanks for your help!!

cheers!

 

First to back up! You need to go to your Cpanel, then find phpMyadmin. From there you can see the databases you have installed and named. You can click on that database and find the "Export" tab. Make sure to export all tables.

 

Do you use an FTP program? You should also back up your PrestaShop files.

 

yeah did it !!!

thanks

[benjamin utterback]

Awesome, I'm glad that we could help. Could you please let us know how you ran the SQL queries? This will help other merchants who encounter a similar problem.

[aeoufashion]

Well here is how i ran the commands

 

1) Went to my hosting control panel and clicked on phpMyAdmin in the database section

2) it opened and on the left column was the name of my store's database

3) i clicked on it and it opened the page with all the tables

4) from there i searched ps_category_lang and clicked on it

5) it opened on a new page and there were all the contents of it .

6) then i searched through the list to find the unwanted category name and noted its category number

7) then i clicked on sql tab from the above listed tab

8) there i copied the commands one by one and clicked go

 

thts it!!!!

cya

[benjamin utterback]

Awesome! That is a clear tutorial. This will definitely help other merchants in the long run as they come across this post. I'll go ahead and mark this thread as SOLVED. Happy Selling!

[aeoufashion]

Thank u all for ur help nd support.....

 

 

 

Warm regards

Vaibhav frm India

[swsindonesia]

Glad that helped you, best of luck with your site!

 

a little click on "like this" wouldn't hurt