Home > Webservices > Eksporter ordrer

Eksport af bestillinger

URL til Webservices : https://sws.spartoo.dk/mp/xml_export_orders.php

Denne webservice gør det muligt at hente informationer om bestillinger, der er afgivet efter en hvis dato ud fra et ID.
. Bestillingerne kan filtreres efter status

Liste over parametre

Parametrene i denne webservice skal sendes via POST

Parameter	Beskrivelse
partenaire	Skal indeholde dit unikke forhandler ID:
date	Den dato du ønsker at se bestillinger fra. Format: ÅÅÅÅ-MM-DD:tt:mm:ss (eksempel : 2011-11-27:03:00:00)
oID	Bestillings ID
statut	Status, der skal filtreres på. Hvis der ikke vælges en parameter, bliver alle bestillinger valgt. > Se listen over statusser

Parameteren forhandler er obligatorisk sammen med enten dato eller oID. Parameteren status er valgfri.

Det returnerede XML-format

<root>
	<orders>
		<order>
			<orders_id>string</orders_id>
			<customers>
				<customers_firstname>string</customers_firstname>
				<customers_lastname>string</customers_lastname>
				<customers_company>string</customers_company>
				<customers_street_address>string</customers_street_address>
				<customers_suburb>string</customers_suburb>
				<customers_city>string</customers_city>
				<customers_postcode>string</customers_postcode>
				<customers_state>string</customers_state>
				<customers_country>string</customers_country>
				<customers_email_address>string</customers_email_address>
				<customers_telephone>string</customers_telephone>
			</customers>
			<delivery>
				<delivery_firstname>string</delivery_firstname>
				<delivery_lastname>string</delivery_lastname>
				<!-- ... "relay_info"-variablen vises kun hvis det er en ordre med afhentning på posthus eller pakkeshop ... -->
				<relay_info>
					<relay_id>int</relay_id>
					<relay_type>string</relay_type>
					<relay_name>string</relay_name>
					<relay_address>string</relay_address>
					<relay_city>string</relay_city>
					<relay_postcode>string</relay_postcode>
					<relay_country_iso>string</relay_country_iso>
				</relay_info>
				<!-- ... Nedenstående "delivery_*"-variabler vises kun hvis det ikke er en ordre med afhentning på posthus eller pakkeshop ... -->
				<delivery_company>string</delivery_companyy>
				<delivery_suburb>string</delivery_suburb>
				<delivery_street_address>string</delivery_street_address>
				<delivery_city>string</delivery_city>
				<delivery_postcode>string</delivery_postcode>
				<delivery_state>string</delivery_state>
				<delivery_country>string</delivery_country>
			</delivery>
			<payment_method>string</payment_method>
			<payment_price>float</payment_price>
			<shipping_price>float</shipping_price>
			<shipping_name>string</shipping_name>
			<order_total>float</order_total>
			<orders_status_name>string</orders_status_name>
			<orders_status_id>int</orders_status_id>
			<date_purchased>[DATE]</date_purchased>
			<last_modified>[DATE]</last_modified>
			<products>
				<product>
					<products_reference>string</products_reference>
					<products_name>string</products_name>
					<products_qty>int</products_qty>
					<products_spartoo>int</products_spartoo>
					<products_manufacturers>string</products_manufacturers>
					<products_size>string</products_size>
					<products_size_reference>string</products_size_reference>
					<products_color>string</products_color>
					<products_price_unit>float</products_price_unit>
					<products_price_unit_with_reduce>float</products_price_unit_with_reduce>
					<products_final_price>float</products_final_price>
				</product>
				<!-- ... Flere muligheder for "product"-kode ... -->
			</products>
			<errors>
				<error>
					<id>int</id>
					<description>string</description>
				</error>
			</errors>
		</order>
		<!-- ... Flere muligheder for "order"-kode ... -->
	</orders>
	<statut>
		<id>int</id>
		<description>string</description>
	</statut>
</root>

Dynamiske variabler

Ved levering til posthus eller pakkeshop tilføjes en relay_info-variabel og delivery_*-variablerne udelades med undtagelse af fornavn og efternavn.
Hvis det ikke er med levering til posthus eller pakkeshop udelades relay_info-variablen og erstattes af delivery_*-variablerne.

Liste over fejlkoder hos webservices

