usps.com Click-n-ship AutoFill Button Contrib

I go the patch installed. I know have 17 items under configuration/USPS Auto Fill. I will install the rest when I get home tonight. Thanks for this great contribution.

Scott

Sbross:

I go the patch installed. I know have 17 items under configuration/USPS Auto Fill. I will install the rest when I get home tonight. Thanks for this great contribution.

Scott

Good to hear!

**I got the code in and uploaded the files and I get this when I go to Admin/orders.

Warning**: main(includes/modules/usps_autofill_button.php) [function.main]: failed to open stream: No such file or directory in /home/rockymt4/public_html/admin/orders.php on line 786

Warning: main(includes/modules/usps_autofill_button.php) [function.main]: failed to open stream: No such file or directory in /home/rockymt4/public_html/admin/orders.php on line 786

Fatal error: main() [function.require]: Failed opening required 'includes/modules/usps_autofill_button.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rockymt4/public_html/admin/orders.php on line 786

Scott

OK, I put the old orders back in and I don't get the error. I suppose I need to use your instructions and merge the orders.php file.

Scott

Sbross:

OK, I put the old orders back in and I don't get the error. I suppose I need to use your instructions and merge the orders.php file.

Scott

You dont need to merge the orders file if you don't have any other changes. Just use the one I included. The error you are getting is because it looks like you dont have the usps_autofill_button.php in the admin/includes/modules/ folder

For some reason the autofill button was not there. I added it and got this message.

Fatal error: Call to undefined function: get_order_total_weight() in /home/rockymt4/public_html/admin/includes/modules/usps_autofill_button.php on line 167

Scott

OK, I looked and for some reason the functions_ordertotalweight.php
was not there. Added that and the button shows up. Cool.

Thanks for the help.

Scott

Everything works great accept I need to ship First Class. I know with paypal you can ship first class. It doesn't give me that choice.

Scott

Sbross:

Everything works great accept I need to ship First Class. I know with paypal you can ship first class. It doesn't give me that choice.

Scott

Thats actually a limitation due to USPS - not this contribution. We tried getting PayPal to work however we couldn't at the time.. I'm not sure if qhome has tried it recently though he did mention something about it

samad64:

Thats actually a limitation due to USPS - not this contribution. We tried getting PayPal to work however we couldn't at the time.. I'm not sure if qhome has tried it recently though he did mention something about it

Ya i took another stab at geting the paypal to work....with no luck. Still drops the address.

I have been workin on a separate standalone program that can run a smart macro/automated script to do it but there are some design ideas that I want to get worked out first.

Keep up the good work. I still can use it when the order more than 13 ounces. We do have some heavy stuff and it will definitely come in handy.

Just a note. I've been using filezilla to upload my files and I've been having problems with the files not updating on the server. I had issues with the USPS Click n Ship and also the Paypal Patch. For some reason when I would drag the whole file structure over some of these files weren't being moved. I got both contributions to work yesterday by moving the individual files over. It might just be me, but check the dates of your files on your server to make sure they have changed when you uploaded your files.

Scott

Sbross:

Keep up the good work. I still can use it when the order more than 13 ounces. We do have some heavy stuff and it will definitely come in handy.

Just a note. I've been using filezilla to upload my files and I've been having problems with the files not updating on the server. I had issues with the USPS Click n Ship and also the Paypal Patch. For some reason when I would drag the whole file structure over some of these files weren't being moved. I got both contributions to work yesterday by moving the individual files over. It might just be me, but check the dates of your files on your server to make sure they have changed when you uploaded your files.

Scott

Good tip.
Also check your ftp client settings. Some of them have a setting to overwrite or leave by default.

I am recieving the following errors when I try to istal this module.

Parse error: syntax error, unexpected '}' in /home/berridge/public_html/admin/super_orders.php on line 1417

in super orders and

Parse error: syntax error, unexpected '}' in /home/berridge/public_html/admin/orders.php on line 882

I am sure all files are in the correct locations and I have correctly installed the sql patch. What exactly is causing this?

i am trying to install this on 1.37 and am getting an error when i try to put in the sql file. You info says if you have a problem to try the other sql file...but there is only 1 in the zip.....Does this contrib still work?

mfreund:

i am trying to install this on 1.37 and am getting an error when i try to put in the sql file. You info says if you have a problem to try the other sql file...but there is only 1 in the zip.....Does this contrib still work?

