Jump to content
greasemonkey

ShipStaion for OsCommerce

Recommended Posts

This module allows you to import your orders from OsCommerce to ShipStaion for easy shipping – including creating shipping labels, sending shipping confirmation emails and comparing shipping rates for most of the North American couriers (including Canadian carriers: Canada Post and Purolator).

No core files changes are required – just adding one file and complete the setup from ShipStation.

Tested on 2.3.4 BS EDGE - should work on any version of 2.3

Here it is.... https://apps.oscommerce.com/RMpJA&shipstaion-for-oscommerce

Edited by greasemonkey

Share this post


Link to post
Share on other sites

Hello, 
I know this is a pretty old topic but I was wondering if this contribution still works. I am trying to get it installed with shipworks however after following the instructions I keep getting errors when testing connection. 

Here is the error I've been getting no matter what I do:

Store Configuration

We received an error testing the Custom store: An error was encountered while attempting to test the connection
 
Any help will be greatly appreciated as my oscommerce store is the only one left that needs integration with SS. 

Share this post


Link to post
Share on other sites

Yes, Sorry I misstyped about shipworks. I Do have ship station and for some weird reason cannot get it to work. I tried to get it to work a while back when I did a 30 day trial. Now I am actually paying for SS and been trying to get it to work with OSC but keep getting errors. I tried putting the php file in my root dir as well as in the catalog dir. I then tried putting it in the admin dir and been getting "unauthorized" error from SS. One time I did get SSL connection error but could not replicate that error. I also get this error when trying to load the file directly (www.mywebsiteaddress/oscommerce/shipstation_osc.php):

THE PAGE CONTAINS FOLLOWING ERRORS:
Error on line 1 at column 1: Document is empty

 

Have you ever had issues with connection between the SS and your site? Any pointers of what I should look into? My OSC version is: 2.3.4 and I am using MTS Mini Template but I doubt this has anything to do with the issue. I suspect it is my .htaccess and or other security config? 

 

Share this post


Link to post
Share on other sites

@rastlin No I have not had any issues connecting this to any site.

The file goes in your root or catalog directory - the same place that you find files such as shopping_cart.php, checkout_shipping.php etc.

Example: http://www.mystore.com/shipstation_osc.php or http://www.mystore.com/catalog/shipstation_osc.php (you may have renamed the catalog like you mentioned above) http://www.mystore.com/oscommerce/shipstation_osc.php

If you use ssl/https on the catalog side of your store then you need to ensure (step 4 in the instructions) the path to the file in the shipstation setup is https (ie look at your index.php does it have https - yes or no).

Example: https://www.mystore.com/shipstation_osc.php or https://www.mystore.com/catalog/shipstation_osc.php (you may have renamed the catalog like you mentioned above) https://www.mystore.com/oscommerce/shipstation_osc.php

Make sure the admin credentials you used in the shipstation setup are correct.

Also, confirm, you have new orders in your store for SS to get and that your "pending" order status and the pending order status=1. You can confirm by navigating to https://mystore.com/admin/orders.php?status=1

 

 

 

 

Share this post


Link to post
Share on other sites

@greasemonkey

I've tried to get it to work for few more hours last night and this morning but to no avail. Keep getting same error from ShipStation. I triple checked all variables (URL, username, password, status IDs and made sure that everything corresponds with the settings in the OsCommerce) The Shipstation shows error when doing "test connection" or when I just hit "connect". The error is:
---------------------------------
Store Configuration
We received an error testing the Custom store: An error was encountered while attempting to test the connection
-------------------------------

I know it is finding the file php file as if I on purpose change the file's name I get not found error. I dont know how to run some type of a debug to see at which point the script fails. It also could be something with Ship Station as maybe they have changed something when initially setting up the custom store? I see that your contribution is from 2017 so even though you are able to run it and it works, maybe the initial set up from SS was changed?

Share this post


Link to post
Share on other sites

@rastlin lets see.... despite the error, will it allow you to connect (hit connect not test connect)?

Also, can you take a screen shot (mask your store url username and password) of your details here

image.png.cf862ac4dc998445eaa6ddefaa63ef86.png

Edited by greasemonkey
added image

Share this post


Link to post
Share on other sites

Nope, Cant connect. It will not let me through to whatever is the next screen or step within the SS. attached is a screen shots. 1st is from when I hit "Test Connection" 2nd is from when I hit "connect"

 

Thank you for looking and trying to help me. I really appreciate it. 

 

 

 

shipstation_error.jpg

shipstation_error_connect.jpg

Share this post


Link to post
Share on other sites

here it is. However, my file is "orders_status.php" not "order_status.php" ... I am not sure if you made a type or if we just found the issue. 

orders_status php screen shot.jpg

Share this post


Link to post
Share on other sites

I sent you a PM.... but first try in ShipStation to change your connection status' to:

Unpaid Status to unpaid

Paid Status to "paid1, paid" (just like that with the comma - without the quotes)

 

Share this post


Link to post
Share on other sites

Hi Brian @rastlin the file seems to be in the right place (just confirm the URL is correctly set in ShipStation - to the one I sent you in the PM).

And also confirm the Unpaid Status and Paid Status in ShipStation are correct as mentioned above. They should be;

unpaid

paid1, paid

Edited by greasemonkey

Share this post


Link to post
Share on other sites

Everything seems to be working perfectly. The issue of No Connection during setup from Ship Station was due to little (stupid) setting within the OSCommerce. My cookies were being forced and this was blocking the connection from SS as SS was not able to use cookies when accessing the site. As soon as this option was turned off from within the OSC the installation from Ship Station was a success. I still had couple other issues due to too long strings that were in my database (payment string) as well as (shipping method string). I had to change those as well as make sure that the new orders would also meet the string length requirements. So far everything is working great. I really appreciate GreaseMonkey helping me look into his contribution and also Special thanks to George from Mini Template System contribution who jumped in and help me find the issue. 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×