Change carrier ids related to products

[Frankie M]

Hi,

We are in the process of update our 1.6 shop to version 8.1.

We already have a lot of products in the shop and they will be migrated to the new version along with the carriers attached to those products.

We want to use another carrier module in the new version, but this module does not support old carrier ids. That is a bit of a problem. We have like 10 carriers for each product and if we need to do this manually it will take forever!

Is it possible to directly alter the table (which one?) that holds the products and carrier ids?

Example, we want all products that are having carrier with id 103 to be replaced with carrier id 163.

Can somebody please tell me what table to change in phpmyadmin and what the sql statement would like like?

Kind regards,

Frank

[ComGrafPL]

Not sure if product table carry specific carrier information. Faster would be use some mass edit module and do that that way.

[bera_ramazan]

hi view ps_carrier and ps_product_carrier    table

[Frankie M]

49 minutes ago, bera_ramazan said:

hi view ps_carrier and ps_product_carrier    table

Thanks! Found it. This is a correlation between id_carrier and id_carrier_reference.