Kode (kategori, materiale)	Beskrivelse
1	Ingen fejlparametrer
-1	Parameteren partenaire er ikke blevet registreret eller er tom
-2	Forhandlerens parametre eksisterer ikke
-3	Der mangler en obligatorisk parameter (date eller oID/rID )
-4	Datoformatet er ugyldigt
-428	Din konto er deaktiveret. Du kan ikke længere benytte webservices
-429	Du har overskredet brugen af denne webservice inden for den seneste time

Beskrivelse af svarfelterne i XML

Variabel	Beskrivelse
orders_id	Ordre-ID
customers	Kundeoplysninger til fakturering
delivery	Kundeoplysninger til levering
customers_firstname / delivery_firstname	Fornavn
customers_lastname / delivery_lastname	Efternavn
customers_company / delivery_company	Firmanavn
customers_street_address / delivery_street_address	Kundens adresse
customers_suburb / delivery_suburb	Eventuel ekstra adresseinformation
customers_city / delivery_city	By
customers_postcode / delivery_postcode	Postnummer
customers_country / delivery_country	Land
customers_telephone	Kundens telefonnummer
relay_info	Information om udleveringssted
relay_id	Identifikation af udleveringssted
relay_type	Udleveringssted - type
relay_name	Udleveringssted - navn
relay_address	Adresse på udleveringssted
relay_city	Udleveringssted - bynavn
relay_postcode	Udleveringssted - postnummer
relay_country	Udleveringssted - land
payment_method	betalingsmetode
payment_price	Gebyr for betaling ( for nuværende, altid 0 )
order_total	Totalbeløb for bestillingen
orders_status_name	Navn på bestillingens nuværende status
orders_status_id	Bestillingens nuværende ID-status
date_purchased	Bestillingsdato
last_modified	Dato for sidste ændring af bestillingen
products	Produktliste
products_reference	Forhandlerens produktid
products_spartoo	Spartoos produktid
products_name	Modelnavn
products_qty	Antal
products_manufacturers	Mærke
products_size	Størrelse
products_color	Farve
products_price_unit	Stykpris ekskl. rabat
products_price_unit_with_reduce	Stykpris inkl. rabat
products_final_price	Totalpris inkl. rabat

Eksempel på retur-XML

Prøvesvar på et opkald til webservicen KO :

<root>
	<orders>
		<order>
			<orders_id>90D813EA1A2365A8</orders_id>
			<customers>	</customers>
			<delivery>
				<delivery_firstname><![CDATA[Robert]]></delivery_firstname>
				<delivery_lastname><![CDATA[Durand]]></delivery_lastname>
				<relay_info>
					<relay_id>1505</relay_id>
					<relay_type><![CDATA[kiala]]></relay_type>
					<relay_name><![CDATA[(NP)LE PAPYRUS]]></relay_name>
					<relay_address><![CDATA[Boulevard Gambetta]]></relay_address>
					<relay_city><![CDATA[Grenoble]]></relay_city>
					<relay_postcode><![CDATA[38000]]></relay_postcode>
					<relay_country_iso><![CDATA[FR]]></relay_country_iso>
				</relay_info>
				<delivery_company><![CDATA[Spartoo]]></delivery_company>
				<delivery_suburb><![CDATA[16 rue Henri Barbusse]]></delivery_suburb>
				<delivery_street_address><![CDATA[16 rue Henri Barbusse]]></delivery_street_address>
				<delivery_city><![CDATA[Grenoble]]></delivery_city>
				<delivery_postcode><![CDATA[38100]]></delivery_postcode>
				<delivery_state></delivery_state>
				<delivery_country><![CDATA[France]]></delivery_country>
			</delivery>
			<payment_method><![CDATA[Paiement par carte bancaire]]></payment_method>
			<payment_price>0</payment_price>
			<order_total>120.0000</order_total>
			<orders_status_name><![CDATA[Commande Vérifiée]]></orders_status_name>
			<orders_status_id>11</orders_status_id>
			<date_purchased>2013-02-12 14:00:00</date_purchased>
			<last_modified>2013-02-12 14:00:00</last_modified>
			<products>
				<product>
					<products_reference><![CDATA[ABCD]]></products_reference>
					<products_name><![CDATA[ALL STAR HI]]></products_name>
					<products_qty>2</products_qty>
					<products_spartoo>123456</products_spartoo>
					<products_manufacturers><![CDATA[Converse]]></products_manufacturers>
					<products_size>42</products_size>
					<products_size_reference><![CDATA[AAAAAA]]></products_size_reference>
					<products_color><![CDATA[Blanc]]></products_color>
					<products_price_unit>60.00</products_price_unit>
					<products_price_unit_with_reduce>200.00</products_price_unit_with_reduce>
					<products_final_price>120.00</products_final_price>
				</product>
			</products>
			<errors>
				<error>
					<id>-1</id>
					<description>Le paramètre partenaire n'est passé ou est vide</description>
				</error>
			</errors>
		</order>
	</orders>
	<statut>
		<id>41</id>
		<description>Annulation commande</description>
	</statut>
