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	Ja
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 Standardwert 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.