Skip to content

weclappUpdateArticles - weclapp

← weclapp Add-On Übersicht

This step updates weclapp articles.


Inputs

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

Name Datentyp Beschreibung Pflichtfeld Werte
account ACCOUNT Nein
testMode STRING Test order updates in dryRun mode. Nein
  • True
  • False
limit STRING Limit the rows to be processed Nein
articlesSpreadsheet SPREADSHEET Ja
mappingdefinition STRING The mapping definition JSON String Ja
Folgende Felder sind zu konfigurieren:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
version SINGLE Nein
id SINGLE Ja
articleNumber SINGLE Ja
description SINGLE Nein
ean SINGLE Nein
fixedPurchaseQuantity SINGLE Nein
internalNote SINGLE Nein
manufacturerPartNumber SINGLE Nein
matchCode SINGLE Nein
minimumPurchaseQuantity SINGLE Nein
name SINGLE Nein
shortDescription1 SINGLE Nein
shortDescription2 SINGLE Nein
taxRateType SINGLE Nein
unitId SINGLE Nein
unitName SINGLE Nein
accountId SINGLE Nein
accountNumber SINGLE Nein
accountingCodeId SINGLE Nein
active SINGLE Nein
applyCashDiscount SINGLE Ja
articleAlternativeQuantities_version MULTIPLEVALUE version 1; version2 Nein
articleAlternativeQuantities_minimumOrderQuantity MULTIPLEVALUE minimumOrderQuantity 1;minimumOrderQuantity 2 Nein
articleAlternativeQuantities_minimumStockQuantity MULTIPLEVALUE minimumStockQuantity1;minimumStockQuantity2 Nein
articleAlternativeQuantities_targetStockQuantity MULTIPLEVALUE targetStockQuantity 1;targetStockQuantity 2 Nein
articleAlternativeQuantities_warehouseId MULTIPLEVALUE warehouseId 1;warehouseId2 Nein
articleAlternativeQuantities_warehouseName MULTIPLEVALUE warehouseName 1;warehouseName2 Nein
articleCalculationPrices_version MULTIPLEVALUE version 1;version2 Nein
articleCalculationPrices_articleCalculationPriceType MULTIPLEVALUE articleCalculationPriceType 1;articleCalculationPriceType2 Nein
articleCalculationPrices_endDate MULTIPLEVALUE endDate 1;endDate2 Nein
articleCalculationPrices_positionNumber MULTIPLEVALUE positionNumber 1;positionNumber2 Nein
articleCalculationPrices_price MULTIPLEVALUE price 1;price2 Nein
articleCalculationPrices_salesChannel MULTIPLEVALUE salesChannel 1;salesChannel2 Nein
articleCalculationPrices_startDate MULTIPLEVALUE startDate 1;startDate2 Nein
articleCategoryId SINGLE Nein
articleGrossWeight SINGLE Nein
articleHeight SINGLE Nein
articleLength SINGLE Nein
articleNetWeight SINGLE Nein
articlePrices_version MULTIPLEVALUE version 1;version 2 Nein
articlePrices_currencyId MULTIPLEVALUE currencyId 1;currencyId2 Nein
articlePrices_currencyName MULTIPLEVALUE currencyName 1;currencyName2 Nein
articlePrices_customerId MULTIPLEVALUE customerId 1;customerId2 Nein
articlePrices_description MULTIPLEVALUE description1;description2 Nein
articlePrices_endDate MULTIPLEVALUE endDate 1;endDate2 Nein
articlePrices_lastModifiedByUserId MULTIPLEVALUE lastModifiedByUserId 1;lastModifiedByUserId2 Nein
articlePrices_positionNumber MULTIPLEVALUE positionNumber 1;positionNumber2 Nein
articlePrices_price MULTIPLEVALUE price 1;price2 Nein
articlePrices_priceScaleType MULTIPLEVALUE priceScaleType 1| priceScaleType2 Nein
articlePrices_priceScaleValue MULTIPLEVALUE priceScaleValue 1;priceScaleValue2 Nein
articlePrices_startDate MULTIPLEVALUE startDate1;startDate2 Nein
articlePrices_salesChannel MULTIPLEVALUE salesChannel1;salesChannel2 Nein
articleType SINGLE Nein
articleWidth SINGLE Nein
availableForSalesChannels MULTIPLEVALUE availableForSalesChannels1;availableForSalesChannels2 Nein
availableInSale SINGLE Ja
averageDeliveryTime SINGLE Nein
barcode SINGLE Nein
batchNumberRequired SINGLE Ja
billOfMaterialPartDeliveryPossible SINGLE Nein
catalogCode SINGLE Nein
commissionRate SINGLE Nein
contractBillingCycle SINGLE Nein
contractBillingMode SINGLE Nein
countryOfOriginCode SINGLE Nein
customerArticleNumbers_version MULTIPLEVALUE version 1;version2 Nein
customerArticleNumbers_customerArticleNumber MULTIPLEVALUE customerArticleNumber 1;customerArticleNumber2 Nein
customerArticleNumbers_customerId MULTIPLEVALUE customerId 1;customerId2 Nein
customsDescription SINGLE Nein
customsTariffNumber SINGLE Nein
customsTariffNumberId SINGLE Nein
defaultLoadingEquipmentIdentifierId SINGLE Nein
defaultPriceCalculationType SINGLE Nein
defaultStoragePlaces MULTIPLEVALUE Nein
defineIndividualTaskTemplates SINGLE Ja
expenseAccountId SINGLE Nein
expenseAccountNumber SINGLE Nein
expirationDays SINGLE Nein
invoicingType SINGLE Nein
launchDate SINGLE Nein
loadingEquipmentArticleId SINGLE Nein
longText SINGLE Nein
lowLevelCode SINGLE Nein
manufacturerId SINGLE Nein
manufacturerName SINGLE Nein
marginCalculationPriceType SINGLE Nein
minimumStockQuantity SINGLE Nein
packagingQuantity SINGLE Nein
packagingUnitBaseArticleId SINGLE Nein
packagingUnitParentArticleId SINGLE Nein
plannedWorkingTimePerUnit SINGLE Nein
primarySupplySourceId SINGLE Nein
procurementLeadDays SINGLE Nein
producerType SINGLE Nein
productionArticle SINGLE Nein
purchaseCostCenterId SINGLE Nein
purchaseCostCenterNumber SINGLE Nein
ratingId SINGLE Nein
ratingName SINGLE Nein
recordItemGroupName SINGLE Nein
safetyStockDays SINGLE Nein
salesCostCenterId SINGLE Nein
salesCostCenterNumber SINGLE Nein
sellByDate SINGLE Nein
sellFromDate SINGLE Nein
serialNumberRequired SINGLE Nein
showOnDeliveryNote SINGLE Nein
statusId SINGLE Nein
supportUntilDate SINGLE Nein
systemCode SINGLE Nein
tags MULTIPLEVALUE tag1;tag2 Nein
targetStockQuantity SINGLE Nein
productionConfigurationRule SINGLE Ja
useAvailableForSalesChannels SINGLE Ja
useSalesBillOfMaterialItemPrices SINGLE Ja
useSalesBillOfMaterialItemPricesForPurchase SINGLE Ja
useSalesBillOfMaterialSubitemCosts SINGLE Ja false

