shipstation no longer importing orders after upgrade.

Zencart 1.5.7, PHP 7.3
I recently finished upgrading to 1.5.7, and shipstation will no longer import the orders. I applied the update found here: https://www.zen-cart.com/showthread.php?226295-Shipstation-Tweak-for-v156-Updated-By

Still not working, even though Shipstation shows no issues, and no errors set. Any clue how to troubleshoot this?

A couple of questions, to make sure I understand the issue(s).

1. By "no longer import the orders", does that mean that the shipstation 'export' of the orders from your store to the shipstation site isn't working?
2. By "no errors set", do you mean that there are no logs recorded in the site's /logs directory?

1. Yes, the export of orders to shipstation is not working.
2. Yes, nothing in the logs directory.

What version of shipstation_zc.php is in use? Any modifications?

Attachment #19208

Shipstation_zc.php version 1.5, downloaded straight from the shipstation website. All I have done is the 1.5.6 tweak here: https://www.zen-cart.com/showthread.php?226295-Shipstation-Tweak-for-v156-Updated-By

It didn't work before that either.

Does the shipstation admin's password contain "HTML special characters", e.g.** "<>**? If so, change the password in the Zen Cart and on shipstation to replace those characters.

Starting with v156, the Zen Cart admin's password-handling changes those characters to their HTML equivalent, e.g. > becomes >, but the storefront password handling doesn't.

lat9:

Does the shipstation admin's password contain "HTML special characters", e.g.** "<>**? If so, change the password in the Zen Cart and on shipstation to replace those characters.

Starting with v156, the Zen Cart admin's password-handling changes those characters to their HTML equivalent, e.g. > becomes >, but the storefront password handling doesn't.

No, just letters, and numbers. I have tried it on the test website too, and it doesn't work there either. When I look at the logs in shipstation, it states: Manual order refresh completed

I tried giving the shipstation account full admin privileges, deleting the account, a few other things, and I can't make it show actual orders in shipstation.

Have you tried running the shipstation_zc.php on your test site:

www.testsite.com/shipstation.zc.php?SS-UserName=[B]adminname[/B]&SS-Password=[B]adminpassword[/B]&action=export&start_date=06/02/2020 05:30&end_date=09/23/2020 22:53

That "should" output the orders directly to your screen.

I entered this date range: > &action=export&start_date=06/02/2020 05:30&end_date=09/23/2020 22:53, and I got all the orders on the screen from that date range. Looks like it's time to call shipstation, but they claim that they won't even respond for at least 72 hours.

So I chatted with Shipstation, and they can see the orders, but for some reason the orders don't show up on my screen. He couldn't figure it out, so he is having someone else look into it, and email me back.

Is there anything that changed between 1.5.5, and 1.5.7 that would effect order status for something lie this? In shipstation, I have the settings for the status set as:
pending, 1
processing, 2
shipped, 3

I added the numbers today, and it made no difference.

He just got back with me. It's an issue within Zen-cart in the order_date field. Instead of a date, it shows DATE_TIME_FORMAT

https://p-1mfgye.b3.n0.cdn.getcloudapp.com/items/bLuwzKK0/Image%202020-09-24%20at%2012.45.48%20PM.png?v=b2e2363a8b5254a625e98f1b2b27ea47

Well, that's *wonderful *(not):no:. Apparently the constants DATE_TIME_FORMAT and DATE_FORMAT_SHORT, which used to be present in the main language file (e.g. /includes/languages/english.php) have magically disappeared in zc157.

Those definitions, for prior ZC versions, were

  define('DATE_FORMAT_SHORT', '%m/%d/%Y');  // this is used for strftime()
  define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

Update: Zen Cart GitHub issue opened (https://github.com/zencart/zencart/issues/3975)

My workaround was to change line 104 in shipstation_zc.php from this:

    return strftime(DATE_TIME_FORMAT, mktime($hour, $minute, $second, $month, $day, $year))

To this:

    return strftime('%m/%d/%Y %H:%M:%S', mktime($hour, $minute, $second, $month, $day, $year));

Question: for the way shipstation is using this, does it really need to rely on a constant in Zen Cart? ie: is it critical that it know something about Zen Cart in order to do what it's doing in this part of the code? Or does shipstation's processing actually need/expect a certain format (which "coincidentally" matched what Zen Cart had in that constant) and therefore it would be more sensible to hard-code the expected format instead of using any constants in Zen Cart anyway?

vanhorn_s: could i get clarification here? Exactly what does work? We're having the same issue and trying to solve it. What precisely did you do/ change to get shipstation working?

Thank you!

When I originally tried post #12, it didn't work, but I accidentally messed it up. If you add those exact 2 lines to the end of the lines that look like that, it will work again.

DATE_TIME_FORMAT fixes applied to https://www.zen-cart.com/downloads.php?do=file&id=1324