Frankie M Posted February 15 Share Posted February 15 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 Link to comment Share on other sites More sharing options...
ComGrafPL Posted February 15 Share Posted February 15 Not sure if product table carry specific carrier information. Faster would be use some mass edit module and do that that way. Link to comment Share on other sites More sharing options...
bera_ramazan Posted February 15 Share Posted February 15 hi view ps_carrier and ps_product_carrier table Link to comment Share on other sites More sharing options...
Frankie M Posted February 15 Author Share Posted February 15 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. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now