WooCommerce Functions

Overview

Namespace urn:WooCommerceFunctions
Available since Zynk Workflow 2023.6.2

This article will outline how to implement the XSLT functions that we have made available for our WooCommerce library. As shown below, you can call methods with or without a connection. If you do not specify a connection, the default connection will be used.

Please note, you must use a WooCommerce V3 connection with this library, the WooCommerce V2 library is not supported by XSLT functions.

You can make use of the Magento functions by including the following declaration in your XSLT document:

<xsl:stylesheet 
    version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt"
    xmlns:WooCommerceFunctions="urn:WooCommerceFunctions"> <!-- define the WooCommerceFunctions argument -->

    <!-- transformation -->

</xsl:stylesheet>

Functions

The following methods can each be called with, or without, a connection identifier. If you do not provide a connection identifier, the default connection will be used.

The function will attempt to parse the connection identifier as a GUID (i.e the connection id), and if that is not successful, it will match to an existing connection based on the connection title.

• GetCustomer(string recordIdentifier)
• GetCustomer(string connectionIdentifier, string recordIdentifier)
• GetOrder(string recordIdentifier)
• GetOrder(string connectionIdentifier, string recordIdentifier)
• GetProduct(string recordIdentifier)
• GetProduct(string connectionIdentifier, string recordIdentifier)

Example

Input

<Data>
    <CustomerData>
        <Datum>
            <Id>51694</Id>
        </Datum>
    </CustomerData>
    <OrderData>
        <Datum>
            <Id>207662</Id>
        </Datum>
    </OrderData>
    <ProductData>
        <Datum>
            <Id>23722</Id>
        </Datum>
    </ProductData>
</Data>

XSLT

<xsl:stylesheet 
    version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt"
    xmlns:wf="urn:WooCommerceFunctions">

    <xsl:output indent="yes"/>

    <xsl:template match="/">
        <Company>
            <Customers>
                <xsl:for-each select="Data/CustomerData/Datum">
                    <xsl:call-template name="Customer"/>
                </xsl:for-each>
            </Customers>
            <Orders>
                <xsl:for-each select="Data/OrderData/Datum">
                    <xsl:call-template name="Order"/>
                </xsl:for-each>
            </Orders>
            <Products>
                <xsl:for-each select="Data/ProductData/Datum">
                    <xsl:call-template name="Product"/>
                </xsl:for-each>
            </Products>
        </Company>
    </xsl:template>

    <xsl:template name="Customer">
        <Customer>
            <xsl:copy-of select="Id"/>
            <xsl:variable name="WooCustomer" select="msxsl:node-set(wf:GetCustomer('Zynk Software Ltd (WooCommerce Version 3.0+)', Id))"/>

            <CompanyName>
                <xsl:choose>
                    <xsl:when test="count($WooCustomer/Errors/Error) &gt; 0">
                        <xsl:copy-of select="$WooCustomer"/>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="concat($WooCustomer/customer/first_name, ' ', $WooCustomer/customer/last_name)"/>
                    </xsl:otherwise>
                </xsl:choose>
            </CompanyName>
            <!-- <Dump>
                <xsl:copy-of select="msxsl:node-set($WooCustomer)"/>
            </Dump> -->
        </Customer>
    </xsl:template>


    <xsl:template name="Order">
        <Order>
            <xsl:copy-of select="Id"/>
            <xsl:variable name="WooOrder1" select="msxsl:node-set(wf:GetOrder('Zynk Software Ltd (WooCommerce Version 3.0+)', Id))"/>
            <xsl:variable name="WooOrder2" select="msxsl:node-set(wf:GetOrder('Zynk Software Ltd (WooCommerce Version 3.0+)', Id))"/>

            <Name1>
                <xsl:choose>
                    <xsl:when test="count($WooOrder1/Errors/Error) &gt; 0">
                        <xsl:copy-of select="$WooOrder1"/>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="$WooOrder1/order/number"/>
                    </xsl:otherwise>
                </xsl:choose>
            </Name1>
            <!-- <Dump>
                <xsl:copy-of select="msxsl:node-set($WooOrder1)"/>
            </Dump> -->

            <Name2>
                <xsl:choose>
                    <xsl:when test="count($WooOrder2/Errors/Error) &gt; 0">
                        <xsl:copy-of select="$WooOrder2"/>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="$WooOrder2/order/number"/>
                    </xsl:otherwise>
                </xsl:choose>
            </Name2>
        </Order>
    </xsl:template>

    <xsl:template name="Product">
        <Product>
            <xsl:copy-of select="Id"/>
            <xsl:variable name="WooProduct" select="msxsl:node-set(wf:GetProduct('Zynk Software Ltd (WooCommerce 3.0+)', Id))"/>

            <Name>
                <xsl:choose>
                    <xsl:when test="count($WooProduct/Errors/Error) &gt; 0">
                        <xsl:copy-of select="$WooProduct"/>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="$WooProduct/product/name"/>
                    </xsl:otherwise>
                </xsl:choose>
            </Name>
            <!-- <Dump>
                <xsl:copy-of select="msxsl:node-set($WooProduct)"/>
            </Dump> -->
        </Product>
    </xsl:template>

</xsl:stylesheet>

Output

<?xml version="1.0" encoding="utf-8"?>
<Company xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:wf="urn:WooCommerceFunctions">
    <Customers>
        <Customer>
            <Id>51694</Id>
            <CompanyName>Joseph Harrison</CompanyName>
        </Customer>
    </Customers>
    <Orders>
        <Order>
            <Id>207662</Id>
            <Name1>sd-81188</Name1>
            <Name2>sd-81188</Name2>
        </Order>
    </Orders>
    <Products>
        <Product>
            <Id>23722</Id>
            <Name>Kohl Rabi Mixed</Name>
        </Product>
    </Products>
</Company>