pixi
Ask AI
What's an 'Ideas Portal'?
DE

Enhanced Shipping Vendor Polling

What is the enhanced Shipping Vendor Polling?

The enhanced shipping vendor polling enables you to connect shipping vendors that use the polling method but were not supported up until now to pixi*.

Furthermore, using this functionality the polling for rated 18+ or hazardous items can be modified and customized queries such as "Split the cash on delivery fee to the number of packages." or "If the weight exceeds X, then use another package type." can be created.

This is then saved as a seperate template for each shipping vendor which is then used to create the polling file after an invoice Ship-Out in pixi* was done. The compatible polling file can then be processed by the appropriate shipping vendor software.


Example Polling Files

Using the enhanced shipping vendor polling, different file types can be created. Depending on the shipping vendors requirements, a proper polling file is created.


CSV / TXT Files

POOL_REFNR§POOL_V_ABS_REFNR§POOL_V_MAND_REFNR§DHL_verfahren§POOL_V_TEILNAHME§POOL_V_PRODUKT_CN§POOL_V_EXTRA§§
POOL_EMPF_NAME1§POOL_EMPF_NAME2§POOL_EMPF_PLZ§POOL_EMPF_ORT§POOL_EMPF_STRASSE§POOL_EMPF_HAUSNR§POOL_GEWICHT§
POOL_ANZAHL_SENDUNGEN§POOL_EMPF_LANDCODE§§POOL_V_ZOLL_WARENLISTE§§§OrderAddressRemarks§POOL_EMPF_TEL§§§ShipEMail
||||POOL_EMPF_NAME1|POOL_EMPF_HAUSNR+POOL_EMPF_STRASSE|ShipCareOf|OrderAddressRemarks|POOL_EMPF_ORT||POOL_EMPF_PLZ|
ShipPhone|ShipEMail|PollingDate.ToString("d")|1|POOL_GEWICHT|POOL_ANZAHL_SENDUNGEN|POOL_EMPF_NAME1||POOL_REFNR|
DHLAbsenderRef||Carton|UK_MAIL_ACOUNT|N|0|Y|P

Back to top

How can I use the enhanced Shipping Vendor Polling?

Only pixi* employees can activate and configure the enhanced shipping vendor polling since changes need to be made to the Shipping Vendors table in pixi* Control Center which customers cannot do.

Please contact your account manager in case you are interested in this functionality.

Back to top

Important pixi Control Center Settings

Only pixi* employees can configure the enhanced shipping vendor polling in pixi* Control Center > table Shipping Vendors. The following settings need to be configured:

  • Use polling template: This option activates the possibility to use the enhanced shipping vendor polling.

  • Polling Template: The source code that is needed to create the polling file needs to be put to this field. Maximum 2.147.483.647 characters are allowed. Check the documentation below (Main procedure, Detail procedure 1) to get to know which variables can be used.

  • Polling file extension: The file extension of the polling file needs to be entered in this field - e.g. ".csv", ".xml", ".txt" oder ".dat".

  • Export folder: Tell us the folder to which the polling file should be saved after it was created. This path can contain maximum 128 characters and needs to end with an "\".
    WARNING: In case you set up a new shipping computer, make sure to use the same file path! Alternatively, you can also ask the pixi* Support to change the folder for you.

  • Main procedure: Enter the main procedure which is needed for the polling file. This procedure is responsible to gather general package information, such as shipping address, amount and weight. By default "Pixi_PollHeader" is used.

  • Detail procedure 1: Some shipping vendors such as V-Log need further item information next to the general package information. These information can be connected to the template using the detail procedure 1. By default "Pixi_PollDetail1" is used.

  • Detail procedure 2: In several cases additional item information are needed at customs. These information can be connected to the template using a seperate procedure. By default - if needed - "Pixi_PollDetail2" is used.

  • Only invoice nr. in file name: If this setting is activated, the invoice number will be used as name for the polling file.

Back to top

Main Procedure Variables

These variables can be used in the polling template. Only the most important ones are listet here.

  • POOL_REFNR: Invoice number

  • POOL_V_ABS_REFNR: Sender reference (default "01")

    • If the database setting "Take SenderRef from Shops" is enabled, the sender reference is taken from the "Easy Log Absender Ref" field in Shops table. In case there is a value in "DHL ABS_REFNR" field in Countries table, this value is used.

  • POOL_V_MAND_REFNR: Client reference (default "01")

  • POOL_V_TEILNAHME: Contains "Teilnahme" of the order and is set depending on several database settings:

    • DHLLocalTeilnahme

    • DHLForeignTeilnahme

    • DHLExpressTeilnahme

    • DHLCODTeilnahme

    • Take Teilnahme from Shops ("Easy Log Absender Ref" is used as Teilnahme)

    • DHL Teilnahme in Countries table

    • DHLRegioATTeilnahme

  • POOL_V_PRODUKT_CN: Contains the value from "Product" field of the order.

  • POOL_V_EXTRA: Contains the value from "Tools" field of the order.

  • POOL_EMPF_REFNR: Recepient reference number

  • POOL_EMPF_NAME1: Contains the first and last name of the shipping address.

  • POOL_EMPF_NAME2: Contains the value from "Company" field of the shipping address.

  • POOL_EMPF_PLZ: Contains the value from "ZIP" field of the shipping address.

  • POOL_EMPF_ORT: Contains the value from "City" field of the shipping address.

  • POOL_EMPF_STRASSE: Contains the value from "Street" field of the shipping address.

  • POOL_EMPF_HAUSNR: Contains the value from "Nr." field of the shipping address.

  • POOL_EMPF_TEL: Contains the value from "Phone" field of the shipping address.

  • POOL_EMPF_FAX: Contains the value from "Fax" field of the shipping address.

  • OrderAddressRemarks: Contains the value from "Address remarks" field of the shipping address.

  • POOL_EMPF_LANDCODE: Contains the value from "DHL Name" field in Countries table.

    • If no value is entered in this field, "Country Name" is used.Tabelle genutzt.

  • POOL_GEWICHT: Package weight

  • POOL_ANZAHL_SENDUNGEN: Number of packages

  • POOL_V_ZOLL_WARENLISTE: Contains several values which are seperated by a semicolon ";".

    • value of the database setting "DHL Zoll Warenliste"

    • value from "DHL Name" field in Countries table; if empty then "Country Name" is used

    • value of the database setting "DHL ZOLL WARENLISTE Zollnummer"

    • package weight

    • invoice amount

  • ShipEMail: Contains the value from "E-Mail" field of the shipping address.

  • DHL_verfahren: Contains the value from "Method" field of the shipping address.

Back to top

Detail Procedure 1 Variables

These variables can be used in the polling template. Only the most important ones are listet here.

  • ItemNrInt: items Shop Item Number

  • ItemPrice: items single gross selling price

  • ItemQty: items ordered quantity

  • ItemText: item name from pixi* Customer Service

  • ItemWeightInKG: items weight in kg

  • ItemPrice_Net: items single net selling price

  • oItemSpecialNote: item note

Back to top