You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi Guys:
I have turned on USPS real time rates and services
Location: System Dashboard > Store > Shipping > Realtime Carriers
Location: System Dashboard > Store > Shipping > Realtime Services
But I cannot get the rates to show up at all for priority medium box (or anything else).
I turned on debug but I am nt sure what it is telling me.
Here is the debug section. Can anyone suggest what my problem is? Thanks.
CORE_DB::clause_insert: The following INSERT clause was created: INSERT INTO ecom_orderitems VALUES ('ORD201309042-5b80t9na71oc', 'ORD201309042', '1378323927', 'P', 'UPS Ground', 'UTFY, UTBB, UTBC', 'All3books', 'All3books', '1', '', '54.85', '0.00', '0', 'Tim', 'Gillespie', 'Mountain Studios', '1025 Oakdale Place', '', 'Boulder', 'Colorado', 'United States', '80304', 'R', 'a:31:{s:6:\"randid\";s:12:\"5b80t9na71oc\";s:2:\"id\";s:9:\"All3books\";s:8:\"quantity\";i:1;s:4:\"name\";s:16:\"UTFY, UTBB, UTBC\";s:6:\"number\";s:9:\"All3books\";s:5:\"imgsm\";s:24:\"utbb-utbc-utfy-small.jpg\";s:7:\"prodinv\";s:1:\"0\";s:7:\"optdisp\";a:0:{}s:9:\"optselids\";s:0:\"\";s:6:\"optids\";s:0:\"\";s:6:\"optinv\";s:0:\"\";s:7:\"dlfiles\";s:0:\"\";s:9:\"delmethod\";s:1:\"R\";s:11:\"sinshipinfo\";a:11:{s:9:\"shiplocal\";s:14:\"UPSTOOLS, USPS\";s:7:\"shipint\";s:4:\"USPS\";s:10:\"shiplength\";s:2:\"11\";s:9:\"shipwidth\";s:3:\"8.5\";s:10:\"shipheight\";s:1:\"2\";s:10:\"shipweight\";s:5:\"4.000\";s:10:\"shipnumbox\";s:1:\"0\";s:13:\"shipstateprov\";s:8:\"Colorado\";s:11:\"shipcountry\";s:13:\"United States\";s:7:\"shipzip\";s:5:\"80304\";s:8:\"shiptype\";s:1:\"R\";}s:9:\"shipemail\";s:0:\"\";s:12:\"sinprodprice\";a:7:{s:4:\"type\";s:1:\"R\";s:8:\"displayb\";s:6:\"$54.85\";s:7:\"actualb\";s:7:\"54.8500\";s:8:\"displayr\";N;s:7:\"actualr\";N;s:9:\"displaybx\";N;s:8:\"actualbx\";N;}s:11:\"sinoptprice\";a:0:{}s:10:\"sinaffcomm\";i:0;s:7:\"taxinfo\";a:3:{s:11:\"ratebasissp\";a:1:{s:8:\"STANDARD\";d:1;}s:10:\"ratebasisc\";a:1:{s:8:\"STANDARD\";d:1;}s:10:\"classbasis\";a:1:{s:8:\"STANDARD\";d:1;}}s:8:\"subtotal\";d:54.85000000000000142108547152020037174224853515625;s:11:\"subtotalrec\";i:0;s:3:\"url\";s:8:\"INTERNAL\";s:9:\"addemtext\";s:0:\"\";s:7:\"xupsell\";s:0:\"\";s:20:\"sinprodloyaltypoints\";i:0;s:19:\"sinoptloyaltypoints\";i:0;s:13:\"loyaltypoints\";i:0;s:7:\"uploads\";a:0:{}s:8:\"savetype\";s:4:\"CART\";s:7:\"sortnum\";i:0;s:10:\"totalbasis\";a:13:{s:8:\"shipping\";s:5:\"12.06\";s:16:\"shipping_taxable\";s:5:\"12.06\";s:15:\"customsurcharge\";s:4:\"0.00\";s:10:\"customsale\";s:4:\"0.00\";s:13:\"loyaltypoints\";s:4:\"0.00\";s:8:\"discount\";s:4:\"0.00\";s:12:\"taxstateprov\";s:4:\"4.48\";s:10:\"taxcountry\";s:4:\"0.00\";s:13:\"taxcountryref\";s:4:\"0.00\";s:17:\"taxcountrydisplay\";s:4:\"0.00\";s:20:\"taxcountryrefdisplay\";s:4:\"0.00\";s:20:\"taxcountrypctdisplay\";s:5:\"0.000\";s:24:\"taxcountrypctshipdisplay\";s:5:\"0.000\";}}')
CORE_DB_mysql::xsql_do: The MySQL extension executed statement: INSERT INTO ecom_orderitems VALUES ('ORD201309042-5b80t9na71oc', 'ORD201309042', '1378323927', 'P', 'UPS Ground', 'UTFY, UTBB, UTBC', 'All3books', 'All3books', '1', '', '54.85', '0.00', '0', 'Tim', 'Gillespie', 'Mountain Studios', '1025 Oakdale Place', '', 'Boulder', 'Colorado', 'United States', '80304', 'R', 'a:31:{s:6:\"randid\";s:12:\"5b80t9na71oc\";s:2:\"id\";s:9:\"All3books\";s:8:\"quantity\";i:1;s:4:\"name\";s:16:\"UTFY, UTBB, UTBC\";s:6:\"number\";s:9:\"All3books\";s:5:\"imgsm\";s:24:\"utbb-utbc-utfy-small.jpg\";s:7:\"prodinv\";s:1:\"0\";s:7:\"optdisp\";a:0:{}s:9:\"optselids\";s:0:\"\";s:6:\"optids\";s:0:\"\";s:6:\"optinv\";s:0:\"\";s:7:\"dlfiles\";s:0:\"\";s:9:\"delmethod\";s:1:\"R\";s:11:\"sinshipinfo\";a:11:{s:9:\"shiplocal\";s:14:\"UPSTOOLS, USPS\";s:7:\"shipint\";s:4:\"USPS\";s:10:\"shiplength\";s:2:\"11\";s:9:\"shipwidth\";s:3:\"8.5\";s:10:\"shipheight\";s:1:\"2\";s:10:\"shipweight\";s:5:\"4.000\";s:10:\"shipnumbox\";s:1:\"0\";s:13:\"shipstateprov\";s:8:\"Colorado\";s:11:\"shipcountry\";s:13:\"United States\";s:7:\"shipzip\";s:5:\"80304\";s:8:\"shiptype\";s:1:\"R\";}s:9:\"shipemail\";s:0:\"\";s:12:\"sinprodprice\";a:7:{s:4:\"type\";s:1:\"R\";s:8:\"displayb\";s:6:\"$54.85\";s:7:\"actualb\";s:7:\"54.8500\";s:8:\"displayr\";N;s:7:\"actualr\";N;s:9:\"displaybx\";N;s:8:\"actualbx\";N;}s:11:\"sinoptprice\";a:0:{}s:10:\"sinaffcomm\";i:0;s:7:\"taxinfo\";a:3:{s:11:\"ratebasissp\";a:1:{s:8:\"STANDARD\";d:1;}s:10:\"ratebasisc\";a:1:{s:8:\"STANDARD\";d:1;}s:10:\"classbasis\";a:1:{s:8:\"STANDARD\";d:1;}}s:8:\"subtotal\";d:54.85000000000000142108547152020037174224853515625;s:11:\"subtotalrec\";i:0;s:3:\"url\";s:8:\"INTERNAL\";s:9:\"addemtext\";s:0:\"\";s:7:\"xupsell\";s:0:\"\";s:20:\"sinprodloyaltypoints\";i:0;s:19:\"sinoptloyaltypoints\";i:0;s:13:\"loyaltypoints\";i:0;s:7:\"uploads\";a:0:{}s:8:\"savetype\";s:4:\"CART\";s:7:\"sortnum\";i:0;s:10:\"totalbasis\";a:13:{s:8:\"shipping\";s:5:\"12.06\";s:16:\"shipping_taxable\";s:5:\"12.06\";s:15:\"customsurcharge\";s:4:\"0.00\";s:10:\"customsale\";s:4:\"0.00\";s:13:\"loyaltypoints\";s:4:\"0.00\";s:8:\"discount\";s:4:\"0.00\";s:12:\"taxstateprov\";s:4:\"4.48\";s:10:\"taxcountry\";s:4:\"0.00\";s:13:\"taxcountryref\";s:4:\"0.00\";s:17:\"taxcountrydisplay\";s:4:\"0.00\";s:20:\"taxcountryrefdisplay\";s:4:\"0.00\";s:20:\"taxcountrypctdisplay\";s:5:\"0.000\";s:24:\"taxcountrypctshipdisplay\";s:5:\"0.000\";}}')
Offline
Do you have the most recent updates installed from July when the USPS changed all the rates and names of the products? It required a code change in CCP.
Offline
Update to CCP 8.0.6:
https://kryptronic.com/cms-xmodnewsrss_ … 2013A.html
Offline
I did and that was the problem.
Thanks for the suggestion.
Offline