Outputs

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

Name Datentyp Beschreibung Werte
updatedArticles SPREADSHEET Spreadsheet containing all successfully updated articles
failedArticles SPREADSHEET Spreadsheet containing all failed articles
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
id SINGLE
articleNumber SINGLE
description SINGLE
ean SINGLE
fixedPurchaseQuantity SINGLE
internalNote SINGLE
manufacturerPartNumber SINGLE
matchCode SINGLE
minimumPurchaseQuantity SINGLE
name SINGLE
shortDescription1 SINGLE
shortDescription2 SINGLE
taxRateType SINGLE
unitId SINGLE
unitName SINGLE
accountId SINGLE
accountNumber SINGLE
accountingCodeId SINGLE
active SINGLE
applyCashDiscount SINGLE
articleAlternativeQuantities_version SINGLE
articleAlternativeQuantities_minimumOrderQuantity SINGLE
articleAlternativeQuantities_minimumStockQuantity SINGLE
articleAlternativeQuantities_targetStockQuantity SINGLE
articleAlternativeQuantities_warehouseId SINGLE
articleAlternativeQuantities_warehouseName SINGLE
articleCalculationPrices_version SINGLE
articleCalculationPrices_articleCalculationPriceType SINGLE
articleCalculationPrices_endDate SINGLE
articleCalculationPrices_positionNumber SINGLE
articleCalculationPrices_price SINGLE
articleCalculationPrices_salesChannel SINGLE
articleCalculationPrices_startDate SINGLE
articleCategoryId SINGLE
articleGrossWeight SINGLE
articleHeight SINGLE
articleImages_version SINGLE
articleImages_fileName SINGLE
articleImages_mainImage SINGLE
articleLength SINGLE
articleNetWeight SINGLE
articlePrices_version SINGLE
articlePrices_currencyId SINGLE
articlePrices_currencyName SINGLE
articlePrices_customerId SINGLE
articlePrices_description SINGLE
articlePrices_endDate SINGLE
articlePrices_lastModifiedByUserId SINGLE
articlePrices_positionNumber SINGLE
articlePrices_price SINGLE
articlePrices_priceScaleType SINGLE
articlePrices_priceScaleValue SINGLE
articlePrices_reductionAdditions_version SINGLE
articlePrices_reductionAdditions_name SINGLE
articlePrices_reductionAdditions_type SINGLE
articlePrices_reductionAdditions_value SINGLE
articlePrices_startDate SINGLE
articlePrices_salesChannel SINGLE
articleType SINGLE
articleWidth SINGLE
availableForSalesChannels SINGLE
availableInSale SINGLE
averageDeliveryTime SINGLE
barcode SINGLE
batchNumberRequired SINGLE
billOfMaterialPartDeliveryPossible SINGLE
catalogCode SINGLE
commissionRate SINGLE
contractBillingCycle SINGLE
contractBillingMode SINGLE
countryOfOriginCode SINGLE
customerArticleNumbers_version SINGLE
customerArticleNumbers_customerArticleNumber SINGLE
customerArticleNumbers_customerId SINGLE
customsDescription SINGLE
customsTariffNumber SINGLE
customsTariffNumberId SINGLE
defaultLoadingEquipmentIdentifierId SINGLE
defaultPriceCalculationType SINGLE
defineIndividualTaskTemplates SINGLE
expenseAccountId SINGLE
expenseAccountNumber SINGLE
expirationDays SINGLE
invoicingType SINGLE
launchDate SINGLE
loadingEquipmentArticleId SINGLE
longText SINGLE
lowLevelCode SINGLE
manufacturerId SINGLE
manufacturerName SINGLE
marginCalculationPriceType SINGLE
minimumStockQuantity SINGLE
packagingQuantity SINGLE
packagingUnitBaseArticleId SINGLE
packagingUnitParentArticleId SINGLE
plannedWorkingTimePerUnit SINGLE
priceCalculationParameters_version SINGLE
priceCalculationParameters_fixSurcharge SINGLE
priceCalculationParameters_fromScale SINGLE
priceCalculationParameters_lowerPurchasePriceBound SINGLE
priceCalculationParameters_margin SINGLE
priceCalculationParameters_percentSurcharge SINGLE
priceCalculationParameters_profit SINGLE
priceCalculationParameters_salesChannel SINGLE
primarySupplySourceId SINGLE
procurementLeadDays SINGLE
producerType SINGLE
productionArticle SINGLE
productionBillOfMaterialItems_version SINGLE
productionBillOfMaterialItems_articleId SINGLE
productionBillOfMaterialItems_articleNumber SINGLE
productionBillOfMaterialItems_positionNumber SINGLE
productionBillOfMaterialItems_quantity SINGLE
purchaseCostCenterId SINGLE
purchaseCostCenterNumber SINGLE
quantityConversions_version SINGLE
quantityConversions_conversionQuantity SINGLE
quantityConversions_createdUserId SINGLE
quantityConversions_lastEditedUserId SINGLE
quantityConversions_oppositeDirection SINGLE
quantityConversions_unitId SINGLE
ratingId SINGLE
ratingName SINGLE
recordItemGroupName SINGLE
safetyStockDays SINGLE
salesBillOfMaterialItems_version SINGLE
salesBillOfMaterialItems_articleId SINGLE
salesBillOfMaterialItems_articleNumber SINGLE
salesBillOfMaterialItems_positionNumber SINGLE
salesBillOfMaterialItems_quantity SINGLE
salesCostCenterId SINGLE
salesCostCenterNumber SINGLE
sellByDate SINGLE
sellFromDate SINGLE
serialNumberRequired SINGLE
showOnDeliveryNote SINGLE
statusId SINGLE
supplySources_version SINGLE
supplySources_articleSupplySourceId SINGLE
supplySources_positionNumber SINGLE
supportUntilDate SINGLE
systemCode SINGLE
tags SINGLE
targetStockQuantity SINGLE
useAvailableForSalesChannels SINGLE
useSalesBillOfMaterialItemPrices SINGLE
useSalesBillOfMaterialItemPricesForPurchase SINGLE
defaultStoragePlaces SINGLE
productionConfigurationRule SINGLE
errorMessage SINGLE
invalidArticles SPREADSHEET Spreadsheet containing all invalid articles
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
id SINGLE
articleNumber SINGLE
description SINGLE
ean SINGLE
fixedPurchaseQuantity SINGLE
internalNote SINGLE
manufacturerPartNumber SINGLE
matchCode SINGLE
minimumPurchaseQuantity SINGLE
name SINGLE
shortDescription1 SINGLE
shortDescription2 SINGLE
taxRateType SINGLE
unitId SINGLE
unitName SINGLE
accountId SINGLE
accountNumber SINGLE
accountingCodeId SINGLE
active SINGLE
applyCashDiscount SINGLE
articleAlternativeQuantities_version SINGLE
articleAlternativeQuantities_minimumOrderQuantity SINGLE
articleAlternativeQuantities_minimumStockQuantity SINGLE
articleAlternativeQuantities_targetStockQuantity SINGLE
articleAlternativeQuantities_warehouseId SINGLE
articleAlternativeQuantities_warehouseName SINGLE
articleCalculationPrices_version SINGLE
articleCalculationPrices_articleCalculationPriceType SINGLE
articleCalculationPrices_endDate SINGLE
articleCalculationPrices_positionNumber SINGLE
articleCalculationPrices_price SINGLE
articleCalculationPrices_salesChannel SINGLE
articleCalculationPrices_startDate SINGLE
articleCategoryId SINGLE
articleGrossWeight SINGLE
articleHeight SINGLE
articleImages_version SINGLE
articleImages_fileName SINGLE
articleImages_mainImage SINGLE
articleLength SINGLE
articleNetWeight SINGLE
articlePrices_version SINGLE
articlePrices_currencyId SINGLE
articlePrices_currencyName SINGLE
articlePrices_customerId SINGLE
articlePrices_description SINGLE
articlePrices_endDate SINGLE
articlePrices_lastModifiedByUserId SINGLE
articlePrices_positionNumber SINGLE
articlePrices_price SINGLE
articlePrices_priceScaleType SINGLE
articlePrices_priceScaleValue SINGLE
articlePrices_reductionAdditions_version SINGLE
articlePrices_reductionAdditions_name SINGLE
articlePrices_reductionAdditions_type SINGLE
articlePrices_reductionAdditions_value SINGLE
articlePrices_startDate SINGLE
articlePrices_salesChannel SINGLE
articleType SINGLE
articleWidth SINGLE
availableForSalesChannels SINGLE
availableInSale SINGLE
averageDeliveryTime SINGLE
barcode SINGLE
batchNumberRequired SINGLE
billOfMaterialPartDeliveryPossible SINGLE
catalogCode SINGLE
commissionRate SINGLE
contractBillingCycle SINGLE
contractBillingMode SINGLE
countryOfOriginCode SINGLE
customerArticleNumbers_version SINGLE
customerArticleNumbers_customerArticleNumber SINGLE
customerArticleNumbers_customerId SINGLE
customsDescription SINGLE
customsTariffNumber SINGLE
customsTariffNumberId SINGLE
defaultLoadingEquipmentIdentifierId SINGLE
defaultPriceCalculationType SINGLE
defineIndividualTaskTemplates SINGLE
expenseAccountId SINGLE
expenseAccountNumber SINGLE
expirationDays SINGLE
invoicingType SINGLE
launchDate SINGLE
loadingEquipmentArticleId SINGLE
longText SINGLE
lowLevelCode SINGLE
manufacturerId SINGLE
manufacturerName SINGLE
marginCalculationPriceType SINGLE
minimumStockQuantity SINGLE
packagingQuantity SINGLE
packagingUnitBaseArticleId SINGLE
packagingUnitParentArticleId SINGLE
plannedWorkingTimePerUnit SINGLE
priceCalculationParameters_version SINGLE
priceCalculationParameters_fixSurcharge SINGLE
priceCalculationParameters_fromScale SINGLE
priceCalculationParameters_lowerPurchasePriceBound SINGLE
priceCalculationParameters_margin SINGLE
priceCalculationParameters_percentSurcharge SINGLE
priceCalculationParameters_profit SINGLE
priceCalculationParameters_salesChannel SINGLE
primarySupplySourceId SINGLE
procurementLeadDays SINGLE
producerType SINGLE
productionArticle SINGLE
productionBillOfMaterialItems_version SINGLE
productionBillOfMaterialItems_articleId SINGLE
productionBillOfMaterialItems_articleNumber SINGLE
productionBillOfMaterialItems_positionNumber SINGLE
productionBillOfMaterialItems_quantity SINGLE
purchaseCostCenterId SINGLE
purchaseCostCenterNumber SINGLE
quantityConversions_version SINGLE
quantityConversions_conversionQuantity SINGLE
quantityConversions_createdUserId SINGLE
quantityConversions_lastEditedUserId SINGLE
quantityConversions_oppositeDirection SINGLE
quantityConversions_unitId SINGLE
ratingId SINGLE
ratingName SINGLE
recordItemGroupName SINGLE
safetyStockDays SINGLE
salesBillOfMaterialItems_version SINGLE
salesBillOfMaterialItems_articleId SINGLE
salesBillOfMaterialItems_articleNumber SINGLE
salesBillOfMaterialItems_positionNumber SINGLE
salesBillOfMaterialItems_quantity SINGLE
salesCostCenterId SINGLE
salesCostCenterNumber SINGLE
sellByDate SINGLE
sellFromDate SINGLE
serialNumberRequired SINGLE
showOnDeliveryNote SINGLE
statusId SINGLE
supplySources_version SINGLE
supplySources_articleSupplySourceId SINGLE
supplySources_positionNumber SINGLE
supportUntilDate SINGLE
systemCode SINGLE
tags SINGLE
targetStockQuantity SINGLE
useAvailableForSalesChannels SINGLE
useSalesBillOfMaterialItemPrices SINGLE
useSalesBillOfMaterialItemPricesForPurchase SINGLE
defaultStoragePlaces SINGLE
productionConfigurationRule SINGLE
errorMessage SINGLE