Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jefff

Archived
  • Posts

    48
  • Joined

  • Last visited

About jefff

  • Birthday 06/07/1964

Profile Information

jefff's Achievements

  1. I just installed CCGV 5.14. I can e-mail a gift voucher and the redeem link works fine. The shopping cart shows the voucher balance. But when I get to the payment screen at checkout, there is nothing there to indicate that there is a voucher balance to be applied -- just the credit box to enter a code to redeem. What's wrong ??!?!???
  2. I've got RC4 running on a live site. No problems so far. And I've modified it so that depending on the ship-to address, it uses either the UPS vendor ship module or the table rate method in the standard shipping modules. :-) I needed that because I wanted a flat rate -- PER ORDER -- not per vendor as the table rate vendors shipping module is.
  3. Anyone have a way to use the vendor shipping table rates so that it uses the total for ALL vendors and products to base the shipping price on ??? If I have 3 products on an order from 3 different vendors, I want to add the prices of ALL 3 products and then use that total for the table rate shipping -- instead of a seperate charge for EACH vendor/item. Or can I enable the standard shipping module table rate in addition to any defined vendor shipping methods ??? Thanks for the replies. Jeff.
  4. One other bug I found today. In the Administration area, when you view an order the shipping line shows that tax for the shipping charge, but the items are not showing the prices with tax added under the columns "Price (inc)" and "Total (inc)". Under those columns, the prices shown are the same as the price in the "Price (exc)" and "Total (exc)" columns. Since the total order tax is shown down in the totals area, it might be cleaner to drop the "(inc)" columns ?? I'm not sure. At this point, though, they are not displaying correctly. Thanks, Jeff.
  5. You also need to change the following in usps.php: if ( ($this->enabled == true) && ((int)constant('MODULE_SHIPPING_USPS_RATES_ZONE_' . $vendors_id) > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . (int)constant('MODULE_SHIPPING_USPS_RATES_ZONE_' . $vendors_id) . "' and zone_country_id = '" . $this->delivery_country_id . "' order by zone_id"); It should be : if ( ($this->enabled == true) && ((int)constant('MODULE_SHIPPING_USPS_ZONE_' . $vendors_id) > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . (int)constant('MODULE_SHIPPING_USPS_ZONE_' . $vendors_id) . "' and zone_country_id = '" . $this->delivery_country_id . "' order by zone_id"); Jeff.
  6. FOUND IT !!! This one - is - a code problem :) In the usps.php file, this function: function enabled($vendors_id='1') { $this->enabled = false; $status = @constant('MODULE_SHIPPING_USPS_RATES_STATUS_' . $vendors_id); if (isset ($status) && $status != '') { $this->enabled = (($status == 'True') ? true : false); } should be as follows: function enabled($vendors_id='1') { $this->enabled = false; $status = @constant('MODULE_SHIPPING_USPS_STATUS_' . $vendors_id); if (isset ($status) && $status != '') { $this->enabled = (($status == 'True') ? true : false); }
  7. I enabled the mail() call in the usps.php module and I never got an email. So I'm wondering now if the module is even getting called. Jeff.
  8. FYI - I'm still not getting anything with the USPS module. Any ideas ?? Thx. Jeff.
  9. Found the prob ! It's not the code.. it's a geography lesson. DUH. UPS does not consider PR as a state in the U.S. like Alaska and Hawaii (but the Postal Service DOES). So if you use this address it will fail: John Doe 123 Any Street San Juan, PR United States If you use this address it will return rates correctly: John Doe 123 Any Street San Juan, PR Puerto Rico Live and learn. :thumbsup:
  10. It's wierd -- it's not like it isn't working at all. I get rates for states in the contig. 48 and for Alaska and Hawaii. Just nothing for Puerto Rico ! Thx.
  11. Any news on this issue ? Thanks for the help. Jeff.
  12. Here's the upsxml.log file contents for the Puerto Rico address: ------------------------------------------ DATE AND TIME: 2005-06-09 08:58:21 UPS URL: https://wwwcie.ups.com:443/ups.app/xml/TimeInTransit UPS REQUEST: <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>xxxxxxxxxxx</AccessLicenseNumber> <UserId>xxxxxxxx</UserId> <Password>xxxxxx</Password> </AccessRequest> <?xml version="1.0"?> <TimeInTransitRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Time in Transit</CustomerContext> <XpciVersion>1.0001</XpciVersion> </TransactionReference> <RequestAction>TimeInTransit</RequestAction> </Request> <TransitFrom> <AddressArtifactFormat> <PoliticalDivision2>Madison</PoliticalDivision2> <PoliticalDivision1>WI</PoliticalDivision1> <CountryCode>US</CountryCode> <PostcodePrimaryLow>53711</PostcodePrimaryLow> </AddressArtifactFormat> </TransitFrom> <TransitTo> <AddressArtifactFormat> <PoliticalDivision2>San Juan</PoliticalDivision2> <PoliticalDivision1>PR</PoliticalDivision1> <CountryCode>US</CountryCode> <PostcodePrimaryLow>00975</PostcodePrimaryLow> <PostcodePrimaryHigh>00975</PostcodePrimaryHigh> </AddressArtifactFormat> </TransitTo> <PickupDate>20050610</PickupDate> <ShipmentWeight> <UnitOfMeasurement> <Code>LBS</Code> </UnitOfMeasurement> <Weight>10</Weight> </ShipmentWeight> <InvoiceLineTotal> <CurrencyCode>USD</CurrencyCode> <MonetaryValue>100</MonetaryValue> </InvoiceLineTotal> </TimeInTransitRequest> UPS RESPONSE: <?xml version="1.0"?><TimeInTransitResponse><Response><TransactionReference><CustomerContext>Time in Transit</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>0</ResponseStatusCode><ResponseStatusDescription>Failure</ResponseStatusDescription><Error><ErrorSeverity>Hard</ErrorSeverity><ErrorCode>270005</ErrorCode><ErrorDescription>Invalid Destination Postal Code in TimeInTransit</ErrorDescription></Error></Response></TimeInTransitResponse> ------------------------------------------ Time in Transit: 0 ------------------------------------------ DATE AND TIME: 2005-06-09 08:58:22 UPS URL: https://wwwcie.ups.com:443/ups.app/xml/Rate UPS REQUEST: <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>xxxxxxxxxx</AccessLicenseNumber> <UserId>xxxxxxxxx</UserId> <Password>xxxxxxx</Password> </AccessRequest> <?xml version="1.0"?> <RatingServiceSelectionRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Rating and Service</CustomerContext> <XpciVersion>1.0001</XpciVersion> </TransactionReference> <RequestAction>Rate</RequestAction> <RequestOption>shop</RequestOption> </Request> <PickupType> <Code>03</Code> </PickupType> <Shipment> <Shipper> <Address> <City>Madison</City> <StateProvinceCode>WI</StateProvinceCode> <CountryCode>US</CountryCode> <PostalCode>53711</PostalCode> </Address> </Shipper> <ShipTo> <Address> <City>San Juan</City> <StateProvinceCode>PR</StateProvinceCode> <CountryCode>US</CountryCode> <PostalCode>00975</PostalCode> <ResidentialAddressIndicator/> </Address> </ShipTo> <Package> <PackagingType> <Code>02</Code> </PackagingType> <PackageWeight> <UnitOfMeasurement> <Code>LBS</Code> </UnitOfMeasurement> <Weight>1.3</Weight> </PackageWeight> </Package> </Shipment> <CustomerClassification> <Code>03</Code> </CustomerClassification> </RatingServiceSelectionRequest> UPS RESPONSE: <?xml version="1.0"?><RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext>Rating and Service</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>0</ResponseStatusCode><ResponseStatusDescription>Failure</ResponseStatusDescription><Error><ErrorSeverity>Hard</ErrorSeverity><ErrorCode>113021</ErrorCode><ErrorDescription>The Ship To postal code is invalid for the selected location.</ErrorDescription></Error></Response></RatingServiceSelectionResponse> ------------------------------------------ DATE AND TIME: 2005-06-09 08:58:22 UPS URL: https://wwwcie.ups.com:443/ups.app/xml/TimeInTransit UPS REQUEST: <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>xxxxxxxxxxxx</AccessLicenseNumber> <UserId>xxxxxxxx</UserId> <Password>xxxxxxxx</Password> </AccessRequest> <?xml version="1.0"?> <TimeInTransitRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Time in Transit</CustomerContext> <XpciVersion>1.0001</XpciVersion> </TransactionReference> <RequestAction>TimeInTransit</RequestAction> </Request> <TransitFrom> <AddressArtifactFormat> <PoliticalDivision2>Madison</PoliticalDivision2> <PoliticalDivision1>WI</PoliticalDivision1> <CountryCode>US</CountryCode> <PostcodePrimaryLow>53711</PostcodePrimaryLow> </AddressArtifactFormat> </TransitFrom> <TransitTo> <AddressArtifactFormat> <PoliticalDivision2>San Juan</PoliticalDivision2> <PoliticalDivision1>PR</PoliticalDivision1> <CountryCode>US</CountryCode> <PostcodePrimaryLow>00975</PostcodePrimaryLow> <PostcodePrimaryHigh>00975</PostcodePrimaryHigh> </AddressArtifactFormat> </TransitTo> <PickupDate>20050610</PickupDate> <ShipmentWeight> <UnitOfMeasurement> <Code>LBS</Code> </UnitOfMeasurement> <Weight>10</Weight> </ShipmentWeight> <InvoiceLineTotal> <CurrencyCode>USD</CurrencyCode> <MonetaryValue>100</MonetaryValue> </InvoiceLineTotal> </TimeInTransitRequest> UPS RESPONSE: <?xml version="1.0"?><TimeInTransitResponse><Response><TransactionReference><CustomerContext>Time in Transit</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>0</ResponseStatusCode><ResponseStatusDescription>Failure</ResponseStatusDescription><Error><ErrorSeverity>Hard</ErrorSeverity><ErrorCode>270005</ErrorCode><ErrorDescription>Invalid Destination Postal Code in TimeInTransit</ErrorDescription></Error></Response></TimeInTransitResponse> ------------------------------------------ Time in Transit: 0 ------------------------------------------ DATE AND TIME: 2005-06-09 08:58:22 UPS URL: https://wwwcie.ups.com:443/ups.app/xml/Rate UPS REQUEST: <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>xxxxxxxxxxx</AccessLicenseNumber> <UserId>xxxxxx</UserId> <Password>xxxxxxx</Password> </AccessRequest> <?xml version="1.0"?> <RatingServiceSelectionRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Rating and Service</CustomerContext> <XpciVersion>1.0001</XpciVersion> </TransactionReference> <RequestAction>Rate</RequestAction> <RequestOption>shop</RequestOption> </Request> <PickupType> <Code>03</Code> </PickupType> <Shipment> <Shipper> <Address> <City>Madison</City> <StateProvinceCode>WI</StateProvinceCode> <CountryCode>US</CountryCode> <PostalCode>53711</PostalCode> </Address> </Shipper> <ShipTo> <Address> <City>San Juan</City> <StateProvinceCode>PR</StateProvinceCode> <CountryCode>US</CountryCode> <PostalCode>00975</PostalCode> <ResidentialAddressIndicator/> </Address> </ShipTo> <Package> <PackagingType> <Code>02</Code> </PackagingType> <PackageWeight> <UnitOfMeasurement> <Code>LBS</Code> </UnitOfMeasurement> <Weight>1.3</Weight> </PackageWeight> </Package> </Shipment> <CustomerClassification> <Code>03</Code> </CustomerClassification> </RatingServiceSelectionRequest> UPS RESPONSE: <?xml version="1.0"?><RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext>Rating and Service</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>0</ResponseStatusCode><ResponseStatusDescription>Failure</ResponseStatusDescription><Error><ErrorSeverity>Hard</ErrorSeverity><ErrorCode>113021</ErrorCode><ErrorDescription>The Ship To postal code is invalid for the selected location.</ErrorDescription></Error></Response></RatingServiceSelectionResponse>
  13. I also tried this shipping from address in the UPS XML setup: Madison, WI 53711 United States. I get the same error: 113021: The Ship To postal code is invalid for the selected location.
  14. The "from" zip code is in Salem, OR 97303 United States
  15. 0.9 RC4: I also just tried with the UPS XML module -- I get this returned during checkout: 113021: The Ship To postal code is invalid for the selected location. Address I'm testing is: San Juan, PR 00975 United States What's up ? Jeff.
×
×
  • Create New...