ShopwareUpdateProducts - Shopware

Version: 6.4.0.0 - 6.4.20.x

← Shopware Add-On Übersicht

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	Ja
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.	Ja
mappingdefinition	STRING	Die Mapping-Definition	Nein
	Folgende Felder sind zu konfigurieren: Feld Datentyp Beschreibung Pflichtfeld Standardwert 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.