Forums / Built-in Shipping and Payment Modules / Tax amount excluded from total amount transferred to Paypal

Tax amount excluded from total amount transferred to Paypal

Locked

Views: 7,287

Results 1 to 16 of 16
This thread is locked. New replies are disabled.
30 Nov 2007, 3:30 PM
#1
rykmann avatar

rykmann

New Zenner

Join Date:
Nov 2007
Posts:
10
Plugin Contributions:
0

Tax amount excluded from total amount transferred to Paypal

I have set-up the tax and shipping in Zen-Cart (ZC). I am using a Paypal IPN. When I go through the checkout ZC adds the correct tax and shipping. I have price breaks on shipping which are dependant on the order amount. When I am transferred to Paypal to make the actual payment the Total amount is transferred (Goods and shipping) less the Tax amount.

30 Nov 2007, 5:03 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax amount excluded from total amount transferred to Paypal

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Nov 2007, 10:41 PM
#3
rykmann avatar

rykmann

New Zenner

Join Date:
Nov 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Spoke to the person setting up my shopping cart and he said that "this has already been done on the PayPal file". I spoke to Paypal support and they say that there must be an error in the format - thats the reason the tax amount is not being accepted by Paypal.

1 Dec 2007, 1:08 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax amount excluded from total amount transferred to Paypal

Perhaps the person setting up your cart can turn on the PayPal debug logging and figure out what's being transmitted incorrectly.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Dec 2007, 7:01 PM
#5
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Rykmann:

I have set-up the tax and shipping in Zen-Cart (ZC). I am using a Paypal IPN. When I go through the checkout ZC adds the correct tax and shipping. I have price breaks on shipping which are dependant on the order amount. When I am transferred to Paypal to make the actual payment the Total amount is transferred (Goods and shipping) less the Tax amount.

Hi ,
I am trying to setup tax for Ryk. I have turned on the paypal debug and below are the returned values. The tax amt seems t be empty and is not parsing correctly. Any insight would b appreciated. Below is debug

Dec 01 2007 12:56 -- IPN PROCESSING INITIATED. 
*** Originating IP: 66.211.170.66  notify.paypal.com

Dec 01 2007 12:56 -- IPN NOTICE :: ipn_application_top -> language files okay

Dec 01 2007 12:56 -- IPN INFO - POST VARS received (sorted):
Array
(
    [address_city] => Sterling Heights
    [address_country] => United States
    [address_country_code] => US
    [address_name] => test testing
    [address_state] => MI
    [address_status] => confirmed
    [address_street] => tstring dr
    [address_zip] => 48310
    [charset] => windows-1252
    [custom] => 
    [first_name] => test
    [item_name1] => Test1
    [item_number1] => ter
    [last_name] => testing
    [mc_currency] => CAD
    [mc_fee] => 0.64
    [mc_gross] => 3.00
    [mc_gross_1] => 0.50
    [mc_handling] => 0.00
    [mc_handling1] => 0.00
    [mc_shipping] => 2.50
    [mc_shipping1] => 0.00
    [mc_tax1] => 0.00
    [notify_version] => 2.4
    [num_cart_items] => 1
    [payer_email] => xxxxxxxxx
    [payer_id] => 7A7C4FVNVQYCJ
    [payer_status] => verified
    [payment_date] => 09:55:53 Dec 01, 2007 PST
    [payment_fee] => 
    [payment_gross] => 
    [payment_status] => Completed
    [payment_type] => instant
    [quantity1] => 1
    [receiver_email] => xxxxxxxxx
    [receiver_id] => xxxxxxxx
    [residence_country] => US
    
    [tax1] => 0.00
    [txn_id] => xxxxxxx
    [txn_type] => cart
    [verify_sign] => xxxxxxxx
)


Dec 01 2007 12:56 -- IPN INFO - POST VARS to be sent back for validation: 
To: [url]www.paypal.com:80[/url]
POST /cgi-bin/webscr HTTP/1.1

Host: [url]www.paypal.com[/url]

Content-type: application/x-www-form-urlencoded

Content-length: 916

Connection: close



