ShopwareUpdateProducts - Shopware

Version: 6.4.0.0 - 6.4.20.x

Mit diesem Step können Sie Artikel und Varianten in einem Shopware 6 aktualisieren. Zum setzen von Beständen und Preisen vorhandener Artikel oder Varianten können die Steps ShopwareSetStockAndPrice verwendet werden. Um neue Produkte zu importieren können Sie den Step ShopwareAddProducts verwenden.

Input	Beschreibung
account	Wählen Sie hier Ihren Shopware 6 Verbindung aus, um auf die Schnittstelle Ihres Shops zuzugreifen zu können (weitere Informationen)
productSpreadsheet	Verknüpfung zu einem (Output) Spreadsheet eines vorherigen Step, dass z.B. mit Artikeldaten eines Lieferanten enthält
mappingdefinition	Durch einen Klick auf "Konfigurieren" können Sie die Spalten des eben verknüpften Spreadsheets zuweisen. Weiterhin haben Sie, falls benötigt, die Möglichkeit die im Spreadsheet enthaltenen Daten zu mappen.
limit (optional)	Dieser Filter schränkt ein wie viele Artikel maximal aktualisiert werden. Gerade während der Erstellung eines Flows ist es praktisch diesen Wert eher klein zu halten (z.B. 1), damit der Aufwand zur Korrektur bei evtl. Fehlern minimiert wird. Default: 10

Beschreibung der Zielspalten

Mit Klick auf den “Konfigurieren” Button gelangen Sie in die sogenannte Mapping Ansicht. Hier können Sie weitere, optional Spalten für die neuen Artikel zuordnen oder mit festen Werten befüllen.

Felder	Anmerkungen	Pflichtfeld	Standardwert
Id	ID des Produkt bzw. der Variante (Abgleichfeld)	ja
ProductNumber	Produktnummer
Name	Titel des Artikels
TaxId	ID des Steuersatzes
Stock	Neuer Bestand des Produkts
Description	Beschreibungstext
MetaDescription	SEO-Meta-Beschreibung
MetaTitle	SEO-Meta-Titel
Keywords	SEO-Schlüsselwörter
MarkAsTopseller	Produkt hervorheben, Ja (true) oder Nein (false)
DisplayInListing	Abverkauf, Ja (true) oder Nein (false)
DeliveryTimeId	ID der Lieferzeit
RestockTime	Wiederauffüllzeit in Tagen
ShippingFree	Versandkostenfrei. Ja (true) oder Nein (false)
MinPurchase	Mindestabnahme
PurchaseSteps	Staffelung
MaxPurchase	Maximalabnahme
IsCloseout	Abverkauf
ReleaseDate	Erscheinungsdatum
EAN	EAN
ManufacturerNumber	Herstellernummer
ManufacturerId	ID des Herstellers
Width	Breite
Height	Höhe
Length	Länge
Weight	Gewicht
PurchaseUnit	Verkaufseinheit
TagIds	Semikolon getrennte Liste der Tag IDs
VisibilitySaleschannelIds	Semikolon getrennte Liste der Verkaufskanal IDs
CategoryIds	Semikolon getrennte Liste der Kategorie IDs
CustomFields	Zusatzfelder können als Schlüssel-Wert Paare angegeben werden, in der Form: Feld1=Wert1;Feld2=Wert2

Inputs

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

Name

Datentyp

Beschreibung

Pflichtfeld

Werte

account

ACCOUNT

Ihre Shopware 6 Verbindung

limit

STRING

Begrenzt die Anzahl der Artikel die aktualisiert werden sollen. Leer für unbegrenzt.

Nein

productSpreadsheet

SPREADSHEET

Ein SPREADSHEET, dass mindestens die Artikel-ID und die Artikeldaten enthält, welche in der Shopware aktualisiert werden sollen.

mappingdefinition

STRING

Die Mapping-Definition

Nein

Folgende Felder sind zu konfigurieren:

Feld	Datentyp	Beschreibung	Pflichtfeld
Id	SINGLE	Unique identity of the product.	Nein
ProductNumber	SINGLE	Unique number assigned to individual products. Define rules for automatic assignment of every product creation as per your number range.	Nein
Name	SINGLE	Name of the product.	Nein
TaxId	SINGLE	Unique identity of tax.	Nein
Stock	SINGLE	Indicates the number of products available.	Nein
PurchasePrice	SINGLE	Deprecated field: Only used in older Shopware 6 Version. Please use ShopwareSetStockAndPrice Step to update Purchase Price of Products.	Nein
Description	SINGLE	Description of the product.	Nein
MetaDescription	SINGLE	A short description of the product for search results listings.	Nein
MetaTitle	SINGLE	A page title indexed by search engines and appears in search results listings.	Nein
Keywords	SINGLE	Keywords that give additional information about the Product.	Nein
AdditionalText	SINGLE	(depracated) AdditonalText is not used anymore. The column will be remove in a future version of this Step.	Nein
Active	SINGLE	If true, the products are available for selection in the storefront for purchase.	Nein
MarkAsTopseller	SINGLE	Indicates weather the product is top seller or not.	Nein
DisplayInListing	SINGLE	(depracated) This column is not used anymore and will be removed in future version of this step.	Nein
DeliveryTimeId	SINGLE	Unique identity of delivery time.	Nein
RestockTime	SINGLE	The restock time in days indicates how long it will take until a sold out item is back in stock.	Nein
ShippingFree	SINGLE	Indicates weather the shipping price is free or not.	Nein
MinPurchase	SINGLE	Minimum number of items that can be purchased.	Nein
PurchaseSteps	SINGLE	Specifies the scales in which the item is to be offered. For example, a scale of 2 means that your customers can purchase 2, 4, 6 products, etc., but not 1, 3 or 5.	Nein
MaxPurchase	SINGLE	Maximum number of items that can be purchased.	Nein
IsCloseout	SINGLE	When the value is set to true, the product is hidden when sold out.	Nein
ReleaseDate	SINGLE	The release date of a product or product model. This can be used to distinguish the exact variant of a product.	Nein
EAN	SINGLE	Indicates EAN of the product.	Nein
ManufacturerNumber	SINGLE	Unique number that describes the manufacturer.	Nein
ManufacturerId	SINGLE	Unique identity of the manufacturer.	Nein
Width	SINGLE	The width of the product.	Nein
Height	SINGLE	The height of the product.	Nein
Length	SINGLE	The length of the product.	Nein
Weight	SINGLE	The weight of the product.	Nein
PurchaseUnit	SINGLE	Quantity of the item purchased. For example, 500ml, 2kg, etc.	Nein
CoverMediaId	SINGLE		Nein
MediaIds	MAP	Media Ids as semicolon separated list, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac. It is also possible to set the position of media ids in the form eg. 25ab9d62bbc346f480549861f0f657b2=0;cbcee43364b444fb879eb2dd05b280ac=1,...	Nein
UnitId	SINGLE	Unique identity of Unit.	Nein
TagIds	MULTIPLEVALUE	Tag ids as semicolon separated list, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac	Nein
VisibilitySaleschannelIds	MULTIPLEVALUE	Visibility ids as semicolon separated list, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac	Nein
CategoryIds	MULTIPLEVALUE	Tag ids as semicolon separated list of category ids, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac	Nein
CustomFields	MAP		Nein
PropertyGroupOptionIds	MULTIPLEVALUE	Property Group Option Ids as semicolon separated list of property ids, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac	Nein

Outputs

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

Name

Datentyp

Beschreibung

Werte

results

SPREADSHEET

Das Ergebnis SPREADSHEET mit den aktualisierten Produkten.

Folgende Felder sind im Output enthalten:

