Can't change carriers: Ranges are overlapping

[Smiles]

I have a problem with my carriers after my update from 1.4.7.0. to 1.6.0.9. I cant change them im stuck in the first screen/tab with the message: Ranges are overlapping.

Found two other topics without solution….

 

https://www.prestashop.com/forums/topic/327296-range-overlapping-problem/

https://www.prestashop.com/forums/topic/340575-ranges-are-overlapping-with-changing-carrier-options/

 

And a bug report: http://forge.prestashop.com/browse/PSCSX-3468

[giasemis]

you can resolve this through myphpadmin directly
go to the ps_range_weight table of your prestashop installation and correct the overlapping there

[Valentina Calzature]

On 5/7/2016 at 9:18 AM, giasemis said:

you can resolve this through myphpadmin directly
go to the ps_range_weight table of your prestashop installation and correct the overlapping there

Hello, I did that, but after doing so the carrier is not showing anymore in back office. it still works, as the shippings are correctly calculated in the orders.

It was carried ID 152, now in back office I see only carrierd id 153, but empty. The ID 152 is correctly showing and working in phpmyadmin. How can I make it show in prestashop back office?

Thanks!

[TCB-Netherlands]

On 12/28/2020 at 9:38 AM, Valentina Calzature said:

Hello, I did that, but after doing so the carrier is not showing anymore in back office. it still works, as the shippings are correctly calculated in the orders.

It was carried ID 152, now in back office I see only carrierd id 153, but empty. The ID 152 is correctly showing and working in phpmyadmin. How can I make it show in prestashop back office?

Thanks!

You have to correct the overlapping Delimiter 1 and 2. If this is not working, Truncate all carrier tables in db including the ps_range_weight. This helpt for me and all is working fine now. No new errors.

[REVOIR]

Hello,
I'm having the same problem.  One of my carriers is not allowing me to make changes.  I have changed the ps_range_weight in the db so there are no overlaps, but it is still not working.  Attached are screen grabs of my problem.  Any ideas on how I can resolve this?

Thanks in advance for any help,
Jim

[ps8modules]

Try to delete the carrier and create a new one.

[REVOIR]

3 minutes ago, WebSoft said:

Try to delete the carrier and create a new one.

I'm trying to avoid doing this as I have over 1000 products and I think I would need to manually associate this to almost every product, as I have selected carriers for certain products.  Do you know of another work around to have the carrier added to all products?

[ps8modules]

I don't see a problem with that.
If you know what ID carrier you will delete.

[ps8modules]

Look in the ps_product_carrier table.

There you have all the carriers assigned to the products.

id_carrier_reference = id_carrier

Edited September 29, 2021 by WebSoft (see edit history)

[REVOIR]

2 minutes ago, WebSoft said:

I don't see a problem with that.
If you know what ID carrier you will delete.

The problem is not with deleting the old carrier, the problem would be associating the carrier with every product.  If I understand correctly, a new carrier would be placed in the "Available carriers" box in the product's "Shipping" settings.  As I use many different carrier combinations for different products, I use the  "Selected carriers" box.  I would have to go through all of my products manually moving the new carrier to the "Selected carriers" box, no?

[REVOIR]

9 minutes ago, WebSoft said:

Look in the ps_product_carrier table.

There you have all the carriers assigned to the products.

id_carrier_reference = id_carrier

Here are the references that I have.  They don't seem to match up.  Any reason why I'm not seeing the id_carrier 432

[ps8modules]

Open a product in the administration and check if a carrier is assigned.

[REVOIR]

Ah.  I'm a dope.  Didn't realize there were so many php entries.  Fixed the overlap.
Thanks for your help at any rate.

[link2badar]

what is the table name in ps 1.6?