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
  #21  
Old 08-22-2016, 11:42 AM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

Thanks for that

But now i'm getting incorrect username and password in shipworks - wtf ?
__________________
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
  #22  
Old 08-22-2016, 12:45 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

I fixed the user/pass issue by rolling back to the previous shipworks module (3.3.6.0) - such a pain.

The table fix didn't solve. It didn't upload anything to the db - but not getting any sql error emails either.
__________________
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
  #23  
Old 08-22-2016, 01:14 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

I see the error. The order ID doesn't exist - it needs to ADD it
__________________
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
  #24  
Old 08-22-2016, 01:28 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

OK somewhat solved it - it adds all the tracking numbers correctly now - they show up in xcart correctly

Code:
db_query("update $sql_tbl[order_tracking_numbers] set tracking='$trackingNumber', orderid='$orderid'");

HOWEVER i now get sql error emails

SQL query : update xcart_order_tracking_numbers set tracking='11111111111111111111', orderid='12345'
Error code : 1062
Description : Duplicate entry '12345-11111111111111111111' for key 'PRIMARY'
Request URI: /admin/shipworks3new.php
Backtrace:
__________________
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
  #25  
Old 08-22-2016, 02:24 PM
 
elmirage001 elmirage001 is offline
 

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

Default Re: Shipworks.com

Do you get the error with a "New" order with a new 'orderid'?
__________________
X-Cart GoldPlus v4.7.11 | PHP 7.2.22
  • 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
  #26  
Old 08-22-2016, 02:27 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

It needs to be insert and not update.....

INSERT xcart_order_tracking_numbers (tracking, orderid)
VALUES (11111111111111111111,12345);
__________________
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
  #27  
Old 08-22-2016, 02:36 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

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)"); 
__________________
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 2 users thank Raptor for this useful post:
elmirage001 (08-22-2016), PhilJ (08-22-2016)
  #28  
Old 08-22-2016, 02:43 PM
 
elmirage001 elmirage001 is offline
 

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

Default Re: Shipworks.com

Quote:
Originally Posted by Raptor
Boom

PHP Code:
db_query("INSERT $sql_tbl[order_tracking_numbers] (tracking, orderid) VALUES ($trackingNumber,$orderid)"); 
Thanks so much! I appreciate all your hard work! Paul
__________________
X-Cart GoldPlus v4.7.11 | PHP 7.2.22
  • 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 user thanks elmirage001 for this useful post:
PhilJ (08-22-2016)
  #29  
Old 08-22-2016, 03:17 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

You can also add your Custom Order Status Codes if you have that module activated. It's easy to find the 2 digital code using something like Firebug

Around Line 258:

PHP Code:
// Returns the status codes supported by XCart
    
function action_GetStatusCodes()
    {
        
$codes = array("B" => "Backordered",
            
"C" => "Complete",
            
"D" => "Declined",
            
"F" => "Failed",
            
"I" => "Not Finished",
            
"P" => "Processed",
            
"Q" => "Queued",
            
"T1" => "Refunded",
            
"V3" => "Canceled"); 

__________________
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 2 users thank Raptor for this useful post:
elmirage001 (08-23-2016), PhilJ (08-22-2016)
  #30  
Old 08-22-2016, 09:15 PM
  Raptor's Avatar 
Raptor Raptor is offline
 

Senior Member
  
Join Date: Jan 2006
Posts: 125
 

Default Re: Shipworks.com

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';
__________________
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 (08-23-2016)
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 12:37 AM.

   

 
X-Cart forums © 2001-2018