order summary details (paypal)

[ygalbrami]

hello,

i want to know this, when buyers will buy few items in my website
when thet press the button to pay they go to paypal but they don't see all the summary details

i need them to see the shipping and all the items the put on the cart.

how can i make this happend the they can see the full detail in paypal?

[ygalbrami]

please help me with that.

[abantecart]

Unfortunately, this is not available in standard paypal.

[ygalbrami]

i have try also paypal pro - but buyer can pay with credit card - i need buyers can pay also with there balance in there paypal account.

please help me to make it work.

[ygalbrami]

please help me to find a solustion

[abolabo]

what about both enabled paypal payment extensions?
standart will use for paypal accounts, pp-pro - for credit cards.

[ygalbrami]

i can't get payment from paypal pro - because of my country.
i have see a lot of website that use paypal and i can see all my item detail so i know there is a way to do so, the problem is what to do?

[ygalbrami]

Unfortunately, this is not available in standard paypal.

so it's not available??
i just make it work with the standard paypal.

and it's very easy.

i make some change in the file "default_pp_standart.tpl"

here the full code Enjoy:

Code Select Expand

<?php
$connect_this = mysql_connect("sql_server", "username", "password") or die("error connect");
$mysql_db = mysql_select_db("my_database")or die("error db");
$get_orderid = $this->session->data['order_id'];

$select_ab_order_products = mysql_query ("SELECT ab_order_products.name, ab_order_products.sku, ab_order_products.price, ab_order_products.quantity FROM ab_order_products INNER JOIN ab_products ON ab_order_products.product_id = ab_products.product_id WHERE ab_order_products.order_id='$get_orderid'") or die ("can't select");
$mnum = 1;
$mounts = 1;
$quantity_n = 1;
?>

<form action="<?php echo str_replace('&', '&amp;', $action); ?>" method="post" id="checkout">
  <input type="hidden" name="cmd" value="_cart" />
  <input type="hidden" name="upload" value="1">
  <input type="hidden" name="business" value="<?php echo $business; ?>" />
<?php 
  while ($get_full_items = mysql_fetch_array($select_ab_order_products)){
?>
  <input type="hidden" name="item_name_<?php echo ($mnum++) ?>" value="<?php echo $get_full_items['name']; ?>" />
<?php $number = $get_full_items['price'];
$get_correct_price = number_format($number, 2, '.', ''); 
?>
  <input type="hidden" name="amount_<?php echo ($mounts++) ?>" value="<?php echo $get_correct_price; ?>" />
  <input type="hidden" name="quantity_<?php echo ($quantity_n++) ?>" value="<?php echo $get_full_items['quantity']; ?>">
  <?php } ?>
  <input type="hidden" name="currency_code" value="<?php echo $currency_code; ?>" />
  <input type="hidden" name="first_name" value="<?php echo $first_name; ?>" />
  <input type="hidden" name="last_name" value="<?php echo $last_name; ?>" />
  <input type="hidden" name="address1" value="<?php echo $address1; ?>" />
  <input type="hidden" name="address2" value="<?php echo $address2; ?>" />
  <input type="hidden" name="city" value="<?php echo $city; ?>" />
  <input type="hidden" name="zip" value="<?php echo $zip; ?>" />
  <input type="hidden" name="country" value="<?php echo $country; ?>" />
  <input type="hidden" name="address_override" value="0" />
  <input type="hidden" name="notify_url" value="<?php echo $notify_url; ?>" />
  <input type="hidden" name="email" value="<?php echo $email; ?>" />
  <input type="hidden" name="invoice" value="<?php echo $invoice; ?>" />
  <input type="hidden" name="lc" value="<?php echo $lc; ?>" />
  <input type="hidden" name="return" value="<?php echo $return; ?>" />
  <input type="hidden" name="rm" value="2" />
  <input type="hidden" name="no_note" value="1" />
  <input type="hidden" name="cancel_return" value="<?php echo $cancel_return; ?>" />
  <input type="hidden" name="paymentaction" value="<?php echo $paymentaction; ?>" />
  <input type="hidden" name="custom" value="<?php echo $custom; ?>" />
</form>
<div class="buttons">
  <table>
    <tr>
      <td align="left"><a onclick="location = '<?php echo str_replace('&', '&amp;', $back); ?>'" class="button"><span><?php echo $button_back; ?></span></a></td>
      <td align="right"><a onclick="$('#checkout').submit();" class="button"><span><?php echo $button_confirm; ?></span></a></td>
    </tr>
  </table>
</div>


[abantecart]

Code you posted is not within AbanteCart code standard.
1. You do not need to create extra connection to MySQL
2. You need to use $this->db->query() to run MySQL queries.

This suggestion will not be helpful for others

[ygalbrami]

other user will be so happy to find this code.
i havve ask here and other places to get the full items list in paypal
everyone say it's can't be done

now it can be done.
and i show how to do it.

[abantecart]

If you say so. It would be nice if you correct your suggestion to be within AbanteCart coding API.

Thank you

[ygalbrami]

but how i will do that?

after i put this line:

Code Select Expand

$this->db->query("SELECT ab_order_products.name, ab_order_products.sku, ab_order_products.price, ab_order_products.quantity FROM ab_order_products INNER JOIN ab_products ON ab_order_products.product_id = ab_products.product_id WHERE ab_order_products.order_id='$get_orderid'")

but what code to use to get data?
for now i use this :

Code Select Expand

<?php echo $get_full_items['name']; ?>

[abolabo]

but how i will do that?

after i put this line:

Code Select Expand

$this->db->query("SELECT ab_order_products.name, ab_order_products.sku, ab_order_products.price, ab_order_products.quantity FROM ab_order_products INNER JOIN ab_products ON ab_order_products.product_id = ab_products.product_id WHERE ab_order_products.order_id='$get_orderid'")

but what code to use to get data?
for now i use this :

Code Select Expand

<?php echo $get_full_items['name']; ?>

1. you don't use db_prefix in table_name. You have to write DB_PREFIX."order_products" instead ab_order_products.
2. assign query result to some handler. For ex.:

Code Select Expand

$result = $this->db->query($sql);
and then get row (or few rows) as array from it:

Code Select Expand

$row = $result->row;
echo $row['name'];

[montrellhale]

Am I able to add PayPal to my site \www.haledigitalmarketing.com /?

[llegrand]

please note that the post above yours were made in 2013 -  lots of changes and improvement since these posts.

Short answer is yes PayPal works well with AbanteCart,  but you do need a PayPal business account