Jump to content

Wrong Carrier ID lists for Shipping Price and Weight Ranges versus IDs listed on Carrier list


Recommended Posts

BASE INFO:

PS Version = 1.5.3.1.

OS = Centos.

Install method = Past installation using WHW1 cpanel prestashop instant install.

If you want more info on the hosting provider, or the server resources, versions of PHP, perl, or other technical info, then please ask.

To head off comments suggesting upgrade.  Not interested in upgrading to 1.6.
 

PROBLEM:

After adding my own carriers and installing UPS and USPS, and then uninstalling UPS and USPS modules and deleting all the Price Ranges and Weight Ranges prior to uninstall, and even going into DB and removing what I could find for listing no longer existing carrier, and removing my carriers, then Prestashop still references older IDs once UPS or other carrier module are installed. I have attached an image of the Carrier list, and the Price Ranges page.  As you can see the Price Ranges list shows IDs from  89 to 99.  The Carrier list shows IDs from 103 to 113.

It seems regardless me uninstalling the modules, somehow the last IDs used is retained somewhere and re-install of the UPS or other carrier module starts the carriers from the next high number, instead of recycling the old ID numbers, but this is not reflected properly on the Price and Weight range lists.  Obviously, I have not been able to locate all the entries in the database for removal.  I can live with PS not recycling the past carrier ID numbers IF PS used the same IDs in the Price Ranges and Weight Ranges.  Meaning if the carrier IDs shown on the Price and Weight Ranges pages matched the IDs shown in the Carrier's list, then that would be fine, I think.

QUESTIONS:
How can I have the Shipping Price and Weight Ranges IDs listed match those listed in the Carrier list?
How can I have PS start from scratch on the carrier ID numbers when a carrier module gets installed?

What other database tables do I need to clear or look at, other than the following, "ps_carrier, ps_carrier_group, ps_carrier_lang, ps_carrier_shop, ps_carrier_tax_rules_group, ps_carrier_zone"? 

What database tables are used by the Prestashop back office Price Ranges page to determine the Carrier IDs when a carrier module like UPS carrier or USPS Carrier are installed?

 

 

IMAGES ATTACHED

Carrier list page.

Price Ranges page.

Weight Ranges page.

ps_carrier listed via phpMyAdmin after all entries were first deleted and then a new carrier added and then UPS carrier module re-installed.

 

post-762028-0-16798800-1408389716_thumb.png

post-762028-0-97119600-1408389681_thumb.png

post-762028-0-06838200-1408389751_thumb.png

post-762028-0-57858800-1408389735_thumb.png

 

UPDATE:

I am getting the impression that the IDs shown on the Price Range and Weight Range pages are not Carrier IDs and so it is okay for them not to match. Please either confirm or correct me on this impression.

 

However, I think something may still not be incorrect.  I will attach the database table of ps_range_price.  For example, the Price (ps_range_price) table entry for ID of 88 is mapped to Carrier ID of 84, which as you will see no longer exists in the carrier list page, and it also does not exist on the ps_carrier table either, as I had it deleted before.

 

Any and all comments are welcome and appreciated.

Edited by hi2014 (see edit history)
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...