weclappUpdateSalesOrder - weclapp

← weclapp Add-On Übersicht

This step updates existing sales orders in weclapp via a spreadsheet.

Inputs

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

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	weclapp account	Ja
limit	STRING	Limits the number of rows used from the input SPREADSHEET. Use low values for testing.	Nein
testMode	STRING	Create orders in dryRun mode.	Nein	True False
ordersUpdateSpreadsheet	SPREADSHEET		Ja
mappingdefinition	STRING	The mapping definition JSON String	Ja
	Folgende Felder sind zu konfigurieren : Feld Datentyp Beschreibung Pflichtfeld Standardwert id SINGLE The internal weclass order id. Leave empty as it is filled automatically. Ja commercialLanguage SINGLE Nein creatorId SINGLE Nein description SINGLE Nein disableEmailTemplate SINGLE Nein false recordComment SINGLE Nein recordFreeText SINGLE Nein recordOpening SINGLE Nein sentToRecipient SINGLE Nein tags MULTIPLEVALUE tag1,tag2 Nein currencyConversionDate SINGLE Nein currencyConversionRate SINGLE Nein grossAmount SINGLE Nein grossAmountInCompanyCurrency SINGLE Nein headerDiscount SINGLE Nein headerSurcharge SINGLE Nein netAmount SINGLE Nein netAmountInCompanyCurrency SINGLE Nein nonStandardTaxId SINGLE Nein nonStandardTaxName SINGLE Nein paymentMethodId SINGLE Nein paymentMethodName SINGLE Nein recordCurrencyId SINGLE Nein recordCurrencyName SINGLE Nein termOfPaymentId SINGLE Nein termOfPaymentName SINGLE Nein commission SINGLE Nein commissionSalesPartners_version MULTIPLEVALUE version 1;version2 Nein commissionSalesPartners_commissionFix MULTIPLEVALUE commissionFix1;commissionFix2 Nein commissionSalesPartners_commissionPercentage MULTIPLEVALUE commissionFix1;commissionFix2 Nein commissionSalesPartners_commissionType MULTIPLEVALUE commissionType1;commissionType2 Nein commissionSalesPartners_salesPartnerSupplierId MULTIPLEVALUE salesPartnerSupplierId1;salesPartnerSupplierId2 Nein commissionSalesPartners_salesPartnerSupplierNumber MULTIPLEVALUE salesPartnerSupplierNumber1;salesPartnerSupplierNumber2 Nein customerId SINGLE Ja customerNumber SINGLE Nein dispatchCountryCode SINGLE Nein factoring SINGLE Nein pricingDate SINGLE Nein responsibleUserId SINGLE Nein responsibleUserUsername SINGLE Nein salesChannel SINGLE Nein servicePeriodFrom SINGLE Nein servicePeriodTo SINGLE Nein shipmentMethodId SINGLE Nein shipmentMethodName SINGLE Nein defaultShippingCarrierId SINGLE Nein defaultShippingCarrierName SINGLE Nein deliveryAddress_city SINGLE Nein deliveryAddress_company SINGLE Nein deliveryAddress_company2 SINGLE Nein deliveryAddress_countryCode SINGLE Nein deliveryAddress_firstName SINGLE Nein deliveryAddress_globalLocationNumber SINGLE Nein deliveryAddress_lastName SINGLE Nein deliveryAddress_middleName SINGLE Nein deliveryAddress_phoneNumber SINGLE Nein deliveryAddress_postOfficeBoxCity SINGLE Nein deliveryAddress_postOfficeBoxNumber SINGLE Nein deliveryAddress_postOfficeBoxZipCode SINGLE Nein deliveryAddress_salutation SINGLE Nein deliveryAddress_state SINGLE Nein deliveryAddress_street1 SINGLE Nein deliveryAddress_street2 SINGLE Nein deliveryAddress_title SINGLE Nein deliveryAddress_titleId SINGLE Nein deliveryAddress_zipcode SINGLE Nein deliveryEmailAddresses_bccAddresses SINGLE Nein deliveryEmailAddresses_ccAddresses SINGLE Nein deliveryEmailAddresses_toAddresses SINGLE Nein invoiceAddress_city SINGLE Nein invoiceAddress_company SINGLE Nein invoiceAddress_company2 SINGLE Nein invoiceAddress_countryCode SINGLE Nein invoiceAddress_firstName SINGLE Nein invoiceAddress_globalLocationNumber SINGLE Nein invoiceAddress_lastName SINGLE Nein invoiceAddress_middleName SINGLE Nein invoiceAddress_phoneNumber SINGLE Nein invoiceAddress_postOfficeBoxCity SINGLE Nein invoiceAddress_postOfficeBoxNumber SINGLE Nein invoiceAddress_postOfficeBoxZipCode SINGLE Nein invoiceAddress_salutation SINGLE Nein invoiceAddress_state SINGLE Nein invoiceAddress_street1 SINGLE Nein invoiceAddress_street2 SINGLE Nein invoiceAddress_title SINGLE Nein invoiceAddress_titleId SINGLE Nein invoiceAddress_zipcode SINGLE Nein plannedDeliveryDate SINGLE Nein plannedShippingDate SINGLE Nein recordAddress_city SINGLE Nein recordAddress_company SINGLE Nein recordAddress_company2 SINGLE Nein recordAddress_countryCode SINGLE Nein recordAddress_firstName SINGLE Nein recordAddress_globalLocationNumber SINGLE Nein recordAddress_lastName SINGLE Nein recordAddress_middleName SINGLE Nein recordAddress_phoneNumber SINGLE Nein recordAddress_postOfficeBoxCity SINGLE Nein recordAddress_postOfficeBoxNumber SINGLE Nein recordAddress_postOfficeBoxZipCode SINGLE Nein recordAddress_salutation SINGLE Nein recordAddress_state SINGLE Nein recordAddress_street1 SINGLE Nein recordAddress_street2 SINGLE Nein recordAddress_title SINGLE Nein recordAddress_titleId SINGLE Nein recordAddress_zipcode SINGLE Nein salesInvoiceEmailAddresses_bccAddresses SINGLE Nein salesInvoiceEmailAddresses_ccAddresses SINGLE Nein salesInvoiceEmailAddresses_toAddresses SINGLE Nein advancePaymentStatus SINGLE Nein OPEN availability SINGLE Nein COMPLETELY_AVAILABLE availabilityForAllWarehouses SINGLE Nein cashAccountId SINGLE Nein customerHabitualExporterLetterOfIntentId SINGLE Nein defaultShippingReturnCarrierId SINGLE Nein defaultShippingReturnCarrierName SINGLE Nein ecommerceOrder_ecommerceId SINGLE Nein ecommerceOrder_externalConnectionId SINGLE Nein fulfillmentProviderId SINGLE Nein invoiceRecipientId SINGLE Nein invoiced SINGLE Nein onlyServices SINGLE Nein orderDate SINGLE Nein orderNumber SINGLE Nein orderNumberAtCustomer SINGLE Nein paid SINGLE Nein payments_version MULTIPLEVALUE version1;version2 Nein payments_amount MULTIPLEVALUE amount1;amount2 Nein payments_positionNumber MULTIPLEVALUE positionNumber1;positionNumber2 Nein payments_salesInvoiceId MULTIPLEVALUE salesInvoiceId1;salesInvoiceId2 Nein plannedProjectEndDate SINGLE Nein plannedProjectStartDate SINGLE Nein quotationId SINGLE Nein quotationNumber SINGLE Nein recordEmailAddresses_bccAddresses SINGLE Nein recordEmailAddresses_ccAddresses SINGLE Nein recordEmailAddresses_toAddresses SINGLE Nein salesOrderPaymentType SINGLE Nein servicesFinished SINGLE Nein shipped SINGLE Nein shippingLabelsCount SINGLE Nein status SINGLE Nein warehouseId SINGLE Nein warehouseName SINGLE Nein errorMessage SINGLE Nein

