Skip to content

Instantly share code, notes, and snippets.

@davidsheardown
Last active November 8, 2023 09:45
Show Gist options
  • Save davidsheardown/7538c9ade6fa2fc62ecf1a07fda49c61 to your computer and use it in GitHub Desktop.
Save davidsheardown/7538c9ade6fa2fc62ecf1a07fda49c61 to your computer and use it in GitHub Desktop.
XQuery/XPath in SQL Example Individual Elements and Rows
Given the XML down below, we can use a couple of queries to get individual elements (or attr) but also a list of other nodes/values:
;with cte
as
(
select
Id,
Filename,
cast (replace(XMLpayload, 'utf-8', 'utf-16') AS XML) as XmlContent,
CreatedAt
from
Pricat
where
Processed = 0
)
-- Now select the relevant fields we want as well as the XML node/elements
select
Id,
Filename,
Header.N.value('(*:DocumentIdentification)[1]', 'varchar(50)') as DocumentIdentificationNo,
GroupsVariant.N.value('(*:ItemNumber)[1]', 'varchar(100)') as ItemNumberBarcode
from
cte
-- *NOTE: We handle the multiple namespaces by using the "*:" before the node name(s)
-- *NOTE: The node names are CASE SENSITIVE!
outer apply cte.XmlContent.nodes('/*:SalesPriceCatalogue_Xml_Full/*:Header') as Header(N)
outer apply cte.XmlContent.nodes('/*:SalesPriceCatalogue_Xml_Full/*:Groups/*:Group/*:Variants/*:Variant') as GroupsVariant(N)
-- The following is where you will need to perform a separate query to return a "set" of prices. Of course, you can't return
-- multiple rows within already rows if you follow me :)
-- So, for example, if you want to return all ADDITIONAL PRICES (you could also filter these!) then...
;with cte
as
(
select
Id,
Filename,
cast (replace(XMLpayload, 'utf-8', 'utf-16') AS XML) as XmlContent,
CreatedAt
from
Pricat
where
Processed = 0
)
SELECT
T.c.query('*:GrossPriceCurrency').value('.', 'varchar(50)') AS GrossPriceCurrency,
T.c.query('*:GrossPriceAmount').value('.', 'varchar(50)') AS GrossPriceAmount,
T.c.query('*:Country/*:CountryName').value('.', 'varchar(50)') AS Country
FROM
cte
cross apply cte.XmlContent.nodes('//*:PriceDetail/*:AdditionalPrices/*:AdditionalPrice') T(c)
--WHERE
--T.c.query('*:Country/*:Cou
<ns0:SalesPriceCatalogue_Xml_Full xmlns:ns0="http://Bestseller.BizTalk.Object.SalesPriceCatalogue.CustomXml.Schemas">
<ns0:Header>
<ns0:SubscriptionType>D</ns0:SubscriptionType>
<ns0:DocumentIdentification>296706233</ns0:DocumentIdentification>
<ns0:CustomerReference>Noos</ns0:CustomerReference>
<ns0:SalesOrderNumber>43189135</ns0:SalesOrderNumber>
<ns0:DispatchNoteNumber>2392828368</ns0:DispatchNoteNumber>
<ns0:OriginatingSystem>
<ns0:ErpSystem>BestInfo2</ns0:ErpSystem>
<ns0:SubSystem>BestPack3</ns0:SubSystem>
<ns0:Organization>Bestseller</ns0:Organization>
</ns0:OriginatingSystem>
<ns0:Date>
<ns0:DocumentDate>2023-10-12</ns0:DocumentDate>
<ns0:DocumentTime>07:00:59</ns0:DocumentTime>
<ns0:SalesOrderDate>2023-10-10</ns0:SalesOrderDate>
<ns0:ValidityStartDate>2023-10-12</ns0:ValidityStartDate>
</ns0:Date>
<ns0:Vat>
<ns0:Rate>23</ns0:Rate>
<ns0:Currency>EUR</ns0:Currency>
</ns0:Vat>
<ns0:Parties>
<ns0:BuyerParty>
<ns0:Name>Born Thurles</ns0:Name>
<ns0:PartyIdentificationDetail>
<ns0:CustomerNumber>301122</ns0:CustomerNumber>
<ns0:VatRegistrationNumber>IE9842299H</ns0:VatRegistrationNumber>
<ns0:GlobalLocationNumber>12264</ns0:GlobalLocationNumber>
</ns0:PartyIdentificationDetail>
<ns0:Address>
<ns0:StreetNameAndNumber>Thurles Shopping Centre</ns0:StreetNameAndNumber>
<ns0:MoreInfo>Elland Clothing Thurles Limited</ns0:MoreInfo>
<ns0:CityName>Tipperary</ns0:CityName>
<ns0:PostcodeIdentification>E41 V4Y9</ns0:PostcodeIdentification>
<ns0:Country>
<ns0:CountryName>IRELAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>372</ns0:CountryCodeNumber>
</ns0:Country>
<ns0:Contact>
<ns0:Telephone>091 895226</ns0:Telephone>
</ns0:Contact>
</ns0:Address>
</ns0:BuyerParty>
<ns0:SupplierParty>
<ns0:Name>BESTSELLER Wholesale (Ireland) Ltd.</ns0:Name>
<ns0:PartyIdentificationDetail>
<ns0:VatRegistrationNumber>IE8265260D</ns0:VatRegistrationNumber>
<ns0:GlobalLocationNumber>5700670000076</ns0:GlobalLocationNumber>
</ns0:PartyIdentificationDetail>
<ns0:Address>
<ns0:StreetNameAndNumber>Unit 14, The Westway Centre, Ballymount Avenue</ns0:StreetNameAndNumber>
<ns0:CityName>Dublin 12</ns0:CityName>
<ns0:PostcodeIdentification>D12 A33D</ns0:PostcodeIdentification>
<ns0:Country>
<ns0:CountryName>IRELAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>372</ns0:CountryCodeNumber>
</ns0:Country>
<ns0:Contact />
</ns0:Address>
</ns0:SupplierParty>
</ns0:Parties>
</ns0:Header>
<ns0:Groups>
<ns0:Group>
<ns0:Variants>
<ns0:Variant>
<ns0:ItemNumberMaster>12150148</ns0:ItemNumberMaster>
<ns0:ItemNumber>5713755553046</ns0:ItemNumber>
<ns0:ItemName>JPSTMARCO JJBOWIE NOOS</ns0:ItemName>
<ns0:GlobalTradeItemNumberVariant>5713755553046</ns0:GlobalTradeItemNumberVariant>
<ns0:GlobalTradeItemNumberMaster>5713753625981</ns0:GlobalTradeItemNumberMaster>
<ns0:SubBrandName>JACK&amp;JONES PANTS STUDIO</ns0:SubBrandName>
<ns0:BrandName>Jack &amp; Jones</ns0:BrandName>
<ns0:CustomsCode>62034235</ns0:CustomsCode>
<ns0:CustomsCodeName>Other</ns0:CustomsCodeName>
<ns0:ValueAddedTaxRate>23</ns0:ValueAddedTaxRate>
<ns0:IsItemPriceMarked>true</ns0:IsItemPriceMarked>
<ns0:IsItemBarcoded>true</ns0:IsItemBarcoded>
<ns0:IsBox>false</ns0:IsBox>
<ns0:IsMarketing>false</ns0:IsMarketing>
<ns0:IsSupplement>false</ns0:IsSupplement>
<ns0:IsNeverOutOfStock>true</ns0:IsNeverOutOfStock>
<ns0:Season>Winter</ns0:Season>
<ns0:DeliveryPeriod>
<ns0:StartDate>1900-01-01</ns0:StartDate>
<ns0:EndDate>2999-12-31</ns0:EndDate>
<ns0:PeriodName>IMMEDIATE</ns0:PeriodName>
</ns0:DeliveryPeriod>
<ns0:ItemDescription>
<ns0:Description> - Detail Type : Chino trousers
- Fabric : Satin fabrics are more shiny than other fabrics. Giving a more exlusive look
- Waist/Rise : Low rise
- Closing/Fly : Zip fly fastening
- Pocket other : Chino pockets
- Occasion/Styling : The chino pant is an essential style for this category. It is the in between of a dress pant and a casual 5 pocket styling. It's a plain styling, with front and back pockets only
- Fit : Slim fit with a low rise, slim knee and tight leg opening
- Fit : Slim Fit</ns0:Description>
<ns0:DescriptionShort>PANTS MALE WOV CO78/COC20/EA2</ns0:DescriptionShort>
<ns0:QualityDescription>Gender: Male
Manufacture: Woven
Manufacture Detail: Twill weave
Style Type: PANTS
Composition: 78% Cotton, 20% Cotton - Recycled, 2% Elastane</ns0:QualityDescription>
</ns0:ItemDescription>
<ns0:ItemCatagorization>
<ns0:ProductGroupName>Trousers</ns0:ProductGroupName>
<ns0:ProductGroupNumber>8</ns0:ProductGroupNumber>
<ns0:ProductSubGroupName>Chinos</ns0:ProductSubGroupName>
<ns0:ProductSubGroupNumber>56</ns0:ProductSubGroupNumber>
<ns0:NcrIdentifier>224</ns0:NcrIdentifier>
<ns0:ProductClassificationCodeBte>110500</ns0:ProductClassificationCodeBte>
<ns0:ProductClassificationCodeBteV2>110510 H-Kombihosen</ns0:ProductClassificationCodeBteV2>
<ns0:TargetGroup>Male</ns0:TargetGroup>
</ns0:ItemCatagorization>
<ns0:ItemClassification>
<ns0:IsInvoiceUnit>true</ns0:IsInvoiceUnit>
<ns0:IsDespatchUnit>false</ns0:IsDespatchUnit>
<ns0:IsOrderingUnit>true</ns0:IsOrderingUnit>
<ns0:IsConsumerUnit>true</ns0:IsConsumerUnit>
</ns0:ItemClassification>
<ns0:CountryOfOrigin>
<ns0:CountryName>PAKISTAN</ns0:CountryName>
<ns0:CountryCodeAlpha2>PK</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>PAK</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>586</ns0:CountryCodeNumber>
</ns0:CountryOfOrigin>
<ns0:Measurement>
<ns0:ItemNetWeight>0.438</ns0:ItemNetWeight>
<ns0:ItemGrossWeight>0.488</ns0:ItemGrossWeight>
</ns0:Measurement>
<ns0:PhysicalAttribute>
<ns0:Size>30</ns0:Size>
<ns0:Length>32</ns0:Length>
<ns0:LengthName>"32</ns0:LengthName>
<ns0:ColourName>Navy Blazer</ns0:ColourName>
<ns0:MainColourName>BLUE</ns0:MainColourName>
<ns0:MainColourNumber>3</ns0:MainColourNumber>
<ns0:ColourNumber>175876</ns0:ColourNumber>
<ns0:PantoneNumber>19-3923 TCX</ns0:PantoneNumber>
<ns0:HexCode>#282D3C</ns0:HexCode>
<ns0:FabricComposition>
<ns0:FabricCompositionText>78% Cotton, 20% Cotton - Recycled, 2% Elastane</ns0:FabricCompositionText>
<ns0:Compositions>
<ns0:Composition>
<ns0:MaterialName>Elastane</ns0:MaterialName>
<ns0:MaterialShortName>EA</ns0:MaterialShortName>
<ns0:Percentage>2</ns0:Percentage>
</ns0:Composition>
<ns0:Composition>
<ns0:MaterialName>Cotton - Recycled</ns0:MaterialName>
<ns0:MaterialShortName>COC</ns0:MaterialShortName>
<ns0:Percentage>20</ns0:Percentage>
</ns0:Composition>
<ns0:Composition>
<ns0:MaterialName>Cotton</ns0:MaterialName>
<ns0:MaterialShortName>CO</ns0:MaterialShortName>
<ns0:Percentage>78</ns0:Percentage>
</ns0:Composition>
</ns0:Compositions>
</ns0:FabricComposition>
<ns0:VariantSpecification>
<ns0:VariantName />
<ns0:StyleVariantNumbering />
</ns0:VariantSpecification>
</ns0:PhysicalAttribute>
<ns0:PriceDetail>
<ns0:LocalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
</ns0:LocalPrice>
<ns0:AdditionalPrices>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>FRANCE</ns0:CountryName>
<ns0:CountryCodeAlpha2>FR</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>FRA</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>250</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>BELGIUM</ns0:CountryName>
<ns0:CountryCodeAlpha2>BE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>BEL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>56</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>NETHERLANDS</ns0:CountryName>
<ns0:CountryCodeAlpha2>NL</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>NLD</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>528</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>GERMANY</ns0:CountryName>
<ns0:CountryCodeAlpha2>DE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>DEU</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>276</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>ITALY</ns0:CountryName>
<ns0:CountryCodeAlpha2>IT</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>ITA</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>380</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>12.50</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>GBP</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>35</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>GBP</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>UNITED KINGDOM</ns0:CountryName>
<ns0:CountryCodeAlpha2>GB</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>GBR</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>826</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>IRELAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>372</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>114.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>DKK</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>399.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>DKK</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>DENMARK</ns0:CountryName>
<ns0:CountryCodeAlpha2>DK</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>DNK</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>208</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>GREECE</ns0:CountryName>
<ns0:CountryCodeAlpha2>GR</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>GRC</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>300</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>34.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>SPAIN</ns0:CountryName>
<ns0:CountryCodeAlpha2>ES</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>ESP</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>724</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>21</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>CAD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>70</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>CAD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>CANADA</ns0:CountryName>
<ns0:CountryCodeAlpha2>CA</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>CAN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>124</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>18.58</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>64.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>LEBANON</ns0:CountryName>
<ns0:CountryCodeAlpha2>LB</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>LBN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>422</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>151.50</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>NOK</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>499.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>NOK</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>NORWAY</ns0:CountryName>
<ns0:CountryCodeAlpha2>NO</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>NOR</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>578</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>156.20</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>SEK</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>499.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>SEK</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>SWEDEN</ns0:CountryName>
<ns0:CountryCodeAlpha2>SE</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>SWE</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>752</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>FINLAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>FI</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>FIN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>246</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>HUNGARY</ns0:CountryName>
<ns0:CountryCodeAlpha2>HU</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>HUN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>348</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>AUSTRIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>AT</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>AUT</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>40</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>16.60</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>CHF</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>49.90</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>CHF</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>SWITZERLAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>CH</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>CHE</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>756</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>20</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>49.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>TURKEY</ns0:CountryName>
<ns0:CountryCodeAlpha2>TR</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>TUR</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>792</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>400</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>TRY</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>999.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>TRY</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>TURKEY</ns0:CountryName>
<ns0:CountryCodeAlpha2>TR</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>TUR</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>792</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>64.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>PLN</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>179.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>PLN</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>POLAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>PL</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>POL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>616</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>343</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>CZK</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>1029</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>CZK</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>CZECH REPUBLIC</ns0:CountryName>
<ns0:CountryCodeAlpha2>CZ</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>CZE</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>203</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>UKRAINE</ns0:CountryName>
<ns0:CountryCodeAlpha2>UA</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>UKR</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>804</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>1203.45</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>RUB</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>3490</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>RUB</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>RUSSIAN FEDERATION</ns0:CountryName>
<ns0:CountryCodeAlpha2>RU</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>RUS</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>643</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>SLOVENIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>SI</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>SVN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>705</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>16.67</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>45</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>USA</ns0:CountryName>
<ns0:CountryCodeAlpha2>US</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>USA</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>840</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>CROATIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>HR</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>HRV</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>191</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>1275</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>INR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>3195</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>INR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>INDIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>IN</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>IND</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>356</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>TUNISIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>TN</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>TUN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>788</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>16.20</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>44.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>CHILE</ns0:CountryName>
<ns0:CountryCodeAlpha2>CL</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>CHL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>152</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>25.90</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>AUD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>69.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>AUD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>AUSTRALIA</ns0:CountryName>
<ns0:CountryCodeAlpha2>AU</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>AUS</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>36</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>555.19</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>MXN</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>1499</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>MXN</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>MEXICO</ns0:CountryName>
<ns0:CountryCodeAlpha2>MX</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>MEX</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>484</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>29.99</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>NZD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>89.99</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>NZD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>NEW ZEALAND</ns0:CountryName>
<ns0:CountryCodeAlpha2>NZ</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>NZL</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>554</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>13.87</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>39.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>PANAMA</ns0:CountryName>
<ns0:CountryCodeAlpha2>PA</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>PAN</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>591</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
<ns0:AdditionalPrice>
<ns0:GrossPriceAmount>20.25</ns0:GrossPriceAmount>
<ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency>
<ns0:RetailPriceAmount>59.95</ns0:RetailPriceAmount>
<ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency>
<ns0:Country>
<ns0:CountryName>URUGUAY</ns0:CountryName>
<ns0:CountryCodeAlpha2>UY</ns0:CountryCodeAlpha2>
<ns0:CountryCodeAlpha3>URY</ns0:CountryCodeAlpha3>
<ns0:CountryCodeNumber>858</ns0:CountryCodeNumber>
</ns0:Country>
</ns0:AdditionalPrice>
</ns0:AdditionalPrices>
</ns0:PriceDetail>
<ns0:Pictures>
<ns0:Picture>
<ns0:ImageType>Pack Shot</ns0:ImageType>
<ns0:ImagePerspective>Front</ns0:ImagePerspective>
<ns0:FileReferenceUrl>https://bsdammediahub.blob.core.windows.net/productassets/12150148/2993779/e76023a4-19d7-41f2-a273-a8e000f1a9f3/e76023a4-19d7-41f2-a273-a8e000f1a9f3_12150148_2993779_001_preview.jpg</ns0:FileReferenceUrl>
<ns0:ShortUrl>http://image.bestseller.com/e76023a4-19d7-41f2-a273-a8e000f1a9f3</ns0:ShortUrl>
</ns0:Picture>
</ns0:Pictures>
<ns0:Pictures>
<ns0:Picture>
<ns0:ImageType>Pack Shot</ns0:ImageType>
<ns0:ImagePerspective>Back</ns0:ImagePerspective>
<ns0:FileReferenceUrl>https://bsdammediahub.blob.core.windows.net/productassets/12150148/2993779/e597e967-74b6-4d23-b190-a8e000f1bcb7/e597e967-74b6-4d23-b190-a8e000f1bcb7_12150148_2993779_002_preview.jpg</ns0:FileReferenceUrl>
<ns0:ShortUrl>http://image.bestseller.com/e597e967-74b6-4d23-b190-a8e000f1bcb7</ns0:ShortUrl>
</ns0:Picture>
</ns0:Pictures>
</ns0:Variant>
</ns0:Variants>
<ns0:Assortments />
</ns0:Group>
</ns0:Groups>
</ns0:SalesPriceCatalogue_Xml_Full>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment