Utility package

Tool version	1.9
Tool files	download
Tool name	wmx2xml.exe

Import tool settings

You need to create a file called settings.xml and place it in the same folder as the tool.

`settings.xml`

<?xml version="1.0" encoding="utf-8"?>
<Settings>
    <!-- ERP Web Service account provided by Webmercs -->
    <Email></Email>
    <Password></Password>

    <!-- Email for receiving error reports. Separate multiple emails with ; -->
    <AdminEmail></AdminEmail>


    <!-- If you want to test without writing order# to webshop database or marking the order as exported -->
    <TestMode>true</TestMode>

    <!-- Optional. Defines settings which control how orders are chosen for import. -->
    <Filter>
        <!-- Specifies exact order for import -->
        <OrderId>0</OrderId>

        <!-- Specifies how old imported orders are. -->
        <LastDaysCount>-1</LastDaysCount>

        <!-- Specifies that only orders marked as 'Printed' should be imported. -->
        <OnlyPrinted>true</OnlyPrinted>

        <!-- Specify a date range. Orders created within it would be imported. -->
        <FromDate>2008-01-01</FromDate>
        <ToDate>2008-01-31</ToDate>

        <!-- Specifies that only orders not marked as imported should be processed. -->
        <OnlyNotImported>true</OnlyNotImported>

        <!-- Specifies that only orders which belong to corporate customers should be imported. -->
        <OnlyCorporate>false</OnlyCorporate>

        <!-- Specifies whether 'Ordered' orders having no vendor responses should be imported. -->
        <SkipVendorOrdersCheck>false</SkipVendorOrdersCheck>

        <!-- Specifies comma-separated list of order status names -->
        <StatusNames>In Process,Deleted</StatusNames>

        <!-- [Obsolete] Specifies coma-separated list of order status codes from the limited set: [InProcess|Shipped|Pending|Paid|Ordered]-->
        <Status>Shipped,Ordered</Status>

        <!-- [true|false] Specified whether orders only with 'Shipped' or 'Ordered' status should be imported -->
        <!--              Makes sense only when <Status> is not defined. -->
        <CheckStatus>true</CheckStatus>
    </Filter>

</Settings>

Filter element and all of its sub-elements are optional and therefore can be omitted.

Using the utility

Downloading orders

wmx2xml.exe -get [o:OrderNumber] [noflag]

The default function of the utility is to download all orders that are not marked as downloaded already, and then mark them as downloaded.
Contact Webmercs to have orders up to a certain date or order number marked as downloaded.

noflag indicates that orders should not be marked as downloaded.
OrderNumber should be replaced with a real webshop order number for downloading one order. Always convenient when testing.

examples:
wmx2xml -get noflag
wmx2xml -get
wmx2xml -get o:26850

Updating orders after import

NB! This command should be executed on orders which were retrieved with noflag command line argument.

wmx2xml.exe -success o:<OrderId> en:<ExternalOrderNumber>

where
<OrderId> is the Webmercs order number
<ExternalOrderNumber> is an external reference to the order (typically the order number assigned to this order in your own accounting system)

Example of the order detail XML

