Collecting data from PayPal

Here we will show you how to customize the information that Paypal sends to Quaderno so that you can invoice correctly and be VAT & GST compliant.
  • In order to be EU VAT compliant with Quaderno and PayPal, it’s necessary to serialise the customer’s VAT number and IP address in the custom variable of your payment form.
  • If you want to display a client’s full billing details on the invoice, you just have to include this information on your PayPal payment forms.
  • To make sure you have enough location evidence to be VAT compliant, we recommend that you include at least the country and IP address on the form. You can also add the VAT number if your client is a business in the EU.
 
In this example, we’ll show you how you can customize your PayPal payment form to include the client’s billing details, VAT number (if applicable), and IP address:
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
  <input type="hidden" name="cmd" value="_xclick">
  <input type="hidden" name="business" value="you@yourdomain.com">
  <input type="hidden" name="item_name" value="New Router">
  <input type="hidden" name="amount" value="100.00">
  <input type="hidden" name="first_name" value="Maurice">
  <input type="hidden" name="last_name" value="Moss">
  <input type="hidden" name="address1" value="123 Carenden Road">
  <input type="hidden" name="city" value="London">
  <input type="hidden" name="zip" value="EC5M 8AJ">
  <input type="hidden" name="country" value="GB">
  <input type="hidden" name="email" value="moss@reynholm.co.uk">
  <input type="hidden" name="custom" value="<?php echo json_encode(array("tax_id" => "GB123456789", "ip_address" => $_SERVER['REMOTE_ADDR'])) ?>"/>
  <input type="hidden" name="return" value="http://yourdomain.com/thank-you.html">
  <input type="image" name="submit" border="0" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynow_LG.gif">
</form>
Combining the IP address and the customer’s billing info will give us enough information to decide whether or not a customer is where they say they are
 
Quaderno can make sense of the following fields in the custom field:
PayPal metadata Quaderno can use
'custom' field
Description
Tax ID of the customer
IP address of the customer
Type of transaction: eserviceebooksaasstandard, and reduced. The default is the type of transaction you’ve selected on your Preferences page.

Tracking product sales

If you’d like to send through SKUs for your products to track your product sales, Quaderno would read the SKU in the following fields in PayPal: NUMBER, ISBN, PLU or MODELNUMBER.