date error with Amazon status update: Fixed - beta 1.6.7.5

Started by advancedmart, October 06, 2014, 07:49:32 PM

Previous topic - Next topic

advancedmart

error with last two versions. if I send tracking to amazon late in the day I get this,

SuperManager sent the following post (FeedSubmissionId 50032016349):
order-id   order-item-id   quantity   ship-date   carrier-code   carrier-name   tracking-number   ship-method
111-4515587-3531415   32092630108762   1   2014-10-05   USPS   US Postal Service   LZ133979353US   Std Canada
111-4515587-3531415   66998603649010   1   2014-10-05   USPS   US Postal Service   LZ133979353US   Std Canada


Amazon sent the following reply:
Feed Processing Summary:
   Number of records processed      2
   Number of records successful      0

original-record-number   order-id   order-item-id   error-code   error-type   error-message
1   111-4515587-3531415      18028   Error   The ship-date or FulfillmentDate you provided (Sun Oct 05 00:00:00 UTC 2014) was not between the order date (Mon Oct 06 00:00:00 UTC 2014) and now (Mon Oct 06 03:10:13 UTC 2014).
1         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].
2   111-4515587-3531415      18028   Error   Your feed has one or more messages that failed to process properly. Please review the error messages for your feed to identify and fix the issue, and then resubmit your feed.
2         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].


SuperManager sent the following post (FeedSubmissionId 50035016350):
order-id   order-item-id   quantity   ship-date   carrier-code   carrier-name   tracking-number   ship-method
102-5136070-3668264   13699075997898   1   2014-10-06   USPS   US Postal Service   9402110200882344914547   Std Cont US Street Addr
108-0605799-1507433   21408227532714   1   2014-10-06   USPS   US Postal Service   9402110200828344828552   Std Cont US Street Addr
112-1383560-8433869   56983712320218   1   2014-10-06   USPS   US Postal Service   9402110200883371443703   Std Cont US Street Addr


Amazon sent the following reply:
Feed Processing Summary:
   Number of records processed      3
   Number of records successful      1

original-record-number   order-id   order-item-id   error-code   error-type   error-message
1   102-5136070-3668264      18028   Error   The ship-date or FulfillmentDate you provided (Mon Oct 06 00:00:00 UTC 2014) was not between the order date (Tue Oct 07 00:00:00 UTC 2014) and now (Tue Oct 07 02:37:31 UTC 2014).
1         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].
2   108-0605799-1507433      18028   Error   The ship-date or FulfillmentDate you provided (Mon Oct 06 00:00:00 UTC 2014) was not between the order date (Tue Oct 07 00:00:00 UTC 2014) and now (Tue Oct 07 02:37:31 UTC 2014).
2         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].
3         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].






David Johns

#1
Thanks for the detail feedback.  The Amazon documentation doesn't give the time zone to use in this update and apparently it can vary from account to account.  I have released an update that takes advantage of undocumented features for this update.  Please give it a try and let me know right away if it is working for you.  To try it out, update to 1.6.7.3 out this morning.

Thanks,
David
SuperManager Support
info@thesupermanager.com

advancedmart

#2
still giving the same error. is there a log, I did not keep error by mistake.

David Johns

I've made another attempt to get Amazon to interpret the times correct.  Please try updating to 1.6.7.4 and see if it works now.

Thanks,
David
SuperManager Support
info@thesupermanager.com

CoolPC


advancedmart

many work but still hit this error today.

SuperManager sent the following post (FeedSubmissionId 50050016353):
order-id   order-item-id   quantity   ship-date   carrier-code   carrier-name   tracking-number   ship-method
105-9961505-8283452   58708942989466   1   2014-10-10T19:00:00+00:00   USPS   US Postal Service   9402110200882348984362   Std Cont US Street Addr


Amazon sent the following reply:
Feed Processing Summary:
   Number of records processed      1
   Number of records successful      0

original-record-number   order-id   order-item-id   error-code   error-type   error-message
1   105-9961505-8283452      18028   Error   The ship-date or FulfillmentDate you provided (Fri Oct 10 19:00:00 UTC 2014) was not between the order date (Fri Oct 10 00:00:00 UTC 2014) and now (Fri Oct 10 07:26:40 UTC 2014).
1         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].

David Johns

