Peoplevox XML Despatches

Zynk will export the data from the "Despatch summary" report in XML format. All columns documented below will appear in the output file.

Also, you can export the related sales order related to the despatch note if you enable the Export Sales Orders task setting.

Tasks

• Export Despatch Summary from Peoplevox

Fields

Salesorder Number

Type	Example	XML
string	1234	<Salesorder_number>1234</Salesorder_number>

Requested Delivery Date

Type	Example	XML
string	'01/07/2017 23:46'	<Requested_delivery_date>'01/07/2017 23:46'</Requested_delivery_date>

Despatch Number

Type	Example	XML
string	456	<Despatch_number>456</Despatch_number>

Carrier

Type	Example	XML
string	DPD	<Carrier>DPD</Carrier>

Service

Type	Example	XML
string	UK Standard 1-2 Days (Tracked)	<Service>UK Standard 1-2 Days (Tracked)</Service>

Despatch Date

Type	Example	XML
string	'03/07/2017 06:03'	<Despatch_date>'03/07/2017 06:03'</Despatch_date>

Tracking Number

Type	Example	XML
string	1234567890	<Tracking_number>1234567890</Tracking_number>

Item Name

Type	Example	XML
string	Test item	<Item_name>Test item</Item_name>

No of Items

Type	Example	XML
string	7	<No_of_items>7</No_of_items>

Destination Country

Type	Example	XML
string	England	<Destination_country>England</Destination_country>

Site Reference

Type	Example	XML
string	PrimarySite	<Site_reference>PrimarySite</Site_reference>

Parent

Type	Example	XML
string		<Parent />

Item Code

Type	Example	XML
string	XXXX	<Item_code>XXXX</Item_code>

Username

Type	Example	XML
string	JoeH	<Username>JoeH</Username>

Carrier Reference

Type	Example	XML
string	DPD	<Carrier_reference>DPD</Carrier_reference>

Service Type Code

Type	Example	XML
string	UK Standard 1-2 Days (Tracked)	<Service_type_code>UK Standard 1-2 Days (Tracked)</Service_type_code>

Customer Order Reference

Type	Example	XML
string		<Customer_order_reference />

Shipping Cost

Type	Example	XML
string	5.95	<Shipping_cost>5.95</Shipping_cost>

Email

Type	Example	XML
string	[email protected]	<Email>[email protected]</Email>

Contact Name

Type	Example	XML
string		<Contact_name />

Total Sale

Type	Example	XML
string	29.89	<Total_sale>29.89</Total_sale>

Discount

Type	Example	XML
string		<Discount />

Tax Paid

Type	Example	XML
string	4.98	<Tax_paid>4.98</Tax_paid>

Channel Name

Type	Example	XML
string		<Channel_name />

Sale Order Attribute 1

Type	Example	XML
string		<Sales_order_attribute_1 />

Sale Order Attribute 2

Type	Example	XML
string		<Sales_order_attribute_2 />

Sale Order Attribute 3

Type	Example	XML
string		<Sales_order_attribute_3 />

Sale Order Attribute 4

Type	Example	XML
string		<Sales_order_attribute_4 />

Sale Order Attribute 5

Type	Example	XML
string		<Sales_order_attribute_5 />

Item Barcode

Type	Example	XML
string	5038135173981	<Item_barcode>5038135173981</Item_barcode>

Item Description

Type	Example	XML
string	This is a test item created for test purposes.	<Item_description>This is a test item created for test purposes.</Item_description>

Default Suppliers Part Number

Type	Example	XML
string	17398	<Default_suppliers_part_number>17398</Default_suppliers_part_number>

Item Buy Price

Type	Example	XML
string	1.29	<Item_buy_price>1.29</Item_buy_price>

Item Wholesale Price

Type	Example	XML
string	0.00	<Item_wholesale_price>0.00</Item_wholesale_price>

Item Retail Price

Type	Example	XML
string	3.42	<Item_retail_price>3.42</Item_retail_price>

Item Weight

Type	Example	XML
string	0.00	<Item_weight>0.00</Item_weight>

Item Height

Type	Example	XML
string		<Item_height />

Item Width

