Exporting Sales from Zenoti

This task will export sales from Zenoti to an XML file.

Settings

Zenoti Connection

Required
Select the Zenoti connection to use. See the Connecting to Zenoti article if you require more information on how to create/manage connections.

Centers

Optional
Used to filter the export based on center. You can provide a comma separated list of either center names or IDs, or leave blank to export from all centers.

End Date

Required
The date to export data until (inclusive).

Invoice Status

Required
Filters the export based on invoice status. Select 'All' to export sales of any invoice status.

Item Type

Required
Filters the export based on item type. Select 'All' to export sales containing any item types.

Start Date

Required
The date to export data from.

Output File

Required
The name of the file to export to. The data will be output in XML format, a sample of which is shown below.

Zynk Settings

See Common Task Settings

Examples

A sample output file is provided below. Please note that each invoice line appears as a separate '' element in the XML. The example below contains a single invoice with two lines.

<?xml version="1.0" encoding="utf-8"?>
<Sales xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Sale>
    <InvoiceNo>12345</InvoiceNo>
    <ReceiptNo>R12345</ReceiptNo>
    <Guest>
      <GuestId>16b8b4d9-7dfc-4315-bc90-965605bcc01b</GuestId>
      <GuestName>John Smith</GuestName>
      <GuestCode>NC123</GuestCode>
    </Guest>
    <SoldOn>2021-10-14T15:56:51</SoldOn>
    <ServicedOn>2021-10-24T15:00:00</ServicedOn>
    <Center>
      <CenterName>Newcastle</CenterName>
      <CenterCode>NC</CenterCode>
    </Center>
    <Item>
      <Type>0</Type>
      <Name>Test Product</Name>
      <Code>TEST0001</Code>
    </Item>
    <Quantity>1</Quantity>
    <UnitPrice>75.0</UnitPrice>
    <SalePrice>75.0</SalePrice>
    <Discount>0.0</Discount>
    <FinalSalePrice>90.0000</FinalSalePrice>
    <TotalTax>15.0</TotalTax>
    <TaxCode>VAT 20%</TaxCode>
    <LoyaltyPointRedemption>0.0000</LoyaltyPointRedemption>
    <MembershipRedemption>0.0000</MembershipRedemption>
    <PrepaidCardRedemption>0.0000</PrepaidCardRedemption>
    <CashbackRedemption>0.0000</CashbackRedemption>
    <PackageRedemption>0.0000</PackageRedemption>
    <Cash>0.0000</Cash>
    <Card>90.0000</Card>
    <Check>0.0000</Check>
    <Custom>0.0000</Custom>
    <Points>0.0000</Points>
    <MembershipPaid>0.0000</MembershipPaid>
    <PrepaidCard>0.0000</PrepaidCard>
    <LastPaymentDate>2021-10-24T16:00:59</LastPaymentDate>
    <InvoiceItemId>42c1a4a8-b801-4954-87a8-e6ce0813b257</InvoiceItemId>
    <RoundingAdjustment>0.0000</RoundingAdjustment>
    <Tips>10.0000</Tips>
    <Employee>
      <Name>Joe Bloggs</Name>
      <Code>123</Code>
      <JobCode>SBT</JobCode>
    </Employee>
    <Tags />
    <Promotion />
    <CouponPrinted />
    <FirstVisit>No</FirstVisit>
    <Package />
    <PackageInvoice />
    <Due>0.0</Due>
    <PaymentType>CC Online(MasterCard)</PaymentType>
    <BusinessUnitName>Default</BusinessUnitName>
    <StateCode />
    <SAC />
    <CreatedDateInCenter>2021-10-14T15:56:51.923</CreatedDateInCenter>
    <ItemRowNum>1</ItemRowNum>
    <RowNum>1</RowNum>
    <HSN />
  </Sale>
  <Sale>
    <InvoiceNo>12345</InvoiceNo>
    <ReceiptNo>R12345</ReceiptNo>
    <Guest>
      <GuestId>16b8b4d9-7dfc-4315-bc90-965605bcc01b</GuestId>
      <GuestName>John Smith</GuestName>
      <GuestCode>NC123</GuestCode>
    </Guest>
    <SoldOn>2021-10-14T15:56:51</SoldOn>
    <ServicedOn>2021-10-24T15:00:00</ServicedOn>
    <Center>
      <CenterName>Newcastle</CenterName>
      <CenterCode>NC</CenterCode>
    </Center>
    <Item>
      <Type>0</Type>
      <Name>Rose Crystal Lymphatic 60min</Name>
      <Code>TRERCLF60</Code>
    </Item>
    <Quantity>1</Quantity>
    <UnitPrice>66.67</UnitPrice>
    <SalePrice>66.67</SalePrice>
    <Discount>0.0</Discount>
    <FinalSalePrice>80.0000</FinalSalePrice>
    <TotalTax>13.33</TotalTax>
    <TaxCode>VAT 20%</TaxCode>
    <LoyaltyPointRedemption>0.0000</LoyaltyPointRedemption>
    <MembershipRedemption>0.0000</MembershipRedemption>
    <PrepaidCardRedemption>0.0000</PrepaidCardRedemption>
    <CashbackRedemption>0.0000</CashbackRedemption>
    <PackageRedemption>0.0000</PackageRedemption>
    <Cash>0.0000</Cash>
    <Card>80.0000</Card>
    <Check>0.0000</Check>
    <Custom>0.0000</Custom>
    <Points>0.0000</Points>
    <MembershipPaid>0.0000</MembershipPaid>
    <PrepaidCard>0.0000</PrepaidCard>
    <LastPaymentDate>2021-10-24T16:00:59</LastPaymentDate>
    <InvoiceItemId>538de2bd-3028-4562-ad96-7993e05b5a13</InvoiceItemId>
    <RoundingAdjustment>0.0000</RoundingAdjustment>
    <Tips>10.0000</Tips>
    <Employee>
      <Name>Joe Bloggs</Name>
      <Code>123</Code>
      <JobCode>SBT</JobCode>
    </Employee>
    <Tags>Kings50%</Tags>
    <Promotion />
    <CouponPrinted />
    <FirstVisit>No</FirstVisit>
    <Package />
    <PackageInvoice />
    <Due>0.0</Due>
    <PaymentType>CC Online(MasterCard)</PaymentType>
    <BusinessUnitName>Default</BusinessUnitName>
    <StateCode />
    <SAC />
    <CreatedDateInCenter>2021-10-14T15:56:51.863</CreatedDateInCenter>
    <ItemRowNum>2</ItemRowNum>
    <RowNum>1</RowNum>
    <HSN />
  </Sale>
</Sales>