Array
(
    [mc_gross] => 3.00
    [address_status] => confirmed
    [item_number1] => ter
    [payer_id] => 7A7C4FVNVQYCJ
    [tax] => 0.00
    [address_street] => xxxxxxxxxx
    [payment_date] => 09:55:53 Dec 01, 2007 PST
    [payment_status] => Completed
    [charset] => windows-1252
    [mc_tax1] => 0.00
    [address_zip] => 48310
    [mc_shipping] => 2.50
    [mc_handling] => 0.00
    [first_name] => Vin
    [mc_fee] => 0.64
    [address_country_code] => US
    [address_name] => testing test
    [notify_version] => 2.4
    [custom] => 
    [payer_status] => verified
    [address_country] => United States
    [num_cart_items] => 1
    [mc_handling1] => 0.00
    [address_city] => Sterling Heights
    [verify_sign] =>xxxxxxx
    [payer_email] => xxxxxxx
    [mc_shipping1] => 0.00
    [tax1] => 0.00
    [txn_id] => 
    [payment_type] => instant
    [last_name] => test
    [address_state] => MI
    [item_name1] => Test1
    [receiver_email] => xxxxxxx.xx
    [payment_fee] => 
    [quantity1] => 1
    [receiver_id] => xxxxxx
    [txn_type] => cart
    [mc_gross_1] => 0.50
    [mc_currency] => CAD
    [residence_country] => US
    [payment_gross] => 
    [cmd] => _notify-validate
)


Dec 01 2007 12:56 -- IPN INFO - Confirmation/Validation response 
SUCCESS

Dec 01 2007 12:56 -- Breakpoint: 1 - Collected data from PayPal notification

Dec 01 2007 12:56 -- Breakpoint: 2 - Validated transaction components

Dec 01 2007 12:56 -- Breakpoint: 3 - Communication method verified

Dec 01 2007 12:56 -- Breakpoint: 4 - Details:  txn_type=unknown    ordersID = 0  IPN_id=0

   Relevant data from POST:
     txn_type = unknown
     parent_txn_id = None
     txn_id = xxxxxxx

Dec 01 2007 12:56 -- Breakpoint: 5 - Transaction type (txn_type) = cart

Dec 01 2007 12:56 -- IPN NOTICE :: Express Checkout payment notice on completed order -- IPN Ignored

Thanks Vin

1 Dec 2007, 7:26 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax amount excluded from total amount transferred to Paypal

The other debug logs related to PayPal_Action_xxxx and PayPal_CURL and PayPal_Debug_ will also show how the information being sent to PayPal was calculated.

If the fix mentioned in the link I posted earlier has been implemented, then the tax problem is likely related to address/zone computation problems.

This may not be a convenient suggestion, but ... v1.3.8 has many PayPal updates in it ... perhaps testing on a fresh v1.3.8 install in another folder+database might tell you whether the problem follows you there or not.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Dec 2007, 8:16 PM
#7
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Here is one of paypal action. The above solution is already implemented. The paypal page shows total amount before paying. Once customer pays the taxes are not applied and the customer is charged after taxes. But paypal total before payment shows total with taxes. I wll post the rest of the debug. If you see anything obvious let me know. Thanks in advance.

Dec-01-2007 12:55:11
ec_step1 - 1
Checking to see if we are in markflow
cart contents: physical

NOTE: $this->showPaymentPage = 1
Customer ID: 27
Session Data: Array
(
    [customers_host_address] => xxxxxcomcast.net
    [cartID] => 
    [cart] => shoppingcart Object
        (
            [observers] => Array
                (
                )

            [contents] => Array
                (
                    [6] => Array
                        (
                            [qty] => 1
                        )

                )

            [total] => 0.5
            [weight] => 1
            [cartID] => 
            [content_type] => physical
            [free_shipping_item] => 0
            [free_shipping_weight] => 0
            [free_shipping_price] => 0
        )

    [navigation] => navigationhistory Object
        (
            [observers] => Array
                (
                )

            [path] => Array
                (
                    [0] => Array
                        (
                            [page] => index
                            [mode] => SSL
                            [get] => Array
                                (
                                    [type] => ec
                                    [markflow] => 1
                                    [clearSess] => 1
                                    [stage] => final
                                    [zenid] => 530944ffeb21db42ddf0d82c5374ca49
                                )

                            [post] => Array
                                (
                                )

                        )

                )

            [snapshot] => Array
                (
                )

        )

    [check_valid] => true
    [language] => english
    [languages_id] => 1
    [languages_code] => en
    [currency] => CAD
    [updateExpirations] => 1
    [session_counter] => 1
    [customers_ip_address] => xxxxx
    [new_products_id_in_cart] => 
    [valid_to_checkout] => 1
    [cart_errors] => 
    [customer_id] => 27
    [customer_default_address_id] => 32
    [customers_authorization] => 0
    [customer_first_name] => Vin
    [customer_country_id] => 241
    [customer_zone_id] => 198
    [sendto] => 32
    [payment] => paypalwpp
    [shipping] => Array
        (
            [id] => table_table
            [title] => Table Rate (Best Way)
            [cost] => 2.5
        )

    [billto] => 32
    [cot_gv] => 0
    [comments] => 
)

