Die Datenbank von Magento ist sehr umfangreich. Um mehr Übersicht über die darin vorhandenen Tabellen zu bekommen, habe ich sie in einem Tabellenbaum zusammengefasst:
- admin
- admin_assert
- admin_role
- admin_rule
- admin_user
- adminnotification
- adminnotification_inbox
- api
- api_assert
- api_role
- api_rule
- api_session
- api_user
- catalog
- category
- anc
- categs
- index
- catalog_category_anc_categs_index_idx
- catalog_category_anc_categs_index_tmp
- index
- products
- index
- catalog_category_anc_products_index_idx
- catalog_category_anc_products_index_tmp
- index
- categs
- catalog_category_entity
- catalog_category_product
- entity
- catalog_category_entity_datetime
- catalog_category_entity_decimal
- catalog_category_entity_int
- catalog_category_entity_text
- catalog_category_entity_varchar
- flat
- store
- catalog_category_flat_store_1
- catalog_category_flat_store_2
- catalog_category_flat_store_3
- store
- product
- catalog_category_product_index
- index
- catalog_category_product_index_idx
- catalog_category_product_index_tmp
- enbl
- catalog_category_product_index_enbl_idx
- catalog_category_product_index_enbl_tmp
- anc
- compare
- catalog_compare_item
- eav
- catalog_eav_attribute
- product
- bundle
- catalog_product_bundle_option
- catalog_product_bundle_selection
- option
- catalog_product_bundle_option_value
- price
- catalog_product_bundle_price_index
- selection
- catalog_product_bundle_selection_price
- stock
- catalog_product_bundle_stock_index
- catalog_product_entity
- catalog_product_link
- catalog_product_option
- catalog_product_relation
- catalog_product_website
- enabled
- catalog_product_enabled_index
- entity
- catalog_product_entity_datetime
- catalog_product_entity_decimal
- catalog_product_entity_gallery
- catalog_product_entity_int
- catalog_product_entity_text
- catalog_product_entity_varchar
- media
- catalog_product_entity_media_gallery
- gallery
- catalog_product_entity_media_gallery_value
- tier
- catalog_product_entity_tier_price
- flat
- catalog_product_flat_1
- catalog_product_flat_2
- catalog_product_flat_3
- index
- catalog_product_index_eav
- catalog_product_index_price
- catalog_product_index_website
- eav
- catalog_product_index_eav_decimal
- catalog_product_index_eav_idx
- catalog_product_index_eav_tmp
- decimal
- catalog_product_index_eav_decimal_idx
- catalog_product_index_eav_decimal_tmp
- price
- bundle
- catalog_product_index_price_bundle_idx
- catalog_product_index_price_bundle_tmp
- opt
- catalog_product_index_price_bundle_opt_idx
- catalog_product_index_price_bundle_opt_tmp
- sel
- catalog_product_index_price_bundle_sel_idx
- catalog_product_index_price_bundle_sel_tmp
- catalog_product_index_price_idx
- catalog_product_index_price_tmp
- cfg
- opt
- agr
- catalog_product_index_price_cfg_opt_agr_idx
- catalog_product_index_price_cfg_opt_agr_tmp
- catalog_product_index_price_cfg_opt_idx
- catalog_product_index_price_cfg_opt_tmp
- agr
- opt
- downlod
- catalog_product_index_price_downlod_idx
- catalog_product_index_price_downlod_tmp
- final
- catalog_product_index_price_final_idx
- catalog_product_index_price_final_tmp
- opt
- agr
- catalog_product_index_price_opt_agr_idx
- catalog_product_index_price_opt_agr_tmp
- catalog_product_index_price_opt_idx
- catalog_product_index_price_opt_tmp
- agr
- bundle
- tier
- catalog_product_index_tier_price
- link
- attribute
- catalog_product_link_attribute_decimal
- catalog_product_link_attribute_int
- catalog_product_link_attribute_varchar
- catalog_product_link_attribute
- catalog_product_link_type
- attribute
- option
- catalog_product_option_price
- catalog_product_option_title
- type
- catalog_product_option_type_price
- catalog_product_option_type_title
- catalog_product_option_type_value
- super
- attribute
- catalog_product_super_attribute_label
- catalog_product_super_attribute_pricing
- catalog_product_super_attribute
- catalog_product_super_link
- attribute
- bundle
- category
- cataloginventory
- cataloginventory_stock
- stock
- cataloginventory_stock_item
- cataloginventory_stock_status
- status
- cataloginventory_stock_status_idx
- cataloginventory_stock_status_tmp
- catalogrule
- affected
- catalogrule_affected_product
- catalogrule
- catalogrule_product
- group
- catalogrule_group_website
- product
- catalogrule_product_price
- affected
- catalogsearch
- catalogsearch_fulltext
- catalogsearch_query
- catalogsearch_result
- checkout
- agreement
- checkout_agreement_store
- checkout_agreement
- agreement
- cms
- block
- cms_block_store
- cms_block
- cms_page
- page
- cms_page_store
- block
- core
- cache
- core_cache_option
- core_cache_tag
- config
- core_config_data
- core_cache
- core_flag
- core_resource
- core_session
- core_store
- core_translate
- core_variable
- core_website
- email
- core_email_template
- layout
- core_layout_link
- core_layout_update
- store
- core_store_group
- url
- core_url_rewrite
- variable
- core_variable_value
- cache
- coupon
- aggregated
- coupon_aggregated_order
- coupon_aggregated_updated
- coupon_aggregated
- aggregated
- cron
- cron_schedule
- customer
- address
- customer_address_entity
- entity
- customer_address_entity_datetime
- customer_address_entity_decimal
- customer_address_entity_int
- customer_address_entity_text
- customer_address_entity_varchar
- customer_entity
- customer_group
- eav
- attribute
- customer_eav_attribute_website
- customer_eav_attribute
- attribute
- entity
- customer_entity_datetime
- customer_entity_decimal
- customer_entity_int
- customer_entity_text
- customer_entity_varchar
- form
- customer_form_attribute
- address
- dataflow
- batch
- dataflow_batch_export
- dataflow_batch_import
- dataflow_batch
- dataflow_profile
- dataflow_session
- import
- dataflow_import_data
- profile
- dataflow_profile_history
- batch
- design
- design_change
- directory
- country
- directory_country_format
- directory_country_region
- region
- directory_country_region_name
- currency
- directory_currency_rate
- directory_country
- country
- downloadable
- downloadable_link
- downloadable_sample
- link
- downloadable_link_price
- downloadable_link_purchased
- downloadable_link_title
- purchased
- downloadable_link_purchased_item
- sample
- downloadable_sample_title
- eav
- attribute
- eav_attribute_group
- eav_attribute_label
- eav_attribute_option
- eav_attribute_set
- option
- eav_attribute_option_value
- eav_attribute
- eav_entity
- entity
- eav_entity_attribute
- eav_entity_datetime
- eav_entity_decimal
- eav_entity_int
- eav_entity_store
- eav_entity_text
- eav_entity_type
- eav_entity_varchar
- form
- eav_form_element
- eav_form_fieldset
- eav_form_type
- fieldset
- eav_form_fieldset_label
- type
- eav_form_type_entity
- attribute
- find
- feed
- import
- find_feed_import_codes
- import
- feed
- gift
- gift_message
- googlebase
- googlebase_attributes
- googlebase_items
- googlebase_types
- googlecheckout
- googlecheckout_notification
- googleoptimizer
- googleoptimizer_code
- importexport
- importexport_importdata
- index
- index_event
- index_process
- process
- index_process_event
- log
- log_customer
- log_quote
- log_summary
- log_url
- log_visitor
- summary
- log_summary_type
- url
- log_url_info
- visitor
- log_visitor_info
- log_visitor_online
- newsletter
- newsletter_problem
- newsletter_queue
- newsletter_subscriber
- newsletter_template
- queue
- newsletter_queue_link
- store
- newsletter_queue_store_link
- paypal
- payment
- paypal_payment_transaction
- paypal_cert
- settlement
- paypal_settlement_report
- report
- paypal_settlement_report_row
- payment
- persistent
- persistent_session
- poll
- poll
- poll_answer
- poll_store
- poll_vote
- product
- alert
- product_alert_price
- product_alert_stock
- alert
- rating
- option
- rating_option_vote
- vote
- rating_option_vote_aggregated
- rating
- rating_entity
- rating_option
- rating_store
- rating_title
- option
- report
- compared
- product
- report_compared_product_index
- product
- event
- report_event_types
- report_event
- viewed
- product
- report_viewed_product_index
- product
- compared
- review
- entity
- review_entity_summary
- review
- review_detail
- review_entity
- review_status
- review_store
- entity
- sales
- bestsellers
- aggregated
- sales_bestsellers_aggregated_daily
- sales_bestsellers_aggregated_monthly
- sales_bestsellers_aggregated_yearly
- aggregated
- billing
- agreement
- sales_billing_agreement_order
- sales_billing_agreement
- agreement
- flat
- creditmemo
- sales_flat_creditmemo_comment
- sales_flat_creditmemo_grid
- sales_flat_creditmemo_item
- invoice
- sales_flat_invoice_comment
- sales_flat_invoice_grid
- sales_flat_invoice_item
- order
- sales_flat_order_address
- sales_flat_order_grid
- sales_flat_order_item
- sales_flat_order_payment
- status
- sales_flat_order_status_history
- quote
- address
- sales_flat_quote_address_item
- item
- sales_flat_quote_item_option
- sales_flat_quote_address
- sales_flat_quote_item
- sales_flat_quote_payment
- shipping
- sales_flat_quote_shipping_rate
- address
- sales_flat_creditmemo
- sales_flat_invoice
- sales_flat_order
- sales_flat_quote
- sales_flat_shipment
- shipment
- sales_flat_shipment_comment
- sales_flat_shipment_grid
- sales_flat_shipment_item
- sales_flat_shipment_track
- creditmemo
- invoiced
- aggregated
- sales_invoiced_aggregated_order
- sales_invoiced_aggregated
- aggregated
- order
- aggregated
- sales_order_aggregated_created
- sales_order_aggregated_updated
- sales_order_status
- sales_order_tax
- status
- sales_order_status_label
- sales_order_status_state
- tax
- sales_order_tax_item
- aggregated
- payment
- sales_payment_transaction
- recurring
- profile
- sales_recurring_profile_order
- sales_recurring_profile
- profile
- refunded
- aggregated
- sales_refunded_aggregated_order
- sales_refunded_aggregated
- aggregated
- shipping
- aggregated
- sales_shipping_aggregated_order
- sales_shipping_aggregated
- aggregated
- bestsellers
- salesrule
- coupon
- salesrule_coupon_usage
- product
- salesrule_product_attribute
- salesrule
- salesrule_coupon
- salesrule_customer
- salesrule_label
- coupon
- sendfriend
- sendfriend_log
- shipping
- shipping_tablerate
- sitemap
- sitemap
- tag
- tag
- tag_properties
- tag_relation
- tag_summary
- tax
- calculation
- rate
- tax_calculation_rate_title
- tax_calculation_rate
- tax_calculation_rule
- rate
- order
- aggregated
- tax_order_aggregated_created
- tax_order_aggregated_updated
- aggregated
- tax_calculation
- tax_class
- calculation
- weee
- weee_discount
- weee_tax
- widget
- instance
- page
- widget_instance_page_layout
- widget_instance_page
- page
- widget
- widget_instance
- instance
- wishlist
- item
- wishlist_item_option
- wishlist
- wishlist_item
- item
- xmlconnect
- config
- xmlconnect_config_data
- notification
- xmlconnect_notification_template
- xmlconnect_application
- xmlconnect_history
- xmlconnect_queue
- config
mich würde mal interessieren, ob man eine Individualisierungsoption für mehere artikel in der datenbank ändern kann. es geht dabei um eine option die für alle artikel als pflichtfeld gelten soll.ist im moment für 60000 artikel auf nein gestellt.
danke und gruß
Bei 60k Artikel würde ich die Anpassung direkt über eine Datenbankabfrage empfehlen.
Wie kann ich producte von eine kategorie löschen ?
Es gibt die Backend-Erweiterung „Enhanced Admin Product Grid“ mit der es möglich ist, Produkte nach Kategorie zu filtern, nach dem man die entsprechende Spalte hinzugefügt hat. Mit Boardmitteln ist es im Backend aber nicht möglich, alle Produkte einer bestimmten Kategorie zu löschen. Zuweisungen Produkt <> Kategorie sind sonst in der Tabelle catalog_category_product gespeichert und können mit einer SQL-Abfrage dort gelöscht werden.
Wie kann ich aus einer Tabelle z.B. den ersten Satz von salesrule_coupon auf eine csh-seite in Magento anzeigen lassen ?
Vielen Dank