Skip to content
Globe Pickup Points - Shopify App

CSV export

You can create a custom CSV template to export your orders including pickup point data to CSV format. This is useful for some carriers that support CSV imports (such as DHL or PPL).

  1. Go to Export in the left-side menu
  2. Click on Add export
  3. Add names for the column and Liquid templating for the values
  4. Save your configuration
  5. Go to Orders and select the orders you wish to export
  6. Under More actions, select Export with Globe
  7. Choose your 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