birblogcu

Hello, thank you very much for your response. @carolm29

Actually, I don’t want to completely remove the woocommerce plugin. (I think the article in the link you provided is about this) As I mentioned in the subject, I set up a WordPress multisite network to create many e-commerce sites and enabled Woocommerce for all subsites to be created throughout the network.

However, when a subsite that will no longer be used is deleted from the network, many of the Woocommerce tables created for this subsite in the database are deleted, but not all of them are deleted. (Tables mentioned in the subject.)

And yes I have some concerns about woocommerce and database. For example, when a subsite is created in the multisite network, dozens of Woocommerce tables are created for this subsite in the database. Since all sites use the same database, it may cause some performance problems as the network grows.

Tables created in the database when a subsite is created in the network;

wp_38_actionscheduler_actions
wp_38_actionscheduler_claims
wp_38_actionscheduler_groups
wp_38_actionscheduler_logs
wp_38_commentmeta
wp_38_comments
wp_38_links
wp_38_options
wp_38_postmeta
wp_38_posts
wp_38_termmeta
wp_38_terms
wp_38_term_relationships
wp_38_term_taxonomy
wp_38_wc_admin_notes
wp_38_wc_admin_note_actions
wp_38_wc_category_lookup
wp_38_wc_customer_lookup
wp_38_wc_download_log
wp_38_wc_orders
wp_38_wc_orders_meta
wp_38_wc_order_addresses
wp_38_wc_order_coupon_lookup
wp_38_wc_order_operational_data
wp_38_wc_order_product_lookup
wp_38_wc_order_stats
wp_38_wc_order_tax_lookup
wp_38_wc_product_attributes_lookup
wp_38_wc_product_download_directories
wp_38_wc_product_meta_lookup
wp_38_wc_rate_limits
wp_38_wc_reserved_stock
wp_38_wc_tax_rate_classes
wp_38_wc_webhooks
wp_38_woocommerce_api_keys
wp_38_woocommerce_attribute_taxonomies
wp_38_woocommerce_downloadable_product_permissions
wp_38_woocommerce_log
wp_38_woocommerce_order_itemmeta
wp_38_woocommerce_order_items
wp_38_woocommerce_payment_tokenmeta
wp_38_woocommerce_payment_tokens
wp_38_woocommerce_sessions
wp_38_woocommerce_shipping_zones
wp_38_woocommerce_shipping_zone_locations
wp_38_woocommerce_shipping_zone_methods
wp_38_woocommerce_square_customers
wp_38_woocommerce_tax_rates
wp_38_woocommerce_tax_rate_locations

Here 40 tables are created just for woocommerce. Actually, we do not use all the functions of Woocommerce. Considering that we have created hundreds of sites on the network, there will be tens of thousands of tables in the database.

At least when we delete a subsite that we will not use, it may be a good solution to completely delete all the tables belonging to this subsite.

Also, the wp_38_options table has a size of 2 MB and when I examine this table, there are hundreds of rows related to woocommerce. (“_transient_wc_report..”, _transient_timeout_wc_admin..”,”_transient_wc_report_orders_stats”,woocommerce_woocommerce_payments_settings, woocommerce_myaccount_edit_address_endpoint” etc.)

Woocommerce has a lot of records in its database and it’s just for a subsite that hasn’t made any sales yet. Woocommerce’s database issues seem a bit difficult to deal with.

Hello, thank you for your response. @afzalpansuvi

The Woocommerce plugin is enabled for subsites but I don’t want to use the recommended plugins. For this reason, I wanted to remove the plugins recommended from the woocoomerce installation wizard and on other pages.

I added this code as a mu-plugin, but the recommended plugins step is still displayed in the woocommerce installation wizard. It would be great to complete the installation without viewing this step.

<?php
add_filter( 'woocommerce_setup_wizard_recommended_plugins', '__return_empty_array' );

Thank you very much for your help @shameemreza

Hello,

Thank you very much for your response. I saw that I could do this by setting capabilities for users with the user role editor, but I could not find all the Woocommerce capabilities for the users. For example, I found the “manage_woocommerce” and “view_woocommerce_reports” capabilities apart from the capabilities that the user role editor adds by default. However, when I enable these capabilities, the user can still access almost all the features of Woocommerce. I want to make this more specific. For example, showing only the “customers” option. However, the “view_woocommerce_reports” ability offers access to the “customers” page along with many other options. Additionally, the status page can still be accessed.

Where can I find all of Woocommerce’s skill names? I checked the repo on Github but it’s really hard to find them there.

Hello, thank you very much for your response.
I tried to do this using the User role editor plugin but I couldn’t block access to the status and extensions pages for the subsite admin/user, for example.

Hello @olgabulat

WordPress system emails are already sent automatically by default. I just use smtp to send these emails. What I want to do is change the content of the emails sent, not the template/design. WordPress doesn’t provide options in network manager to change the content of some system emails like user authentication. (We can only edit the content of the welcome email from the panel.)

@mayuripatel This is not what I want. “I want to edit the content of system emails”. this plugin just helps us to change the template.

@bcworkz

Thanks for your response.

I am creating the site network with subdomains and there is a wildcard DNS record. I tried the piece of code in your message and still it wasn’t redirected to the home page when the user typed in a non-subdomain.

@bcworkz Hi, thank you for your answer but I am getting the same result. It’s a blank page and the page doesn’t redirect to any URL.

Hello @wpmudevsupport12
Thank you very much for your support. It’s nice to discover mu-plugins and this worked.

@abretado1985

Thank you very much for this.
The last login works but the resource usages give the same value for each site. For example, all sub-sites appear as 500 mb, and I think these resource usages are the main site’s resource usage.

@bcworkz

Thank you for your reply. Do you know of a plugin for this?

I chose the email template and sent a test email, but when I checked my email, I noticed that the incoming email was displayed as HTML code. There are only HTML codes in the e-mail. I wonder why these codes don’t work in email?

Hello,
This issue was caused by another plugin. Problem solved and thank you. @wpmudev-support2

Hello @wpmudevsupport13 Thank you for your response.

The site network has 80+ themes installed and it will be difficult to do. Is there an easier way to do this?

Also, can I have a popup appear on all subsites with branda? Or can I run javascript code?

• This reply was modified 1 year, 12 months ago by birblogcu.

This issue was caused by another plugin. Thank you for the help.

Problem solved.

Hello @wpmudevsupport12
Thank you for your response.

I chose the email template and sent a test email, but when I checked my email, I noticed that the incoming email was displayed as HTML code. There are only HTML codes in the e-mail. I wonder why these codes don’t work in email?