moneeeka Posted September 15, 2013 Share Posted September 15, 2013 Hi, would just like to ask if there is a way to do a mass update of all the product's shipping carriers? I have 1,000++ products and I need to "Unselect All" of their shipping carriers so that no carrier is selected and for all the carriers to be used in shipping the product. Thanks! Link to comment Share on other sites More sharing options...
surin Posted September 16, 2013 Share Posted September 16, 2013 I Have same issue...can anybody guide us to "UNSELECT ALL" carriers for all products...i have 2500+ products to do... Is it prossible with sql command or through phpmyadmin. Link to comment Share on other sites More sharing options...
pkittle Posted July 17, 2014 Share Posted July 17, 2014 Hi - I just had a quick look at this one as I need to do this too - looks like the ps_carrier table can just be updated with the product number s- so you just need to do an insert into that table with carrier id and product id for each item Link to comment Share on other sites More sharing options...
AWR Posted August 28, 2016 Share Posted August 28, 2016 Guide to "UNSELECT ALL" carriers for all products Simply you have to access the db and empty the ps_product_carrier table (do not delete it). From phpMyAdmin run the SQL command: TRUNCATE TABLE ps_product_carrier (Note: first make a backup of the table). Link to comment Share on other sites More sharing options...
Recommended Posts