Shipstation not sending orders after Joomla 4 and hikashop 5 upgrade

-- HikaShop version -- : 5.0.0
-- Joomla version -- : 4.3.4
-- PHP version -- : 8.1

After upgrading to Joomla 4 and Hikashop 5 yesterday, i've noticed that my orders aren't being imported into shipstation. There were some issues with the older version of this plugin, so i downloaded and installed the latest from here: www.hikashop.com/marketplace/product/232-shipstation.html

I turned on debug and the logs are a bit odd. I can see that the username and password is set correctly, but when the notification is triggered, the username and password is blank (replaced visible username/passwords with XXX)?

http://mojooutdoors.com/index.php?option=com_hikashop&ctrl=shipstation-- 09.22.23 12:54:18 --
Shipstation notification with unexpected username and password
Shipstation Username: XXXXXX
Shipstation Password: XXXXXX
http://mojooutdoors.com/index.php?option=com_hikashop&ctrl=shipstation&SS-UserName=XXXXXX&SS-Password=XXXXX&action=export&start_date=09%2f22%2f2023+19%3a49&end_date=09%2f22%2f2023+19%3a54&page=1-- 09.22.23 12:54:34 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+19%3a49 // End date: 09%2f22%2f2023+19%3a54-- 09.22.23 12:54:37 --
Shipstation notification with unexpected username and password
Shipstation Username: 
Shipstation Password: 
http://mojooutdoors.com/index.php?option=com_hikashop&ctrl=shipstation-- 09.22.23 12:54:43 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+19%3a49 // End date: 09%2f22%2f2023+19%3a54-- 09.22.23 12:54:43 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+06%3a47 // End date: 09%2f23%2f2023+12%3a54-- 09.22.23 12:55:32 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+06%3a54 // End date: 09%2f23%2f2023+12%3a55-- 09.22.23 12:55:37 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+06%3a55 // End date: 09%2f23%2f2023+12%3a55

action=export&start_date=09%2f22%2f2023+19%3a49&end_date=09%2f22%2f2023+19%3a54&page=1

Hi Philip,

I have triple checked the username and password in the shipstation plugin and store settings on shipstation custom store setup. Right after the upgrade, I observed some orders made prior to the update getting marked as shipped (correct behavior), but recent orders are not being imported correctly into shipstation from the website. I suspect there is something wrong with the SQL query as the connection is made, but no orders are returned from the query:

http://mojooutdoors.com/index.php?option=com_hikashop&ctrl=shipstation-- 09.22.23 12:54:43 --
no orders database matched with this dates
Start Date: 09%2f22%2f2023+19%3a49 // End date: 09%2f22%2f2023+19%3a54-- 09.22.23 12:54:43 --

Thanks for taking a look. In my previous response I noted that the connection seems to work, BUT the database query seems to return no orders.

I have updated the shipstation plugin multiple times already (note this is the free version from hikashop marketplace page). This was working just fine prior to the joomla 4 and hikashop 5 upgrades. The SQL query seems to be broken.

The free version of the hikashop plugin shows last updated in 2017, but appears to have been patched for php 8+. www.hikashop.com/marketplace/product/232-shipstation.html

Is the free version of the plugin no longer supported by hikashop team? I noticed there is now a paid version of the shipstation plugin that's updated regularly. I'm not clear of the differences between the free and paid versions based on the marketplace pages.

www.hikashop.com/marketplace/product/160...station-updated.html

I'm okay with paying for the paid version if it will fix the issue with syncing orders, but the free plugin should be removed from marketplace if broken and no longer supported.

After purchasing the paid version of the plugin, everything works just fine. I suspect that the free version is for Joomla 3 only and was never updated for joomla 4.

In any case, the GET call that shipstation issues appears to be for last 12 hours. Is there an easy way to initiate this sync but for orders older than 12 hours?

I manually edited the plugin start time to 9/21 and all older orders are now showing up in shipstation. Might be a nice feature to add to the plugin as a way of manually syncing back from any given date.

Found another php issue with shipstation.php

[Wed Sep 27 14:43:47.403605 2023] [fcgid:warn] [pid 133211:tid 140657743206144] [client XXXXXX] mod_fcgid: stderr: PHP Warning:  Undefined array key "ctrl" in /plugins/system/shipstation/shipstation.php on line 853, referer: https://www.mojooutdoors.com/index.php?option=com_hikashop&ctrl=checkout&task=after_end&order_id=68752&order_token=bczQ3a49&Itemid=883

I found this in my server's php logs. This happens every time an order is placed is and customer is redirected to "after_end.php" view (thank you page).