News:

Looking for documentation? Take a look on our wiki

Main Menu

Payment received by PayPal & shipping costs

Started by Jan1812, September 09, 2011, 15:46:05 PM

Previous topic - Next topic

Jan1812

We have a joomla site which includes a shop (virtuamart).
The site works fine! We have a problem with paypal.
The price of the item on the order of joomla and on receipt of paypal payment, there's a difference. This is also true for the shipping. See attachment!
Why is this and how do I fix this?

[attachment cleanup by admin]

Jan1812

hi,

should i up-grade to 1.1.9 OR 2.0?
do they have that problem?
because 1.1.5 does!
pls help

grtz

stinga

Not sure I understand the problem.
Those images are very blurry and difficult to read.
Maybe some screen shots of the order and the PP screen?
What is the difference in price?
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Jan1812

#3
thx for the reply!
I'll tell you about it:


Order:
Price: €95  Shipping: €8  Tax: €17,88  Total: €103

Paypal:
Price: €96,39  Shipping: €6.61  Total: €103

So, that's my problem.
Why is there a difference?
Can you help me pls?

jameel

This is due to the tax is being divided into the shipping and item price
Virtuemart + Joomla extensions www.itechshop.org
get Paypal extended, payza extended, moneybookers extended module that let you use 98  currencies nonsupported paypal/alertpay/mb currencies on VM 1.1.x and convert them to supported one at www.itechshop.org

220+ domain extensions www.industechnologies.co

Jan1812


stinga

Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Jan1812

Did you read my post above?
Why is there a diffrence?

Jan

stinga

I think what you mean is...
'How do I show the tax in PayPal"

There is nothing wrong with the amount you are sending to PayPal.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Jan1812

I think you're right!
What do i have to do to make it right?

stinga

You need to send the tax amount to PP in the the correct field name and you will need to mod the payment extra info field to get J!/VM to send the data to PP.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Jan1812

Stinga,
thank you so much for your patience with me.
I am very new to this area.
Would you tell me exactly what to do in PP & VM?
Step by step pls

stinga

#12
If you are not getting the tax you will need to alter code, have a look at the extra payment info in the PP setup on VM and see if tax is being sent.
This is PHP code, have a look and see if it makes sense, if it does not make sense then it would be better to ask someone to do the job for you.
You could paste the code here and see if someone can help you.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Jan1812

<?php
$db1 = new ps_DB();
$q = "SELECT country_2_code FROM #__vm_country WHERE country_3_code='".$user->country."' ORDER BY country_2_code ASC";
$db1->query($q);

$url = "https://www.paypal.com/cgi-bin/webscr";
$tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");
$discount_total = $db->f("coupon_discount") + $db->f("order_discount");
$post_variables = Array(
"cmd" => "_ext-enter",
"redirect_cmd" => "_xclick",
"upload" => "1",
"business" => PAYPAL_EMAIL,
"receiver_email" => PAYPAL_EMAIL,
"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"),
"order_id" => $db->f("order_id"),
"invoice" => $db->f("order_number"),
"amount" => round( $db->f("order_total")-$db->f("order_shipping"), 2),
"shipping" => sprintf("%.2f", $db->f("order_shipping")),
"currency_code" => $_SESSION['vendor_currency'],

"address_override" => "1",
"first_name" => $dbbt->f('first_name'),
"last_name" => $dbbt->f('last_name'),
"address1" => $dbbt->f('address_1'),
"address2" => $dbbt->f('address_2'),
"zip" => $dbbt->f('zip'),
"city" => $dbbt->f('city'),
"state" => $dbbt->f('state'),
"country" => $db1->f('country_2_code'),
"email" => $dbbt->f('user_email'),
"night_phone_b" => $dbbt->f('phone_1'),
"cpp_header_image" => $vendor_image_url,

"return" => SECUREURL ."index.php?option=com_virtuemart&page=checkout.result&order_id=".$db->f("order_id"),
"notify_url" => SECUREURL ."administrator/components/com_virtuemart/notify.php",
"cancel_return" => SECUREURL ."index.php",
"undefined_quantity" => "0",

"test_ipn" => PAYPAL_DEBUG,
"pal" => "NRUBJXESJTY24",
"no_shipping" => "1",
"no_note" => "1"
);
if( $page == "checkout.thankyou" ) {
$query_string = "?";
foreach( $post_variables as $name => $value ) {
$query_string .= $name. "=" . urlencode($value) ."&";
}
vmRedirect( $url . $query_string );
} else {
echo '<form action="'.$url.'" method="post" target="_blank">';
echo '<input type="image" name="submit" src="https://www.paypal.com/en_US/i/btn/x-click-but6.gif" alt="Click to pay with PayPal - it is fast, free and secure!" />';

foreach( $post_variables as $name => $value ) {
echo '<input type="hidden" name="'.$name.'" value="'.htmlspecialchars($value).'" />';
}
echo '</form>';

}
?>

Jan1812

#14
Stinga,

will you or sombody else fix this pls?
In the PHP do i need to fill something else in?