Skip to content

CSV export

The CSV Export feature in Globe Pickup Points allows you to create custom CSV templates for exporting orders, including pickup point data. This is especially useful for carriers that support CSV imports, such as DHL or PPL, enabling seamless parcel management and label generation.

Setting up a custom CSV export

Follow these steps to create and use a custom CSV export template:

  1. Navigate to Export in the left-side menu.
  2. Click on Add export to create a new export template.
  3. Define the column names and use Liquid templating to specify the values.
  4. Save your configuration.
  5. Go to the Orders page and select the orders you wish to export.
  6. Under More actions, select Export with Globe.
  7. Choose your custom template, click Export, and follow the link to download your CSV.

Liquid variables and conditions

You can use order and point variables in the export values. All available values are based on the following example.

For instance, you could use {{ order.shippingAddress.name }} for customer’s name.

{
"order": {
"name": "#1234",
"email": "test@example.com",
"shippingAddress": {
"name": "Jan Novak",
"firstName": "Jan",
"lastName": "Novak",
"company": "Example Corp",
"address1": "Jindrisska 16",
"address2": "2nd Floor",
"city": "Prague",
"zip": "110 00",
"provinceCode": "PR",
"country": "Czech Republic",
"countryCodeV2": "CZ",
"phone": "+420 800 123 456",
},
"currentTotalWeight": 2000,
"totalWeight": 2000,
"note": "Please deliver between 10 AM and 2 PM.",
"totalPriceSet": {
"presentmentMoney": {
"amount": "499.00",
"currencyCode": "CZK"
}
},
"totalOutstandingSet": {
"presentmentMoney": {
"amount": "250.00",
"currencyCode": "CZK"
}
}
},
"point": {
"id": "22064",
"name": "Prague, Narodni 40 (Electronic centrum)",
"place": "Electronic Centrum",
"address": "Narodni 40, Prague, 11102",
"addressObject": {
"place": "Electronic Centrum",
"street": "Narodni 40",
"city": "Prague",
"zip": "111 02",
"country": "cz"
},
"latitude": 50.08156,
"longitude": 15.41637,
"openingHours": {
"monday": "08:00–12:00, 13:00–16:00",
"tuesday": "08:00–12:00, 13:00–16:00",
"wednesday": "08:00–12:00",
"thursday": "08:00–12:00, 13:00–16:00",
"friday": "08:00–12:00, 13:00–16:00",
"saturday": "",
"sunday": ""
},
"provider": "packeta"
}
}

Liquid conditions are also supported, you can use for example:

{% if point.id %}{{ point.id }} {% endif %}{{ order.shippingAddress.city}}

Example use case - PPL CZ

Instead of manually creating parcels in the PPL system, you can use a CSV import to automatically add your Shopify orders with pickup point data (or for address delivery) and print labels.

We have added a template to automatically setup a CSV export that is accepted by the PPL system. To add this export, select Load from template on Create new export and select PPL.

Export example