ShipStation

Hi Philip,

We installed the new version you provided. The error message went away but the order still not connect to Shipstation. Also, since we installed the plugin a new issue has showed up. In Paypal, the city says "false' (in Hikashop the city information is correct).

Can we hire you to just login to the site and Shipstation to get Shipstation working and fix the city 'false' issue?

thank you

I just re-installed the plugin and followed all the new instructions. The cart connects to ShipStation without errors. However, a test purchase still does not show up in ShipStation.

Below are errors we found at colostrumtherapy.com/index.php?option=co...hop&ctrl=shipstation

Notice: Undefined offset: 1 in /home/colos/public_html/plugins/system/shipstation/shipstation.php on line 173

Notice: Undefined offset: 1 in /home/colos/public_html/plugins/system/shipstation/shipstation.php on line 178

===

Please note that we have a standard Hikashop config with only 10 products and no custom plugins, etc., and are willing to pay anyone to help us. We have been patiently asking for help for a long time but now my boss is getting impatient and we may have to switch to another cart as he is using Shipstation for all his other websites and he loves it very much.

I will PM the login details and pray that you try to fix the issue. Again, we would be happy to pay for your time.

We manage our own servers and understand the issue. This site accepts only US customers so we block most foreign IPs. ShipStation has no issues communicating with our site (as we whitelisted their IPs).

We have programmers around the world work on the site without issues once they email us their IP.

Please go to whereismyip.com and we will then whitelist your IP. You can PM the IP if you wish.

Thank you

We have whitelisted your IP and PM'd all the logins.

Hello,

We are encountering and error:

An error occurred attempting to update orders: Error in XML. Reason: The 'OrderDate' element is invalid - The value 'Nov/09/2015 15:49' is invalid according to its datatype 'DateTime' - The Pattern constraint failed.

Can you please help?

Hello! Just checking in. Any luck with this fix? Would it hurt if we look at the code at the same time in an attempt to fix it ourselves? or should we let you deal with it?

Thanks,

Hey HikaShop team,

I am a developer engaged by nevosolutions to help him solve his issue with the shipstation xml. The fix is actually pretty straight forward, and there was one other fix that was also required in order to have everything work properly. In the end, we were able to send a bunch of orders over to shipstation.

So, for the date format issue:

ShipStation requires a very specific date format that can be found in their XSD definitions.

<xs:element type="DateTime" name="OrderDate"/>
<xs:element type="DateTime" name="LastModified"/>

They are not using the standard XML datetime type definition, and instead, are using the following simple type:

<xs:simpleType name="DateTime">
<xs:restriction base="xs:string">
<xs:pattern value="[0-9][0-9]?/[0-9][0-9]?/[0-9][0-9][0-9]?[0-9]? [0-9][0-9]?:[0-9][0-9]?[0-9]?[0-9]?.
?[aApP]?[mM]?"/>
</xs:restriction>
</xs:simpleType>

This means they want a format that looks like: MM/DD/YYYY HH:MM:SS.

If I remember correctly, you were using 'M/d/Y H:i' as your date format string. This would give you a date that could look like the following:

Sep/11/2015 09:00
or
Dec/11/2015 12:55

Neither of these satisfy the requirements for the simpleType listed above. If you change your date formatting string to: m/d/Y H:i:s you will get:

09/11/2015 09:00:00
or
12/11/2015 12:55:00

Both of which do satisfy their simple type, and are accepted.

Once that is resolved, the next issue becomes apparent.

The country code that is currently being passed by the shipstation plugin looks like this: country_United_States_Of_America_243

Shipstation requires that country code by a 2 letter representation of the country.

I solved this by loading the zones (very similar to how addresses are being loaded by the plugin) with the array keyed on 'zone_namekey'.

I then use $zone =& $zones[$address] after we have snagged the address out of the addresses array, in order to get the proper zone object.

In the xml, I do $zone->zone_code_2 where you are currently using $address->address_country.

With these two fairly simple changes, I was able to export orders for two different stores to shipstation, with no hiccups at all.

It appears the date issue is reverted in that last version attached.

An error occurred attempting to update orders: Error in XML. Reason: The 'OrderDate' element is invalid - The value 'Oct/13/2015 03:19:38' is invalid according to its datatype 'DateTime' - The Pattern constraint failed.

natselection,

Given the format your error shows, it looks like you aren't using the attached version.

The attached version has the correct timestamp format (that I am using in a live install) of 'm/d/Y H:i:s'

This would produce a date that looks like '10/13/2015 03:19:38'. The format your error shows is the old format from prior to the fix. I would try replacing your file with the version attached to the forum (incase they have not released this on the download page, as of yet)