{"id":5000,"date":"2019-07-04T12:16:48","date_gmt":"2019-07-04T06:46:48","guid":{"rendered":"https:\/\/phpyouth.com\/blog\/?p=5000"},"modified":"2026-10-07T14:59:19","modified_gmt":"2026-10-07T09:29:19","slug":"remove-wc_sessions-in-woocommerce","status":"publish","type":"post","link":"https:\/\/phpyouth.com\/blog\/remove-wc_sessions-in-woocommerce\/","title":{"rendered":"How to Remove wc_sessions in WooCommerce"},"content":{"rendered":"

Hello friends!
\nToday, in this tutorial, we will learn how to remove sessions in WooCommerce. First, we will discuss why we need to remove these sessions from WooCommerce. These sessions make the wp_options<\/strong> table heavy in size. WooCommerce stores the _wc_session_xxx<\/strong> and _wc_session_expires_xxx<\/strong> entries in the wp_options table.<\/p>\n

There are two reasons behind this, and below are:<\/p>\n

    \n
  1. Cron tasks are not working on the site<\/li>\n
  2. A bot is crawling your site and creating sessions on the fly<\/li>\n<\/ol>\n

    That’s the reason, _wc_session_xxx<\/strong> and _wc_session_expires_xxx<\/strong> entries are stored in the wp_options<\/em> table and make your website Database heavy.<\/p>\n

    We can avoid the bots from creating these sessions while crawling the website. What we have to do is we need to add the following code to the robots.txt<\/strong> file. You can find this file in the website root directory.<\/p>\n

    [sourcecode language=”plain”]
    \nUser-agent: *
    \nDisallow: \/add-to-cart=<\/em>
    \n[\/sourcecode]<\/p>\n

    Let’s see how we can remove these sessions from WooCommerce. There are two ways to do this. Below are:<\/p>\n

      \n
    1. Through the WordPress Dashboard<\/li>\n
    2. From phpMyAdmin<\/li>\n<\/ol>\n

      1. Through the WordPress Dashboard<\/h2>\n

      From the Dashboard, WooCommerce provides a Tool <\/strong>feature through which we can delete these Sessions<\/em>. Here are the steps, please follow:<\/p>\n

        \n
      1. Log in to your website Dashboard. Click Status<\/strong>, sub-menu of WooCommerce, see screenshot below…
        \n\"WooCommerce<\/a><\/li>\n
      2. On the WooCommerce Status<\/em> page, click on the Tools<\/em> tab, Find Clear customer sessions,<\/strong> and beside this, you will see the Clear<\/strong> button, see screenshot below…\"Clear<\/a><\/li>\n
      3. Once you hit the Clear <\/strong>button, all sessions will be deleted automatically.<\/li>\n
      4. But sometimes, the Database is so big that the process of deleting session entries fails because of either low PHP Execution time<\/em> or low Memory limit<\/em>. In that case, we have to delete these sessions from phpMyAdmin<\/em>.<\/li>\n<\/ol>\n

        2 From phpMyAdmin<\/h2>\n

        If your process fails from the WordPress Dashboard, then don’t worry, we can delete these sessions from phpMyAdmin<\/em> as well. We need to run a MySQL query on the wp_options<\/strong> table. Copy below MySQL query below and run it in your database.<\/p>\n

        [sourcecode language=”plain”]
        \nDELETE FROM wp_options
        \nWHERE option_name LIKE 'wc_session<\/em>%' OR option_name LIKE 'wc_session_expires<\/em>%'
        \n[\/sourcecode]<\/p>\n

        At last, if you want to avoid the wp_options<\/strong> table from becoming so big, then make sure that cron isn\u2019t disabled on your website. To do so, please check your WordPress install does NOT contain<\/strong> the line below; if so, then remove it or make FALSE<\/em>:<\/p>\n

        [sourcecode language=”plain”]
        \ndefine('DISABLE_WP_CRON', 'true');
        \n[\/sourcecode]<\/p>\n

        Friends, if you follow these steps, your website will definitely load fast. Please let me know through your comments if this article helps you. Keep learning.<\/p>\n

        \"\"<\/a>\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

        Hello friends! Today, in this tutorial, we will learn how to remove sessions in WooCommerce. First, we will discuss why we need to remove these sessions from WooCommerce. These sessions make the wp_options table heavy in size. WooCommerce stores the _wc_session_xxx and _wc_session_expires_xxx entries in the wp_options table. There are two reasons behind this, and […]<\/p>\n","protected":false},"author":1,"featured_media":5033,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[8,185,4],"tags":[118,188],"class_list":["post-5000","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-plugins","category-woocommerce","category-wordpress","tag-phpmyadmin","tag-woocommerce"],"acf":[],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zepR-1iE","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":5041,"url":"https:\/\/phpyouth.com\/blog\/remove-woocommerce-billing-fields\/","url_meta":{"origin":5000,"position":0},"title":"How to Remove WooCommerce Billing Fields","author":"RK Jajoria","date":"August 8, 2019","format":false,"excerpt":"Hello friends, Good Morning! Today, we are going to learn a WooCommerce trick. This trick is about how to remove WooCommerce billing fields. I want to tell you that WooCommerce is a very powerful WordPress tool that converts a simple website into an E-commerce one. Nowadays, if we look at\u2026","rel":"","context":"In "WooCommerce"","block_context":{"text":"WooCommerce","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/woocommerce\/"},"img":{"alt_text":"Remove WooCommerce billing fields","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/08\/Remove-WooCommerce-billing-fields.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/08\/Remove-WooCommerce-billing-fields.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/08\/Remove-WooCommerce-billing-fields.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":5259,"url":"https:\/\/phpyouth.com\/blog\/list-woocommerce-products-on-google-shopping\/","url_meta":{"origin":5000,"position":1},"title":"List Your Woocommerce Products On Google Shopping","author":"RK Jajoria","date":"June 23, 2022","format":false,"excerpt":"I heard many times that WordPress is not good for creating an online store. However, it is totally a myth. In fact, WordPress allows you to design any website, and you can create your own online store with the help of the WooCommerce plugin. Furthermore, WooCommerce helps online stores connect\u2026","rel":"","context":"In "Plugins"","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"List your woocommerce products on google shopping","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2022\/06\/List-your-woocommerce-products-on-google-shopping.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2022\/06\/List-your-woocommerce-products-on-google-shopping.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2022\/06\/List-your-woocommerce-products-on-google-shopping.webp?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":7060,"url":"https:\/\/phpyouth.com\/blog\/gravity-forms-wordpress-plugin\/","url_meta":{"origin":5000,"position":2},"title":"Gravity Forms WordPress Plugin vs WooCommerce vs MetForm for Event Registration","author":"RK Jajoria","date":"June 24, 2025","format":false,"excerpt":"If you run events on a WordPress site, you need a way to sign people up. Most site owners end up choosing between three tools: the Gravity Forms WordPress plugin, WooCommerce, and MetForm. Each one can handle event registration, but they solve the problem in very different ways. This guide\u2026","rel":"","context":"In "Plugins"","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"Gravity Forms WordPress Plugin vs WooCommerce vs MetForm for Event Registration","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/06\/Gravity-Forms-WordPress-Plugin-vs-WooCommerce-vs-MetForm-for-Event-Registration.webp?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":8596,"url":"https:\/\/phpyouth.com\/blog\/increase-conversions-with-woocommerce-file-upload-features\/","url_meta":{"origin":5000,"position":3},"title":"Increase Conversions with WooCommerce File Upload Features","author":"RK Jajoria","date":"March 26, 2025","format":false,"excerpt":"Have you ever lost a sale because your customers were unable to upload relevant files during the checkout process? In the world of e-commerce, convenience is essential for improving sales conversion numbers. Setting up a file upload WooCommerce solution lets customers submit necessary files seamlessly during checkout, whether that's a\u2026","rel":"","context":"In "Plugins"","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"Phpyout Increase Conversions with WooCommerce File Upload Features","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/02\/Increase-Conversions-with-WooCommerce-File-Upload-Features.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/02\/Increase-Conversions-with-WooCommerce-File-Upload-Features.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/02\/Increase-Conversions-with-WooCommerce-File-Upload-Features.webp?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/02\/Increase-Conversions-with-WooCommerce-File-Upload-Features.webp?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/02\/Increase-Conversions-with-WooCommerce-File-Upload-Features.webp?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":12487,"url":"https:\/\/phpyouth.com\/blog\/best-hosting-for-woocommerce\/","url_meta":{"origin":5000,"position":4},"title":"Best WooCommerce Hosting in 2026","author":"RK Jajoria","date":"May 12, 2026","format":false,"excerpt":"WooCommerce hosting in 2026 means real-world performance, not spec sheets. This guide covers the best hosting for WooCommerce based on real stores we've tested, not just benchmark tools. What Performance Benchmarks Should I Look for in WooCommerce Hosting? When comparing WooCommerce hosting, focus on how the server performs during real\u2026","rel":"","context":"In "Web Hosting"","block_context":{"text":"Web Hosting","link":"https:\/\/phpyouth.com\/blog\/category\/web-hosting\/"},"img":{"alt_text":"Best Hosting for WooCommerce","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/05\/Best-woocommerce-hosting.webp?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":8880,"url":"https:\/\/phpyouth.com\/blog\/10-best-woocommerce-migration-plugins\/","url_meta":{"origin":5000,"position":5},"title":"10 Best WooCommerce Migration Plugins for 2026 (Ranked)","author":"RK Jajoria","date":"May 14, 2025","format":false,"excerpt":"WooCommerce Migration Plugins can make transferring your online store much easier and more secure. Whether you\u2019re moving to a new host, switching domains, or consolidating two WooCommerce stores into one, manually copying products, orders, customers, and coupons is a good way to lose data, break URLs, or spend a weekend\u2026","rel":"","context":"In "Plugins"","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"WooCommerce Migration Plugins","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2025\/05\/10-Best-WooCommerce-Migration-Plugins.webp?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png","_links":{"self":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/5000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/comments?post=5000"}],"version-history":[{"count":1,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/5000\/revisions"}],"predecessor-version":[{"id":13777,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/5000\/revisions\/13777"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media\/5033"}],"wp:attachment":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media?parent=5000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/categories?post=5000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/tags?post=5000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}