cmugume 1 Posted September 11, 2013 Hello all, I signed up a new shipping carrier to my store but I have over 1000 items in store, what do I do to have the new carrier showing up with the old one without editing each product to unselect all/select all under shipping? Thanks Share this post Link to post Share on other sites
NemoPS 1,879 Posted September 11, 2013 Hi, Carriers are usually available for all products, unless you specifically deselect them from each product page Share this post Link to post Share on other sites
cmugume 1 Posted September 11, 2013 My problem was when I entered the items we selected the only carrier that we had at the time, so the new carrier is not selected for those items. Stupid error we made, should have not selected so new carriers are available for the products Share this post Link to post Share on other sites
lucav87 1 Posted December 4, 2015 Hello, i have the same problem... it's possibile delete all carrier or add in all production another carrier? use prestashop 1.6.1.3 see the attachment. Thanks and sorry for my bad english Share this post Link to post Share on other sites
NemoPS 1,879 Posted December 5, 2015 Ctrl+click and select multiple Share this post Link to post Share on other sites
TUFFNET 0 Posted January 13, 2016 (edited) Same problem.. i have 1000 products and 4 carriers. Now i need add 1 new carrier. How i can add this new carrier to all products?? edit: prestashop 1.6.1.3 Edited January 13, 2016 by TUFFNET (see edit history) Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 15, 2016 You can run a query like $data = array( 'id_product' => (int)$id_product, 'id_carrier_reference' => (int)$id_carrier, 'id_shop' => (int)$id_shop ); Db::getInstance()->insert('product_carrier', $data, false, true, Db::INSERT_IGNORE); I didn't test it, but anyway make sure you replace variables. Backup the table before 1 Share this post Link to post Share on other sites
TUFFNET 0 Posted January 16, 2016 Sorry im noobie.. dont know how replace variables. i know new carrier is id6, shop is id1, and products from id8 - id1032 so i need add carrier id6 to all products Share this post Link to post Share on other sites
bala.k@fapworld.ae 0 Posted January 17, 2016 Guys please talk in english...Prestashop was designed to help normal users setup their stores up and running, Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 18, 2016 @bala.k: Then the short answer is: you can't. Share this post Link to post Share on other sites
TUFFNET 0 Posted January 18, 2016 Nemo1 Can you help little more please? or some mysql query? Share this post Link to post Share on other sites
bala.k@fapworld.ae 0 Posted January 18, 2016 @bala.k: Then the short answer is: you can't. Super - Why dont you guys do something bout that - if I have 5000 Products of which 2000 are available in Country X where I have tied up with a carrier of that country - What do I do?? Opening all 2000 products and adding the carrier - Does not seem logical solution and its very time consuming. Adding to that I am not a programmer..Appreciate if some one develops a patch or something. Thanks Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 20, 2016 (edited) Super - Why dont you guys do something bout that - if I have 5000 Products of which 2000 are available in Country X where I have tied up with a carrier of that country - What do I do?? Opening all 2000 products and adding the carrier - Does not seem logical solution and its very time consuming. Adding to that I am not a programmer..Appreciate if some one develops a patch or something. Thanks You? Who? I am not in the prestashop team, otherwise I would. If you are happy to pay for a premium addon, it's another story, since "we guys" are contributors. @Tuffnet: I will hopefully come up with a tutorial one of these days Edited January 20, 2016 by Nemo1 (see edit history) Share this post Link to post Share on other sites
TUFFNET 0 Posted January 20, 2016 Hi i solve my own problem with dumbing ps_product_carrier.sql and .csv then removed dublicates from colum1 and then chanced that colum2 where are carrier id to new. then save it 2.csv open ps_product_carrier.sql with notepad++ added that 2.csv with copypaste + little edit. then added it back to mysql.Hopely some day there will be easyer to add bulk carrier Share this post Link to post Share on other sites
bala.k@fapworld.ae 0 Posted January 20, 2016 Hi i solve my own problem with dumbing ps_product_carrier.sql and .csv then removed dublicates from colum1 and then chanced that colum2 where are carrier id to new. then save it 2.csv open ps_product_carrier.sql with notepad++ added that 2.csv with copypaste + little edit. then added it back to mysql. Hopely some day there will be easyer to add bulk carrier mmm, Thanks Will try this out. Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 22, 2016 I am actually working on a free module to do it, it will be out next week Share this post Link to post Share on other sites
bala.k@fapworld.ae 0 Posted January 23, 2016 I am actually working on a free module to do it, it will be out next week Great, Thanks Share this post Link to post Share on other sites
TUFFNET 0 Posted February 2, 2016 heh.. now need add carrier it again.. have nemo1 you make that module? Share this post Link to post Share on other sites
NemoPS 1,879 Posted February 3, 2016 Oh, yes http://store.nemops.com/free-modules/43-carrier-assigner-free-module.html#.VrHObrI4Hmh 5 2 Share this post Link to post Share on other sites
TUFFNET 0 Posted February 3, 2016 Thank you! i will test it in thisweek. Share this post Link to post Share on other sites
TUFFNET 0 Posted February 4, 2016 Working fine! just wondering, no remove option.. Share this post Link to post Share on other sites
NemoPS 1,879 Posted February 5, 2016 Yes, I might add that and other options (like csv uploads) o a PRO version Share this post Link to post Share on other sites
Roxter 0 Posted May 16, 2016 Many Thank You's for doing this and making it free Nemo1. Share this post Link to post Share on other sites
Fab20620 4 Posted August 25, 2016 Thanks a lot, it's a time saver.If someone is looking for a simple solution to remove any existing carrier from products (in order to make all carrier available for shipping selection), you just have to empty the product_carrier sql table.YOURDBPREFIX_product_carrier 1 Share this post Link to post Share on other sites
etelefonro 1 Posted September 27, 2016 Nemo ! you saved me and many other , thank you. this module verry big time saver 1 Share this post Link to post Share on other sites
KevinNash 119 Posted December 7, 2016 Hello Nemo, I see that your huge time saver module is for PS 1.6, can it be modified to work on PS 1.5.4.1 easily ? I thank you in advance Share this post Link to post Share on other sites
NemoPS 1,879 Posted December 9, 2016 You should be able to use it on that version already Share this post Link to post Share on other sites
KevinNash 119 Posted December 9, 2016 Hello nemops, Sadly no, the configuration is broken, I can't select any category as you can see on this picture : I also tried to add a carrier to a product with the product number and I got this error message : [PrestaShop] Fatal error in module AdminController:Class name must be a valid object or a string Can you take a look to make it 1.5 compatible ? Share this post Link to post Share on other sites
Jignesh.aakoliya 5 Posted December 13, 2016 Hi Nemo,Big thanks for you efforts. Just install your free module to my upgraded shop and this works like charm.it helps me to add new career in 500+ product in few minutes.Thanks 1 Share this post Link to post Share on other sites
wojtek992 1 Posted April 17, 2017 NemoPS you are my best friend now THANKS a lot 1 Share this post Link to post Share on other sites
massimomassimo 1 Posted August 12, 2017 Today (2017 August 12) I try on Prestashop 1.6.1.10. With category it works quite fine as far I can see. Eventually I will update. Thank you! Share this post Link to post Share on other sites
pietro 7 Posted October 17, 2017 Oh, yes http://store.nemops.com/free-modules/43-carrier-assigner-free-module.html#.VrHObrI4Hmh you saved the day, thank you Nemo! Share this post Link to post Share on other sites
Enthu86 0 Posted January 24, 2018 Hi Nemo, Working perfect. Can I enquire if it's possible that when I assign a carrier for a specific product using your module, it will not be available for other products? I am facing this issue, and I am unsure how to overcome it at all. No features or configuration to achieve this. Share this post Link to post Share on other sites
ANGELO Vintage 11 Posted July 11, 2018 very usefull module, should be great to add a new field like: ADD/REMOVE so you can choose what kind of operation you need to do in a partocular product or category, it will be super easy to remove carriers too Share this post Link to post Share on other sites
KevinNash 119 Posted July 11, 2018 Hi Nemo, can you adapt this module for PS 1.5 ? Share this post Link to post Share on other sites
NemoPS 1,879 Posted July 21, 2018 @KevinNash it works on 1.5.5+ but not with the old system Share this post Link to post Share on other sites
KevinNash 119 Posted July 21, 2018 Thank you NemoPS. Sadly I am on PS 1.5.4.1 and I can't upgrade because of tons of core modifications he he. I suppose you can't adapt the module for version under 1.5.5 ? Share this post Link to post Share on other sites
estorde 3 Posted October 16, 2018 On 3/2/2016 at 10:52 AM, NemoPS said: Oh, yes http://store.nemops.com/free-modules/43-carrier-assigner-free-module.html#.VrHObrI4Hmh Thank you so much for your effort and time invested on solving this issue Nemo. All the best Share this post Link to post Share on other sites
borisdifiore 2 Posted October 19, 2018 Hi Nemo, is it possible to have multiple choice in carrier selection input? I would like to assign more then 1 carrier each time to all products. Thank you Boris Share this post Link to post Share on other sites
NemoPS 1,879 Posted October 20, 2018 Well not as it is, you'd have to edit the method and loop through an array instead of using a single value (it's enough to set the multiple attribute for the select box, then edit the postProcess method Share this post Link to post Share on other sites
borisdifiore 2 Posted October 22, 2018 On 10/20/2018 at 4:31 PM, NemoPS said: Well not as it is, you'd have to edit the method and loop through an array instead of using a single value (it's enough to set the multiple attribute for the select box, then edit the postProcess method Thank you Nemo, unfortunately my php programming capacities are not enough to implement your suggestion. Share this post Link to post Share on other sites
majesty3 0 Posted January 24, 2019 Hello everyone. Can some1 reshare this module here? I've tried to download it from nemo's store but the site is offline for some time now. Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 25, 2019 The site is available again Share this post Link to post Share on other sites
majesty3 0 Posted January 25, 2019 Wonderful news Thank you for info and this module, sir! Share this post Link to post Share on other sites
majesty3 0 Posted January 25, 2019 8 hours ago, NemoPS said: The site is available again I have one question though. Is there (or will be) a version of this module which allows to add carriers by manufacturer or supplier? Share this post Link to post Share on other sites
NSN 23 Posted January 25, 2019 If you need more flexibility in assigning carriers you might take a look at the Prestools suite and buy the carrier plugin for it. https://www.prestools.com/prestools-suite-plugins Share this post Link to post Share on other sites
NemoPS 1,879 Posted January 26, 2019 Not, really, I am not planning new releases any time soon to be honest Share this post Link to post Share on other sites
djaychela 1 Posted October 31, 2019 Nemo - thanks for the plugin - just saved me hours of work! It seems to work fine on Prestashop 1.7.6, for the record (site says only 1.6). 1 Share this post Link to post Share on other sites
timoraes 0 Posted December 28, 2019 I changed the association of products and carriers directly in db, but the changes I made do not appear in the store. The information in the table is correct. How do I get prestashop to update the data I entered directly in db? It seems that this is a recurring problem. Share this post Link to post Share on other sites
NemoPS 1,879 Posted December 30, 2019 what's your prestashop version? Share this post Link to post Share on other sites
cardetailacores 1 Posted February 11, 2020 (edited) Nemo you are a GOD , thank you alot. Saved my life in 2020 Edited February 11, 2020 by cardetailacores (see edit history) 1 Share this post Link to post Share on other sites
dolec 0 Posted March 24, 2020 I dont see all carriers despite they are active some help? Share this post Link to post Share on other sites
Dhruv Patel 1 Posted April 10, 2020 On 3/24/2020 at 5:36 PM, dolec said: I dont see all carriers despite they are active some help? Have you added specific configurations in carrier like weight, amount, etc.? If yes then check those products which suitable your configuration to particular carriers. Share this post Link to post Share on other sites
NemoPS 1,879 Posted April 11, 2020 using ASM? If so check that they are selected in the carriers list for each warehouse Share this post Link to post Share on other sites
celiag 0 Posted April 22, 2020 On 2/3/2016 at 9:52 AM, NemoPS said: Oh, yes http://store.nemops.com/free-modules/43-carrier-assigner-free-module.html#.VrHObrI4Hmh Thanks Nemo! Just installed and works fine. Still have to update for a dozen categories, but better than for thousands products. Share this post Link to post Share on other sites
chagui900 11 Posted May 12, 2020 hola, alguien sabe decirme si funciona con la ultima version 1.7? este modulo es justo lo que necesito Share this post Link to post Share on other sites