{"id":7872,"date":"2024-03-15T14:00:00","date_gmt":"2024-03-15T14:00:00","guid":{"rendered":"https:\/\/musilda.cz\/?p=7872"},"modified":"2024-03-15T14:00:00","modified_gmt":"2024-03-15T14:00:00","slug":"struktura-woocommerce-databaze","status":"publish","type":"post","link":"https:\/\/affinite.io\/cs\/struktura-woocommerce-databaze\/","title":{"rendered":"Struktura WooCommerce datab\u00e1ze"},"content":{"rendered":"\n<p>Ned\u00e1vno byl na blogu aktualizov\u00e1n \u010dl\u00e1nek o <a href=\"https:\/\/musilda.cz\/struktura-wordpress-databaze\/\" target=\"_blank\" rel=\"noopener\">struktu\u0159e WordPressu<\/a>, kter\u00fdm by bylo vhodn\u00e9 nejprve za\u010d\u00edt, abychom se nejd\u0159\u00edve dok\u00e1zali orientovat v samotn\u00e9m WordPressu.<\/p>\n\n\n\n<p>Dnes si uk\u00e1\u017eeme p\u0159ehled o struktu\u0159e WooCommerce datab\u00e1ze, kter\u00fd m\u016f\u017ee komukoliv pracuj\u00edc\u00edm s Woo p\u0159ij\u00edt vhod. Pro ostatn\u00ed m\u016f\u017ee poslou\u017eit alespo\u0148 k pochopen\u00ed z\u00e1kladn\u00edch operac\u00ed v datab\u00e1zi.<\/p>\n\n\n\n<p>Zjednodu\u0161en\u00fd diagram WooCommerce datab\u00e1ze s aktivn\u00edm <strong>HPOS<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/musilda.cz\/wp-content\/uploads\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"778\" src=\"https:\/\/musilda.cz\/wp-content\/uploads\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-1024x778.jpg\" alt=\"\" class=\"wp-image-8478\" srcset=\"https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-1024x778.jpg 1024w, https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-300x228.jpg 300w, https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-768x583.jpg 768w, https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-1536x1166.jpg 1536w, https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2024\/03\/struktura-woocommerce-databaze-diagram-aktivni-hpos-2048x1555.jpg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Jak z\u00edskat p\u0159\u00edstup k WooCommerce datab\u00e1zi?<\/h2>\n\n\n\n<p>Budeme pot\u0159ebovat p\u0159\u00edstup k phpMyAdmin, kter\u00fd v\u011bt\u0161inou najdeme v nastaven\u00ed na\u0161eho webhostingu. Levn\u011bj\u0161\u00ed hostitel\u00e9 \u010dasto pou\u017e\u00edvaj\u00ed cPanel. Pro prov\u00e1d\u011bn\u00ed pokro\u010dil\u00fdch SQL dotaz\u016f bude pot\u0159eba WP-CLI(n\u00e1stroj pro p\u0159\u00edkazov\u00fd \u0159\u00e1dek). <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tabulky spojen\u00e9 s produkty a objedn\u00e1vky<\/h2>\n\n\n\n<p>P\u0159i manipulaci s daty tabulek m\u016f\u017ee b\u00fdt zprvu obt\u00ed\u017en\u00e9 se v nich orientovat. Mezi nej\u010dast\u011bji pou\u017e\u00edvan\u00e9 tabulky v tomto ohledu pat\u0159\u00ed <strong><a href=\"#woocommerce_order_items\">woocommerce_order_items<\/a> <\/strong>a <strong><a href=\"#woocommerce_order_itemmeta\">woocommerce_order_itemmeta<\/a><\/strong>, kter\u00fdm se nejsp\u00ed\u0161e nevyhneme. P\u0159i manipulaci s produkty a objedn\u00e1vky bohu\u017eel nejsou jedin\u00e9, kter\u00e9 tato data obsahuj\u00ed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ve kter\u00fdch tabulk\u00e1ch najdeme data o produktech?<\/h3>\n\n\n\n<p>Pokud v tabulk\u00e1ch posts a postmeta nenajdeme \u017e\u00e1dn\u00e9 produkty, nejsp\u00ed\u0161e budeme m\u00edt povolen\u00e9 HPOS v nastaven\u00ed WooCommerce(<strong>WooCommerce &gt; Nastaven\u00ed &gt; Pokro\u010dil\u00e9 &gt; Vlastnosti<\/strong>). <\/p>\n\n\n\n<p>HPOS ji\u017e nen\u00ed z\u00e1visl\u00e9 na tabulce _posts, a p\u0159in\u00e1\u0161\u00ed zcela nov\u00e9 a optimalizovan\u011bj\u0161\u00ed tabulky.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>wc_product_meta_lookup<\/li>\n\n\n\n<li>wc_order_product_lookup<\/li>\n\n\n\n<li>posts<\/li>\n\n\n\n<li>postmeta<\/li>\n<\/ul>\n\n\n\n<p>V p\u0159\u00edpad\u011b aktivn\u00edho HPOS ji\u017e produkty nejsou z\u00e1visl\u00e9 na tabulk\u00e1ch posts a postmeta. Nov\u011b je nahrazuj\u00ed n\u00e1sleduj\u00edc\u00ed tabulky:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>_wc_orders<\/li>\n\n\n\n<li>_wc_order_addresses<\/li>\n\n\n\n<li>_wc_order_operational_data<\/li>\n\n\n\n<li>_wc_orders_meta<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Ve kter\u00fdch tabulk\u00e1ch najdeme data o objedn\u00e1vk\u00e1ch?<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>woocommerce_order_items<\/li>\n\n\n\n<li>woocommerce_order_itemmeta<\/li>\n\n\n\n<li>posts<\/li>\n\n\n\n<li>postmeta<\/li>\n\n\n\n<li>comments<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Souhrn v\u0161ech WooCommerce tabulek:<\/h2>\n\n\n\n<p>N\u00e1sleduj\u00edc\u00ed tabulky jsou automaticky vytvo\u0159eny po aktivaci pluginu WooCommerce. U tabulek se je\u0161t\u011b bude objevovat prefix, kter\u00fd jsme nastavili p\u0159i tvorb\u011b datab\u00e1ze(defaultn\u011b b\u00fdv\u00e1 p\u0159edpona &#8222;wp&#8220;, kterou bych z hlediska bezpe\u010dnosti nedoporu\u010doval).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"#actionscheduler_actions\">actionscheduler_actions<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 informace o akc\u00edch, kter\u00e9 budou provedeny pl\u00e1nova\u010dem akc\u00ed.<\/li>\n\n\n\n<li><strong><a href=\"#actionscheduler_claims\">actionscheduler_claims<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"#actionscheduler_groups\">actionscheduler_groups<\/a><\/strong><\/li>\n\n\n\n<li><a href=\"#actionscheduler_logs\"><strong>actionscheduler_logs<\/strong> <\/a>&#8211; Logy o prov\u00e1d\u011bn\u00ed pl\u00e1nova\u010de akc\u00ed<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_sessions\">woocommerce_sessions<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 nap\u0159\u00edklad data o n\u00e1kupn\u00edch ko\u0161\u00edc\u00edch z\u00e1kazn\u00edk\u016f<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_api_keys\">woocommerce_api_keys<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 API kl\u00ed\u010de pou\u017e\u00edvan\u00e9 pro REST API<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_attribute_taxonomies\">woocommerce_attribute_taxonomies<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 glob\u00e1ln\u00ed n\u00e1zvy atribut\u016f taxonomie pro produkty<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_downloadable_product_permissions\">woocommerce_downloadable_product_permissions<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 p\u0159\u00edstupov\u00e1 opr\u00e1vn\u011bn\u00ed(ud\u011blen\u00e1 po zakoupen\u00ed) k virtu\u00e1ln\u00edm produkt\u016fm ke sta\u017een\u00ed<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_order_items\">woocommerce_order_items<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 polo\u017eky, souvisej\u00edc\u00ed s objedn\u00e1vkami<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_order_itemmeta\">woocommerce_order_itemmeta<\/a><\/strong> &#8211; Metadata o polo\u017ek\u00e1ch objedn\u00e1vky<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_tax_rates\">woocommerce_tax_rates<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 da\u0148ov\u00e9 sazby, kter\u00e9 lze definovat v administraci webu<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_tax_rate_locations\">woocommerce_tax_rate_locations<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 m\u00edsta(PS\u010c a m\u011bsta), kter\u00e1 jsou spojena s v\u00fd\u0161e uveden\u00fdmi da\u0148ov\u00fdmi sazbami<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_shipping_zones\">woocommerce_shipping_zones<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 p\u0159epravn\u00ed z\u00f3ny, kter\u00e9 lze editovat v oblasti nastaven\u00ed<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_shipping_zone_locations\">woocommerce_shipping_zone_locations<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 m\u00edsta spojen\u00e1 s p\u0159epravn\u00edmi z\u00f3nami<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_shipping_zone_methods\">woocommerce_shipping_zone_methods<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 zp\u016fsoby dopravy spojen\u00e9 s p\u0159epravn\u00edmi z\u00f3nami<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_payment_tokens\">woocommerce_payment_tokens<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 platebn\u00ed tokeny z\u00e1kazn\u00edk\u016f<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_payment_tokenmeta\">woocommerce_payment_tokenmeta<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 metadata o platebn\u00edch tokenech<\/li>\n\n\n\n<li><strong><a href=\"#woocommerce_log\">woocommerce_log<\/a><\/strong> &#8211; Obecn\u00e1 tabulka pro \u0159e\u0161en\u00ed logov\u00e1n\u00ed<\/li>\n\n\n\n<li><strong><a href=\"#wc_webhooks\">wc_webhooks<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 v\u0161echny webhooky, kter\u00e9 byly v obchod\u011b nastaveny<\/li>\n\n\n\n<li><strong><a href=\"#wc_download_log\">wc_download_log<\/a><\/strong> &#8211; Ukl\u00e1d\u00e1 z\u00e1znamy o stahov\u00e1n\u00ed digit\u00e1ln\u00edch produkt\u016f<\/li>\n\n\n\n<li><strong><a href=\"#wc_product_meta_lookup\">wc_product_meta_lookup<\/a><\/strong> &#8211; Obsahuje informace o metadatech produkt\u016f<\/li>\n\n\n\n<li><strong><a href=\"#wc_tax_rate_classes\">wc_tax_rate_classes<\/a><\/strong> &#8211; Uchov\u00e1v\u00e1 data o da\u0148ov\u00fdch t\u0159\u00edd\u00e1ch<\/li>\n\n\n\n<li><strong><a href=\"#wc_reserved_stock\">wc_reserved_stock<\/a><\/strong> &#8211; Tabulka slou\u017e\u00ed nap\u0159\u00edklad ke sledov\u00e1n\u00ed n\u00e1vrhu objedn\u00e1vky, produktu a skladov\u00e9ho mno\u017estv\u00ed.<\/li>\n<\/ul>\n\n\n\n<p>V souvislosti s WooCommerce p\u0159ijdou za\u010d\u00e1tkem \u010dervna nov\u00e9 zm\u011bny, kter\u00e9 zcela odstran\u00ed zastaral\u00fd &#8222;Legacy REST API&#8220;! V\u00edce se dozv\u00edte <a href=\"https:\/\/musilda.cz\/legacy-rest-api-se-ve-woocommerce-9-0-jiz-neobjevi\/\" target=\"_blank\" rel=\"noopener\">zde<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Detaily jednotliv\u00fdch tabulek<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"actionscheduler_actions\">Tabulka: actionscheduler_actions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>action_id <\/strong>&#8211; ID<\/li>\n\n\n\n<li><strong>hook <\/strong>&#8211; n\u00e1zev akce nebo ud\u00e1losti<\/li>\n\n\n\n<li><strong>status <\/strong>&#8211; stav akce(nap\u0159\u00edklad &#8222;pending&#8220;)<\/li>\n\n\n\n<li><strong>scheduled_date_gmt <\/strong>&#8211; pl\u00e1novan\u00e9 datum a \u010das akce ve sv\u011btov\u00e9m \u010dase<\/li>\n\n\n\n<li><strong>scheduled_date_local<\/strong> &#8211; pl\u00e1novan\u00e9 datum a \u010das akce v m\u00eds\u00edtn\u00edm \u010dase<\/li>\n\n\n\n<li><strong>args<\/strong> &#8211; argumenty, nebo data spojen\u00e1 s akc\u00ed, kter\u00e1 bude provedena<\/li>\n\n\n\n<li><strong>schedule<\/strong> &#8211; frekvence, s jakou je akce pl\u00e1nov\u00e1na (nap\u0159. &#8222;once&#8220; &#8211; jednou, &#8222;hourly&#8220; &#8211; ka\u017edou hodinu, atd.)<\/li>\n\n\n\n<li><strong>group_id<\/strong> &#8211; ID skupiny<\/li>\n\n\n\n<li><strong>attemps<\/strong> &#8211; po\u010det pokus\u016f o proveden\u00ed akce<\/li>\n\n\n\n<li><strong>last_attempt_gmt<\/strong> &#8211; datum a \u010das posledn\u00edho pokusu o proveden\u00ed akce ve sv\u011btov\u00e9m \u010dase<\/li>\n\n\n\n<li><strong>last_attempt_local<\/strong> &#8211; datum a \u010das posledn\u00edho pokusu o proveden\u00ed akce v m\u00edstn\u00edm \u010dase<\/li>\n\n\n\n<li><strong>claim_id<\/strong><\/li>\n\n\n\n<li><strong>extended_args<\/strong> &#8211; roz\u0161\u00ed\u0159en\u00ed argument\u016f a dal\u0161\u00edch dat spojen\u00fdch s akc\u00ed<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"actionscheduler_claims\">Tabulka: actionscheduler_claims<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>claim_id<\/strong> &#8211; ID<\/li>\n\n\n\n<li><strong>date_created_gmt<\/strong> &#8211; datum a \u010das vytvo\u0159en\u00ed n\u00e1roku ve sv\u011btov\u00e9m \u010dase<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"actionscheduler_groups\">Tabulka: actionscheduler_groups<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>group_id<\/strong> &#8211; ID<\/li>\n\n\n\n<li><strong>slug<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"actionscheduler_logs\">Tabulka: actionscheduler_logs<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>log_id<\/strong> &#8211; ID<\/li>\n\n\n\n<li><strong>action_id<\/strong> &#8211; ID akce<\/li>\n\n\n\n<li><strong>message<\/strong> &#8211; popis ud\u00e1losti<\/li>\n\n\n\n<li><strong>log_date_gmt<\/strong> &#8211; datum a \u010das vytvo\u0159en\u00ed z\u00e1znamu v logu ve sv\u011btov\u00e9m \u010dase<\/li>\n\n\n\n<li><strong>log_date_local<\/strong> &#8211; datum a \u010das vytvo\u0159en\u00ed z\u00e1znamu v logu v m\u00edstn\u00edm \u010dase<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_sessions\">Tabulka: woocommerce_sessions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>session_id<\/strong> &#8211; ID<\/li>\n\n\n\n<li><strong>session_key<\/strong> &#8211; kl\u00ed\u010d, kter\u00fd slou\u017e\u00ed k identifikaci u\u017eivatelsk\u00e9 relace<\/li>\n\n\n\n<li><strong>session_value<\/strong> &#8211; ur\u010dit\u00e1 hodnota spojena s danou relac\u00ed<\/li>\n\n\n\n<li><strong>session_expiry<\/strong> &#8211; datum a \u010das, kdy relace vypr\u0161\u00ed a bude pova\u017eov\u00e1na za neplatnou<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_api_keys\">Tabulka: woocommerce_api_keys<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>key_id<\/strong> &#8211; unik\u00e1tn\u00ed identifik\u00e1tor ka\u017ed\u00e9ho API kl\u00ed\u010de<\/li>\n\n\n\n<li><strong>user_id<\/strong> &#8211; identifik\u00e1tor u\u017eivatele, kter\u00fd dan\u00fd API kl\u00ed\u010d vytvo\u0159il <\/li>\n\n\n\n<li><strong>description<\/strong> &#8211; popis API kl\u00ed\u010de<\/li>\n\n\n\n<li><strong>permission<\/strong> &#8211; opr\u00e1vn\u011bn\u00ed nebo pr\u00e1va spojen\u00e1 s API kl\u00ed\u010dem<\/li>\n\n\n\n<li><strong>consumer_key<\/strong> &#8211; unik\u00e1tn\u00ed identifik\u00e1tor spot\u0159ebitele souvisej\u00edc\u00edho s API kl\u00ed\u010dem<\/li>\n\n\n\n<li><strong>consumer_secret<\/strong> &#8211; tajn\u00fd kl\u00ed\u010d, kter\u00fd spolu s consumer_key slou\u017e\u00ed k ov\u011b\u0159en\u00ed identity spot\u0159ebitele<\/li>\n\n\n\n<li><strong>nonces<\/strong> &#8211; je n\u00e1hodn\u00fd \u010d\u00edseln\u00fd \u0159et\u011bzec, kter\u00fd se pou\u017e\u00edv\u00e1 k prevenci opakovan\u00e9ho pou\u017eit\u00ed stejn\u00e9 \u017e\u00e1dosti<\/li>\n\n\n\n<li><strong>truncated_key<\/strong> &#8211; zkr\u00e1cen\u00fd podoba kl\u00ed\u010de pro zobrazen\u00ed<\/li>\n\n\n\n<li><strong>last_access<\/strong> &#8211; datum a \u010das posledn\u00edho p\u0159\u00edstupu, nebo pou\u017eit\u00ed API kl\u00ed\u010de<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_attribute_taxonomies\">Tabulka: woocommerce_attribute_taxonomies<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>attribute_id<\/strong> &#8211; ID <\/li>\n\n\n\n<li><strong>attribute_name<\/strong> &#8211; n\u00e1zev atributu<\/li>\n\n\n\n<li><strong>attribute_label<\/strong> &#8211; popisek atributu<\/li>\n\n\n\n<li><strong>attribute_type<\/strong> &#8211; typ atributu<\/li>\n\n\n\n<li><strong>attribute_orderby<\/strong> &#8211; zp\u016fsob \u0159azen\u00ed produkt\u016f podle tohoto atributu<\/li>\n\n\n\n<li><strong>attribute_public<\/strong> &#8211; ur\u010duje, zda je da\u0148ov\u00fd atribut ve\u0159ejn\u011b viditeln\u00fd<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_downloadable_product_permissions\">Tabulka: woocommerce_downloadable_product_permissions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>permission_id<\/strong> &#8211; ID ka\u017ed\u00e9ho opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed<\/li>\n\n\n\n<li><strong>download_id<\/strong> &#8211; ID sta\u017eiteln\u00e9ho produktu, ke kter\u00e9mu je toto opr\u00e1vn\u011bn\u00ed p\u0159i\u0159azeno<\/li>\n\n\n\n<li><strong>product_id<\/strong> &#8211; ID produktu, ke kter\u00e9mu se toto opr\u00e1vn\u011bn\u00ed vztahuje<\/li>\n\n\n\n<li><strong>order_id<\/strong> &#8211; ID objedn\u00e1vky, ve kter\u00e9 byl sta\u017eiteln\u00fd produkt zakoupen<\/li>\n\n\n\n<li><strong>order_key<\/strong> &#8211; unik\u00e1tn\u00ed kl\u00ed\u010d objedn\u00e1vky<\/li>\n\n\n\n<li><strong>user_email<\/strong> &#8211; e-mailov\u00e1 adresa u\u017eivatele, kter\u00fd m\u00e1 opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed<\/li>\n\n\n\n<li><strong>user_id<\/strong> &#8211; identifik\u00e1tor u\u017eivatele, ke kter\u00e9mu je opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed p\u0159i\u0159azeno<\/li>\n\n\n\n<li><strong>downloads_remaining<\/strong> &#8211; po\u010det zb\u00fdvaj\u00edc\u00edch stahov\u00e1n\u00ed povolen\u00fdch t\u00edmto opr\u00e1vn\u011bn\u00edm<\/li>\n\n\n\n<li><strong>access_granted<\/strong> &#8211; datum a \u010das, kdy bylo opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed ud\u011bleno<\/li>\n\n\n\n<li><strong>access_expires<\/strong> &#8211; datum a \u010das, kdy opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed vypr\u0161\u00ed a ji\u017e nebude platn\u00e9<\/li>\n\n\n\n<li><strong>download_count<\/strong> &#8211; celkov\u00fd po\u010det stahov\u00e1n\u00ed proveden\u00fdch pomoc\u00ed tohoto opr\u00e1vn\u011bn\u00ed<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_order_items\">Tabulka: woocommerce_order_items<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>order_item_id<\/strong> &#8211; ID objedn\u00e1vky<\/li>\n\n\n\n<li><strong>order_item_name<\/strong> &#8211; n\u00e1zev polo\u017eky objedn\u00e1vky<\/li>\n\n\n\n<li><strong>order_item_type<\/strong> &#8211; Typ polo\u017eky objedn\u00e1vky, kter\u00fd m\u016f\u017ee ozna\u010dovat, zda se jedn\u00e1 o produkt, slu\u017ebu, slevu atd.<\/li>\n\n\n\n<li><strong>order_id<\/strong> &#8211; ID objedn\u00e1vky, ke kter\u00e9 polo\u017eka n\u00e1le\u017e\u00ed<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_order_itemmeta\">Tabulka: woocommerce_order_itemmeta<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>meta_id<\/strong> &#8211; ID z\u00e1znamu v metadatech<\/li>\n\n\n\n<li><strong>order_item_id<\/strong> &#8211; ID polo\u017eky objedn\u00e1vky<\/li>\n\n\n\n<li><strong>meta_key<\/strong> &#8211; Kl\u00ed\u010d metadat<\/li>\n\n\n\n<li><strong>meta_value<\/strong> &#8211; hodnota metadata, obsahuj\u00edc\u00ed samotnou informaci<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_tax_rates\">Tabulka: woocommerce_tax_rates<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>tax_rate_id<\/strong> &#8211; ID ka\u017ed\u00e9 da\u0148ov\u00e9 sazby<\/li>\n\n\n\n<li><strong>tax_rate_country<\/strong> &#8211; zem\u011b, na kterou se dan\u00e1 da\u0148ov\u00e1 sazba vztahuje<\/li>\n\n\n\n<li><strong>tax_rate_state<\/strong> &#8211; st\u00e1t nebo region v r\u00e1mci zem\u011b, ke kter\u00e9mu se da\u0148ov\u00e1 sazba vztahuje<\/li>\n\n\n\n<li><strong>tax_rate<\/strong> &#8211; hodnota da\u0148ov\u00e9 sazby vyj\u00e1d\u0159en\u00e1 v procentech<\/li>\n\n\n\n<li><strong>tax_rate_name<\/strong> &#8211; n\u00e1zev, nebo popis da\u0148ov\u00e9 sazby<\/li>\n\n\n\n<li><strong>tax_rate_priority<\/strong> &#8211; priorita da\u0148ov\u00e9 sazby v p\u0159\u00edpad\u011b, \u017ee existuj\u00ed sazby, kter\u00e9 se vz\u00e1jemn\u011b p\u0159ekr\u00fdvaj\u00ed<\/li>\n\n\n\n<li><strong>tax_rate_compound<\/strong> &#8211; ur\u010duje, zda se dan\u00e1 da\u0148ov\u00e1 sazba pou\u017eije i na ji\u017e zdan\u011bn\u00e9 \u010d\u00e1stky (slo\u017een\u00e1 da\u0148)<\/li>\n\n\n\n<li><strong>tax_rate_shipping<\/strong> &#8211; ur\u010duje, zda se dan\u00e1 da\u0148ov\u00e1 sazba vztahuje na n\u00e1klady na dopravu<\/li>\n\n\n\n<li><strong>tax_rate_order<\/strong> &#8211; po\u0159ad\u00ed, ve kter\u00e9m jsou aplikov\u00e1ny da\u0148ov\u00e9 sazby<\/li>\n\n\n\n<li><strong>tax_rate_class<\/strong> &#8211; T\u0159\u00edda nebo kategorie da\u0148ov\u00e9 sazby<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_tax_rate_locations\">Tabulka: woocommerce_tax_rate_locations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>location_id<\/strong> &#8211; ID<\/li>\n\n\n\n<li><strong>location_code<\/strong> &#8211; k\u00f3d, nebo ozna\u010den\u00ed geografick\u00e9ho um\u00edst\u011bn\u00ed, ke kter\u00e9mu se da\u0148ov\u00e1 sazba vztahuje<\/li>\n\n\n\n<li><strong>tax_rate_id<\/strong> &#8211; ID da\u0148ov\u00e9 sazby, ke kter\u00e9 je toto um\u00edst\u011bn\u00ed p\u0159i\u0159azeno<\/li>\n\n\n\n<li><strong>location_type<\/strong> &#8211; typ um\u00edst\u011bn\u00ed, m\u016f\u017ee b\u00fdt nap\u0159. &#8222;country&#8220; (zem\u011b), &#8222;state&#8220; (st\u00e1t)&#8230;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_shipping_zones\">Tabulka: woocommerce_shipping_zones<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>zone_id<\/strong> &#8211; ID ka\u017ed\u00e9 dopravn\u00ed z\u00f3ny<\/li>\n\n\n\n<li><strong>zone_name<\/strong> &#8211; n\u00e1zev dopravn\u00ed z\u00f3ny<\/li>\n\n\n\n<li><strong>zone_order<\/strong> &#8211; po\u0159ad\u00ed, ve kter\u00e9m jsou dopravn\u00ed z\u00f3ny zobrazeny nebo aplikov\u00e1ny<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_shipping_zone_locations\">Tabulka: woocommerce_shipping_zone_locations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>location_id<\/strong> -ID z\u00e1znamu v tabulce<\/li>\n\n\n\n<li><strong>zone_id<\/strong> &#8211; ID dopravn\u00ed z\u00f3ny <\/li>\n\n\n\n<li><strong>location_code<\/strong> &#8211; k\u00f3d, nebo ozna\u010den\u00ed geografick\u00e9ho um\u00edst\u011bn\u00ed<\/li>\n\n\n\n<li><strong>location_type<\/strong> &#8211; typ um\u00edst\u011bn\u00ed(zem\u011b, st\u00e1t&#8230;)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_shipping_zone_methods\">Tabulka: woocommerce_shipping_zone_methods<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>zone_id<\/strong> &#8211; ID dopravn\u00ed z\u00f3ny, ke kter\u00e9 jsou tyto metody p\u0159i\u0159azeny<\/li>\n\n\n\n<li><strong>instance_id<\/strong> &#8211; ID ka\u017ed\u00e9 instance dopravn\u00ed metody v r\u00e1mci dan\u00e9 z\u00f3ny<\/li>\n\n\n\n<li><strong>method_id<\/strong> &#8211; ID konkr\u00e9tn\u00ed dopravn\u00ed metody<\/li>\n\n\n\n<li><strong>method_order<\/strong> &#8211; po\u0159ad\u00ed, ve kter\u00e9m jsou tyto metody zobrazeny nebo aplikov\u00e1ny v r\u00e1mci z\u00f3ny<\/li>\n\n\n\n<li><strong>is_enabled<\/strong> &#8211; ur\u010duje, zda je tato dopravn\u00ed metoda povolena, nebo zak\u00e1z\u00e1na<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_payment_tokens\">Tabulka: woocommerce_payment_tokens<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>token_id<\/strong> &#8211; ID platebn\u00edho tokenu<\/li>\n\n\n\n<li><strong>gateway_id<\/strong> &#8211; ID platebn\u00ed br\u00e1ny, ke kter\u00e9 je tento token p\u0159i\u0159azen<\/li>\n\n\n\n<li><strong>token<\/strong> &#8211; samotn\u00fd platebn\u00ed token nebo k\u00f3d, kter\u00fd je pou\u017e\u00edv\u00e1n k identifikaci platebn\u00ed karty nebo jin\u00e9ho zp\u016fsobu platby<\/li>\n\n\n\n<li><strong>user_id<\/strong> &#8211; ID u\u017eivatele, ke kter\u00e9mu je tento platebn\u00ed token p\u0159i\u0159azen<\/li>\n\n\n\n<li><strong>type<\/strong> &#8211; typ platebn\u00edho tokenu<\/li>\n\n\n\n<li><strong>is_default<\/strong> &#8211; ur\u010duje, zda je tento platebn\u00ed token nastaven jako v\u00fdchoz\u00ed pro dan\u00e9ho u\u017eivatele<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_payment_tokenmeta\">Tabulka: woocommerce_payment_tokenmeta<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>meta_id<\/strong> &#8211; ID z\u00e1znamu<\/li>\n\n\n\n<li><strong>payment_token_id<\/strong> &#8211; ID platebn\u00edho tokenu<\/li>\n\n\n\n<li><strong>meta_key<\/strong> &#8211; kl\u00ed\u010d metadat<\/li>\n\n\n\n<li><strong>meta_value<\/strong> &#8211; hodnora metadat obsahuj\u00edc\u00ed samostatnou indormaci<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"woocommerce_log\">Tabulka: woocommerce_log<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>log_id<\/strong> &#8211; ID z\u00e1zamu<\/li>\n\n\n\n<li><strong>timestamp<\/strong> &#8211; timestamp ud\u00e1losti, kdy do\u0161lo k logov\u00e1n\u00ed<\/li>\n\n\n\n<li><strong>level<\/strong> &#8211; \u00farove\u0148 d\u016fle\u017eitosti nebo z\u00e1va\u017enosti z\u00e1znamu<\/li>\n\n\n\n<li><strong>source<\/strong> &#8211; zdroj nebo m\u00edsto, kde do\u0161lo k dan\u00e9 ud\u00e1losti nebo chyb\u011b<\/li>\n\n\n\n<li><strong>message<\/strong> &#8211; textov\u00e1 zpr\u00e1va nebo popis ud\u00e1losti nebo chyby<\/li>\n\n\n\n<li><strong>context<\/strong> &#8211; kontext nebo dal\u0161\u00ed informace spojen\u00e9 s ud\u00e1lost\u00ed, kter\u00e9 mohou b\u00fdt u\u017eite\u010dn\u00e9 p\u0159i diagnostice<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"wc_webhooks\">Tabulka: wc_webhooks<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>webhook_id<\/strong> &#8211; ID webhooku<\/li>\n\n\n\n<li><strong>status<\/strong> &#8211; stav webhooku, nap\u0159\u00edklad aktivn\u00ed, nebo deaktivovan\u00fd<\/li>\n\n\n\n<li><strong>name<\/strong> &#8211; n\u00e1zev webhooku<\/li>\n\n\n\n<li><strong>user_id<\/strong> &#8211; ID u\u017eivatele, kter\u00fd vytvo\u0159il dan\u00fd webhook<\/li>\n\n\n\n<li><strong>delivery_url<\/strong> &#8211; URL adresa, na kterou jsou pos\u00edl\u00e1na ozn\u00e1men\u00ed (payload) ud\u00e1lost\u00ed<\/li>\n\n\n\n<li><strong>secret<\/strong> &#8211; tajn\u00fd kl\u00ed\u010d pou\u017e\u00edvan\u00fd k ov\u011b\u0159en\u00ed autenti\u010dnosti webhooku<\/li>\n\n\n\n<li><strong>topic<\/strong> &#8211; ur\u010duje, na jakou ud\u00e1lost m\u00e1 reagovat<\/li>\n\n\n\n<li><strong>date_created<\/strong> &#8211; datum a \u010das vytvo\u0159en\u00ed webhooku<\/li>\n\n\n\n<li><strong>date_created_gmt<\/strong> &#8211; datum a \u010das vytvo\u0159en\u00ed webhooku ve sv\u011btov\u00e9m \u010dase<\/li>\n\n\n\n<li><strong>date_modified<\/strong> &#8211; datum a \u010das posledn\u00ed \u00fapravy webhooku<\/li>\n\n\n\n<li><strong>date_modified_gmt<\/strong> &#8211; datum a \u010das posledn\u00ed \u00fapravy webhooku ve sv\u011btov\u00e9m \u010dase<\/li>\n\n\n\n<li><strong>api_version<\/strong> &#8211; verze API pou\u017e\u00edvan\u00e1 pro tento webhook<\/li>\n\n\n\n<li><strong>failure_count<\/strong> &#8211; po\u010det ne\u00fasp\u011b\u0161n\u00fdch pokus\u016f o doru\u010den\u00ed webhooku<\/li>\n\n\n\n<li><strong>pending_delivery<\/strong> &#8211; ur\u010duje, zda je webhook ve front\u011b pro odesl\u00e1n\u00ed (true\/false)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"wc_download_log\">Tabulka: wc_download_log<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>download_log_id<\/strong> &#8211; ID z\u00e1znamu<\/li>\n\n\n\n<li><strong>timestamp<\/strong> &#8211; ur\u010duje, kdy do\u0161lo ke sta\u017een\u00ed<\/li>\n\n\n\n<li><strong>permission_id<\/strong> &#8211; ID opr\u00e1vn\u011bn\u00ed ke sta\u017een\u00ed, kter\u00e9 je propojeno s digit\u00e1ln\u00edm produktem<\/li>\n\n\n\n<li><strong>user_id<\/strong> &#8211; ID u\u017eivatele, kter\u00fd provedl sta\u017een\u00ed<\/li>\n\n\n\n<li><strong>user_ip_address<\/strong> &#8211; IP adresa u\u017eivatele, kter\u00fd provedl sta\u017een\u00ed<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"wc_product_meta_lookup\">Tabulka: wc_product_meta_lookup<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>product_id<\/strong> &#8211; ID produktu, ke kter\u00e9mu jsou tyto metainformace p\u0159i\u0159azen<\/li>\n\n\n\n<li><strong>sku<\/strong> &#8211; ozna\u010den\u00ed pro skladov\u00e1n\u00ed a sledov\u00e1n\u00ed z\u00e1sob<\/li>\n\n\n\n<li><strong>virtual<\/strong> &#8211; ur\u010duje, zda je produkt virtu\u00e1ln\u00ed (true\/false), kdy produkt nem\u00e1 fyzickou podobu<\/li>\n\n\n\n<li><strong>downloadable<\/strong> &#8211; ur\u010duje, zda je produkt sta\u017eiteln\u00fd (true\/false)<\/li>\n\n\n\n<li><strong>min_price<\/strong> &#8211; nejni\u017e\u0161\u00ed cena produktu<\/li>\n\n\n\n<li><strong>max_price<\/strong> &#8211; nejvy\u0161\u0161\u00ed cena produktu<\/li>\n\n\n\n<li><strong>onsale<\/strong> &#8211; ur\u010duje, zda je produkt ve slev\u011b (true\/false)<\/li>\n\n\n\n<li><strong>stock_quantity<\/strong> &#8211; mno\u017estv\u00ed z\u00e1sob produktu<\/li>\n\n\n\n<li><strong>stock_status<\/strong> &#8211; stav dostupnosti z\u00e1sob produktu<\/li>\n\n\n\n<li><strong>rating_count<\/strong> &#8211; po\u010det hodnocen\u00ed produktu<\/li>\n\n\n\n<li><strong>average_rating<\/strong> &#8211; pr\u016fm\u011brn\u00e9 hodnocen\u00ed produktu<\/li>\n\n\n\n<li><strong>total_sales<\/strong> &#8211; celkov\u00fd po\u010det prodan\u00fdch kus\u016f produktu<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"wc_tax_rate_classes\">Tabulka: wc_tax_rate_classes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>tax_rate_class_id<\/strong> &#8211; ID t\u0159\u00eddy da\u0148ov\u00fdch sazeb<\/li>\n\n\n\n<li><strong>name<\/strong> &#8211; n\u00e1zev t\u0159\u00eddy da\u0148ov\u00fdch sazeb<\/li>\n\n\n\n<li><strong>slug<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"wc_reserved_stock\">Tabulka: wc_reserved_stock<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>order_id<\/strong> &#8211; ID objedn\u00e1vky, ke kter\u00e9 je rezervovan\u00e9 skladov\u00e9 mno\u017estv\u00ed p\u0159i\u0159azeno<\/li>\n\n\n\n<li><strong>product_id<\/strong> &#8211; ID produktu, pro kter\u00fd je rezervovan\u00e9 skladov\u00e9 mno\u017estv\u00ed ur\u010deno<\/li>\n\n\n\n<li><strong>stock_quantity<\/strong> &#8211; mno\u017estv\u00ed produktu, kter\u00e9 je rezervov\u00e1no<\/li>\n\n\n\n<li><strong>timestamp<\/strong><\/li>\n\n\n\n<li><strong>expires<\/strong> &#8211; datum a \u010das, kdy rezervace vypr\u0161\u00ed a bude uvoln\u011bna<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Z\u00e1v\u011br<\/h2>\n\n\n\n<p>WooCommerce je jedn\u00edm z nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00edch plugin\u016f pro e-shopy ve WordPressu, a proto m\u016f\u017ee b\u00fdt znalost jeho datab\u00e1ze u\u017eite\u010dn\u00e1 nap\u0159\u00edklad p\u0159i \u0159e\u0161en\u00ed probl\u00e9m\u016f, optimalizaci, nebo p\u0159i pokro\u010dil\u00fdch \u00faprav\u00e1ch WooCommerce e-shopu.<\/p>\n\n\n\n<p>Rovn\u011b\u017e doporu\u010duji p\u0159e\u010d\u00edst <a href=\"https:\/\/musilda.cz\/struktura-wordpress-databaze\/\" target=\"_blank\" rel=\"noopener\">\u010dl\u00e1nek o fungov\u00e1n\u00ed WordPress datab\u00e1ze<\/a>, pokud jste je\u0161t\u011b ne\u010detli.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ned\u00e1vno byl na blogu aktualizov\u00e1n \u010dl\u00e1nek o struktu\u0159e WordPressu, kter\u00fdm by bylo vhodn\u00e9 nejprve za\u010d\u00edt, abychom se nejd\u0159\u00edve dok\u00e1zali orientovat v samotn\u00e9m WordPressu. Dnes si uk\u00e1\u017eeme p\u0159ehled o struktu\u0159e WooCommerce datab\u00e1ze, kter\u00fd m\u016f\u017ee komukoliv pracuj\u00edc\u00edm s Woo p\u0159ij\u00edt vhod. Pro ostatn\u00ed m\u016f\u017ee poslou\u017eit alespo\u0148 k pochopen\u00ed z\u00e1kladn\u00edch operac\u00ed v datab\u00e1zi. Zjednodu\u0161en\u00fd diagram WooCommerce datab\u00e1ze s<\/p>\n","protected":false},"author":1,"featured_media":7976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-7872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-woocommerce"],"_links":{"self":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/7872"}],"collection":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/comments?post=7872"}],"version-history":[{"count":0,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/7872\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media\/7976"}],"wp:attachment":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media?parent=7872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/categories?post=7872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/tags?post=7872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}