OK.  Making progress now.  Now amazon is reading the time correctly from the submission.  The issue seems to be rounding errors SuperManager puts on the time of shipment.  AdvancedMart,  how are you importing shipment information from SuperManager for that order?  Dazzle XML? Text import from FedEx or another software? Typing in manually?  Something else?

Thanks,
David
SuperManager Support
info@thesupermanager.com

CoolPC

#7
The error is back today, processed 9 orders and all failed, unfortunately I accidentally wiped my clipboard so I can't paste the dump

David Johns

CoolPC,

Thanks for chiming in.  It seems the issue probably occurs when trying to send orders before noon local time.  In some places, SuperManager makes an  that when you say a pack is shipped today it sets the exact time to today at noon.  If you update orders before noon, it then says its not noon yet, but you are telling me you shipped it at noon today.  We will take one of a couple of approaches to correcting the issue, but I'm wondering what method you are using that sets the shipmark date.  Dazzle XML, WorldShip XML, Manually entering it, etc?

Thanks,
David
SuperManager Support
info@thesupermanager.com

advancedmart

time came from   Dazzle XML  Print Date & Time:   10/10/2014  9:49 PM
Ship Date:   10/10/2014

got this error

SuperManager sent the following post (FeedSubmissionId 50055016354):
order-id   order-item-id   quantity   ship-date   carrier-code   carrier-name   tracking-number   ship-method
116-0655384-8399416   23711652458218   1   2014-10-10T19:00:00+00:00   USPS   US Postal Service   9402110200830439169594   Std Cont US PO Box


Amazon sent the following reply:
Feed Processing Summary:
   Number of records processed      1
   Number of records successful      0

original-record-number   order-id   order-item-id   error-code   error-type   error-message
1   116-0655384-8399416      18028   Error   The ship-date or FulfillmentDate you provided (Fri Oct 10 19:00:00 UTC 2014) was not between the order date (Sat Oct 11 00:00:00 UTC 2014) and now (Sat Oct 11 04:50:02 UTC 2014).
1         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].

order date in SM  10 Oct 2014 17:34:29

order date on amazon, Order Date:   October 10, 2014 5:34:29 PM PDT


advancedmart

still happens when I update late at night,

SuperManager sent the following post (FeedSubmissionId 50062016356):
order-id   order-item-id   quantity   ship-date   carrier-code   carrier-name   tracking-number   ship-method
112-0895113-2273044   65440086202362   1   2014-10-13T19:00:00+00:00   USPS   US Postal Service   9402110200829350575560   Std Cont US Street Addr


Amazon sent the following reply:
Feed Processing Summary:
   Number of records processed      1
   Number of records successful      0

original-record-number   order-id   order-item-id   error-code   error-type   error-message
1   112-0895113-2273044      18028   Error   The ship-date or FulfillmentDate you provided (Mon Oct 13 19:00:00 UTC 2014) was not between the order date (Mon Oct 13 00:00:00 UTC 2014) and now (Mon Oct 13 07:50:47 UTC 2014).
1         99011   Warning   The value in the "carrier-name" (US Postal Service) field was ignored because it is invalid or conflicts with the value in another field.: [carrier-code = "USPS"].

CoolPC

We use Dazzle and Worldship XML for updating the orders, we process them a few times a day, I'll try and test out only sending updates after Noon PDT and see if the error persists.

*edit*
I just tried updating the orders that didn't go through on Friday and they went through at 9:45AM PDT

David Johns

We just released 1.6.7.5, which we think will help problems a bit.  A while back, from looking at the Amazon documentation, we thought it was only possible to set the day, but not the time of the ship date.  Because of that, we were often getting these errors for customers processing orders in certain time zones.  For that reason, we changed the shipment imports to  shipments were made at noon local time, which made it most likely that shipments would be recorded in the same date no matter which time zone was .  The drawback of this is that orders received the next day in GMT caused errors because Amazon saw it as being shipped the day before the order was received.  Now that we have successfully demonstrated being able to pass amazon both the date and time of the shipment, we have switched beta 1.6.7.5 to record the shipment date specified by dazzle/stamps.com/other text file, but use the current time of day if not specified.  I think this approach will work for all situations.  Please give it a try and report back.

Thanks,
David
SuperManager Support
info@thesupermanager.com