Hallo, ich suche dringend ein Verzeichnis der beteiligten Tabellen in Shopware 4.xx. Habe leider nur eines für Shopware 3 gefunden und das scheint sich deutlich von 4 zu unterscheiden. Vielen Dank.
Was denn, auch die Shopware Entwickler können hierzu nichts sagen? Liebe Grüße Rolf
Die kannst Du Dir doch selbst anzeigen lassen: 1. Mit phpmyadmin die entsprechende Datenbank auswählen und die Tabellen werden links gelistet 2. Auf der Kommandozeile mit mysql: mysql -uDEINUSER -pDEINPASSWORT mysql\> show databases; mysql\> use MEINEDATENBANK; mysql\> show tables; mysql\> show tables; +---------------------------------------------------+ | Tables\_in\_MEINEDATENBANK | +---------------------------------------------------+ | pi\_paymorrow\_orders | | s\_addon\_premiums | | s\_article\_configurator\_dependencies | | s\_article\_configurator\_groups | | s\_article\_configurator\_option\_relations | | s\_article\_configurator\_options | | s\_article\_configurator\_price\_surcharges | | s\_article\_configurator\_set\_group\_relations | | s\_article\_configurator\_set\_option\_relations | | s\_article\_configurator\_sets | | s\_article\_configurator\_template\_prices | | s\_article\_configurator\_template\_prices\_attributes | | s\_article\_configurator\_templates | | s\_article\_configurator\_templates\_attributes | | s\_article\_img\_mapping\_rules | | s\_article\_img\_mappings | | s\_articles | | s\_articles\_attributes | | s\_articles\_avoid\_customergroups | | s\_articles\_categories | | s\_articles\_details | | s\_articles\_downloads | | s\_articles\_downloads\_attributes | | s\_articles\_esd | | s\_articles\_esd\_attributes | | s\_articles\_esd\_serials | | s\_articles\_img | | s\_articles\_img\_attributes | | s\_articles\_information | | s\_articles\_information\_attributes | | s\_articles\_notification | | s\_articles\_prices | | s\_articles\_prices\_attributes | | s\_articles\_relationships | | s\_articles\_similar | | s\_articles\_supplier | | s\_articles\_supplier\_attributes | | s\_articles\_translations | | s\_articles\_vote | | s\_billing\_template | | s\_blog | | s\_blog\_assigned\_articles | | s\_blog\_attributes | | s\_blog\_comments | | s\_blog\_media | | s\_blog\_tags | | s\_campaigns\_articles | | s\_campaigns\_banner | | s\_campaigns\_containers | | s\_campaigns\_groups | | s\_campaigns\_html | | s\_campaigns\_links | | s\_campaigns\_logs | | s\_campaigns\_mailaddresses | | s\_campaigns\_maildata | | s\_campaigns\_mailings | | s\_campaigns\_positions | | s\_campaigns\_sender | | s\_campaigns\_templates | | s\_categories | | s\_categories\_attributes | | s\_categories\_avoid\_customergroups | | s\_cms\_content | | s\_cms\_groups | | s\_cms\_static | | s\_cms\_static\_attributes | | s\_cms\_static\_groups | | s\_cms\_support | | s\_cms\_support\_attributes | | s\_cms\_support\_fields | | s\_core\_acl\_privileges | | s\_core\_acl\_resources | | s\_core\_acl\_roles | | s\_core\_auth | | s\_core\_auth\_attributes | | s\_core\_auth\_roles | | s\_core\_config\_element\_translations | | s\_core\_config\_elements | | s\_core\_config\_form\_translations | | s\_core\_config\_forms | | s\_core\_config\_mails | | s\_core\_config\_mails\_attachments | | s\_core\_config\_mails\_attributes | | s\_core\_config\_values | | s\_core\_countries | | s\_core\_countries\_areas | | s\_core\_countries\_attributes | | s\_core\_countries\_states | | s\_core\_countries\_states\_attributes | | s\_core\_currencies | | s\_core\_customergroups | | s\_core\_customergroups\_attributes | | s\_core\_customergroups\_discounts | | s\_core\_customerpricegroups | | s\_core\_detail\_states | | s\_core\_documents | | s\_core\_documents\_box | | s\_core\_engine\_elements | | s\_core\_engine\_groups | | s\_core\_factory | | s\_core\_licenses | | s\_core\_locales | | s\_core\_log | | s\_core\_menu | | s\_core\_multilanguage | | s\_core\_optin | | s\_core\_paymentmeans | | s\_core\_paymentmeans\_attributes | | s\_core\_paymentmeans\_countries | | s\_core\_paymentmeans\_subshops | | s\_core\_plugins | | s\_core\_pricegroups | | s\_core\_pricegroups\_discounts | | s\_core\_rewrite | | s\_core\_rewrite\_urls | | s\_core\_rulesets | | s\_core\_sessions | | s\_core\_shop\_currencies | | s\_core\_shop\_pages | | s\_core\_shops | | s\_core\_snippets | | s\_core\_states | | s\_core\_subscribes | | s\_core\_tax | | s\_core\_tax\_rules | | s\_core\_templates | | s\_core\_translations | | s\_core\_units | | s\_core\_widget\_views | | s\_core\_widgets | | s\_crontab | | s\_emarketing\_banners | | s\_emarketing\_banners\_attributes | | s\_emarketing\_banners\_statistics | | s\_emarketing\_lastarticles | | s\_emarketing\_partner | | s\_emarketing\_promotion\_articles | | s\_emarketing\_promotion\_banner | | s\_emarketing\_promotion\_containers | | s\_emarketing\_promotion\_html | | s\_emarketing\_promotion\_links | | s\_emarketing\_promotion\_main | | s\_emarketing\_promotion\_positions | | s\_emarketing\_promotions | | s\_emarketing\_referer | | s\_emarketing\_tellafriend | | s\_emarketing\_voucher\_codes | | s\_emarketing\_vouchers | | s\_emarketing\_vouchers\_attributes | | s\_emarketing\_vouchers\_cashed | | s\_emotion | | s\_emotion\_attributes | | s\_emotion\_categories | | s\_emotion\_element | | s\_emotion\_element\_value | | s\_emotion\_grid | | s\_export | | s\_export\_articles | | s\_export\_attributes | | s\_export\_categories | | s\_export\_suppliers | | s\_filter | | s\_filter\_articles | | s\_filter\_attributes | | s\_filter\_options | | s\_filter\_relations | | s\_filter\_values | | s\_library\_component | | s\_library\_component\_field | | s\_media | | s\_media\_album | | s\_media\_album\_settings | | s\_media\_association | | s\_media\_attributes | | s\_order | | s\_order\_attributes | | s\_order\_basket | | s\_order\_basket\_attributes | | s\_order\_billingaddress | | s\_order\_billingaddress\_attributes | | s\_order\_comparisons | | s\_order\_details | | s\_order\_details\_attributes | | s\_order\_documents | | s\_order\_documents\_attributes | | s\_order\_esd | | s\_order\_history | | s\_order\_notes | | s\_order\_number | | s\_order\_shippingaddress | | s\_order\_shippingaddress\_attributes | | s\_plugin\_recommendations | | s\_plugin\_swag\_trusted\_shops\_excellence\_orders | | s\_plugin\_widgets\_notes | | s\_premium\_dispatch | | s\_premium\_dispatch\_attributes | | s\_premium\_dispatch\_categories | | s\_premium\_dispatch\_countries | | s\_premium\_dispatch\_holidays | | s\_premium\_dispatch\_paymentmeans | | s\_premium\_holidays | | s\_premium\_shippingcosts | | s\_search\_fields | | s\_search\_index | | s\_search\_keywords | | s\_search\_tables | | s\_statistics\_currentusers | | s\_statistics\_pool | | s\_statistics\_referer | | s\_statistics\_search | | s\_statistics\_visitors | | s\_user | | s\_user\_attributes | | s\_user\_billingaddress | | s\_user\_billingaddress\_attributes | | s\_user\_debit | | s\_user\_shippingaddress | | s\_user\_shippingaddress\_attributes | +---------------------------------------------------+
Hallo, zunächst vielen Dank. Vielleicht habe ich mich nicht konkret genug ausgedrückt. Ich bräuchte nicht nur die einzelnen Tabellen, sondern noch eine kurze Beschreibung der einzelnen Feldinhalte, so wie hier: http://wiki.shopware.de/Beteiligte-Tabe … l_245.html Hintergund ist der, dass ich versuche herauszufinden welcher Wert in welches Feld bei einer Bestellung, beim Anlegen eines Kunden und beim Anlegen eines neuen Artikels geschrieben wird. LG Rolf
Hallo zusammen, leider ist der Link nicht mehr aktuell, es kommt ein 404. Hat evtl. jemand die Daten noch vorliegen und könnte mir die Seite zur Verfügung stellen? Sonnige Grüße.
Soweit ich weiß existiert so eine Tabelle nicht. Prinzipiell aber sind die meisten Tabellen und Spalten Namen recht eindeutig. Ansonsten einfach mal eine Quatsch Bestellung aufgeben und schauen wo welche Daten landen Gesendet von meinem iPhone mit Tapatalk
Hallo, Evtl. hilft das ER-Diagramm von Shopware 4 weiter? http://wiki.shopware.de/Shopware-4-ER-D … 1_869.html
[quote=„Sysgrade GmbH“]Hallo, Evtl. hilft das ER-Diagramm von Shopware 4 weiter? http://wiki.shopware.de/Shopware-4-ER-D … 1_869.html[/quote] Uh, das schaut gut aus. Vielen Dank für den Link. Vielen Dank auch den anderen für Ihre Antworten. Nicht nur das arbeiten mit dem System bereitet Spaß auch die Community hilft gut mit und Antwortet schnell. Danke schön.