Page 1 of 4 123 ... LastLast
Results 1 to 10 of 38
  1. #1
    Join Date
    Apr 2007
    Posts
    649
    Plugin Contributions
    0

    Default Stamps.com getting error while importing

    I am trying to use Stamps.com, but where the heck is the batch file??? I can't find it anywhere.

  2. #2

    Default Re: stamps.com help

    Hello,

    If there is anything else you need help with, please feel free to let me know.

    Thanks!
    Chuck
    Stamps.com

  3. #3
    Join Date
    Apr 2010
    Posts
    262
    Plugin Contributions
    1

    Default stamps.com no longer working with 1.5.3

    I just got done upgrading to 1.5.3, and stamps.com will no longer import orders. It appears to be a compatibility issue, but I have no clue what to edit, so that it will work again. I tested, and it can access the database by doing this:

    https:// my site admin /stamps.php?shipping_access_token=XXXXXXXXXXXXXXXXXXXXXX&cmd=ping

    I have already tried the latest stamps.com integration software, and they claim it has only been tested to work up to 1.5.0

  4. #4
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    Can't help with the Stamps.com issue other than to offer a suggestion.

    ShipStation.com has a better interface, has the capability of applying rules and filters that you build to orders imported and has the ability to use both Stamps.com (or Endicia) and Express1 rates for printing USPS postage. Will also print UPS and Fedex labels if you have accounts with them. When shipping Priority and Express mail, Express 1 rates are better than Stamps.com

    OH, and Stamps.com recently bought ShipStation.

    If you are not subscribed to receive zencart notices, the zencart USPS plugin will be updated next week so that it will work with the USPS updates that go into effect on Sept 7, 2014.
    Last edited by RixStix; 30 Aug 2014 at 02:41 PM.
    Rick
    RixStix (dot) com
    aka: ChainWeavers (dot) com

  5. #5
    Join Date
    Apr 2010
    Posts
    262
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    I may have to do that. I just don't like how ship station is double the price of stamps.com

  6. #6
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    That was my thought too, initially. It doesn't take much shipping per month to offset the expense with timesavings and reduced frustration by not beating my head against the wall every time I had a Stamps.com problem and the months it took for them to address the problems.
    Rick
    RixStix (dot) com
    aka: ChainWeavers (dot) com

  7. #7
    Join Date
    Apr 2010
    Posts
    262
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    I started the free trial of ship station, and I really like how it works, but it is going to cost me $65 a month, because I also import orders from Ebay, and Paypal.

  8. #8
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    Instead of upgrading from bronze to gold,

    Try Changing your subscription plan and instead of clicking the upgrade button for silver or gold, look in the upper right of that window and try Increasing the number of selling channels by 2 which appears to keep the features of bronze but allowing 3 channels @ $10/channel instead of $20/channel.
    Rick
    RixStix (dot) com
    aka: ChainWeavers (dot) com

  9. #9
    Join Date
    Apr 2010
    Posts
    262
    Plugin Contributions
    1

    Default Re: stamps.com no longer working with 1.5.3

    Quote Originally Posted by RixStix View Post
    Instead of upgrading from bronze to gold,

    Try Changing your subscription plan and instead of clicking the upgrade button for silver or gold, look in the upper right of that window and try Increasing the number of selling channels by 2 which appears to keep the features of bronze but allowing 3 channels @ $10/channel instead of $20/channel.
    Apparently they won't let me do that until the trial is over.


    Does anybody have any suggestion on how to add logon credentials to ShippingZSettings.php, or another workaround to make this work again? I can always just use the sales record form Paypal to ship from, but it doesn't post back to zencart.

  10. #10
    Join Date
    Apr 2010
    Posts
    262
    Plugin Contributions
    1

    Default Stamps.com setting error while importing.

    I recently upgraded to the new stamps.com software, and you now install it in the admin folder, and it goes straight to the database. It is working flawlessly, except it sets an error in the log folder every time.

    I had to edit out the admin folder name, and login credentials on this:
    Code:
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:828]
    #2  GetCountryID() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:846]
    #3  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #4  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #5  Action_GetOrders() called at [/home2/redsauto/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 828
    [18-Sep-2015 10:07:27 America/Denver] Request URI: XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:828]
    #2  GetCountryID() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:846]
    #3  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #4  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #5  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 828
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:855]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 855
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:855]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 855
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:856]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 856
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:856]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:492]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 856
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:828]
    #2  GetCountryID() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:846]
    #3  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #4  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #5  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 828
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:828]
    #2  GetCountryID() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:846]
    #3  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #4  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #5  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 828
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:855]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 855
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:855]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 855
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:856]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): Access denied for user 'XXXXXXXXXXXXXXXX'@'localhost' (using password: NO) in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 856
    [18-Sep-2015 10:07:27 America/Denver] Request URI: /XXXXXXXXXXXXXXXX/stamps.php?username=XXXXXXXXXXXXXXXX&password=XXXXXXXXXXXXXXXX&action=getorders&maxcount=50&start=2015-09-17T22%3A00%3A51, IP address: 216.52.211.20
    #1  mysql_real_escape_string() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:856]
    #2  GetStateCode() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:506]
    #3  WriteOrder() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:384]
    #4  Action_GetOrders() called at [/home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php:176]
    
    [18-Sep-2015 10:07:27 America/Denver] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home2/redsauto/public_html/XXXXXXXXXXXXXXXX/stamps.php on line 856
    Lines 171-179
    Code:
                                   switch (strtolower($action))
                                    {
                                            case 'getmodule': Action_GetModule(); break;
                                            case 'getstore': Action_GetStore(); break;
                                            case 'getcount': Action_GetCount(); break;
                                            case 'getorders': Action_GetOrders(); break;
                                            case 'getstatuscodes': Action_GetStatusCodes(); break;
                                            case 'updatestatus': Action_UpdateStatus(); break;
                                            default: outputError(60, "'$action' not supported");
    lines 381-387
    Code:
                            $processedIds .= $row->fields['orders_id'];
    
                            // output the order xml
                            WriteOrder($row);
    
                            // Next order
                            $row->MoveNext();
    lines 485-497
    Code:
                    writeStartTag("ShippingAddress");
                    writeElement("FullName", $row->fields['delivery_name']);
                    writeElement("Company", $row->fields['delivery_company']);
                    writeElement("Street1", $row->fields['delivery_street_address']);
                    writeElement("Street2", $row->fields['delivery_suburb']);
                    writeElement("Street3", "");
                    writeElement("City", $row->fields['delivery_city']);
                    writeElement("State", GetStateCode($row->fields['delivery_country'], $row->fields['delivery_state']));
                    writeElement("PostalCode", $row->fields['delivery_postcode']);
                    writeElement("Country", $row->fields['delivery_country']);
                    writeElement("Phone", $shipPhone);
                    writeElement("Email", $shipEmail);
                    writeCloseTag("ShippingAddress");
    lines 824-867
    Code:
            function GetCountryID($country_name)
            {
                    global $db;
                    $qry = sprintf("select countries_id from ". TABLE_COUNTRIES. " where countries_name = '%s'",
                                    mysql_real_escape_string($country_name));
    
                    $countryQuery = $db->Execute($qry);
                    if ($countryQuery->RecordCount() == 0)
                    {
                            return $country_name;
                    }
                    else
                    {
                            return $countryQuery->fields['countries_id'];
                    }
            }
    
            // Returns the state code for a given state and country name
            function GetStateCode($country_name, $state_name)
            {
                    global $db;
    
                    $country_id = GetCountryID($country_name);
    
                    if ($country_id == '')
                    {
                            return $state_name;
                    }
    
                    // now lookup the state code based on countryid and state name
                    $qry = sprintf("select zone_code from ". TABLE_ZONES. " where zone_country_id = '%s' and zone_name = '%s'",
                                    mysql_real_escape_string($country_id),
                                    mysql_real_escape_string($state_name));
                    $stateQuery = $db->Execute($qry);
                    if ($stateQuery->RecordCount() == 0)
                    {
                            return $state_name;
                    }
                    else
                    {
                            return $stateQuery->fields['zone_code'];
                    }
    
            }

 

 
Page 1 of 4 123 ... LastLast

Similar Threads

  1. v138a Stamps.com: How do I prevent Non-shippable items from batch importing?
    By gachogavacho in forum Addon Shipping Modules
    Replies: 14
    Last Post: 20 Aug 2014, 08:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR