ShopwareGetCustomers - Shopware

Version: 6.5.x

← Shopware Add-On Übersicht

Kunden aus einem Shopware-System abrufen.

Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

Name

Datentyp

Beschreibung

Pflichtfeld

Werte

account

ACCOUNT

Ihr Konto

limit

STRING

Die Anzahl der abgerufenen Kunden begrenzen. Leer lassen für unbegrenzt.

Nein

active

STRING

Filtern Sie aktive oder inaktive Kunden.

Nein

Alle
Ja
Nein

additionalFields

STRINGLIST

Zusätzliche Felder von Kunden abrufen

Nein

Standard-Rechnungsadresse
Standard-Lieferadresse
Standard-Zahlungsart

createdFrom

DATETIME

Verwenden Sie dieses Datum, um Kunden zu filtern, die später erstellt wurden, z.B. 2014-02-27 00:00.

Nein

createdTo

DATETIME

Nutzen Sie dieses Datum, um Kunden zu filtern, die früher erstellt wurden, z.B. 2014-02-28 00:00.

Nein

customerId

STRING

Kunden-ID Filter

Nein

customerIdSpreadsheet

SPREADSHEET

Spreadsheet mit Kunden-IDs.

Nein

mappingdefinition

STRING

Die Mapping-Definition JSON-String

Nein

Folgende Felder sind zu konfigurieren:

Feld	Datentyp	Beschreibung	Pflichtfeld	Standardwert
CustomerId	SINGLE		Nein

customerNumber

STRING

Kundenauftragsnummer Filter

Nein

salesChannelId

STRING

Vertriebskanal-ID Filter

Nein

updatedFrom

DATETIME

Nutzen Sie dieses Datum, um Kunden zu filtern, die später aktualisiert wurden, 2014-02-27 00:00

Nein

updatedTo

DATETIME

Verwenden Sie dieses Datum, um Kunden zu filtern, die vorher aktualisiert wurden, z.B. 2014-02-28 00:00

Nein

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

Name

Datentyp

Beschreibung

Werte

result

SPREADSHEET

Das Ergebnis-Spreadsheet, das die Kundendaten enthält.

Folgende Felder sind im Output enthalten:

Feld	Datentyp	Beschreibung
identifier	SINGLE	The identifier column to import Spreadsheet into a Datastore.
Id	SINGLE	Unique identity of the customer.
CustomerNumber	SINGLE	Unique number assigned to identify a customer.
FirstName	SINGLE	First name of the customer.
LastName	SINGLE	Last name of the customer.
Email	SINGLE	Email ID of the customer.
SalutationId	SINGLE	Unique identity of salutation.
Title	SINGLE	Titles or honorifics like Mr, Mrs, etc.
Active	SINGLE	To keep the status of the customer active, the boolean value is set to true.
AffiliateCode	SINGLE	An affiliate code is an identification option with which website operators can mark outgoing links.
Birthday	SINGLE	To capture customer's birthday details.
CampaignCode	SINGLE	A campaign code is the globally unique identifier for a campaign.
Company	SINGLE	Company name of the customer.
DefaultPaymentMethodId	SINGLE	Unique identity of previous payment method.
DefaultPaymentMethodPluginId	SINGLE
DefaultPaymentMethodName	SINGLE
DefaultPaymentMethodDescription	SINGLE
DefaultPaymentMethodPosition	SINGLE
DefaultPaymentMethodActive	SINGLE
DefaultPaymentMethodAfterOrderEnabled	SINGLE
DefaultPaymentMethodPlugin	SINGLE
DefaultPaymentMethodSalesChannelDefaultAssignments	SINGLE
DefaultPaymentMethodAvailabilityRule	SINGLE
DefaultPaymentMethodAvailabilityRuleId	SINGLE
DefaultPaymentMethodVersionId	SINGLE
DefaultBillingAddressId	SINGLE	Unique identity of default billing address.
DefaultBillingAddressCountryId	SINGLE	Unique identity of country.
DefaultBillingAddressCountryStateId	SINGLE	Unique identity of state.
DefaultBillingAddressSalutationId	SINGLE	Unique identity of salutation.
DefaultBillingAddressFirstName	SINGLE	First name of the customer.
DefaultBillingAddressLastName	SINGLE	Last name of the customer.
DefaultBillingAddressStreet	SINGLE	Street address.
DefaultBillingAddressZipcode	SINGLE	Zip code of the country.
DefaultBillingAddressCity	SINGLE	Name of the city.
DefaultBillingAddressCompany	SINGLE	Name of the company.
DefaultBillingAddressDepartment	SINGLE	Name of the department.
DefaultBillingAddressTitle	SINGLE	Title name given to customer like DR., Prof., etc.
DefaultBillingAddressVatId	SINGLE	Unique identity of VAT.
DefaultBillingAddressPhoneNumber	SINGLE	Phone number of the customer.
DefaultBillingAddressAdditionalAddressLine1	SINGLE	Additional address input if necessary.
DefaultBillingAddressAdditionalAddressLine2	SINGLE	Additional address input if necessary.
DefaultBillingAddressCreatedAt	SINGLE	Created at timestamp.
DefaultBillingAddressUpdatedAt	SINGLE	Last updated timestamp.
DefaultShippingAddressId	SINGLE	Unique identity of default shipping address.
DefaultShippingAddressCountryId	SINGLE	Unique identity of country.
DefaultShippingAddressCountryStateId	SINGLE	Unique identity of state.
DefaultShippingAddressSalutationId	SINGLE	Unique identity of salutation.
DefaultShippingAddressFirstName	SINGLE	First name of the customer.
DefaultShippingAddressLastName	SINGLE	Last name of the customer.
DefaultShippingAddressStreet	SINGLE	Street address.
DefaultShippingAddressZipcode	SINGLE	Zip code of the country.
DefaultShippingAddressCity	SINGLE	Name of the city.
DefaultShippingAddressCompany	SINGLE	Name of the company.
DefaultShippingAddressDepartment	SINGLE	Name of the department.
DefaultShippingAddressTitle	SINGLE	Title name given to customer like DR., Prof., etc.
DefaultShippingAddressVatId	SINGLE	Unique identity of VAT.
DefaultShippingAddressPhoneNumber	SINGLE	Phone number of the customer.
DefaultShippingAddressAdditionalAddressLine1	SINGLE	Additional address input if necessary.
DefaultShippingAddressAdditionalAddressLine2	SINGLE	Additional address input if necessary.
DefaultShippingAddressCreatedAt	SINGLE	Created at timestamp.
DefaultShippingAddressUpdatedAt	SINGLE	Last updated timestamp.
DoubleOptInConfirmDate	SINGLE	Date and time when the double opt-in email was confirmed.
DoubleOptInEmailSentDate	SINGLE	Date and time when the double opt-in email was sent.
DoubleOptInRegistration	SINGLE	Set to true to allow user subscriptions to an email marketing list.
GroupId	SINGLE	Unique identity of customer group.
Guest	SINGLE	Boolean value is true if it is to be a guest account.
Hash	SINGLE	Password hash for customer recovery.
LanguageId	SINGLE	Unique identity of language.
FirstLogin	SINGLE	To capture date and time of customer's first login.
LastLogin	SINGLE	To capture date and time of customer's last login.
LastOrderDate	SINGLE	Captures last order date.
LastPaymentMethodId	SINGLE	Unique identity of previous payment method.
SalesChannelId	SINGLE	Unique identity of sales channel.
UpdatedAt	SINGLE	Last updated timestamp.
CreatedAt	SINGLE	Creation timestamp.