ShopwareAddProducts - Shopware

Version: 6.4.0.0 - 6.4.20.x

← Shopware Add-On Übersicht

Mit diesem Step können Sie Einzelartikel in einem Shopware 6 Shop anlegen.  Um vorhandene Produkte zu aktualisieren, können Sie den Step ShopwareUpdateProducts 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 angelegt 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
autoCreateManufacturers	Sollen neue Hersteller automatisch angelegt werden (Zielspalte 'ManufacturerName')? Wenn die Option aktiviert ist und der Herstellername der Zielspalte ManufacturerName nicht vorhanden ist, wird automatisch ein neuer Hersteller mit diesem Namen angelegt.	Nein	Nein Ja (Standardwert)
autoCreateTax	Sollen neue Steuersätze automatisch angelegt werden (Zielspalte 'TaxRate' )? Wenn die Option aktiviert ist und der Steuersatz der Zielspalte TaxRate nicht vorhanden ist, wird automatisch ein neuer Steuersatz angelegt.	Nein	Nein (Standardwert) Ja

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
ProductNumber	Produktnummer	Ja
Name	Titel des Artikels	Ja
TaxId	ID des Steuersatzes	(Ja) TaxRate oder TaxId
TaxRate	Steuersatz (siehe autoCreateTax Option)	(Ja) TaxRate oder TaxId
Stock	Bestand des Produkts	Ja	0
PriceCurrencyId	Preis Währung	(Ja) PriceCurrencyId oder PriceCurrencyIsoCode	Standardwährung des Systems
PriceCurrencyIsoCode	ISO Code der Währung	(Ja) PriceCurrencyId oder PriceCurrencyIsoCode
PriceGross	Bruttopreis
PriceNet	Nettopreis
PriceLinked	Ist der Netto und Bruttopreis verknüpft ? Ja (true) oder Nein (false)
ListPriceGross	Brutto Streichpreis des Artikel.
ListPriceNet	Netto Streichpreis des Artikel.
ListPriceLinked	Ist der Netto und Brutto Streichpreis verknüpft ? Ja (true) oder Nein (false)
PurchasePriceGross	Einkaufspreis Brutto
PurchasePriceNet	Einkaufspreis Netto (kann nur für Versionen >= 6.3.2.0 gesetzt werden, siehe https://issues.shopware.com/issues/NEXT-9825)
PurchasePriceLinked	Ist der Netto und Brutto Einkaufspreis verknüpft ? Ja (true) oder Nein (false)  (kann nur für Versionen >= 6.3.2.0 gesetzt werden, siehe https://issues.shopware.com/issues/NEXT-9825)
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
ManufacturerName	Name des Herstellers (siehe autoCreateManufacturers Option)
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 angelegt werden sollen. Leer für unbegrenzt.	Nein
productSpreadsheet	SPREADSHEET	Ein SPREADSHEET mit den Artikeldaten die zu Shopware importiert werden sollen.	Ja
mappingdefinition	STRING	Die Mapping-Definition als JSON String	Nein
	Folgende Felder sind zu konfigurieren: Feld Datentyp Beschreibung Pflichtfeld Standardwert Id SINGLE The UUID of new products is generated automatically (empty value) or can optionally be entered here (pattern: ^[0-9a-f]{32}$ ). Nein ProductNumber SINGLE Unique number assigned to individual products. Define rules for automatic assignment of every product creation as per your number range. Ja Name SINGLE Name of the product. Ja TaxId SINGLE Unique identity of tax. Nein TaxRate SINGLE Nein Stock SINGLE Indicates the number of products available. Ja 0 PriceCurrencyId SINGLE Nein PriceCurrencyIsoCode SINGLE Nein PriceGross SINGLE Nein PriceNet SINGLE Nein PriceLinked SINGLE Nein PriceRuleId SINGLE Nein ListPriceGross SINGLE Nein ListPriceNet SINGLE Nein ListPriceLinked SINGLE Nein RegulationPriceGross SINGLE Nein RegulationPriceNet SINGLE Nein RegulationPriceLinked SINGLE Nein PurchasePriceGross SINGLE Nein PurchasePriceNet SINGLE Nein PurchasePriceLinked SINGLE 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 Nein Active SINGLE When boolean value is 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 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 ManufacturerName SINGLE Name 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. 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 Category ids as semicolon separated list of category ids, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac Nein CustomFields MAP Custom product fields as map, e.g. custom_field1=Text1;custom_field2=132 Nein PropertyGroupOptionIds MULTIPLEVALUE Property Group Option Ids as semicolon separated list of property ids, e.g. 25ab9d62bbc346f480549861f0f657b2;cbcee43364b444fb879eb2dd05b280ac Nein
autoCreateManufacturers	STRING	Sollen neue Hersteller automatisch angelegt werden (Zielspalte 'ManufacturerName')?	Nein	Nein Ja
autoCreateTax	STRING	Sollen neue Steuersätze automatisch angelegt werden (Zielspalte 'TaxRate' )?	Nein	Nein Ja

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	Ein SPREADSHEET, dass die erstellten Produkte enthält.
	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.