Outputs

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

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
updateSuccess	SPREADSHEET	Spreadsheet with successfully updated purchase orders.	Ja
	Folgende Felder sind im Output enthalten : Feld Datentyp Beschreibung Pflichtfeld Standardwert id SINGLE Nein version SINGLE Nein commercialLanguage SINGLE Nein creatorId SINGLE Nein description SINGLE Nein disableEmailTemplate SINGLE Nein recordComment SINGLE Nein recordFreeText SINGLE Nein recordOpening SINGLE Nein sentToRecipient SINGLE Nein tags SINGLE Nein currencyConversionDate SINGLE Nein currencyConversionRate SINGLE Nein grossAmount SINGLE Nein grossAmountInCompanyCurrency SINGLE Nein headerDiscount SINGLE Nein headerSurcharge SINGLE Nein netAmount SINGLE Nein netAmountInCompanyCurrency SINGLE Nein nonStandardTaxId SINGLE Nein nonStandardTaxName SINGLE Nein paymentMethodId SINGLE Nein paymentMethodName SINGLE Nein recordCurrencyId SINGLE Nein recordCurrencyName SINGLE Nein termOfPaymentId SINGLE Nein termOfPaymentName SINGLE Nein commission SINGLE Nein commissionSalesPartners_version SINGLE Nein commissionSalesPartners_commissionFix SINGLE Nein commissionSalesPartners_commissionPercentage SINGLE Nein commissionSalesPartners_commissionType SINGLE Nein commissionSalesPartners_salesPartnerSupplierId SINGLE Nein commissionSalesPartners_salesPartnerSupplierNumber SINGLE Nein customerId SINGLE Nein customerNumber SINGLE Nein dispatchCountryCode SINGLE Nein factoring SINGLE Nein pricingDate SINGLE Nein responsibleUserId SINGLE Nein responsibleUserUsername SINGLE Nein salesChannel SINGLE Nein servicePeriodFrom SINGLE Nein servicePeriodTo SINGLE Nein shipmentMethodId SINGLE Nein shipmentMethodName SINGLE Nein defaultShippingCarrierId SINGLE Nein defaultShippingCarrierName SINGLE Nein deliveryAddress_city SINGLE Nein deliveryAddress_company SINGLE Nein deliveryAddress_company2 SINGLE Nein deliveryAddress_countryCode SINGLE Nein deliveryAddress_firstName SINGLE Nein deliveryAddress_globalLocationNumber SINGLE Nein deliveryAddress_lastName SINGLE Nein deliveryAddress_middleName SINGLE Nein deliveryAddress_phoneNumber SINGLE Nein deliveryAddress_postOfficeBoxCity SINGLE Nein deliveryAddress_postOfficeBoxNumber SINGLE Nein deliveryAddress_postOfficeBoxZipCode SINGLE Nein deliveryAddress_salutation SINGLE Nein deliveryAddress_state SINGLE Nein deliveryAddress_street1 SINGLE Nein deliveryAddress_street2 SINGLE Nein deliveryAddress_title SINGLE Nein deliveryAddress_titleId SINGLE Nein deliveryAddress_zipcode SINGLE Nein deliveryEmailAddresses_bccAddresses SINGLE Nein deliveryEmailAddresses_ccAddresses SINGLE Nein deliveryEmailAddresses_toAddresses SINGLE Nein invoiceAddress_city SINGLE Nein invoiceAddress_company SINGLE Nein invoiceAddress_company2 SINGLE Nein invoiceAddress_countryCode SINGLE Nein invoiceAddress_firstName SINGLE Nein invoiceAddress_globalLocationNumber SINGLE Nein invoiceAddress_lastName SINGLE Nein invoiceAddress_middleName SINGLE Nein invoiceAddress_phoneNumber SINGLE Nein invoiceAddress_postOfficeBoxCity SINGLE Nein invoiceAddress_postOfficeBoxNumber SINGLE Nein invoiceAddress_postOfficeBoxZipCode SINGLE Nein invoiceAddress_salutation SINGLE Nein invoiceAddress_state SINGLE Nein invoiceAddress_street1 SINGLE Nein invoiceAddress_street2 SINGLE Nein invoiceAddress_title SINGLE Nein invoiceAddress_titleId SINGLE Nein invoiceAddress_zipcode SINGLE Nein plannedDeliveryDate SINGLE Nein plannedShippingDate SINGLE Nein recordAddress_city SINGLE Nein recordAddress_company SINGLE Nein recordAddress_company2 SINGLE Nein recordAddress_countryCode SINGLE Nein recordAddress_firstName SINGLE Nein recordAddress_globalLocationNumber SINGLE Nein recordAddress_lastName SINGLE Nein recordAddress_middleName SINGLE Nein recordAddress_phoneNumber SINGLE Nein recordAddress_postOfficeBoxCity SINGLE Nein recordAddress_postOfficeBoxNumber SINGLE Nein recordAddress_postOfficeBoxZipCode SINGLE Nein recordAddress_salutation SINGLE Nein recordAddress_state SINGLE Nein recordAddress_street1 SINGLE Nein recordAddress_street2 SINGLE Nein recordAddress_title SINGLE Nein recordAddress_titleId SINGLE Nein recordAddress_zipcode SINGLE Nein salesInvoiceEmailAddresses_bccAddresses SINGLE Nein salesInvoiceEmailAddresses_ccAddresses SINGLE Nein salesInvoiceEmailAddresses_toAddresses SINGLE Nein advancePaymentStatus SINGLE Nein availability SINGLE Nein availabilityForAllWarehouses SINGLE Nein cashAccountId SINGLE Nein customerHabitualExporterLetterOfIntentId SINGLE Nein defaultShippingReturnCarrierId SINGLE Nein defaultShippingReturnCarrierName SINGLE Nein ecommerceOrder_ecommerceId SINGLE Nein ecommerceOrder_externalConnectionId SINGLE Nein fulfillmentProviderId SINGLE Nein invoiceRecipientId SINGLE Nein invoiced SINGLE Nein onlyServices SINGLE Nein orderDate SINGLE Nein orderNumber SINGLE Nein orderNumberAtCustomer SINGLE Nein paid SINGLE Nein payments_version SINGLE Nein payments_amount SINGLE Nein payments_positionNumber SINGLE Nein payments_salesInvoiceId SINGLE Nein plannedProjectEndDate SINGLE Nein plannedProjectStartDate SINGLE Nein quotationId SINGLE Nein quotationNumber SINGLE Nein recordEmailAddresses_bccAddresses SINGLE Nein recordEmailAddresses_ccAddresses SINGLE Nein recordEmailAddresses_toAddresses SINGLE Nein salesOrderPaymentType SINGLE Nein servicesFinished SINGLE Nein shipped SINGLE Nein shippingLabelsCount SINGLE Nein status SINGLE Nein warehouseId SINGLE Nein warehouseName SINGLE Nein createdDate SINGLE Nein lastModifiedDate SINGLE Nein shippingCostItems SINGLE Nein