=================================

Dec-01-2007 12:55:11
getOverrideAddress - 1
Now in markflow mode.
SESSION[sendto] = 32
=================================

Dec-01-2007 12:55:11
getOverrideAddress - 2
$address_arr->fields = Array
(
    [entry_firstname] => xxx
    [entry_lastname] => xx
    [entry_street_address] => xxxxx
    [entry_suburb] => 
    [entry_city] => Ajax
    [entry_postcode] => L1Z 1A5
    [entry_country_id] => 241
    [entry_zone_id] => 198
    [entry_state] => 
    [zone_code] => ON
    [countries_iso_code_2] => CA
)

=================================

Dec-01-2007 12:55:11
ec_step1 - 2 -submit
Array
(
    [RETURNURL] => "https://summersoles.ca.sslpowered.com/store/ipn_main_handler.php?type=ec
    [CANCELURL] => "https://summersoles.ca.sslpowered.com/store/index.php?main_page=checkout_shipping&ec_cancel=1
    [LOCALECODE] => US
    [CURRENCY] => CAD
    [PAYMENTACTION] => Sale
    [EMAIL] => xxxxx
    [PHONENUM] => xxxxxxx
    [SOLUTIONTYPE] => SOLE
)

=================================
1 Dec 2007, 8:18 PM
#8
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Dec-01-2007 12:55:51
getLineItemDetails 3
LineItemDetails: 
Details:Array
(
    [ITEMAMT] => 0.5
    [SHIPPINGAMT] => 2.5
    [AMT] => 3
    [TAXAMT] => 0
    [L_NUMBER0] => ter
    [L_QTY0] => 1
    [L_NAME0] => Test1
    [L_AMT0] => 0.5
    [L_TAXAMT0] => 0
)


DEFAULT_CURRENCY = CAD
SESSION['currency'] = CAD
order->info['currency'] = CAD
$currencies->currencies[$_SESSION['currency']]['value'] = 1.00000000
currencies Object
(
    [observers] => Array
        (
        )

    [currencies] => Array
        (
            [CAD] => Array
                (
                    [title] => Canadian Dollar
                    [symbol_left] => $
                    [symbol_right] => 
                    [decimal_point] => .
                    [thousands_point] => ,
                    [decimal_places] => 2
                    [value] => 1.00000000
                )

        )

)

=================================

Dec-01-2007 12:55:51
getLineItemDetails 7
checking subtotals... 
itemamt: 0.50
taxamt: 0.00
shippingamt: 2.50
handlingamt: 
-------------------
subtotal: 3.00
AMT: 3.00
-------------------
difference: 0  (abs+rounded: 0)
=================================

Dec-01-2007 12:55:51
getLineItemDetails 8
subtotals balance - okay
=================================

Dec-01-2007 12:55:51
before_process - EC-1
Beginning EC mode
=================================

Dec-01-2007 12:55:51
before_process - EC-2
address overrides added:
Array
(
    [ITEMAMT] => 0.50
    [SHIPPINGAMT] => 2.50
    [AMT] => 3.00
    [TAXAMT] => 0.00
    [L_NUMBER0] => ter
    [L_QTY0] => 1
    [L_NAME0] => Test1
    [L_AMT0] => 0.50
    [L_TAXAMT0] => 0.00
    [SHIPTONAME] => xxxxxxx
    [SHIPTOSTREET] => xxxxxxx
    [SHIPTOSTREET2] => 
    [SHIPTOCITY] => Sterling Heights
    [SHIPTOSTATE] => MI
    [SHIPTOZIP] => xxx
    [SHIPTOCOUNTRYCODE] => US
)

=================================

Dec-01-2007 12:55:51
before_process - EC-3
address info added:
Array
(
    [ITEMAMT] => 0.50
    [SHIPPINGAMT] => 2.50
    [AMT] => 3.00
    [TAXAMT] => 0.00
    [L_NUMBER0] => ter
    [L_QTY0] => 1
    [L_NAME0] => Test1
    [L_AMT0] => 0.50
    [L_TAXAMT0] => 0.00
    [SHIPTONAME] => xxxx
    [SHIPTOSTREET] => xxxx
    [SHIPTOSTREET2] => 
    [SHIPTOCITY] => Sterling Heights
    [SHIPTOSTATE] => MI
    [SHIPTOZIP] => 48310
    [SHIPTOCOUNTRYCODE] => US
)

=================================

Dec-01-2007 12:55:51
before_process - EC-4
info being submitted:
EC-5YR04954LA575831C 7A7C4FVNVQYCJ 3.00
Array
(
    [ITEMAMT] => 0.50
    [SHIPPINGAMT] => 2.50
    [AMT] => 3.00
    [TAXAMT] => 0.00
    [L_NUMBER0] => ter
    [L_QTY0] => 1
    [L_NAME0] => Test1
    [L_AMT0] => 0.50
    [L_TAXAMT0] => 0.00
    [SHIPTONAME] =>xxxx
    [SHIPTOSTREET] => xxxxx
    [SHIPTOCITY] => Sterling Heights
    [SHIPTOSTATE] => MI
    [SHIPTOZIP] => 48310
    [SHIPTOCOUNTRYCODE] => US
    [BUTTONSOURCE] => ZenCart-EC_us
    [CURRENCY] => CAD
)

=================================

Dec-01-2007 12:55:54
before_process - EC-5
resultset:
Array
(
    [TIMESTAMP] => 2007-12-01T17:55:54Z
    [CORRELATIONID] => 21cf23e19c0d6
    [ACK] => Success
    [VERSION] => 2.300000
    [BUILD] => 1.0006
    [TOKEN] => xxxxxx
    [TRANSACTIONID] => xxxx
    [TRANSACTIONTYPE] => cart
    [PAYMENTTYPE] => instant
    [ORDERTIME] => 2007-12-01T17:55:53Z
    [AMT] => 3.00
    [CURRENCYCODE] => CAD
    [FEEAMT] => 0.64
    [TAXAMT] => 0.00
    [PAYMENTSTATUS] => Completed
    [PENDINGREASON] => None
    [REASONCODE] => None
    [CURL_ERRORS] => 
)

=================================
1 Dec 2007, 8:22 PM
#9
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Dec-01-2007 12:55:48
PayPal test Log - ec_step2 $_REQUEST data
In function: ec_step2()

Data in $_REQUEST = 

Array
(
    [type] => ec
    [amp;zenid] => xxxx
    [token] => EC-xxx
    [PayerID] => xxxx
    [zenid] => xx
)

=================================

Dec-01-2007 12:55:50
ec_step2_finish - 1
START: paypal_ec_payer_info= Array
(
    [payer_id] => xxx
    [payer_email] => xxxxx
    [payer_salutation] => 
    [payer_gender] => 
    [payer_firstname] => xxx
    [payer_lastname] => xx
    [payer_business] => 
    [payer_status] => verified
    [ship_country_code] => US
    [ship_address_status] => Confirmed
    [ship_phone] => 
    [ship_name] => xxx
    [ship_street_1] => xxx
    [ship_street_2] => 
    [ship_city] => Sterling Heights
    [ship_state] => MI
    [ship_postal_code] => 48310
    [ship_country_name] => United States
)

=================================

Dec-01-2007 12:55:50
ec_step2_finish - 2
country_id = 223 United States US
address_format_id = 2
state_id = 33 (original state tested: MI)
country1->fields['countries_id'] = 
country2->fields['countries_id'] = 
$order = stdClass Object
(
    [customer] => Array
        (
            [name] => xxx
            [company] => 
            [street_address] =>xxx
            [suburb] => 
            [city] => Sterling Heights
            [postcode] => 48310
            [state] => MI
            [country] => Array
                (
                    [id] => 223
                    [title] => United States
                    [iso_code_2] => US
                    [iso_code_3] => 
                )

            [format_id] => 2
            [email_address] => xxx
            [telephone] => 
            [zone_id] => 33
        )

    [billing] => Array
        (
            [name] =>xxx
            [company] => 
            [street_address] => xx
            [suburb] => 
            [city] => Sterling Heights
            [postcode] => 48310
            [state] => MI
            [country] => Array
                (
                    [id] => 223
                    [title] => United States
                    [iso_code_2] => US
                    [iso_code_3] => 
                )

            [format_id] => 2
            [zone_id] => 33
        )

    [delivery] => Array
        (
            [name] => xxxx
            [company] => 
            [street_address] => xxxx
            [suburb] => 
            [city] => Sterling Heights
            [postcode] => 48310
            [state] => MI
            [country] => Array
                (
                    [id] => 223
                    [title] => United States
                    [iso_code_2] => US
                    [iso_code_3] => 
                )

            [country_id] => 223
            [format_id] => 2
            [zone_id] => 33
        )

)

