International First Class Shipping w/ New Version

Store Builder Questions
1

We have offered International First Class Shipping to our customers, but since installing the newest version of CS-Cart, it will not show this option to our buyers any longer?



Does anyone know a fix for this issue?



Russ

2

USPS updated their prices on 28/01/2013 and with that some shipping method names have been changed (why they change this, I do not know!). Since V3.0.5 was released before January 28th, this will break for all CS-Cart customers until CS-Cart update the appropriate data in the database. Here is the fix which I have also applied to a 3.0.5 site:



Create a database backup (Administration>Database) before you do anything.



Now access your database by your desired method (phpMyAdmin is common with most webhosts).



Run the following SQL command to update the appropriate field. Remember to backup before running this:


UPDATE 'cscart_shipping_services' SET code = 'First-Class Package International Service' WHERE code = 'First Class Mail International Parcel' AND module = 'usps'


and


UPDATE 'cscart_shipping_services' SET code = 'Standard Post' WHERE code = 'Parcel Post M' AND module = 'usps'


and


UPDATE 'cscart_shipping_service_descriptions' SET description = 'Standard Post' WHERE description = 'USPS Parcel Machinable'


and


UPDATE 'cscart_shipping_service_descriptions' SET description = 'USPS First-Class Package International Service' WHERE description = 'USPS First-Class Mail International Parcel'


The “AND module = 'usps'” should not be necessary but just in case you (or anyone else looking to fix this problem) have integrated any custom shipping methods with the same 'code' name, this won't cause any conflicts.

3

The above fix doens't work. Here is the bulk sql that will work:


UPDATE cscart_shipping_services SET code = 'First Class Package International Service' WHERE code = 'First Class Mail International Parcel';
UPDATE cscart_shipping_services SET code = 'Standard Post' WHERE code = 'Parcel Post M';
UPDATE cscart_shipping_service_descriptions SET description = 'Standard Post' WHERE description = 'USPS Parcel Machinable';
UPDATE cscart_shipping_service_descriptions SET description = 'USPS First-Class Package International Service' WHERE description = 'USPS First-Class Mail International Parcel';

4

It works for one of my stores…“First Class” has been changed to “First-Class”.

5

parcelbound is a real company but service is terrible. They are rated F by Better Business Bureau which si the bureau that rates companies in the states.