Contrib works fine. Are you using a prefix in your database?

If so, edit the sql file and change:

SELECT @gid := configuration_group_id 
FROM configuration_group where configuration_group_title LIKE '%USPS Auto-Fill Config%';

to

SELECT @gid := configuration_group_id 
FROM [B]prefix_[/B]configuration_group where configuration_group_title LIKE '%USPS Auto-Fill Config%';

hmm not to sound dumb...but not sure how to find it.....usually i delete the prefix but this time i guess i forgot my prefix is zen_

Not sure how to find field you are talking about in phpmyadmin

any help is appreciated

i keep looking have no idea how to do it

can you help?

here is the error i am getting when i try to import the sql file

BTW i renamed all the tables so there is nomore prefix...thought that would fix it but no luck....here is the error when i try to put in the sql file

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total' or 'subtotal' if you want to use that order value for the declaration val' at line 1
in:
[INSERT INTO configuration VALUES ('', 'Return: Full Name', 'USPS_RETURN_FULLNAME', '', 'Set this to your return address Full Name', @gid, '5', now(), now(), NULL, NULL), ('', 'Return: Company Name', 'USPS_RETURN_COMPANY_NAME', '', 'Set this to your return address Company Name', @gid, '10', now(), now(), NULL, NULL), ('', 'Return: Address 1', 'USPS_RETURN_ADDRESSONE', '', 'Set this to your return address street 1', @gid, '15', now(), now(), NULL, NULL), ('', 'Return: Address 2', 'USPS_RETURN_ADDRESSTWO', '', 'Set this to your return address street 2', @gid, '20', now(), now(), NULL, NULL), ('', 'Return: City', 'USPS_RETURN_CITY', '', 'Set this to your return address city', @gid, '25', now(), now(), NULL, NULL), ('', 'Return: State', 'USPS_RETURN_STATE', '', 'Set this to your return address state. NOTE: THIS MUST BE IN A 2 LETTER ABBREVIATED FORMAT (i.e. AZ, KY, MI)', @gid, '30', now(), now(), NULL, NULL), ('', 'Return: ZipCode', 'USPS_RETURN_ZIPCODE', '', 'Set this to your return address zipcode', @gid, '35', now(), now(), NULL, NULL), ('', 'Return: Phone Number', 'USPS_RETURN_PHONENUMBER', '', 'Set this to your company phone number for International Shipping. (no dashes: 4041234567)', @gid, '40', now(), now(), NULL, NULL), ('', 'Delivery: Default Notify via Email', '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, "zen_cfg_select_option(array('true', 'false'),"), ('', 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '10.00', '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), ('', 'Delivery: Default Weight (Pounds)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '1', '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), ('', '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), ('', '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, "zen_cfg_select_option(array('same', 'other'),"), ('', 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '00000', '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), ('', '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), ('', 'Delivery: Default Non-Delivery Checkbox (Return-to-Sender)', 'USPS_DELIVERY_DEFAULT_NONDELIVERY', 'Y', 'Set this to Y if you want the checkbox for Return-To-Sender to be checked by default (International Packages Only)', @gid, '80', now(), now(), NULL, "zen_cfg_select_option(array('N', 'Y'),"), ('', 'Delivery: Default Privacy Acknowledge Checkbox', 'USPS_DELIVERY_DEFAULT_ACKNOWLEDGE', 'on', 'Set this to on if you want the Acknowledge checkbox to be checked by default (International Packages Only)', @gid, '85', now(), now(), NULL, "zen_cfg_select_option(array('off', 'on'),");]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Well the removing the prefix helped all the other contribs i was having problems with so i tried a re import of your usps 1.1 sql file through phpmyadmin and i am getting this error

ALTER TABLE orders DROP total_weight ;

MySQL said: Documentation
#1091 - Can't DROP 'total_weight'; check that column/key exists

what do you suggest? I would really like to get this working

thanks

Matt

mfreund:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total' or 'subtotal' if you want to use that order value for the declaration val' at line 1

OK, this error was supposed to be fixed with 1.1b but apparently I fixed it in one file and uploaded the other. So I've fixed (and i checked 3 times to be sure) and reuploaded the file to the downloads area. It is still 1.1b but it should have a different correction message when they approve it. That will fix the 'total' thing.

The last error you got is fine. It is just trying to drop a table that doesn't exist.

Sorry for the confusion.

For now, try this: