If IsOrder=true the the order IS saved in the xml cache. Then you can use teacommerce:GetFinalizedOrders and then use xslt to select the orders you need.
Yes a finalized order is one that has been paid for. If some orders are missing from the xml - try regenerate it. Go to the Tea Commerce section and right click and refresh the order xml
Orders by user - see all orders with status
I can use this to see all FinalisedOrders
<xsl:for-each select="teacommerce:GetFinalizedOrdersXmlForMember( umbraco.library:GetCurrentMember()/@id )/order">
<xsl:value-of select="@name" /> - <xsl:value-of select="@totalPriceFormatted" />
</xsl:for-each>
How do I see ALL order history - pending and cancelled orders too?
Hi Richard
We only save the finalized orders as xml. So if you need orders that hasent been finalized you - you need to use SQL to fetch them from the DB.
Kind regards
Anders
If I got the orders from the TeaCommerce_Order table with IsOrder = TRUE, could I then call each order by orderId ?
If IsOrder=true the the order IS saved in the xml cache. Then you can use teacommerce:GetFinalizedOrders and then use xslt to select the orders you need.
OK, so what is the definition of a finialised order, just one which has been paid for?
I have checked again and not all the ones that have IsOrder = TRUE are on the finalised orders xml
Yes a finalized order is one that has been paid for. If some orders are missing from the xml - try regenerate it. Go to the Tea Commerce section and right click and refresh the order xml
OK, it seems it is in the full finalised orders, but not against the individual User, I will check. Thanks
is working on a reply...