{"id":370,"date":"2024-09-06T07:57:54","date_gmt":"2024-09-06T07:57:54","guid":{"rendered":"https:\/\/help.webstock.nl\/?post_type=docs&p=370"},"modified":"2024-09-06T07:57:54","modified_gmt":"2024-09-06T07:57:54","password":"","slug":"12-4-inkooporders-importeren","status":"publish","type":"docs","link":"https:\/\/help.webstock.nl\/?docs=12-4-inkooporders-importeren","title":{"rendered":"12.4 Inkooporders Importeren\u00a0"},"content":{"rendered":"\n

Inkooporders kunnen automatisch ge\u00efmporteerd worden in WebStock op basis van een taakplanner. Deze taakplanner kijkt eens in het ingesteld aantal minuten in een directory op de server of er nieuwe te importeren bestanden staan. Ook is het mogelijk om een FTP locatie in te stellen waar WebStock de bestanden ophaalt. In WebStock doet u alle instellingen voor de import definitie.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

1. Ga naar instellingen -> programma instellingen
2. klik op de tab “inkooporders \u201d\u00a0
3. Open Import<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Definitie van de te importeren velden voor inkooporders:<\/span><\/p>

<\/col><\/col><\/col><\/col><\/col><\/col><\/col><\/colgroup>

beschikbare kolomen<\/span><\/p><\/th>

data type<\/span><\/p><\/th>

length<\/span><\/p><\/th>

verplicht<\/span><\/p><\/th>

default<\/span><\/p><\/th>

Korte uitleg<\/span><\/p><\/th><\/tr><\/thead>

po_number<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

Ja<\/span><\/p><\/td>

<\/td>

inkoopordernummer<\/span><\/p><\/td><\/tr>

po_description<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

100<\/span><\/p><\/td>

<\/td><\/td>

inkooporder omschrijving<\/span><\/p><\/td><\/tr>

po_deliver_date<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_supplierreference<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

100<\/span><\/p><\/td>

<\/td><\/td>

inkooporder referentie leverancier<\/span><\/p><\/td><\/tr>

po_handling_date<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

<\/td><\/td>

huidige datum<\/span><\/p><\/td>

inkooporder datum af te handelen<\/span><\/p><\/td><\/tr>

po_shipping_details<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

inkooporder transport details<\/span><\/p><\/td><\/tr>

po_deliveryaddress<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_status<\/span><\/p><\/td>

int<\/span><\/p><\/td>

<\/td><\/td>

10<\/span><\/p><\/td>

inkooporder orderstatus<\/span><\/p><\/td><\/tr>

po_project<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

<\/td><\/td><\/td>

inkooporder project<\/span><\/p><\/td><\/tr>

po_suppliernumber<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

Ja<\/span><\/p><\/td>

<\/td>

leveranciersnummer<\/span><\/p><\/td><\/tr>

po_suppliercompany<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier bedrijf<\/span><\/p><\/td><\/tr>

po_suppliercontact<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier contact<\/span><\/p><\/td><\/tr>

po_supplieraddress<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier adres\u00a0<\/span><\/p><\/td><\/tr>

po_supplieraddresshousenumber<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier adres huisnummer\u00a0<\/span><\/p><\/td><\/tr>

po_supplieraddresshousenumberaddition<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier adres huisnummer toevoeging<\/span><\/p><\/td><\/tr>

po_supplierzipcode<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

10<\/span><\/p><\/td>

<\/td><\/td>

leverancier postcode<\/span><\/p><\/td><\/tr>

po_suppliercity<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

leverancier stad<\/span><\/p><\/td><\/tr>

po_suppliercountry<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

20<\/span><\/p><\/td>

<\/td><\/td>

leverancier land<\/span><\/p><\/td><\/tr>

po_supplieremail<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

100<\/span><\/p><\/td>

<\/td><\/td>

leverancier email<\/span><\/p><\/td><\/tr>

po_supplierdescription<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

100<\/span><\/p><\/td>

<\/td><\/td>

leverancier omschrijving<\/span><\/p><\/td><\/tr>

po_suppliertelephone<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_suppliername<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_extern_id<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_extern_guid<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_warehouse<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

po_order_date<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_quantity<\/span><\/p><\/td>

double<\/span><\/p><\/td>

<\/td>

Ja<\/span><\/p><\/td>

<\/td>

inkooporderregel hoeveelheid<\/span><\/p><\/td><\/tr>

pol_extern_id<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_extern_guid<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_salesordernumber<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_extern_salesorderparent_id<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_articlenumber<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

Ja<\/span><\/p><\/td>

–<\/span><\/p><\/td>

inkooporderregel artikelnummer<\/span><\/p><\/td><\/tr>

pol_articlenumbersupplier<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_articlebarcode<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

20<\/span><\/p><\/td>

<\/td><\/td>

inkooporderregel barcode<\/span><\/p><\/td><\/tr>

pol_article_requiresserialnumber<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_article_requireslot<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_article_price<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_eancode<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_lot<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td><\/td>

inkooporderregel partij<\/span><\/p><\/td><\/tr>

pol_lotdescription<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_lot_expiry_date<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_description<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td>

–<\/span><\/p><\/td><\/tr>

pol_productname<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

<\/td>

artikelnummer<\/span><\/p><\/td>

inkooporderregel product<\/span><\/p><\/td><\/tr>

pol_producttypename<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

50<\/span><\/p><\/td>

Ja<\/span><\/p><\/td>

IMPORT<\/span><\/p><\/td>

inkooporderregel producttype<\/span><\/p><\/td><\/tr>

pol_productdescription<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

100<\/span><\/p><\/td>

<\/td><\/td>

inkooporderregel product omschrijving<\/span><\/p><\/td><\/tr>

pol_packaging_quantity<\/span><\/p><\/td>

int<\/span><\/p><\/td>

<\/td><\/td>

1<\/span><\/p><\/td>

inkooporderregel product aantal in verpakking<\/span><\/p><\/td><\/tr>

pol_unit<\/span><\/p><\/td>

vchar<\/span><\/p><\/td>

10<\/span><\/p><\/td>

<\/td>

stuks<\/span><\/p><\/td>

inkooporderregel product verpakking eenheid<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Inkooporders kunnen automatisch ge\u00efmporteerd worden in WebStock op basis van een taakplanner. Deze taakplanner kijkt eens in het ingesteld aantal minuten in een directory op de server of er nieuwe te importeren bestanden staan. Ook is het mogelijk om een FTP locatie in te stellen waar WebStock de bestanden ophaalt. In WebStock doet u alle […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[18],"doc_tag":[],"class_list":["post-370","docs","type-docs","status-publish","hentry","doc_category-12-import-en-export"],"year_month":"2026-05","word_count":215,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Webdesign","author_nicename":"webdesign","author_url":"https:\/\/help.webstock.nl\/?author=2"},"doc_category_info":[{"term_name":"12. Import en Export","term_url":"https:\/\/help.webstock.nl\/?doc_category=12-import-en-export"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/docs\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=370"}],"version-history":[{"count":1,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/docs\/370\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=\/wp\/v2\/docs\/370\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/help.webstock.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_category&post=370"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.webstock.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}