Update new brand in several product tables

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/

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.

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.

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 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

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

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>Import menu.

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

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/ for the column file_name of the table hikashop_file where the images data is stored.