updatesFailed	SPREADSHEET	Spreadsheet with failed purchase orders updates.	Ja
	Folgende Felder sind im Output enthalten : Feld Datentyp Beschreibung Pflichtfeld Standardwert id SINGLE Nein version SINGLE Nein commercialLanguage SINGLE Nein creatorId SINGLE Nein description SINGLE Nein disableEmailTemplate SINGLE Nein recordComment SINGLE Nein recordFreeText SINGLE Nein recordOpening SINGLE Nein sentToRecipient SINGLE Nein tags SINGLE Nein currencyConversionDate SINGLE Nein currencyConversionRate SINGLE Nein grossAmount SINGLE Nein grossAmountInCompanyCurrency SINGLE Nein headerDiscount SINGLE Nein headerSurcharge SINGLE Nein netAmount SINGLE Nein netAmountInCompanyCurrency SINGLE Nein nonStandardTaxId SINGLE Nein nonStandardTaxName SINGLE Nein paymentMethodId SINGLE Nein paymentMethodName SINGLE Nein recordCurrencyId SINGLE Nein recordCurrencyName SINGLE Nein termOfPaymentId SINGLE Nein termOfPaymentName SINGLE Nein commission SINGLE Nein commissionSalesPartners_version SINGLE Nein commissionSalesPartners_commissionFix SINGLE Nein commissionSalesPartners_commissionPercentage SINGLE Nein commissionSalesPartners_commissionType SINGLE Nein commissionSalesPartners_salesPartnerSupplierId SINGLE Nein commissionSalesPartners_salesPartnerSupplierNumber SINGLE Nein customerId SINGLE Nein customerNumber SINGLE Nein dispatchCountryCode SINGLE Nein factoring SINGLE Nein pricingDate SINGLE Nein responsibleUserId SINGLE Nein responsibleUserUsername SINGLE Nein salesChannel SINGLE Nein servicePeriodFrom SINGLE Nein servicePeriodTo SINGLE Nein shipmentMethodId SINGLE Nein shipmentMethodName SINGLE Nein defaultShippingCarrierId SINGLE Nein defaultShippingCarrierName SINGLE Nein deliveryAddress_city SINGLE Nein deliveryAddress_company SINGLE Nein deliveryAddress_company2 SINGLE Nein deliveryAddress_countryCode SINGLE Nein deliveryAddress_firstName SINGLE Nein deliveryAddress_globalLocationNumber SINGLE Nein deliveryAddress_lastName SINGLE Nein deliveryAddress_middleName SINGLE Nein deliveryAddress_phoneNumber SINGLE Nein deliveryAddress_postOfficeBoxCity SINGLE Nein deliveryAddress_postOfficeBoxNumber SINGLE Nein deliveryAddress_postOfficeBoxZipCode SINGLE Nein deliveryAddress_salutation SINGLE Nein deliveryAddress_state SINGLE Nein deliveryAddress_street1 SINGLE Nein deliveryAddress_street2 SINGLE Nein deliveryAddress_title SINGLE Nein deliveryAddress_titleId SINGLE Nein deliveryAddress_zipcode SINGLE Nein deliveryEmailAddresses_bccAddresses SINGLE Nein deliveryEmailAddresses_ccAddresses SINGLE Nein deliveryEmailAddresses_toAddresses SINGLE Nein invoiceAddress_city SINGLE Nein invoiceAddress_company SINGLE Nein invoiceAddress_company2 SINGLE Nein invoiceAddress_countryCode SINGLE Nein invoiceAddress_firstName SINGLE Nein invoiceAddress_globalLocationNumber SINGLE Nein invoiceAddress_lastName SINGLE Nein invoiceAddress_middleName SINGLE Nein invoiceAddress_phoneNumber SINGLE Nein invoiceAddress_postOfficeBoxCity SINGLE Nein invoiceAddress_postOfficeBoxNumber SINGLE Nein invoiceAddress_postOfficeBoxZipCode SINGLE Nein invoiceAddress_salutation SINGLE Nein invoiceAddress_state SINGLE Nein invoiceAddress_street1 SINGLE Nein invoiceAddress_street2 SINGLE Nein invoiceAddress_title SINGLE Nein invoiceAddress_titleId SINGLE Nein invoiceAddress_zipcode SINGLE Nein plannedDeliveryDate SINGLE Nein plannedShippingDate SINGLE Nein recordAddress_city SINGLE Nein recordAddress_company SINGLE Nein recordAddress_company2 SINGLE Nein recordAddress_countryCode SINGLE Nein recordAddress_firstName SINGLE Nein recordAddress_globalLocationNumber SINGLE Nein recordAddress_lastName SINGLE Nein recordAddress_middleName SINGLE Nein recordAddress_phoneNumber SINGLE Nein recordAddress_postOfficeBoxCity SINGLE Nein recordAddress_postOfficeBoxNumber SINGLE Nein recordAddress_postOfficeBoxZipCode SINGLE Nein recordAddress_salutation SINGLE Nein recordAddress_state SINGLE Nein recordAddress_street1 SINGLE Nein recordAddress_street2 SINGLE Nein recordAddress_title SINGLE Nein recordAddress_titleId SINGLE Nein recordAddress_zipcode SINGLE Nein salesInvoiceEmailAddresses_bccAddresses SINGLE Nein salesInvoiceEmailAddresses_ccAddresses SINGLE Nein salesInvoiceEmailAddresses_toAddresses SINGLE Nein advancePaymentStatus SINGLE Nein availability SINGLE Nein availabilityForAllWarehouses SINGLE Nein cashAccountId SINGLE Nein customerHabitualExporterLetterOfIntentId SINGLE Nein defaultShippingReturnCarrierId SINGLE Nein defaultShippingReturnCarrierName SINGLE Nein ecommerceOrder_ecommerceId SINGLE Nein ecommerceOrder_externalConnectionId SINGLE Nein fulfillmentProviderId SINGLE Nein invoiceRecipientId SINGLE Nein invoiced SINGLE Nein onlyServices SINGLE Nein orderDate SINGLE Nein orderNumber SINGLE Nein orderNumberAtCustomer SINGLE Nein paid SINGLE Nein payments_version SINGLE Nein payments_amount SINGLE Nein payments_positionNumber SINGLE Nein payments_salesInvoiceId SINGLE Nein plannedProjectEndDate SINGLE Nein plannedProjectStartDate SINGLE Nein quotationId SINGLE Nein quotationNumber SINGLE Nein recordEmailAddresses_bccAddresses SINGLE Nein recordEmailAddresses_ccAddresses SINGLE Nein recordEmailAddresses_toAddresses SINGLE Nein salesOrderPaymentType SINGLE Nein servicesFinished SINGLE Nein shipped SINGLE Nein shippingLabelsCount SINGLE Nein status SINGLE Nein warehouseId SINGLE Nein warehouseName SINGLE Nein errorMessage SINGLE Nein
missingIds	SPREADSHEET		Ja