Stock Management showing wrong name

[Dionla]

Prestashop version 1.7.8.8

When creating products i would typically 'Duplicate' the product to create the next one.
after creating all my products i go back to the stock management but it seems to of kept the 'copy of' name and isnt updating the product name to match the actual product

how do i go about fixing this up so the product names show correctly in stock management

[jerome409]

Good evening I have exactly the same problem did you find a solution to this problem?

Thank you in advance for your answers

[musicmaster]

The ps_stock_available table doesn't store product names. So the most likely explanation is that you have a multi-language shop and that you changed the name only in one language.

[jerome409]

@musicmaster good evening, actually I had three languages at the time but two are only activated today, and I don't see where I can change the name of the product according to the Lang. Could you help me or give me a screenshot? screen please thank you very much I wish you a nice evening

[musicmaster]

In Prestashop 8 it is at the top of language specific fields:

In older versions it is at the side:

[Dionla]

i dont have any other language enabled other than english as far as i know, but i still have this issue

[jerome409]

@maître de musique Thank you but I don't have the same display as you and I can't change the language...

 

[jerome409]

@maître de musique I think the name is stored elsewhere because I don't see any other place for the "copy" only in stock management

[musicmaster]

3 hours ago, Dionla said:

i dont have any other language enabled other than english as far as i know, but i still have this issue

It doesn't matter whether a language is enabled. Even if it is disabled the option to set texts for it is there in the backoffice.

[musicmaster]

2 hours ago, jerome409 said:

@maître de musique Thank you but I don't have the same display as you and I can't change the language...

 

Seeing the picture makes me wonder whether you understood what I wrote.

[jerome409]

Il y a 2 heures, musicmaster a dit :

Seeing the picture makes me wonder whether you understood what I wrote.

yes I understood but I have no choice to change the language to modify the title, I activated another language to see and it doesn't change anything I have the option but in all languages I put the fair title but in stock the title of the product keeps the copy of

[musicmaster]

18 hours ago, jerome409 said:

yes I understood but I have no choice to change the language to modify the title, I activated another language to see and it doesn't change anything I have the option but in all languages I put the fair title but in stock the title of the product keeps the copy of

Obviously you have no other choice than looking straight in the database and finding out for which languages and shops the product still has the "copy of" name in the ps_product_lang table.

[jerome409]

@musicmaster sorry I'm a novice, where can I find this file?

[musicmaster]

1 minute ago, jerome409 said:

@musicmaster sorry I'm a novice, where can I find this file?

This is a database table. If you don't know how to find that you should hire support.

[Dionla]

18 hours ago, musicmaster said:

This is a database table. If you don't know how to find that you should hire support.

Yeah, i found my products in that table. they do have the 'copy of'.
What table has the original names in it so i can copy from. this table doesn't have the product name inside it only the product name to reference. 

[Dionla]

For anyone wondering on a script how to fix it

UPDATE `ps_product_lang` AS lang1
INNER JOIN `ps_product_lang` AS lang2
ON lang1.id_product = lang2.id_product
SET lang1.name = lang2.name,
    lang1.link_rewrite = lang2.link_rewrite
WHERE lang1.id_shop = 1 
  AND lang2.id_shop = 2
  AND lang2.name LIKE '%ENTER YOUR PRODUCT NAME HERE%';

Entering the product name will only update those products, saves you updating your entire database.
As mentioned you will be modifying your DB, so take a backup and take care when doing so

[jerome409]

Hello, is there anyone who speaks French who could help me? I still have this problem with the copy and also articles which do not have a name in the stock tab...