Skip to content

Export Orders

In Mintsoft, an order is intended to represent a sale that the company has made to a client.

You can manage orders from the Mintsoft web portal. For reference, you can create and update orders using the Zynk connector with the Import Orders task.

Using the settings outlined below, you can configure the task to meet your specific requirements for exporting order records from Mintsoft.

Connection Settings

Connection

Required
The Mintsoft connection to use. See the Connecting to Mintsoft article on how to configure a Mintsoft connection in Zynk.

File Settings

Output File

Required
The name of the file to export the data to.

Mintsoft Settings

Channel

Optional
Optionally filter the result data by channel.

This task setting will provide a list of channels configured in the Mintsoft account associated with the given connection.

Client

Optional
Optionally filter the result data by client.

This task setting will provide a list of clients configured in the Mintsoft account associated with the given connection.

Courier Service

Optional
Optionally filter the result data by courier service.

This task setting will provide a list of courier services configured in the Mintsoft account associated with the given connection.

Date Created

Optional
Export records created on or after the given date and time when the export type is set to 'New'.

Date Modified

Optional
Export records modified on or after the given date and time when the export type is set to 'Modified'.

Export Type

Required
Select the type of export you wish to execute.

  • New - Export new records from Mintsoft. The task will store the most recent created date of the last batch of exported records.
  • Modified - Export new and modified records from Mintsoft. The task will store the most recent modified date of the last batch of exported records.
  • All - Export all records from Mintsoft.

Include Tags

Optional
Optionally include order tags in the export from Mintsoft.

Page Size

Required
The amount of records to return per page. The maximum allowed is 100 records per page.

Status

Optional
Optionally filter the result data by status.

This task setting will provide a list of order statuses configured in the Mintsoft account associated with the given connection.

Warehouse

Optional
Optionally filter the result data by warehouse.

This task setting will provide a list of warehouses configured in the Mintsoft account associated with the given connection.

XML

