Want to add "USPS Parcel post" service into CS-Cart

Store Builder Questions
1

I checked CS-cart’s built-in USPS services, and looks like there are some services missing. For instance, I use USPS Parcel Post service everyday but I don’t seem to be able to find it in CS-cart.



Is there a way to refresh all CS-cart’s USPS service list directly from USPS web site?

I know the latest CS-cart release does have some issues with USPS service name code, and require some sql scripts to update those service name codes. so, should I look into inserting records into the shipping service table to have the missing USPS services show up ???



I am pretty new to CS-cart, but I like it so far, anyone can shed some light on this for me ?.



Thanks in advance …

2

I think that USPS Ground Machine is the same as Parcel Post.



You can update the service code names and descriptions by executing the following SQL commands:

UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail International Package' WHERE service_id='54' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail' WHERE service_id='70' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail International Large Envelope' WHERE service_id='203' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail International Parcels' WHERE service_id='204' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail International Letters' WHERE service_id='205' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS First-Class Mail International Flats' WHERE service_id='206' AND lang_code='EN';
UPDATE cscart_shipping_services SET code='First-Class Mail International Package' WHERE service_id='54';
UPDATE cscart_shipping_services SET code='First-Class Mail International Large Envelope' WHERE service_id='203';
UPDATE cscart_shipping_services SET code='First-Class Mail International Parcels' WHERE service_id='204';
UPDATE cscart_shipping_services SET code='First-Class Mail International Letters' WHERE service_id='205';
UPDATE cscart_shipping_services SET code='First-Class Mail International Flats' WHERE service_id='206';




Bob

3

Just confirmed that USPS Ground Machine and USPS Ground Non Machine request rates for Parcel Post M and Parcel Post N, respectively.



If you really want to change this, you can run the following SQL queries:


UPDATE cscart_shipping_service_descriptions SET description='USPS Parcel Post Machinable' WHERE service_id='48' AND lang_code='EN';
UPDATE cscart_shipping_service_descriptions SET description='USPS Parcel Post Non-machinable' WHERE service_id='49' AND lang_code='EN';




Keep these handy in case CS-Cart updates the descriptions in the future.



Bob

4

jobosales, U’re the man !!! Tank myou sooooooo much !!!