usps.com Click-n-ship AutoFill Button Contrib

[guido49]

OK...after much ado and taking another good look at the SQL code, I finally got it right and fixed the problem.

Obviously I was being really blind and/or stupid (or both) as I found a bunch of typos in the SQL I posted before.

Now I can access the config under the Admin login with no issues...AND...the module still works properly.

Anyway, ses707, thanks for your input.

[ses707]

OK...after much ado and taking another good look at the SQL code, I finally got it right and fixed the problem.

Obviously I was being really blind and/or stupid (or both) as I found a bunch of typos in the SQL I posted before.

Now I can access the config under the Admin login with no issues...AND...the module still works properly.

Anyway, ses707, thanks for your input.

Glad you got it figured out, it's frustrating when zen sql insert doesn't let you run perfectly acceptable statements depending on the environment. Not getting the prepend right will make it fail to appear. I hope you enjoy using the addon!

[jackie.taferner]

New version of the module is available for download: http://www.zen-cart.com/downloads.php?do=file&id=182

Included fixes:
-Fix delivery state & country field so they show up in USPS site.
-Added 'Save to address book' functionality.

[romy]

By the way, here's the SQL code as it's being run...maybe there's something wrong I just can't seem to see?

SET @gid=0;
SELECT @gid:=configuration_group_id
FROM zen_configuration_group
WHERE configuration_group_title LIKE '%USPS Auto-Fill Config%'
LIMIT 1;
DELETE FROM zen_configuration_group WHERE configuration_group_title LIKE '%USPS Auto-Fill Config%';
DELETE FROM zen_configuration_group WHERE configuration_group_title LIKE '%USPS AutoFill%';
DELETE FROM zen_configuration_group WHERE configuration_group_title LIKE '%USPS AutoFill Config%';
DELETE FROM zen_admin_pages WHERE page_key='uspsautofill';
DELETE FROM zen_configuration WHERE configuration_key LIKE 'USPS_RETURN%' LIMIT 8;
DELETE FROM zen_configuration WHERE configuration_key LIKE 'USPS_DELIVERY%' LIMIT 9;

# Insert New USPS AutoFill Configuration Group
INSERT INTO zen_configuration_group VALUES ('', 'USPS AutoFill', 'USPS AutoFill Config', '1', '1');
SET @gid=last_insert_id();
UPDATE zen_configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO zen_configuration VALUES (NULL, 'Return: Tracking Email', 'USPS_RETURN_TRACKING_EMAIL', '', 'Set this to the email address used for receiving tracking updates. ', @gid, '41', now(), now(), NULL, NULL), (NULL, 'Return: Tracking Notify via Email (checkbox)', 'USPS_RETURN_TRACKING_EMAIL_NOTIFY', 'false', 'Set this to true if you want to check the tracking notifications checkbox to receive tracking updates to the email specified.', @gid, '42', now(), now(), NULL, "cfg_select_option(array('true', 'false'),"), (NULL, 'Delivery: Default Notify via Email (checkbox)', 'USPS_DELIVERY_DEFAULT_EMAIL_NOTIFY', 'true', 'Set this to true if you want the Notify By Email checkbox checked by default', @gid, '45', now(), now(), NULL, "cfg_select_option(array('true', 'false'),"), NULL, 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '', 'Set this to total or subtotal if you want to use that order value for the declaration value, or set this to a price if you want a default contents value for International shipping, or leave blank to not use it', @gid, '50', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Pounds)',
'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '', 'Set this to the default weight in pounds. Useful if you sell only one type of item. Leave blank if using the order total weight', @gid, '55', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Ounces)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_OUNCES', '', 'Set this to the default weight in ounces. Useful if you sell only one type of item. Leave blank if using the order total weight', @gid, '60', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Shipping from Same ZipCode (Radio Button)', 'USPS_DELIVERY_SAME_ZIPCODE', 'same', 'Set this to same if you want to have your Return Address Zipcode as the default Ship-From zipcode. If set to Other, then enter in your default Ship-From zipcode in the next setting', @gid, '65', now(), now(), NULL, "cfg_select_option(array('same', 'other'),"), (NULL, 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '', 'Set the default ZipCode you would like as your Ship-From zipcode. Only if the above setting is set to Other', @gid, '70', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Insurance Value', 'USPS_DELIVERY_INSURANCE_VALUE', '', 'Set to total or subtotal if you want to use that order value for the insurance value, or set to a price (i.e. 5.25) if you want to use a preset price. Or leave blank to not use it', @gid, '75', now(), now(), NULL, NULL);

ALTER TABLE zen_orders DROP total_weight;
ALTER TABLE zen_orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';

# Register the pages for Admin Access Control
DELETE FROM zen_admin_pages WHERE page_key='uspsautofill';
INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES

('uspsautofill','BOX_CONFIGURATION_USPS_AUTOFILL','FILENAME_CONFIGURATION','1',' configuration','Y','1');
UPDATE zen_admin_pages SET sort_order = (SELECT configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'USPS AutoFill') WHERE page_key = 'uspsautofill';
UPDATE zen_admin_pages SET page_params = CONCAT('gID=',(SELECT configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'USPS AutoFill')) WHERE page_key = 'uspsautofill';

working with 1.5.0
read this whole forum and nothing has helped.
what should the install-1.5.0 sql look like.
when I install install-1.5.0 it gives me a 404 page
Thanks

[jackie.taferner]

romy, I hope this helps you:

1) Make sure you have downloaded the latest copy of USPS AutoFill from the link above.
2) Make sure that ALL 1.5.0 files are uploaded to your admin directory before running SQL.
3) Use the SQL inside that package, by opening the install-1.5.0.sql file in Notepad and copy/paste into Tools > SQL Patches

[romy]

Hello,
I did everything you listed before.
did give the copy/paste a try in the SQL
I get "The website cannot display the page"
when I hit send or upload..
I gave it a try with 1.3.9 and it worked perfect but with 1.5.0 no luck.

[jackie.taferner]

Which version of Zen Cart are you using? You should only install the SQL that matches your version of Zen Cart.

[atfpodcast]

I get errors when I upload the .sql patch file. It says to refresh and try again.

[atfpodcast]

when i apply the 1.50 but it is working the only downfall about click and ship is it only works with flat rate and priority grrrr

[barco57]

UK addresses are not populating correctly, it appears to not be sending the country correctly.
Any addresses with the country listed as United Kingdom fail to pass the country correctly.........
Apparently the client can get it to work because they have the module that allows them to edit the clients information, and they are changing the country to Great Britain and then submitting and it works.

am I going to have to change the Country name from United Kingdom to Great Britain (for new Customers) and then mass change it in the database (for old customers) ?