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