=================================

Dec-01-2007 12:55:50
findMatchingAddressBookEntry - 1-stats
country:queryfactoryresult Object
(
    [is_cached] => 
    [resource] => Resource id #135
    [cursor] => 0
    [EOF] => 1
)

country_zone_check:queryfactoryresult Object
(
    [is_cached] => 
    [resource] => Resource id #136
    [cursor] => 0
    [EOF] => 
    [fields] => Array
        (
            [zone_id] => 1
        )

)

zone_check:queryfactoryresult Object
(
    [is_cached] => 
    [resource] => Resource id #137
    [cursor] => 0
    [EOF] => 
    [fields] => Array
        (
            [zone_id] => 33
        )

)
check_zone: 1
zone:33
=================================

Dec-01-2007 12:55:50
findMatchingAddressBookEntry - 2-read for match

SQL was:SELECT address_book_id, entry_street_address, entry_suburb

                FROM address_book

                WHERE customers_id = 27

                AND entry_country_id = 223  AND entry_zone_id = 33
RecordCount = 1
=================================

Dec-01-2007 12:55:50
findMatchingAddressBookEntry - 3a
From PayPal:

xxx


From DB:

xxxx

queryfactoryresult Object
(
    [is_cached] => 
    [resource] => Resource id #139
    [cursor] => 0
    [EOF] => 
    [fields] => Array
        (
            [address_book_id] => 48
            [entry_street_address] => 3xxx
            [entry_suburb] => 
        )

)

=================================

Dec-01-2007 12:55:50
findMatchingAddressBookEntry - 3b
Exact match:
Array
(
    [address_book_id] => 48
    [entry_street_address] => xxx
    [entry_suburb] => 
)

=================================

Dec-01-2007 12:55:50
ec_step2_finish - 3
Exiting ec_step2_finish logged-in mode.
Selected address: 48
Original was: 32
=================================

Dec-01-2007 12:55:50
termEC-2
BEFORE: $this->showPaymentPage = 1
Token Data:EC-5YR04954LA575831C
=================================

Dec-01-2007 12:55:50
termEC-3
AFTER: $this->showPaymentPage = 0
=================================

Dec-01-2007 12:55:50
termEC-7
$this->showPaymentPage NOT true, and have custom page parameter: checkout_process
=================================

