Automation is needed for creating an invoice on Paypal and a link to it.
Automation is preferable through Make.com, but I am open to considering other options.
The input data such as:
- client data
- list of products and prices
will be obtained using MySQL queries to the website's database (the store is on Opencart, we can formulate the MySQL query for the developer) and must be sent to Paypal.
And this data:
- invoice number (preferably, we would like to set it ourselves, but if this is not possible, I am ready to discuss other options)
- shipping cost
will be entered manually and must be taken from a Google Sheet and must also be sent to Paypal.
As a result of the work, we should receive a Paypal link for invoice payment similar to the example:
https://www.paypal.com/invoice/p/#Z2YASLQCUATSHHUJ
and record this link in the same Google Sheet from which the invoice number and shipping cost will be taken.
The invoice should ultimately include: seller's company data, a breakdown of products, shipping, seller's note for the buyer (VAT Margin scheme – Collector's items and antiques (article 41, VAT Act)), the invoice number provided by us.