Jump to content

Recommended Posts

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

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

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

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

post-891144-0-60061500-1449249916_thumb.jpg

Share this post


Link to post
Share on other sites

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 by TUFFNET (see edit history)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

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 by Nemo1 (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

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

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

  • Like 1

Share this post


Link to post
Share on other sites

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

Hello nemops,

 

Sadly no, the configuration is broken, I can't select any category  as you can see on this picture :

 

post-603134-0-18977700-1481311250_thumb.jpg

 

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

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

  • Like 1

Share this post


Link to post
Share on other sites

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

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 it works on 1.5.5+ but not with the old system

Share this post


Link to post
Share on other sites

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

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

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

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

Not, really, I am not planning new releases any time soon to be honest

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More