[Skip to main content](#vessel-content)

#   Update new brand in several product tables

##

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago [\#343346](#343346) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343346 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")* was created by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")*

-- HikaShop version -- : 4.6.1
-- Joomla version -- : 3.10.10
-- PHP version -- : 7.4.30
-- Browser(s) name and version -- : FF 102.0.1

Hi Nicolas,

I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.:
*Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image*

- Export all products to CSV via export on products page
- Delete all product and columns of products not being changed in CSV
- Change the name in the right cells
- Import CSV via mass action

Is the way described above right and which import action do I have to use?

Thanks in advance!!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

4 years 3 months ago [\#343348](#343348) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343348 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi,

You can do it like that yes. You should use the filter "CSV products".

Note however that you can also easily do it through your PHPMyAdmin, and not just for products in HikaShop but for anything stored in the database:
[ bobcares.com/blog/find-and-replace-in-phpmyadmin/](https://bobcares.com/blog/find-and-replace-in-phpmyadmin/)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago [\#343363](#343363) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  Replied by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343363 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Thanks Nicolas,

Will the alias be changed automatically when changing the name of the product, change it in the CSV to be imported or does it have to be cleared like the canonical url with a mass action?

Thanks,
Remco

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

4 years 3 months ago [\#343366](#343366) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343366 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi,

No, if you change the name of the product with the CSV import, it won't automatically change the alias. You need to also include the new alias in the CSV.
Also, note that you can't change the product_code of your products with that method. That's because the import system relies on the product_code to update the products you already have.
If that's necessary, then the only possible solution would be the one through PHPMyAdmin I was proposing as second solution in my previous message.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago -  4 years 3 months ago [\#343380](#343380) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  Replied by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343380 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi Nicolas,

- Just a question because I'm interested ![:-)](/media/kunena/emoticons/9.png ":-)") Why does the import system relies on the product\_code instead of the product\_id?
- Ooh and.....is changing the image title and alt possible via import? Can't find the cells in the product export.
- And last, but not least ![;-)](/media/kunena/emoticons/14.png ";-)") What does the option "Save the products on Mass Action csv import" exactly mean?

Cheers,
Remco

Last edit: 4 years 3 months ago by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

4 years 3 months ago -  4 years 3 months ago [\#343381](#343381) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343381 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi,

1. Because the product_id is auto incremented and can change from one website to another. Like when people are migrating their shop from one joomla to another joomla and they do the import several times while modifying their CSV in between.

2. You can use the column images_name in your CSV to add the image name which will be used as title/alt

3. If you don't tick that option "Save the products on Mass Action csv import" it will just load the products data from the CSV and if you don't have any action in the mass action, nothing will happen. But with that option ticked, it will update/add the products in the database after loading the information from the CSV even without any action.

Last edit: 4 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago -  4 years 3 months ago [\#343405](#343405) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  Replied by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343405 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi Nicolas,

Thanks for all the info! Just a last question: Is there a difference between the mass action we discussed and the import function at the product page or are they different ways to the same result?

BTW column images_name didn't work to change the title and alt for the product images!

Cheers,
Remco

Last edit: 4 years 3 months ago by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 654
-
-

4 years 3 months ago -  4 years 3 months ago [\#343414](#343414) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343414 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hello,

Yes, MassAction and Import function are quite different process but can leads in some case (like yours) to the same results (create and update).

For your column **images\_name**, in order to check, can you provide your used CSV file ?
**Note :** If required, you can use our **[ Contact us](https://www.hikashop.com/support/contact-us.html)** form to provide your CSV file, just don't forget to add an **Url link to this topic** in order to keep the link.

Regards

Last edit: 4 years 3 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 654
-
-

4 years 3 months ago [\#343448](#343448) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343448 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

From what you sent, we weren't able to see your image reference, see my screenshot as an example, and note that in your product listing you can create a CSV by clicking on the button "export" in your Backend product listing.

Hope this will help you to achieve your needs.
Regards

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago [\#343507](#343507) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  Replied by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343507 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi Philip,

The CSV file I've sent you was a stripped down version of an export from the product listing. The same as the CSV file you've sent me by mail. But also in your CSV I didn't find the column "images_name" what was suggested to me by Nicolas:
*2. You can use the column images\_name in your CSV to add the image name which will be used as title/alt*.
Also I don't see a screenshot with your last response.
So what to do with an CSV import to add image title and alt?
Cheers, Remco

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

4 years 3 months ago [\#343526](#343526) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343526 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi,

As I said, you can just add a column images_name to your CSV with the value in it for the image you have in the images column.
The rest should be automatic during the import via the Products&gt;Import menu.

Unfortunately, the CSV import from the mass action system doesn't support that capability.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")**
- [![RustyHika's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33482-rustyhika "View RustyHika's Profile") Topic Author
- [ Offline](/forum/user/33482-rustyhika)

Less More

- Posts: 94
- Thank you received: 2
-
-

4 years 3 months ago [\#343539](#343539) by [RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")  Replied by *[RustyHika](/forum/user/33482-rustyhika "View RustyHika's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343539 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi Nicolas,

I didn't use the import, but mass actions....and didn't use the "images" column, because I thought the import relies on the "product_code" column. Can this be the cause of the failing import of the "images_name" column?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

4 years 2 months ago [\#343546](#343546) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update new brand in several product tables](/forum/37-import-export-csv-xls/904754-update-new-brand-in-several-product-tables#343546 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 3.10.10 -- PHP version -- : 7.4.30 -- Browser(s) name and version -- : FF 102.0.1  Hi Nicolas,  I searched the forum, but couldn't find a best practice for updating a changed brand name in several, but not all products.: Name / Product Code / Page Title / Meta description / Alias (skip because created from product code?) / Image Name / Image  &#42; Export all products to CSV via export on products page  &#42; Delete all product and columns of products not being changed in CSV  &#42; Change the name in the right cells  &#42; Import CSV via mass action  Is the way described above right and which import action do I have to use?  Thanks in advance!!")*

Hi,

Yes. As I said in my last message, the images_name column will only be taken into account for the import, it won't work with a mass action. And it also requires the "images" column to be present in the CSV (otherwise the system doesn't know which image name correspond to which image of the product (since a product can have several images))

So to update a brand name in the title/name of images of products, I think the best will be to do it via PHPMyAdmin.
It's actually quite easy. You can follow the instructions at [ bobcares.com/blog/find-and-replace-in-phpmyadmin/](https://bobcares.com/blog/find-and-replace-in-phpmyadmin/) for the column file_name of the table hikashop_file where the images data is stored.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ3NTQtdXBkYXRlLW5ldy1icmFuZC1pbi1zZXZlcmFsLXByb2R1Y3QtdGFibGVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.433 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