<?xml version="1.0" encoding="utf-8"?>
<Orders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Order>
    <ID>4398</ID>
    <LastUpdated>2023-01-20T09:22:26.7649032</LastUpdated>
    <LastUpdatedByUser>[email protected]</LastUpdatedByUser>
    <OrderNumber>1000000005</OrderNumber>
    <ExternalOrderReference>5</ExternalOrderReference>
    <OrderDate>2023-01-20T09:19:34.1221871</OrderDate>
    <DeliveryDate xsi:nil="true" />
    <DespatchDate xsi:nil="true" />
    <RequiredDespatchDate xsi:nil="true" />
    <RequiredDeliveryDate>2023-01-20T00:00:00</RequiredDeliveryDate>
    <FirstName>Joseph</FirstName>
    <LastName>Harrison</LastName>
    <CompanyName>Zynk Software Ltd</CompanyName>
    <Address1>6 Charlotte Square</Address1>
    <Address2>...</Address2>
    <Town>Newcastle</Town>
    <County>Tyne and Wear</County>
    <Postcode>NE1 4XF</Postcode>
    <Phone>0191 820 1484</Phone>
    <Email>[email protected]</Email>
    <CountryID>1</CountryID>
    <Country>
      <ID>1</ID>
      <LastUpdated>2012-05-05T22:16:35.487</LastUpdated>
      <LastUpdatedByUser>GROVESLU</LastUpdatedByUser>
      <Name>UNITED KINGDOM</Name>
      <ISOCode2>GB</ISOCode2>
      <ISOCode3>GBR</ISOCode3>
    </Country>
    <Source>API</Source>
    <Comments>This is an example order for Zynk Software Ltd.</Comments>
    <GiftMessages>Merry Christmas!</GiftMessages>
    <DeliveryNotes>Leave by the back door.</DeliveryNotes>
    <OrderStatusID>9</OrderStatusID>
    <NumberOfParcels>1</NumberOfParcels>
    <TotalItems>3</TotalItems>
    <TotalWeight>3.63</TotalWeight>
    <OrderValue>259.98</OrderValue>
    <Part>1</Part>
    <NumberOfParts>1</NumberOfParts>
    <CourierServiceID>1008</CourierServiceID>
    <CourierServiceTypeID>8</CourierServiceTypeID>
    <TrackingURL />
    <ShippingTotalExcludingVAT>8.33</ShippingTotalExcludingVAT>
    <ShippingTotalVAT>1.66</ShippingTotalVAT>
    <DiscountTotalExcludingVAT xsi:nil="true" />
    <DiscountTotalVAT xsi:nil="true" />
    <TotalVAT xsi:nil="true" />
    <PIIRemoved>false</PIIRemoved>
    <ShippingNet>8.33</ShippingNet>
    <ShippingTax>1.66</ShippingTax>
    <ShippingGross>9.99</ShippingGross>
    <DiscountNet xsi:nil="true" />
    <DiscountTax xsi:nil="true" />
    <DiscountGross xsi:nil="true" />
    <TotalOrderNet xsi:nil="true" />
    <TotalOrderTax xsi:nil="true" />
    <TotalOrderGross>259.98</TotalOrderGross>
    <ChannelID>47</ChannelID>
    <Channel>
      <ID>47</ID>
      <LastUpdated>2023-01-19T11:50:11.9899822</LastUpdated>
      <LastUpdatedByUser>SYSTEM</LastUpdatedByUser>
      <Name>API</Name>
      <Description>API</Description>
      <IsActive>true</IsActive>
      <Logo>API</Logo>
      <ClientID>0</ClientID>
    </Channel>
    <CurrencyID>1</CurrencyID>
    <Currency>
      <ID>1</ID>
      <LastUpdated>2016-05-11T22:17:25.963</LastUpdated>
      <LastUpdatedByUser>SYSTEM</LastUpdatedByUser>
      <Name>United Kingdom Pound</Name>
      <Code>GBP</Code>
      <Symbol>£</Symbol>
    </Currency>
    <Items>
      <Item>
        <ID>6476</ID>
        <LastUpdated>2023-01-20T09:22:26.467</LastUpdated>
        <LastUpdatedByUser>[email protected]</LastUpdatedByUser>
        <ProductID>1828</ProductID>
        <SKU>10006 00 06 00060</SKU>
        <OrderID>4398</OrderID>
        <QuantityOrdered>1</QuantityOrdered>
        <QuantityAllocated>0</QuantityAllocated>
        <QuantityCommitted>0</QuantityCommitted>
        <QuantityOnBackOrder>1</QuantityOnBackOrder>
        <SourceLineSubTotal xsi:nil="true" />
        <SourceLineTotalTax xsi:nil="true" />
        <SourceLineTotalDiscount xsi:nil="true" />
        <SourceLineTotal xsi:nil="true" />
        <Price>100</Price>
        <UnitPrice xsi:nil="true" />
        <UnitPriceVAT xsi:nil="true" />
        <VAT>20</VAT>
        <Discount>0</Discount>
        <PriceNet>100</PriceNet>
        <Tax>20</Tax>
        <DiscountGross>0</DiscountGross>
        <TaxRate xsi:nil="true" />
        <DiscountNet xsi:nil="true" />
        <DiscountTax xsi:nil="true" />
        <NetPaid>100</NetPaid>
        <TaxPaid>100</TaxPaid>
        <TotalTax>101</TotalTax>
        <Details>An example item.</Details>
        <OrderItemNameValues>
          <NameValue>
            <ID>590</ID>
            <LastUpdated>2023-01-20T09:19:34.107</LastUpdated>
            <LastUpdatedByUser>[email protected]</LastUpdatedByUser>
            <Name>ChannelSKU</Name>
            <Value>10006 00 06 00060</Value>
            <Internal>true</Internal>
          </NameValue>
        </OrderItemNameValues>
        <WarehouseID xsi:nil="true" />
        <MatchWarehouseOn>ID</MatchWarehouseOn>
      </Item>
      <Item>
        <ID>6477</ID>
        <LastUpdated>2023-01-20T09:22:26.763</LastUpdated>
        <LastUpdatedByUser>[email protected]</LastUpdatedByUser>
        <ProductID>1828</ProductID>
        <SKU>10006 00 06 00060</SKU>
        <OrderID>4398</OrderID>
        <QuantityOrdered>2</QuantityOrdered>
        <QuantityAllocated>0</QuantityAllocated>
        <QuantityCommitted>0</QuantityCommitted>
        <QuantityOnBackOrder>2</QuantityOnBackOrder>
        <SourceLineSubTotal xsi:nil="true" />
        <SourceLineTotalTax xsi:nil="true" />
        <SourceLineTotalDiscount xsi:nil="true" />
        <SourceLineTotal xsi:nil="true" />
        <Price>100</Price>
        <UnitPrice xsi:nil="true" />
        <UnitPriceVAT xsi:nil="true" />
        <VAT>20</VAT>
        <Discount>0</Discount>
        <PriceNet>100</PriceNet>
        <Tax>20</Tax>
        <DiscountGross>0</DiscountGross>
        <TaxRate xsi:nil="true" />
        <DiscountNet xsi:nil="true" />
        <DiscountTax xsi:nil="true" />
        <NetPaid>100</NetPaid>
        <TaxPaid>100</TaxPaid>
        <TotalTax>102</TotalTax>
        <OrderItemNameValues />
        <WarehouseID xsi:nil="true" />
        <MatchWarehouseOn>ID</MatchWarehouseOn>
      </Item>
    </Items>
    <OrderNameValues>
      <OrderNameValue>
        <ID>6274</ID>
        <LastUpdated>2023-01-20T09:19:34.1221871</LastUpdated>
        <LastUpdatedByUser>[email protected]</LastUpdatedByUser>
        <Name>SourceCourierServiceName</Name>
        <Value>Customer Collection</Value>
        <Internal xsi:nil="true" />
      </OrderNameValue>
    </OrderNameValues>
    <IsOrderLocked>false</IsOrderLocked>
    <SourceOrderDate xsi:nil="true" />
    <ClientID>126</ClientID>
    <MatchClientOn>ID</MatchClientOn>
    <WarehouseID>3</WarehouseID>
    <MatchWarehouseOn>ID</MatchWarehouseOn>
  </Order>
</Orders>