Title: Luca's Replies - page 2 | WordPress.org --- # Luca [ ](https://wordpress.org/support/users/screenload/) * [Profile](https://wordpress.org/support/users/screenload/) * [Topics Started](https://wordpress.org/support/users/screenload/topics/) * [Replies Created](https://wordpress.org/support/users/screenload/replies/) * [Reviews Written](https://wordpress.org/support/users/screenload/reviews/) * [Topics Replied To](https://wordpress.org/support/users/screenload/replied-to/) * [Engagements](https://wordpress.org/support/users/screenload/engagements/) * [Favorites](https://wordpress.org/support/users/screenload/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 16 through 30 (of 37 total) [←](https://wordpress.org/support/users/screenload/replies/?output_format=md) [1](https://wordpress.org/support/users/screenload/replies/?output_format=md) 2 [3](https://wordpress.org/support/users/screenload/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/screenload/replies/page/3/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Smush – Image Optimization, Compression, Lazy Load, WebP & CDN] Update counter bug](https://wordpress.org/support/topic/update-counter-bug/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 1 month ago](https://wordpress.org/support/topic/update-counter-bug/#post-11402817) * No one, all up to date according to the list. It’s just the little “1”. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Smush – Image Optimization, Compression, Lazy Load, WebP & CDN] Update counter bug](https://wordpress.org/support/topic/update-counter-bug/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 1 month ago](https://wordpress.org/support/topic/update-counter-bug/#post-11402263) * [Screenshot](https://i.imgur.com/WSenhWY.png) * As you can see, there is an update notice and all plugins are up to date. This only happens when you plugin is installed, if I remove it, it disappears. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Approve User] Change text after registration](https://wordpress.org/support/topic/change-text-after-registration/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 1 month ago](https://wordpress.org/support/topic/change-text-after-registration/#post-11370848) * Perfect, thank you very much! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Approve User] Change text after registration](https://wordpress.org/support/topic/change-text-after-registration/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 1 month ago](https://wordpress.org/support/topic/change-text-after-registration/#post-11370656) * Ah yes! * How do I change it from my functions.php? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Product Visibility by User Role for WooCommerce] Update roles via PHP](https://wordpress.org/support/topic/update-roles-via-php/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 8 months ago](https://wordpress.org/support/topic/update-roles-via-php/#post-10666283) * Nevermind, this worked: [https://wordpress.org/support/topic/can-this-plugin-be-used-with-rest-api/](https://wordpress.org/support/topic/can-this-plugin-be-used-with-rest-api/) * `update_post_meta(48,'_alg_wc_pvbur_invisible',array('administrator'));` * Needed to put it into an array… - This reply was modified 7 years, 8 months ago by [Luca](https://wordpress.org/support/users/screenload/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] ‘Sku already exists’ but there no matching SKU on site](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/#post-10544314) * Just make sure to tick all boxes 😀 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] ‘Sku already exists’ but there no matching SKU on site](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/#post-10544299) * Hmmm… deleting the orphan tables is basically what you need to to. I think a premium plugin is not necessary here, I heard this could do this, too: [https://wordpress.org/plugins/wp-optimize/](https://wordpress.org/plugins/wp-optimize/) * Just tested it, worked for me, hope it does for you as well! - This reply was modified 7 years, 9 months ago by [Luca](https://wordpress.org/support/users/screenload/). Reason: tested it * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Comply with GDPR: Wipe all customer data](https://wordpress.org/support/topic/comply-with-gdpr-wipe-all-customer-data/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/comply-with-gdpr-wipe-all-customer-data/#post-10544277) * You could just clear the orders and customers tables in the database. That’s a one-line SQL-Query: `TRUNCATE TABLE wp_woocommerce_order_items` * Just do this for all tables (with private data) on the staging version by replacing _wp\_woocommerce\_order\_items_. - This reply was modified 7 years, 9 months ago by [Luca](https://wordpress.org/support/users/screenload/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] How to check the text “Select a country” in drop down?](https://wordpress.org/support/topic/how-to-check-the-text-select-a-country-in-drop-down/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/how-to-check-the-text-select-a-country-in-drop-down/#post-10544250) * What is it you want to “check”? Some further information of what you’re trying to do would be helpful! 🙂 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Need a product to override shipping Zones](https://wordpress.org/support/topic/need-a-product-to-override-shipping-zones/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/need-a-product-to-override-shipping-zones/#post-10544240) * As long as you’re not shipping anything, try to set it up as a digital product. Like a download or something. * Either way, I would think about just adding a donation button from paypal. It’s very easy to set up. And the donator does not need to fill out all the forms… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Get all product variations by category](https://wordpress.org/support/topic/get-all-product-variations-by-category/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/get-all-product-variations-by-category/#post-10544138) * “tax_query” is not a valid parameter for that function. Just use “category” and the ID: * ``` $args = array( 'post_type' => 'product_variation', 'post_status' => array('private', 'publish'), 'category' => $selected_category_id ); $variations = get_posts( $args ); ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] ‘Sku already exists’ but there no matching SKU on site](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/#post-10543564) * Wow, what was I thinking, the SQL-query is garbage 😀 Try this one instead: * `SELECT * FROM wp_postmeta WHERE meta_key LIKE '_sku' AND meta_value LIKE 'REPLACE- WITH-A-SKU'` * REPLACE-WITH-A-SKU = an example SKU from the 1000 products * And for the cleanup I would try this one, as it removes orphaned reference data: [https://de.wordpress.org/plugins/advanced-database-cleaner/](https://de.wordpress.org/plugins/advanced-database-cleaner/) * Anyways, you should check the passes for any redundant data * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Unsecured links](https://wordpress.org/support/topic/unsecured-links/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/unsecured-links/#post-10543522) * Add this to the first line of your .htaccess file for an instant fix. * `ErrorDocument 404 /` * It’s only a temporary solution, I have no idea whats wrong with your shop! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] ‘Sku already exists’ but there no matching SKU on site](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/) * [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 9 months ago](https://wordpress.org/support/topic/sku-already-exists-but-there-no-matching-sku-on-site/#post-10543043) * Hey, try to look for it in the database directly. * Open a connection to the SQL-Database and run following command: * `SELECT * FROM 'wp_postmeta' WHERE '_sku' = 'REPLACE-WITH-A-SKU'` * REPLACE-WITH-A-SKU = an example SKU from the 1000 products * If a line is shown, there is probably some leftover data. In this case you need a plugin to clean up the database! - This reply was modified 7 years, 9 months ago by [Luca](https://wordpress.org/support/users/screenload/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Update / Refresh product with php](https://wordpress.org/support/topic/update-refresh-product-with-php/) * Thread Starter [Luca](https://wordpress.org/support/users/screenload/) * (@screenload) * [7 years, 10 months ago](https://wordpress.org/support/topic/update-refresh-product-with-php/#post-10511545) * I did, but now I discovered something that seems to be the problem: The variations are there and the attributes are also in the correct field, but they are not .. like put togher? * **Screenshots:** [https://image.ibb.co/fKFzuJ/werte.png](https://image.ibb.co/fKFzuJ/werte.png) [https://image.ibb.co/eBacgy/variations.png](https://image.ibb.co/eBacgy/variations.png) * How do you tell woocommerce which options equal which variation with PHP? I couldn’t find anything working online 🙁 Viewing 15 replies - 16 through 30 (of 37 total) [←](https://wordpress.org/support/users/screenload/replies/?output_format=md) [1](https://wordpress.org/support/users/screenload/replies/?output_format=md) 2 [3](https://wordpress.org/support/users/screenload/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/screenload/replies/page/3/?output_format=md)