Jump to content

[ps 1.5.2] items shown three times in shop


Recommended Posts

HI,

 

I'm working to get my shop (1.4.9) upgraded to 1.5.2 but are running into problems. Most I can fix, however, I'm stuck with this one:

 

all the items are show three times in the shop, while in the BO there are present only once. I've read this can be due to mulitple upgrade attemps (and this was the case primarily), but this time I've started from a backedup 1.4.9 shop and upgraded to 1.5.2 (manual procedure by transferring a local version) and executed the upgrade.php a single time.

 

Although the result of the upgrade script was a page of XML garbage (in Firefox), everything seems to be upgraded well and I can use the new funcionality.

 

How can I fix that my items show up three times? Is it in the database or in the code of the FO? I cannot detect anything weird in the database fields but I'm not sure how everything needs to be set.

 

Hope you can give me a clue.

 

Thanks.

Link to comment
Share on other sites

hi inijman, the problem that you're having could be a database issue. What I realized after updating my shop from scratch (fresh install + db imports) is that v.1.5.2 uses a shop feature to determine what is enabled/disabled for your current shop (in the case that you have multiple shops).

 

I suppose that somewhere along the way you import the products multiple times. The table in the database that handles the product listing is the category_product table. In this table you can possibly list the same item multiple times. Meaning you could have is listed once in your inventory but list it as many times as you want within different categories...This could be the problem, but it's hard to say.

 

I would suggest doing a fresh db import using the CSV Import tool (Back Office: Advanced Parameters > CSV Import). From there you can list your product in their default categories. It only allows one category per product. If you need to list them in multiple categories and it's too tedious to do you will need to do a direct db import into the category_product table of the phpMyadmin.

 

This is just a solution, but Im not sure what your probably actually is.

Link to comment
Share on other sites

hi,

 

thanks. I've looked into this table, but have equal rows as products so the triplication does not seem to originate from here.

 

I actually also tried a fresh install and a db import but it seems quite a bit has changes from 1.4.9 to 1.5.2 and importing a db from 1.4.9 into a 1.5.2 install went horrible wrong (several hook error messages everywhere).

 

Any other suggestions where to fix this? I have only ~40 items in the show so I could edit manually the table causing this. Or can I export the parts and re import them?

Link to comment
Share on other sites

  • 3 months later...

hi jessie and other friends

i had a problem just like yours in 1.5 upgrade and when i imported .csv files.

i tried to write a script to import product directly from my own mysql db to presta db, but the problem appeared so.

then i searched and searched and searched and not found any reason to this issue

but finally i found a solution which at least worked for me.

 

************ solution ************

table: ps_image & ps_image_shop

field: cover

this field should be (1) for first image of unique product and (0) for other images of that unique product.

if you set this field to (1) for all images of one product prestashop will be confused and the list of products will be overwritten by multiple cover image products.

pay attention that repetitions are equal to number of images.

 

************ solution ************

 

thanks in advance to all new ideas...

Link to comment
Share on other sites

×
×
  • Create New...