</root>

Prøvesvar på et opkald til webservicen OK :

<root>
	<orders>
		<order>
			<orders_id>90D813EA1A2365A8</orders_id>
			<customers>
				<customers_firstname><![CDATA[Robert]]></customers_firstname>
				<customers_lastname><![CDATA[Durand]]></customers_lastname>
				<customers_company><![CDATA[Spartoo]]></customers_company>
				<customers_street_address><![CDATA[16 rue Henri Barbusse]]></customers_street_address>
				<customers_suburb><![CDATA[2eme Etage]]></customers_suburb>
				<customers_city><![CDATA[Grenoble]]></customers_city>
				<customers_postcode><![CDATA[38100]]></customers_postcode>
				<customers_state></customers_state>
				<customers_country><![CDATA[France]]></customers_country>
				<customers_telephone><![CDATA[0612345678]]></customers_telephone>
			</customers>
			<delivery>
				<delivery_firstname><![CDATA[Robert]]></delivery_firstname>
				<delivery_lastname><![CDATA[Durand]]></delivery_lastname>
				<relay_info>
					<relay_id>1505</relay_id>
					<relay_type><![CDATA[kiala]]></relay_type>
					<relay_name><![CDATA[(NP)LE PAPYRUS]]></relay_name>
					<relay_address><![CDATA[Boulevard Gambetta]]></relay_address>
					<relay_city><![CDATA[Grenoble]]></relay_city>
					<relay_postcode><![CDATA[38000]]></relay_postcode>
					<relay_country_iso><![CDATA[FR]]></relay_country_iso>
				</relay_info>
				<delivery_company><![CDATA[Spartoo]]></delivery_company>
				<delivery_suburb><![CDATA[16 rue Henri Barbusse]]></delivery_suburb>
				<delivery_street_address><![CDATA[16 rue Henri Barbusse]]> </delivery_street_address>
				<delivery_city><![CDATA[Grenoble]]></delivery_city>
				<delivery_postcode><![CDATA[38100]]></delivery_postcode>
				<delivery_state></delivery_state>
				<delivery_country><![CDATA[France]]></delivery_country>
			</delivery>
			<payment_method><![CDATA[Paiement par carte bancaire]]></payment_method>
			<payment_price>0</payment_price>
			<order_total>120.0000</order_total>
			<orders_status_name><![CDATA[Commande Vérifiée]]></orders_status_name>
			<orders_status_id>11<orders_status_id>
			<date_purchased>2013-02-12 14:00:00</date_purchased>
			<last_modified>2013-02-12 14:00:00</last_modified>
			<products>
				<product>
					<products_reference>ABCD</products_reference>
					<products_name><![CDATA[ALL STAR HI]]></products_name>
					<products_qty>2</products_qty>
					<products_spartoo>123456</products_spartoo>
					<products_manufacturers><![CDATA[Converse]]></products_manufacturers>
					<products_size>42></products_size>
					<products_size_reference><![CDATA[AAAAAA]]></products_size_reference>
					<products_color><![CDATA[Blanc]]></products_color>
					<products_price_unit>60.00</products_price_unit>
					<products_price_unit_with_reduce>200.00</products_price_unit_with_reduce>
					<products_final_price>120.00</products_final_price>
				</product>
			</products>
			<errors>
				<error>
					<id>1</id>
					<description>Pas d'erreur de paramètres</description>
				</error>
			</errors>
		</order>
	</orders>
	<statut>
		<id>11</id>
		<description>Commande vérifiée</description>
	</statut>
</root>