Dec-01-2007 12:55:50
termEC-10
Redirecting to checkout_process - Stack: header
Message: 
Session Data: Array
(
    [customers_host_address] =>xxx.comcast.net
    [cartID] => 
    [cart] => shoppingcart Object
        (
            [observers] => Array
                (
                )

            [contents] => Array
                (
                    [6] => Array
                        (
                            [qty] => 1
                        )

                )

            [total] => 0.5
            [weight] => 1
            [cartID] => 
            [content_type] => physical
            [free_shipping_item] => 0
            [free_shipping_weight] => 0
            [free_shipping_price] => 0
        )

    [navigation] => navigationhistory Object
        (
            [observers] => Array
                (
                )

            [path] => Array
                (
                    [0] => Array
                        (
                            [page] => index
                            [mode] => SSL
                            [get] => Array
                                (
                                    [type] => ec
                                    [amp;zenid] => 530944ffeb21db42ddf0d82c5374ca49
                                    [token] => EC-5YR04954LA575831C
                                    [PayerID] => 7A7C4FVNVQYCJ
                                )

                            [post] => Array
                                (
                                )

                        )

                )

            [snapshot] => Array
                (
                )

        )

    [check_valid] => true
    [language] => english
    [languages_id] => 1
    [languages_code] => en
    [currency] => CAD
    [updateExpirations] => 1
    [session_counter] => 1
    [customers_ip_address] => xxx
    [new_products_id_in_cart] => 
    [valid_to_checkout] => 1
    [cart_errors] => 
    [customer_id] => 27
    [customer_default_address_id] => 32
    [customers_authorization] => 0
    [customer_first_name] => xx
    [customer_country_id] => 241
    [customer_zone_id] => 198
    [sendto] => 48
    [payment] => paypalwpp
    [shipping] => Array
        (
            [id] => table_table
            [title] => Table Rate (Best Way)
            [cost] => 2.5
        )

    [billto] => 32
    [cot_gv] => 0
    [comments] => 
    [paypal_ec_markflow] => 1
    [paypal_ec_token] => EC-5YR04954LA575831C
    [paypal_ec_payer_id] => 7A7C4FVNVQYCJ
    [paypal_ec_payer_info] => Array
        (
            [payer_id] => 7A7C4FVNVQYCJ
            [payer_email] => xxx
            [payer_salutation] => 
            [payer_gender] => 
            [payer_firstname] => xxx
            [payer_lastname] => xxx
            [payer_business] => 
            [payer_status] => verified
            [ship_country_code] => US
            [ship_address_status] => Confirmed
            [ship_phone] => 
            [ship_name] => xx
            [ship_street_1] => xx
            [ship_street_2] => 
            [ship_city] => Sterling Heights
            [ship_state] => MI
            [ship_postal_code] => 48310
            [ship_country_name] => United States
        )

    [paypal_ec_temp] => 
)

=================================
1 Dec 2007, 8:23 PM
#10
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

2007-12-01 12:55:12

(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 45
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
[4] => X-VPS-VIT-Integration-Version: 0.1
)

Request Parameters: {SetExpressCheckout}
Array
(
[LOCALECODE] => US
[PAYMENTACTION] => Sale
[EMAIL] => xxx
[PHONENUM] => xxxx
[AMT] => 3.18
[RETURNURL] => https://summersoles.ca.sslpowered.com/store/ipn_main_handler.php?type=ec
[CANCELURL] => https://summersoles.ca.sslpowered.com/store/index.php?main_page=checkout_shipping&ec_cancel=1
[PAGESTYLE] => Primary
[METHOD] => SetExpressCheckout
[CURRENCYCODE] => CAD
[USER] => xxxxxx
[PWD] => ****************
[VERSION] => 2.3
[SIGNATURE] => ****************************************************XWDN
)

Response:
Array
(
[TIMESTAMP] => 2007-12-01T17:55:12Z
[CORRELATIONID] => 4152d96a5b39f
[ACK] => Success
[VERSION] => 2.300000
[BUILD] => 1.0006
[TOKEN] => EC-xxxx
[CURL_ERRORS] =>
)

SetExpressCheckout, Elapsed: 1523ms -- Success

1 Dec 2007, 8:24 PM
#11
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

2007-12-01 12:55:50

(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 45
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
[4] => X-VPS-VIT-Integration-Version: 0.1
)

Request Parameters: {GetExpressCheckoutDetails}
Array
(
[TOKEN] => EC-xxx
[METHOD] => GetExpressCheckoutDetails
[USER] => xxxx
[PWD] => xxxx
[VERSION] => 2.3
[SIGNATURE] => xxxxxx
)

Response:
Array
(
[TIMESTAMP] => 2007-12-01T17:55:50Z
[CORRELATIONID] => 1cf75c8ce4144
[ACK] => Success
[VERSION] => 2.300000
[BUILD] => 1.0006
[TOKEN] => EC-x
[EMAIL] => xxx
[PAYERID] => xxx
[PAYERSTATUS] => verified
[FIRSTNAME] => xxx
[LASTNAME] => xx
[COUNTRYCODE] => US
[SHIPTONAME] => xxx
[SHIPTOSTREET] => xxxx
[SHIPTOCITY] => Sterling Heights
[SHIPTOSTATE] => MI
[SHIPTOCOUNTRYCODE] => US
[SHIPTOCOUNTRYNAME] => United States
[SHIPTOZIP] => 48310
[ADDRESSID] => PayPal
[ADDRESSSTATUS] => Confirmed
[CURL_ERRORS] =>
)

GetExpressCheckoutDetails, Elapsed: 1464ms -- Success

1 Dec 2007, 8:25 PM
#12
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

2007-12-01 12:55:54

(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 45
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
[4] => X-VPS-VIT-Integration-Version: 0.1
)

Request Parameters: {DoExpressCheckoutPayment}
Array
(
[ITEMAMT] => 0.50
[SHIPPINGAMT] => 2.50
[AMT] => 3.00
[TAXAMT] => 0.00
[L_NUMBER0] => ter
[L_QTY0] => 1
[L_NAME0] => Test1
[L_AMT0] => 0.50
[L_TAXAMT0] => 0.00
[SHIPTONAME] => xx
[SHIPTOSTREET] => xxxx
[SHIPTOCITY] => Sterling Heights
[SHIPTOSTATE] => MI
[SHIPTOZIP] => 48310
[SHIPTOCOUNTRYCODE] => US
[BUTTONSOURCE] => ZenCart-EC_us
[TOKEN] => EC-xx
[PAYERID] => xx
[PAYMENTACTION] => Sale
[NOTIFYURL] => "https://summersoles.ca.sslpowered.com/store/ipn_main_handler.php"
[METHOD] => DoExpressCheckoutPayment
[CURRENCYCODE] => CAD
[USER] =>xxx
[PWD] => ****************
[VERSION] => 2.3
[SIGNATURE] => ****************************************************XWDN
)

Response:
Array
(
[TIMESTAMP] => 2007-12-01T17:55:54Z
[CORRELATIONID] => xxx
[ACK] => Success
[VERSION] => 2.300000
[BUILD] => 1.0006
[TOKEN] => EC-xxx
[TRANSACTIONID] => xxx
[TRANSACTIONTYPE] => cart
[PAYMENTTYPE] => instant
[ORDERTIME] => 2007-12-01T17:55:53Z
[AMT] => 3.00
[CURRENCYCODE] => CAD
[FEEAMT] => 0.64
[TAXAMT] => 0.00
[PAYMENTSTATUS] => Completed
[PENDINGREASON] => None
[REASONCODE] => None
[CURL_ERRORS] =>
)

DoExpressCheckoutPayment, Elapsed: 3183ms -- Success

1 Dec 2007, 8:32 PM
#13
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax amount excluded from total amount transferred to Paypal

It seems that it's not finding any tax match, and is thus not assessing tax on the order.```
info being submitted:
EC-5YR04954LA575831C 7A7C4FVNVQYCJ 3.00
Array
(
[ITEMAMT] => 0.50
[SHIPPINGAMT] => 2.50
[AMT] => 3.00
[TAXAMT] => 0.00
[L_NUMBER0] => ter
[L_QTY0] => 1
[L_NAME0] => Test1
[L_AMT0] => 0.50
[L_TAXAMT0] => 0.00
[SHIPTONAME] =>xxxx
[SHIPTOSTREET] => xxxxx
[SHIPTOCITY] => Sterling Heights
[SHIPTOSTATE] => MI
[SHIPTOZIP] => 48310
[SHIPTOCOUNTRYCODE] => US
[CURRENCY] => CAD


I guess my next question is ... why are you processing in CAD on a customer ordering with a Michigan address? And are you set up to collect tax on Michigan sales?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Dec 2007, 8:35 PM
#14
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

Well no actually the address returned was my MI address. The address send was a canadian address. But same thing happens if even both addresses are same.

1 Dec 2007, 8:46 PM
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax amount excluded from total amount transferred to Paypal

How are you getting to PayPal?

Are you clicking the orange Express Checkout button, or choosing "PayPal" from the checkout_payment screen, and then going to PayPal after clicking Continue on the Confirmation screen?

Also, is this happening "before" or "after" logging in to your store account?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Dec 2007, 10:29 PM
#16
vin avatar

vin

New Zenner

Join Date:
Dec 2007
Posts:
10
Plugin Contributions:
0

Re: Tax amount excluded from total amount transferred to Paypal

DrByte:

How are you getting to PayPal?

Are you clicking the orange Express Checkout button, or choosing "PayPal" from the checkout_payment screen, and then going to PayPal after clicking Continue on the Confirmation screen?

Also, is this happening "before" or "after" logging in to your store account?

Getting to paypal after clicking on paypal express payment option on step 2 of 3 of order checkout. The customer is taken to payapl after confirmation of order. Customer has to create an account with store for that.