Stamps.com getting error while importing

[mprough]

Actually that's not it.... Here are the changes

Around line 829 find

mysql_real_escape_string($country_name));

change to

zen_db_input($country_name));

Then around line 856 find

mysql_real_escape_string($country_id),
mysql_real_escape_string($state_name));

Change to

zen_db_input($country_id),
zen_db_input($state_name));

~Melanie

[cyphercys]

Hello everyone,

After updating PHP to 7.1, I was also getting this same issue. Melanie's suggested edits fixed the issue of the orders importing into the Stamps.com software. Thanks so much for that! Stamps.com support was no help.

Now, although the orders import into stamps.com, it is no able to postback updates to zen-cart. Which means I still have to manually update the order. Any ideas?

Thanks for reviewing this. I really appreciate it guys.

Mike

[DrByte]

Someone mentioned an error on PHP 7, and I see that there's a fix needed for using PHP 7.2 or newer.
Updated zip attached (taken from Stamps.com site download, applied the mysql_xxxx function fix and the while/each-to-foreach fix for PHP 7.2+).

Their original download, and install instructions are at: https://stamps.custhelp.com/app/answ...04/r_id/100233

[swguy]

Does this still work? It seems like Stamps is trying to get people to upgrade to ShipStation now.

[CraftCorner]

Does this still work? It seems like Stamps is trying to get people to upgrade to ShipStation now.

As of today....my orders no longer import, even with Dr. Byte's updated PHP file. I cannot go to ShipStation - they price on volume, and my volume is way too high, it would cost me thousands of dollars per year. Is there any other option that works with ZC, like PirateShip?

[DrByte]

Are any PHP errors logged, either as /logs/myDebug-adm-xxxxx.log files, or generally in your server's error logs?

[CraftCorner]

Are any PHP errors logged, either as /logs/myDebug-adm-xxxxx.log files, or generally in your server's error logs?

There's nothing in /logs/ with that filename. I'd have to ask my web person to look in the server logs, as I have no idea what I would be looking for.

[CraftCorner]

Are any PHP errors logged, either as /logs/myDebug-adm-xxxxx.log files, or generally in your server's error logs?

Running ZC 1.5.7 and PHP 7.2

DrByte, I spent a lot of time with my web person this afternoon trying to figure this out. She couldn't find any PHP errors specific to stamps.php or stamps.com; however, we did discover this:

Friday, October 30 was the last day I imported orders to stamps.com using the stamps.com software.
Saturday, October 31, I changed my password (it's set on a 90 day cycle).
Monday, November 2, I was unable to import orders.
Today, while speaking with her, I was shipping packages. Some of the shipments were orders that had been imported last week. I shipped against the imported record and the corresponding order in ZC was updated with the tracking information and the status of "Delivered".

So, we know that stamps.com is able to write back to ZC, but stamps.com is not successfully extracting new orders from ZC.

We saw the shipstation error thread and wondered if the same issue existed with the stamps.com error I'm experiencing, so we added the following lines to english.php:
define('DATE_FORMAT_SHORT', '%m/%d/%Y'); // this is used for strftime()
define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

There was no change in the performance.

We're still scratching our heads as to what changed on Saturday - so I did change my admin password, since we thought the ^ character might be giving ZC fits. No change. This next part is important, I think - because I put in an entirely fake password in the stamps.com data connection setup and it did not error out.

No errors are generating in the admin activity log or any other error log she can see. I'm using your updated stamps.php file and it's been working fine - up until Monday, November 2, when stamps.com stopped importing orders.

Any ideas?