<Order>
  <OrderId>10000</OrderId>
  <DealerId>1</DealerId>
  <ExternalCode>WMX-10000</ExternalCode>
  <OrderTime>2008-11-02T15:40:46.96+01:00</OrderTime>
  <CurrentTime>2008-11-14T16:13:44.667+01:00</CurrentTime>
  <ShipToID />
  <ShipDate>2008-11-14T15:03:11.267+01:00</ShipDate>
  <Status>Sendt</Status>
  <AuthorPersonalNumber>12</AuthorPersonalNumber>
  <SalesRepName>Mr. PlacedBy</SalesRepName>
  <UserDepartment />
  <Comment>User comment</Comment>
  <AdminComment>11.11.08 - sent email</AdminComment>
  <ExtraSum>0.0000</ExtraSum>
  <AdditionalCharge>10.0000</AdditionalCharge>
  <TaxSum>1260.2000</TaxSum>
  <ShippingSum>215.2000</ShippingSum>
  <ShippingMethodID>2</ShippingMethodID>
  <ShippingMethod>Posten Standard</ShippingMethod>
  <SubTotal>4825.6000</SubTotal>
  <Total>6301.0000</Total>
  <Discount>0.0000</Discount>
  <DiscountCouponCode />
  <OrgNumber>1234-6789</OrgNumber>
  <PaymentTypeId>10</PaymentTypeId>
  <PaymentTerms>Faktura</PaymentTerms>
  <PaymentType>Faktura30</PaymentType>
  <PaymentDays>30</PaymentDays>
  <PaymentTab>1</PaymentTab>
  <PaymentGroup>3</PaymentGroup>
  <UserIP>85.1.1.1</UserIP>
  <DueDate>2008-12-14T16:13:44.667+01:00</DueDate>
  <InvoiceNumber />
  <CustomerPO>#12345</CustomerPO>
  <WarehouseNumber />
  <Author>
    <UserId>1</UserId>
    <PersonalNumber>12</PersonalNumber>
    <Name>Mr. PlacedBy</Name>
    <Department />
    <Email>sales@web.no</Email>
  </Author>
  <SalesRep>
    <UserId>4</UserId>
    <PersonalNumber>141</PersonalNumber>
    <Name>Mr. SalesRep</Name>
    <Department />
    <Email>info@web.no</Email>
  </SalesRep>
  <Customer>
    <UserID>23427</UserID>
    <CustomerId>7</CustomerId>
    <Number>30004</Number>
    <UserEmail>someuser@example.com</UserEmail>
    <CreditLimit>0.0000</CreditLimit>
    <PaymentTermsID>1</PaymentTermsID>
    <DefaultBillingContact>
      <ContactId>4E8514CA-6E8E-45C4-9326-EA54349A1835</ContactId>
      <AddressId>134716</AddressId>
      <FirstName>John</FirstName>
      <LastName>Smith</LastName>
      <ZipCode>6509</ZipCode>
      <Address1>Langveien 1</Address1>
      <Address2 />
      <City>KRISTIANSUND N</City>
      <CountryCode>NO</CountryCode>
      <Phone>99999999</Phone>
      <WorkPhone />
      <Fax />
      <Company />
      <Department />
      <InvoiceNumber />
      <StateName>NO</StateName>
    </DefaultBillingContact>
    <DefaultShippingContact>
      <ContactId>37EEE4FE-8817-4647-89ED-6A1238932A9D</ContactId>
      <AddressId>204504</AddressId>
      <FirstName>John</FirstName>
      <LastName>Smith</LastName>
      <ZipCode>6509</ZipCode>
      <Address1>langveien 1</Address1>
      <Address2 />
      <City>KRISTIANSUND N</City>
      <CountryCode>NO</CountryCode>
      <Phone>99999999</Phone>
      <WorkPhone />
      <Fax />
      <Company />
      <Department />
      <StateName>NO</StateName>
    </DefaultShippingContact>
  </Customer>
  <BillingContact>
    <ContactId>4E8514CA-6E8E-45C4-9326-EA54349A1835</ContactId>
    <AddressId>419369</AddressId>
    <FirstName>John</FirstName>
    <LastName>Smith</LastName>
    <ZipCode>6509</ZipCode>
    <Address1>langveien 1</Address1>
    <Address2 />
    <City>KRISTIANSUND N</City>
    <CountryCode>NO</CountryCode>
    <Phone>99999999</Phone>
    <WorkPhone />
    <Fax />
    <Company />
    <Department />
    <InvoiceNumber />
    <StateName>NO</StateName>
  </BillingContact>
  <ShippingContact>
    <ContactId>37EEE4FE-8817-4647-89ED-6A1238932A9D</ContactId>
    <AddressId>419370</AddressId>
    <FirstName>John</FirstName>
    <LastName>Smith</LastName>
    <ZipCode>6509</ZipCode>
    <Address1>langveien 1</Address1>
    <Address2 />
    <City>KRISTIANSUND N</City>
    <CountryCode>NO</CountryCode>
    <Phone>99999999</Phone>
    <WorkPhone />
    <Fax />
    <Company />
    <Department />
    <StateName>NO</StateName>
  </ShippingContact>
  <OrderContent>
    <OrderLine>
      <OrderLineId>276548</OrderLineId>
      <ProductId>1891359</ProductId>
      <ProductName>PHENOM TRIPLE-CORE 2.3 GHZ L2=512KB CORE L3=2MB SOC AM2+ 95W PIB</ProductName>
      <BrandName>AMD</BrandName>
      <BrandId>270</BrandId>
      <BrandCode />
      <BrandSku>HD8650WCGHBOX</BrandSku>
      <VendorBrandSku>HD8650WCGHBOX</VendorBrandSku>
      <SellingPrice>721.6000</SellingPrice>
      <PriceWithoutDiscount>721.6000</PriceWithoutDiscount>
      <Qty>1</Qty>
      <Stock>3</Stock>
      <SnapStock>91</SnapStock>
      <ClaimNumber />
      <BundleName />
      <Cost>678.0000</Cost>
      <SalesTax>25.00</SalesTax>
      <Weight>1.80</Weight>
      <Comment />
      <Vendor>
        <Id>7</Id>
        <Name>GNT</Name>
        <ShortName>GNT</ShortName>
        <Code />
      </Vendor>
      <Category>
        <Id>36124</Id>
        <Name>Prosessorer</Name>
        <Code />
      </Category>
      <CategoryFolder>
        <Id>103086</Id>
        <Name>Prossessorer</Name>
        <Code />
      </CategoryFolder>
    </OrderLine>
    <OrderLine>
      <OrderLineId>276549</OrderLineId>
      <ProductId>1853623</ProductId>
      <ProductName>GA-MA78GM-S2H AMD AM2+ PHENOM AM2 ATHLON64 DDR2 1066 SATA 3GB S  16</ProductName>
      <BrandName>GIGABYTE</BrandName>
      <BrandId>139</BrandId>
      <BrandCode />
      <BrandSku>GA-MA78GM-S2H</BrandSku>
      <VendorBrandSku>GA-MA78GM-S2H</VendorBrandSku>
      <SellingPrice>467.2000</SellingPrice>
      <PriceWithoutDiscount>467.2000</PriceWithoutDiscount>
      <Qty>1</Qty>
      <Stock>100</Stock>
      <SnapStock>224</SnapStock>
      <ClaimNumber />
      <BundleName />
      <Cost>535.0000</Cost>
      <SalesTax>25.00</SalesTax>
      <Weight>2.70</Weight>
      <Comment />
      <Vendor>
        <Id>21</Id>
        <Name>Norek</Name>
        <ShortName>Norek</ShortName>
        <Code />
      </Vendor>
      <Category>
        <Id>36123</Id>
        <Name>Hovedkort</Name>
        <Code />
      </Category>
      <CategoryFolder>
        <Id>103046</Id>
        <Name>Hovedkort/Skjermkort/Lydkort</Name>
        <Code />
      </CategoryFolder>
    </OrderLine>
    <OrderLine>
      <OrderLineId>276550</OrderLineId>
      <ProductId>1824598</ProductId>
      <ProductName>DDR2 HyperX PC8500 4096MB CL5, Kit 4x matched HyperX 1GB DDR2</ProductName>
      <BrandName>KINGSTON</BrandName>
      <BrandId>5</BrandId>
      <BrandCode />
      <BrandSku>KHX8500D2K4/4G</BrandSku>
      <VendorBrandSku>KHX8500D2K4/4G</VendorBrandSku>
      <SellingPrice>621.6000</SellingPrice>
      <PriceWithoutDiscount>621.6000</PriceWithoutDiscount>
      <Qty>1</Qty>
      <Stock>1</Stock>
      <SnapStock>27</SnapStock>
      <ClaimNumber />
      <BundleName />
      <Cost>539.0000</Cost>
      <SalesTax>25.00</SalesTax>
      <Weight>0.10</Weight>
      <Comment />
      <Vendor>
        <Id>7</Id>
        <Name>GNT</Name>
        <ShortName>GNT</ShortName>
        <Code />
      </Vendor>
      <Category>
        <Id>36213</Id>
        <Name>Systemminne</Name>
        <Code />
      </Category>
      <CategoryFolder>
        <Id>103173</Id>
        <Name>Minne</Name>
        <Code />
      </CategoryFolder>
    </OrderLine>
    <OrderLine>
      <OrderLineId>276556</OrderLineId>
      <ProductId>334242</ProductId>
      <ProductName>Wireless-G PCI 54 Mbps 802.11g , WPA/AES</ProductName>
      <BrandName>LINKSYS</BrandName>
      <BrandId>366</BrandId>
      <BrandCode />
      <BrandSku>WMP54G</BrandSku>
      <VendorBrandSku>WMP54G</VendorBrandSku>
      <SellingPrice>209.6000</SellingPrice>
      <PriceWithoutDiscount>209.6000</PriceWithoutDiscount>
      <Qty>1</Qty>
      <Stock>147</Stock>
      <SnapStock>147</SnapStock>
      <ClaimNumber />
      <BundleName />
      <Cost>173.0000</Cost>
      <SalesTax>25.00</SalesTax>
      <Weight>0.24</Weight>
      <Comment />
      <Vendor>
        <Id>3</Id>
        <Name>Ingram Micro</Name>
        <ShortName>IM</ShortName>
        <Code />
      </Vendor>
      <Category>
        <Id>36180</Id>
        <Name>Trådløst Nettverk</Name>
        <Code />
      </Category>
      <CategoryFolder>
        <Id>102690</Id>
        <Name>Nettverk/Kommunikasjon</Name>
        <Code />
      </CategoryFolder>
    </OrderLine>
  </OrderContent>
  <VendorOrder>
    <Id>1000001</Id>
    <VendorId>3</VendorId>
    <VendorOrderNumber>3000007</VendorOrderNumber>
    <WebShopReference>10000AIX</WebShopReference>
    <TrackingNumber>
      <Number>CS3XXXXXXXXDK</Number>
      <TrackingUrl>http://example.com/Shipment.aspx?Number=CS3XXXXXXXXDK</TrackingUrl>
    </TrackingNumber>
    <TrackingNumber>
      <Number>CS5XXXXXXXXDK</Number>
      <TrackingUrl>http://example.com/Shipment.aspx?Number=CS5XXXXXXXXDK</TrackingUrl>
    </TrackingNumber>
  </VendorOrder>
  <VendorOrder>
    <Id>1000002</Id>
    <VendorId>7</VendorId>
    <VendorOrderNumber>700001</VendorOrderNumber>
    <WebShopReference>10000ZBZ</WebShopReference>
    <TrackingNumber>
      <Number>34000XXXXXXXXXXX09</Number>
      <TrackingUrl>http://example.com/Default.aspx?fraktnr=34000XXXXXXXXXXX09</TrackingUrl>
    </TrackingNumber>
    <TrackingNumber>
      <Number>34000XXXXXXXXXXX19</Number>
      <TrackingUrl>http://example.com/Default.aspx?fraktnr=34000XXXXXXXXXXX19</TrackingUrl>
    </TrackingNumber>
  </VendorOrder>
  <Settings>
    <DealerName>Default</DealerName>
    <CurrencyCode>NOK</CurrencyCode>
    <PaymentProfile>Default</PaymentProfile>
    <VatCode>353</VatCode>
    <FreightLineSku>FRAKT</FreightLineSku>
    <PaymentExternalCode />
    <CountryCode>NO</CountryCode>
    <DocumentVersion>1.02</DocumentVersion>
  </Settings>
</Order>