Title: simplevendor's Replies | WordPress.org --- # simplevendor [ ](https://wordpress.org/support/users/simplevendor/) * [Profile](https://wordpress.org/support/users/simplevendor/) * [Topics Started](https://wordpress.org/support/users/simplevendor/topics/) * [Replies Created](https://wordpress.org/support/users/simplevendor/replies/) * [Reviews Written](https://wordpress.org/support/users/simplevendor/reviews/) * [Topics Replied To](https://wordpress.org/support/users/simplevendor/replied-to/) * [Engagements](https://wordpress.org/support/users/simplevendor/engagements/) * [Favorites](https://wordpress.org/support/users/simplevendor/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/simplevendor/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/simplevendor/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Bulk Edit Sales Price](https://wordpress.org/support/topic/bulk-edit-sales-price/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years ago](https://wordpress.org/support/topic/bulk-edit-sales-price/#post-17959750) * Our host has also been looking into the performance issue and said that the database interactions appear in the slow log, not sure if there’s a way to optimize the table or re-build it with the correct keys if any are missing? * Here is what they said: * The above slow log indicates that the time-consuming operations are primarily related to database interactions and bulk processing of posts. Optimizing database performance and reviewing the efficiency of these functions could help improve speed. * You may consider involving a developer to look into the database optimization& the woocommerce functions involved. * Here are the entries in the log: * ```wp-block-code script_filename = /wp-admin/edit.phpmysqli_query() /wp-includes/class-wpdb.php:2344_do_query() /wp-includes/class-wpdb.php:2258query() /wp-includes/class-wpdb.php:3026get_var() /wp-content/plugins/woocommerce/includes/wc-term-functions.php:490_wc_term_recount() /wp-includes/taxonomy.php:3566wp_update_term_count_now() /wp-includes/taxonomy.php:3549wp_update_term_count() /wp-includes/post.php:7910_update_term_count_on_transition_post_status() /wp-includes/class-wp-hook.php:324apply_filters() /wp-includes/class-wp-hook.php:348do_action() /wp-includes/plugin.php:517do_action() /wp-includes/post.php:5521wp_transition_post_status() /wp-includes/post.php:4781wp_insert_post() /wp-includes/post.php:4993wp_update_post() /wp-admin/includes/post.php:703bulk_edit_posts() /wp-admin/edit.php:194 ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Bulk Edit Sales Price](https://wordpress.org/support/topic/bulk-edit-sales-price/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years ago](https://wordpress.org/support/topic/bulk-edit-sales-price/#post-17959288) * Here is the Gist link: [https://gist.github.com/phpdevop/a1fb0da3c9a8f02e91e11414a72647ba](https://gist.github.com/phpdevop/a1fb0da3c9a8f02e91e11414a72647ba) * I manually selected 20 products and then went to Bulk Actions > Edit and set the sales price. It took about 45 seconds to complete the process. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Bulk Edit Sales Price](https://wordpress.org/support/topic/bulk-edit-sales-price/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years ago](https://wordpress.org/support/topic/bulk-edit-sales-price/#post-17958466) * Thanks for the feedback, here’s some more details: 1. Our server was currently set to use 4032M for memory_limit and 1000 for max_execution_time. This seems like a good amount over default. Our server has 8G of Ram and we never really max out the CPU. 2. Why would a plugin work more efficiently than the default bulk edit built into WordPress? I can look into that third-party plugin. 3. We currently use the default databaes tables and indexes for wordpress and woocommerce and have also use the Index WP MySQL for Speed plugin that adds in high performance indexing. In either case the response time is pretty slow while doing bulk edits. 4. On the staging site we only have WordPress and Woocommerce enabled. The theme is also the standard 2024 theme. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Jetpack - WP Security, Backup, Speed, & Growth] Update Plugin Error admin](https://wordpress.org/support/topic/update-plugin-error-admin/) * [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years ago](https://wordpress.org/support/topic/update-plugin-error-admin/#post-17958023) * As a temporary fix, I was able to get the error to go away by commenting out the alert[‘is_silent’] array and returning false instead. Hopefully a real fix is made soon, here is what I replaced in the file “/jetpack/jetpack_vendor/automattic/ jetpack-my-jetpack/src/class-initializer.php” on line 735: * function ( $alert ) { // We don’t want to show silent alerts // return ! $alert[‘ is_silent’]; return false;} * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Gateway Affirm] A ton of deprecated notes in php error log](https://wordpress.org/support/topic/a-ton-of-deprecated-notes-in-php-error-log/) * [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years ago](https://wordpress.org/support/topic/a-ton-of-deprecated-notes-in-php-error-log/#post-17957980) * Doesn’t look like there is a fix for this yet since we are receiving these notices also. We are using PHP 8.2, I was able to get the messages to go away by declaring all the variables above the __construct in the file “_/woocommerce-gateway-affirm/ includes/class-wc-gateway-affirm.php_“. Like this: * ```wp-block-code public $public_key; public $private_key; public $public_key_ca; public $private_key_ca; public $region; public $debug; public $testmode; public $auth_only_mode; public $checkout_mode; public $cancel_url; public $custom_cancel_url; public $promo_id; public $affirm_color; public $show_learnmore; public $enhanced_analytics; public $show_fee; public $category_ala; public $product_ala; public $product_ala_options; public $cart_ala; public $min; public $max; public $inline; public $partial_capture; public $use_site_language; public function __construct() { ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 1 month ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17836263) * We do not have a nexus in Colorado, only Florida. We also never setup a TaxJar account directly, we just installed the Woocommerce Tax plugin and connected it to our WordPress.com account. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17833617) * Here is how its set currently * ![](https://i0.wp.com/snipboard.io/0YKpXE.jpg?ssl=1) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17833606) * I just ran two tests, one with the Priority set to 0 and again with the Priority set to 1. In both cases the checkout rate that is returned overwrites the 0% that I enter into the admin area and the tax is calculated in the cart. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17830305) 1. The checkout url is here: [https://www.geosreef.com/checkout/](https://www.geosreef.com/checkout/) You will need to add a product to the cart first. 2. The main site url is [https://www.geosreef.com](https://www.geosreef.com) * ![](https://i0.wp.com/snipboard.io/RKxVv5.jpg?ssl=1) * ![](https://i0.wp.com/snipboard.io/3otZm0.jpg?ssl=1) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17828856) * The only thing I can guess is the shop address isn’t completely entered under WooCommerce > Settings > General, only the state and zip code are entered. Does WooCommerce Tax need the full address or is just state and zip code work? It has worked fine in the past, but just now seems to be calculating Colorado rates. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17828854) * Yes I also deleted all the rows under “Standard” tax rate and created a single row. That row had US – CO – all zips and all cities – 0% for the tax rate – and a priority of 100. When I go to checkout and enter a Colorado shipping address, the logs show that the rate was zero, then it updates the row with the returned tax rate, and charges tax in the cart. Going back into the “Standard” tax rate table, that 0% now shows the returned tax rate. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Tax (formerly WooCommerce Shipping & Tax)] Colorado Tax Rate Being Applied](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 2 months ago](https://wordpress.org/support/topic/colorado-tax-rate-being-applied/#post-17828853) * I removed all rates under “Standard” tax rates like the guide suggested. When I then go to checkout and enter in a Colorado shipping address, it calculates a tax amount and saves a tax percent to the “Standard” tax rate area. * Where does WooCommerce get the data for if a store sells over $100,000 in revenue? Looking at our orders, we are nowhere near the $100k limit. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Weight Based Shipping Table Rate for WooCommerce – Flexible Shipping] WC_Shipping_Method in Error Log](https://wordpress.org/support/topic/wc_shipping_method-in-error-log/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [2 years, 6 months ago](https://wordpress.org/support/topic/wc_shipping_method-in-error-log/#post-17418610) * Yes it does work, I just noticed the error in the log. Trying to get errors fixed to help with site performance. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PDF Invoices & Packing Slips for WooCommerce] Slow Page Load](https://wordpress.org/support/topic/slow-page-load-10/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [3 years ago](https://wordpress.org/support/topic/slow-page-load-10/#post-16983546) * Thanks I had the first option selected, I deactivated it and it did improve the speed. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Constant Contact Forms] Add Customer at Checkout](https://wordpress.org/support/topic/add-customer-at-checkout/) * Thread Starter [simplevendor](https://wordpress.org/support/users/simplevendor/) * (@simplevendor) * [3 years, 4 months ago](https://wordpress.org/support/topic/add-customer-at-checkout/#post-16585577) * Can both plugins be used at the same time also? Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/simplevendor/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/simplevendor/replies/page/2/?output_format=md)