Type	Example	XML
string		<Item_width />

Item Depth

Type	Example	XML
string		<Item_depth />

Item Tags

Type	Example	XML
string		<Item_tags />

Item Attribute 1

Type	Example	XML
string	X	<Item_attribute_1>X</Item_attribute_1>

Item Attribute 2

Type	Example	XML
string	Y	<Item_attribute_2>Y</Item_attribute_2>

Item Attribute 3

Type	Example	XML
string	Z	<Item_attribute_3>Z</Item_attribute_3>

Item Attribute 4

Type	Example	XML
string		<Item_attribute_4 />

Item Attribute 5

Type	Example	XML
string		<Item_attribute_5 />

Item Attribute 6

Type	Example	XML
string		<Item_attribute_6 />

Item Attribute 7

Type	Example	XML
string		<Item_attribute_7 />

Item Attribute 8

Type	Example	XML
string		<Item_attribute_8 />

Item Attribute 9

Type	Example	XML
string		<Item_attribute_9 />

Item Attribute 10

Type	Example	XML
string		<Item_attribute_10 />

Item Attribute 11

Type	Example	XML
string		<Item_attribute_11 />

Item Attribute 12

Type	Example	XML
string		<Item_attribute_12 />

Item Attribute 13

Type	Example	XML
string		<Item_attribute_13 />

Item Attribute 14

Type	Example	XML
string		<Item_attribute_14 />

Item Attribute 15

Type	Example	XML
string		<Item_attribute_15 />

SalesOrder

See Peoplevox XML Sales Orders

Example XML

<?xml version="1.0" encoding="utf-8"?>
<DespatchSummary
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Despatch>
    <Salesorder_number>1234</Salesorder_number>
    <Requested_delivery_date>'01/07/2017 23:46'</Requested_delivery_date>
    <Despatch_number>456</Despatch_number>
    <Carrier>DPD</Carrier>
    <Service>UK Standard 1-2 Days (Tracked)</Service>
    <Despatch_date>'03/07/2017 06:03'</Despatch_date>
    <Tracking_number>1234567890</Tracking_number>
    <Item_name>Test item</Item_name>
    <No_of_items>7</No_of_items>
    <Destination_country>England</Destination_country>
    <Site_reference>PrimarySite</Site_reference>
    <Parent />
    <Item_code>XXXX</Item_code>
    <Username>JoeH</Username>
    <Carrier_reference>DPD</Carrier_reference>
    <Service_type_code>UK Standard 1-2 Days (Tracked)</Service_type_code>
    <Customer_order_reference />
    <Shipping_cost>5.95</Shipping_cost>
    <Email>[email protected]</Email>
    <Contact_name />
    <Total_sale>29.89</Total_sale>
    <Discount />
    <Tax_paid>4.98</Tax_paid>
    <Channel_name />
    <Sales_order_attribute_1 />
    <Sales_order_attribute_2 />
    <Sales_order_attribute_3 />
    <Sales_order_attribute_4 />
    <Sales_order_attribute_5 />
    <Item_barcode>5038135173981</Item_barcode>
    <Item_description>This is a test item created for test purposes.</Item_description>
    <Default_suppliers_part_number>17398</Default_suppliers_part_number>
    <Item_buy_price>1.29</Item_buy_price>
    <Item_wholesale_price>0.00</Item_wholesale_price>
    <Item_retail_price>3.42</Item_retail_price>
    <Item_weight>0.00</Item_weight>
    <Item_height />
    <Item_width />
    <Item_depth />
    <Item_tags />
    <Item_attribute_1>X</Item_attribute_1>
    <Item_attribute_2>Y</Item_attribute_2>
    <Item_attribute_3>Z</Item_attribute_3>
    <Item_attribute_4 />
    <Item_attribute_5 />
    <Item_attribute_6 />
    <Item_attribute_7 />
    <Item_attribute_8 />
    <Item_attribute_9 />
    <Item_attribute_10 />
    <Item_attribute_11 />
    <Item_attribute_12 />
    <Item_attribute_13 />
    <Item_attribute_14 />
    <Item_attribute_15 />
  </Despatch>
</DespatchSummary>