Processing of personal data according to the GDPR in JTL-Wawi

Introduction

On this page you can find important information on the processing of personal data for users of JTL-Wawi. It addresses a lot of questions that often come up within the scope of the General Data Protection Regulation (GDPR).

Please note that this page only provides you with information. This is not legally binding advice. For legally binding statements on the topic of the EU’s GDPR, please consult a legal counsel.

Go to the GDPR page of JTL-Shop

Processes and data storage in the software

What are the processes and functions via which personal data is processed in the application and where is it stored in the database?

Customers

Function/category

Database table and fields

Reason for processing in the application

Storage duration, possibilities for processing and deleting, and notes

Customer data via interfaces/manual entry

  • JTL-Shop
  • JTL-Connector (Third-party shops)
  • Connection to Amazon
  • Connection to eBay
  • Manual entry
  • CSV import with JTL-DataTransfer (customer data and/or sales orders)

tcustomer

  • cCustomer ID
  • cFormOfAdress
  • cTitle
  • cFirstName
  • cSurname
  • cCompany
  • cCompany 2
  • cStreet
  • cHouseNumber
  • cAddress 2
  • cPostalCode
  • cCity
  • cState
  • cPhone
  • cMobile
  • cFax
  • cEmail
  • cVAT
  • cWWW
  • cBirthday

Reason for processing in the application

  • Set as billing address for new sales orders by default
  • Communication with customer about order status
  • Order fulfilment

Until deleted in JTL-Wawi

Sales order fulfilment (sales quotation, sales order, A/R invoice, invoice correction)

  • JTL-Shop
  • JTL-Connector (Third-party shops)
  • Connection to Amazon
  • Connection to eBay
  • Sales orders in JTL-Wawi
  • tcustomer with the fields mentioned above
  • tbillingaddress, including all fields
  • tshippingaddress, including all fields
  • taddress, including all fields
  • A/R invoice address and delivery address are needed for order fulfilment
  • Emails with the current order status are sent to the email address saved as the billing address.
  • If applicable Needed for possible questions about the order / delivery by e-mail or telephone (if a telephone number is requested)
  • Needed for exact receipts in the ERP system (Bill)

Until deleted in JTL-Wawi

Import of sales orders

  • JTL-Shop
  • JTL-Connector (Third-party shops)

tInetAddress, including all fields

Temporary cache for synchronisation

Deleted after every synchronisation; only acts as cache

Import of sales orders

  • Connection to eBay

eBay_buyer

  • CityName
  • Country
  • CountryName
  • Name
  • PostalCode
  • Street
  • Street1
  • Street2
  • Phone
  • SA_CityName
  • SA_Country
  • SA_CountryName
  • SA_ExternalAddressID
  • SA_Name
  • SA_PostalCode
  • SA_StateOrProvince
  • SA_Street
  • SA_Street1
  • SA_Street2
  • SA_Phone
  • Email

Contains all information on buyers, which is needed for creating sales order and A/R invoice

Until deleted manually in the database

Import of sales orders

  • Connection to eBay

eBay_Checkout

  • cPaymentReference
  • cShippingTitle
  • cShippingFirstName
  • cShippingSurname
  • cShippingName 2
  • cShippingStreet
  • cShippingAdress 2
  • cShippingPostalcode
  • cShippingCity
  • cShippingCity 2
  • cShippingCountry
  • cShippingPhone
  • cShippingFax
  • cShippingMobile
  • cPaymentMethod
  • cPaymentBankName
  • cPaymentBankCode
  • cPaymentAccountNo.
  • cPaymentCardNo.
  • cPaymentValidity
  • cPaymentCVV
  • cPaymentCardType
  • cPaymentOwner
  • cPhone
  • cFax
  • cMobile
  • cEmail
  • cCompany
  • cShippingCompany
  • cVAT
  • cAddress 2
  • cFormOfAdress
  • cFirstName
  • cSurname
  • cPostalCode
  • cCity
  • cCountry
  • cStreet

Contains all information on the purchase process, which are needed for creating the sales order and A/R invoice

Until deleted manually in the database

Import of sales orders

  • Connection to Amazon

