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.

[DrByte]

Does this help?
http://www.zen-cart.com/forum/showpo...1&postcount=21

[Rykmann]

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.

[DrByte]

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

[vin]

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: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1

Host: www.paypal.com

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

[DrByte]

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.

[vin]

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
)

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

[vin]

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] => 
)

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

[vin]

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] => 
)

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

[vin]

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