Invoice URL

Not sure there is, by default, a direct URL which points to all the invoices. It would be easy enough to create a page though which lists all the invoices in a repeater (or similar). To display the contents of the invoice (stored as HTML content in the database) you simply need to call string invoice = OrderInfoProvider.GetInvoice(OrderID); And then render the string.

Hello Duong,

As Bryan said, listing the order invoice via repeater or custom web part are the two easiest options in this case. First, you need to gather the data from database, for example you using a SQL data source Web part with this query:

SELECT OrderID, OrderInvoice, OrderSiteID
FROM COM_Order
WHERE OrderSiteID = '{%CurrentSite.SiteID|(identity)GlobalAdministrator%}'
ORDER BY OrderID

This will allow you to show both URL of the invoice using OrderID, and the actual HTML of the invoice, stored in OrderInvoice.

After you have setup this data source, use a Basic Repeater Web Part to list the data. You can use either this transformation to list invoice links:

<a href="~/CMSModules/Ecommerce/CMSPages/GetInvoice.aspx?orderid=<%# Eval("OrderID") %>"><%# Eval("OrderID") %></a><br />

Or this transformation, to show the actual invoices:

<%# Eval("OrderInvoice") %><br />

Thanks for that, it's really helpful :)

I'm integrated this HTML with ABCPDF API to convert the HTML to PDF. It's running fine :)

Regards, Duong

Hi, Duong.

As for me, I have seldom tried to convert the HTML to PDF with ABCPDF API. I wonder have you ever worked it out? Do I need another 3rd party manual toolkit? When it comes to PDF converting process, I have another question, I wonder have you ever tried to convert pdf to other image files before? As for myself, I am testing the related PDF to JPG converting, PDF to PNG converting, and PDF to BMP converting programs these days. Do you have experience about it? Any suggestion will be appreciated. Thanks in advance.

Best regards,

Lee