pf_amazon_order

  • cBuyerName
  • cBuyerEmail
  • cBuyerPhoneNumber
  • cBillAddress1
  • cBillAddress2
  • cBillAddress3
  • cBillCity
  • cBillState
  • cBillPostalCode
  • cBillCountry
  • cRecipientName
  • cShipAddress1
  • cShipAddress2
  • cShipAddress3
  • cShipCity
  • cShipState
  • cShipPostalCode
  • cShipCountry
  • cShipPhoneNumber

Contains all information on buyers, which is needed for creating sales order and A/R invoice

Until deleted manually in the database

Dropshipping by external suppliers

tPurchaseOrderSupplierLA, tPurchaseOrderSupplierRA

  • cCompany
  • cCompany 2
  • cFormOfAdress
  • cTitle
  • cFirstName
  • cSurname
  • cStreet
  • cStreet
  • cAddress 2
  • cAddress 2
  • cPostalCode
  • cCity
  • cState
  • cCountryISO
  • cPhone
  • cFax
  • cMobile
  • cEmail
  • Information is sent to the supplier so that they can trigger the shipment to the customer
  • This does not usually occur in practice, but it is possible to enter a customer’s address as the billing address.

Until deleted in JTL-Wawi

Fulfilment by an external logistics provider

tFulfillmentOrder

  • cShippingAddressCompany
  • cShippingAddressFormOfAdress
  • cShippingAddressTitle
  • cShippingAddressFirstName
  • cShippingAddressSurname
  • cShippingAddressStreet
  • cShippingAddressPostalCode
  • cShippingAddressCity
  • cShippingAddressCountry
  • cShippingAddressPhone
  • cShippingAddressFax
  • cShippingAddressEmail
  • cShippingAddress 2
  • cShippingAddressState

Information is sent to a logistics provider so that they can trigger the shipment to the customer

Until deleted in JTL-Wawi

Log for eBay

ebay_log

  • Name of eBay account

Information on synchronised data (no content) such as:

  • “Query about “Kiwi” (253540198515) by account 4711”
  • “Quotation for “253540198515” by account 4711”

Until automated deletion via JTL-Wawi; you can find the settings under JTL-Wawi > Menu Admin > Globale Einstellungen > Tab Debug > Logbücher automatisch löschen ( JTL-Wawi > Menu Admin > Global settings > Tab Debugger/Logs > Delete log files automatically (Minimum: 1 month).

Customer data via interfaces/manual entry

  • JTL-Shop
  • JTL-Connector (Third-party shops)
  • Connection to Amazon
  • Connection to eBay
  • Manual entry
  • CSV import with JTL-DataTransfer (customer data and/or sales orders)

tcustomer

  • cCustomer ID
  • cFormOfAdress
  • cTitle
  • cFirstName
  • cSurname
  • cCompany
  • cCompany 2
  • cStreet
  • cHouseNumber
  • cAddress 2
  • cPostalCode
  • cCity
  • cState
  • cPhone
  • cMobile
  • cFax
  • cEmail
  • cVAT
  • cWWW
  • cBirthday

Reason for processing in the application

  • Set as billing address for new sales orders by default
  • Communication with customer about order status
  • Order fulfilment

Until deleted in JTL-Wawi

Suppliers

Creating suppliers/fulfilment service providers

tSupplier

For purchase orders and the posting of A/P invoices

Until deleted in JTL-Wawi

Purchasing goods

tA/PInvoice

  • cSupplier
  • cAddress 2
  • cStreet
  • cPostalCode
  • cCity
  • cCountryISO
  • cState
  • cPhone
  • cFax
  • cMobile
  • cEmail

For offsetting A/P invoices for accounting

Until deleted in JTL-Wawi

User/Employee name

Employee receives user account

tuser

  • cName
  • cEmail
  • cDepartment
  • cFax
  • cMobile

Needed to record and assign user rights

Until deleted in JTL-Wawi

How should I treat questions on the storage of personal data?

We have compiled more information on this topic here:

How do I delete a customer’s personal data when they ask me to?

We have compiled more information on this topic here:

How do I secure the connection of the database to the client of JTL-Wawi with SSL?

We have compiled more information on this topic here: