Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Shipworks.com
 
Reply
   X-Cart forums > General > General talk
 
Thread Tools
  #31  
Old 08-23-2016, 05:56 AM
 
elmirage001 elmirage001 is offline
 

X-Wizard
  
Join Date: Apr 2007
Posts: 1,543
 

Default Re: Shipworks.com

Quote:
Originally Posted by Raptor
Also noticed after the upgrade, xcart puts a ton of tracking numbers as "0" in older orders. To easily get rid of all these just run the query

DELETE FROM `xcart_order_tracking_numbers` WHERE `xcart_order_tracking_numbers`.`tracking` = '0';
Hi Raptor, thanks again for both fixing SW, and for the education on how! I would have been banging my head on the wall for many days...

Paul
__________________
X-Cart GoldPlus v4.7.11 | PHP 7.2
  • XCARTMODS.CO.UK | reBOOT Template |
  • Smack Digital | CDSEO Pro 2.0 + Custom Replacements | Category SEO Map |
  • Total Server Solutions Hosting | Linux | PHP v7.2 | MySQL v5.6.40 |
Reply With Quote

The following 2 users thank elmirage001 for this useful post:
PhilJ (08-26-2016), Raptor (08-25-2016)
  #32  
Old 09-30-2016, 07:16 AM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

Quote:
Originally Posted by Raptor
Boom

I fixed the problem. Line 250:

It needs to insert the values and not update as they are now stored in a separate table from the order – update won’t work as the values don’t exist. This will now also support multiple tracking numbers too.

This is for all X-Cart versions above 4.7

PHP Code:
db_query("INSERT $sql_tbl[order_tracking_numbers] (tracking, orderid) VALUES ($trackingNumber,$orderid)"); 

Fixed a small bug. The tracking number had to be wrapped in single quotes '$trackingNumber' or tracking numbers with letters would not insert (so most international tracking numbers)

PHP Code:
db_query("INSERT $sql_tbl[order_tracking_numbers] (tracking, orderid) VALUES ('$trackingNumber',$orderid)"); 

Shipworks have been notified and they should be updating their official php soon enough.
__________________
X-Cart Gold Plus v4.7.7
- ReBOOT Template
- Advanced Category Menus & Featured Categories
- Advanced Testimonials
- Advanced Upselling Products
- Abandoned Cart Reminder
- Shipworks

Designed By Phil Jones - Highly Recommended for all X-Cart Custom work
www.xcartmods.co.uk
Reply With Quote

The following user thanks Raptor for this useful post:
elmirage001 (10-14-2016)
  #33  
Old 09-30-2016, 07:21 AM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

Now we need to get it to update the order status if it is changed in Xcart

i.e. if an order in X-Cart has already been downloaded to Shipworks as processed, but it is later set to cancelled or declined (in X-cart) - the status remains as processed in Shipworks, you have to do it manually - which is a nightmare if you have a seperate accounts and shipping department and hundreds of orders.
__________________
X-Cart Gold Plus v4.7.7
- ReBOOT Template
- Advanced Category Menus & Featured Categories
- Advanced Testimonials
- Advanced Upselling Products
- Abandoned Cart Reminder
- Shipworks

Designed By Phil Jones - Highly Recommended for all X-Cart Custom work
www.xcartmods.co.uk
Reply With Quote

The following user thanks Raptor for this useful post:
elmirage001 (10-02-2016)
  #34  
Old 10-18-2016, 06:48 AM
 
elmirage001 elmirage001 is offline
 

X-Wizard
  
Join Date: Apr 2007
Posts: 1,543
 

Default Re: Shipworks.com

Quote:
Originally Posted by Raptor
Now we need to get it to update the order status if it is changed in Xcart

i.e. if an order in X-Cart has already been downloaded to Shipworks as processed, but it is later set to cancelled or declined (in X-cart) - the status remains as processed in Shipworks, you have to do it manually - which is a nightmare if you have a seperate accounts and shipping department and hundreds of orders.
I looked at the code (with my limited understanding...) and I do not see a way for the user to mod this. It looks to me like the change would have to happen in the Shipworks software itself.
__________________
X-Cart GoldPlus v4.7.11 | PHP 7.2
  • XCARTMODS.CO.UK | reBOOT Template |
  • Smack Digital | CDSEO Pro 2.0 + Custom Replacements | Category SEO Map |
  • Total Server Solutions Hosting | Linux | PHP v7.2 | MySQL v5.6.40 |
Reply With Quote
  #35  
Old 12-30-2016, 01:18 AM
 
eric_smith eric_smith is offline
Banned
 

Newbie
  
Join Date: Dec 2016
Posts: 3
 

Default Re: Shipworks.com

Yes I used Shipworks.com for x cart and found a good integration between the two. And Shipworks is very good at customer managing.
Reply With Quote
  #36  
Old 10-26-2018, 09:42 AM
 
elmirage001 elmirage001 is offline
 

X-Wizard
  
Join Date: Apr 2007
Posts: 1,543
 

Default Re: Shipworks.com

Quote:
Originally Posted by Raptor
Fixed a small bug. The tracking number had to be wrapped in single quotes '$trackingNumber' or tracking numbers with letters would not insert (so most international tracking numbers)

PHP Code:
db_query("INSERT $sql_tbl[order_tracking_numbers] (tracking, orderid) VALUES ('$trackingNumber',$orderid)"); 

Shipworks have been notified and they should be updating their official php soon enough.
Hi Raptor,

My test store is now on 4.7.10 and PHP 7.2 so I asked for an updated ShipWorks3.php file. First they sent me the X-CART 5 version and after another request I was sent the same old XCART4_v3_3_6_1.zip version.

I applied your database edit above and it works great! I also made the change below. Not sure if it's 100% correct but it worked for me. I'll send ShipWorks my updated .php file.

From:
Code:
# Required XCart setup require "../top.inc.php"; include "./auth.php";
To:
Code:
# Required XCart setup //require "../top.inc.php"; //include "./auth.php"; require_once __DIR__.'/top.inc.php'; require_once __DIR__.'/auth.php';
Thank you again for making the upgrade process easier!!

Paul
__________________
X-Cart GoldPlus v4.7.11 | PHP 7.2
  • XCARTMODS.CO.UK | reBOOT Template |
  • Smack Digital | CDSEO Pro 2.0 + Custom Replacements | Category SEO Map |
  • Total Server Solutions Hosting | Linux | PHP v7.2 | MySQL v5.6.40 |
Reply With Quote
Reply
   X-Cart forums > General > General talk


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 10:59 PM.

   

 
X-Cart forums © 2001-2018