Feld	Datentyp	Beschreibung	Standardwert
Type	SINGLE	Type of product.
identifier	SINGLE	The identifier column to import Spreadsheet into a Datastore.
Id	SINGLE	Unique identity of the product.
parent_identifier	SINGLE	The parent_identifier column to import Spreadsheet into a Datastore.
ParentId	SINGLE	Unique identity of the parent product (MainVariant).
ChildCount	SINGLE	Number of variants the product has.
ProductNumber	SINGLE	Unique number assigned to individual products. Define rules for automatic assignment of every product creation as per your number range.
Name	SINGLE	Name of the product.
MetaTitle	SINGLE	A page title indexed by search engines and appears in search results listings.
MetaDescription	SINGLE	A short description of the product for search results listings.
Description	SINGLE	Description of the product.
Keywords	SINGLE	Keywords that give additional information about the Product.
AdditionalText	SINGLE	(depracated) AdditonalText is not used anymore. The column will be remove in a future version of this Step.
Active	SINGLE	If true, the products are available for selection in the storefront for purchase.
MarkAsTopseller	SINGLE	Indicates weather the product is top seller or not.
CoverId	SINGLE	Unique identity of a ProductMedia item used as product cover.
CoverUrl	SINGLE	Url of cover image.
ImageUrls	MULTIPLEVALUE	A list of image URLs (media type = image)
MediaIds	MULTIPLEVALUE	A list of product media Ids
MediaUrls	MULTIPLEVALUE	A list of the URLs of all product media (including images)
PriceGross	SINGLE	The gross price value.
PriceNet	SINGLE	The net price value
PriceLinked	SINGLE	If true, the net and gross value is linked	true
PriceListPriceGross	SINGLE	The gross list price value.
PriceListPriceNet	SINGLE	The net list price value.
PriceListPriceLinked	SINGLE	If true, the net list price and gross list price is linked
PriceRegulationPriceGross	SINGLE	The gross regulation price value.
PriceRegulationPriceNet	SINGLE	The net regulation price value.
PriceRegulationPriceLinked	SINGLE	If true, the net regulation price and gross regulation price is linked
PurchasePrice	SINGLE	(depracated) Purchase price (gross) of default currency.
PurchasePriceGross	SINGLE	The gross price value.
PurchasePriceNet	SINGLE	The net price value
PurchasePriceLinked	SINGLE	If true, the net and gross value is linked	true
DefaultCurrencyId	SINGLE	Unique identity of currency.
DefaultCurrencyName	SINGLE	Full name of the currency. For example, US-Dollar.
DefaultCurrencyIsoCode	SINGLE	Standard international three digit code to represent currency. For example, USD.
TaxId	SINGLE	Unique identity of tax.
TaxRate	SINGLE	Rate of tax.
TaxName	SINGLE	Name defined for a Tax.
Stock	SINGLE	Indicates the number of products available.
AvailableStock	SINGLE	Indicates the number of products still available. This value results from the stock minus the open orders.
Available	SINGLE	Indicates weather the product is available or not.
DisplayInListing	SINGLE	(depracated) This column is not used anymore and will be removed in future version of this step.
DeliveryTimeId	SINGLE	Unique identity of delivery time.
RestockTime	SINGLE	The restock time in days indicates how long it will take until a sold out item is back in stock.
ShippingFree	SINGLE	Indicates weather the shipping price is free or not.
MinPurchase	SINGLE	Minimum number of items that can be purchased.
PurchaseSteps	SINGLE	Specifies the scales in which the item is to be offered. For example, a scale of 2 means that your customers can purchase 2, 4, 6 products, etc., but not 1, 3 or 5.
MaxPurchase	SINGLE	Maximum number of items that can be purchased.
IsCloseout	SINGLE	When the value is set to true, the product is hidden when sold out.
ReleaseDate	SINGLE	The release date of a product or product model. This can be used to distinguish the exact variant of a product.
EAN	SINGLE	Indicates EAN of the product.
ManufacturerNumber	SINGLE	Unique number that describes the manufacturer.
ManufacturerId	SINGLE	Unique identity of the manufacturer.
ManufacturerMediaId	SINGLE	Unique identity of the media.
ManufacturerLink	SINGLE	URL of the manufacturer's portal.
ManufacturerName	SINGLE	Name of the product manufacturer.
ManufacturerDescription	SINGLE	A detailed description of product manufacturer.
Width	SINGLE	The width of the product.
Height	SINGLE	The height of the product.
Length	SINGLE	The length of the product.
Weight	SINGLE	The weight of the product.
PurchaseUnit	SINGLE	Quantity of the item purchased. For example, 500ml, 2kg, etc.
UnitId	SINGLE	Unique identity of the unit.
UnitShortCode	SINGLE	Short name for unit, e.g., m, kg.
UnitName	SINGLE	Full name of the unit, e.g., Meter, kilogram.
PackUnit	SINGLE	Type of packing. For example, bottle, tin, crate, etc.
ReferenceUnit	SINGLE	Price of purchased item calculated as per the reference unit. Say, you bought 500ml of milk and the price is calculated in reference to 1000ml.
ProductId	SINGLE	Unique identity of the product.
CustomFields	MAP
CustomFieldsJSON	MAP	Custom fields as JSON-Map.
CategoryTreeIds	MULTIPLEVALUE
CategoryBreadcrumbs	MULTIPLEVALUE
CategoryNames	MULTIPLEVALUE
VisibilitySaleschannelIds	MULTIPLEVALUE
PropertyIds	MULTIPLEVALUE
PropertyNamesMap	MAP
OptionIds	MULTIPLEVALUE
OptionNamesMap	MAP
TagIds	MULTIPLEVALUE
TagNames	MULTIPLEVALUE
BlacklistIds	MULTIPLEVALUE
WhitelistIds	MULTIPLEVALUE
AdvancedPricesGross	MAP	Advanced pricing (gross) as map, e.g. ruleId1=11;ruleId2=13.20
AdvancedPricesNet	MAP	Advanced pricing (net) as map, e.g. ruleId1=11;ruleId2=13.20
AdvancedPricesListPriceGross	MAP	Advanced pricing (gross list price) as map, e.g. ruleId1=11;ruleId2=13.20
AdvancedPricesListPriceNet	MAP	Advanced pricing (net list price) as map, e.g. ruleId1=11;ruleId2=13.20
ConfiguratorSettingsIdOptionIdMap	MAP	Map of configurator settings ids and optionId (id1=optionId1;id2=optionId2,...).
ConfiguratorSettingsOptionPriceGrossMap	MAP	Configurator settings (option id=price gross ) as map, e.g. option1=11.00;option2=13.20
ConfiguratorSettingsOptionPriceNetMap	MAP	Configurator settings (option id=price net ) as map, e.g. option1=11.00;option2=13.20
CreatedAt	SINGLE
UpdatedAt	SINGLE
VersionId	SINGLE	Unique identity of the product's version.
ParentVersionId	SINGLE	Unique identity of the parent product's version.