WooWeekly #429: Bulk Replace SKUs, Hide Attributes

Hello there,

Welcome back to WooWeekly, your weekly appointment with WooCommerce tutorials, tips and updates handpicked for you (and the other 17,470 subscribers) so that you can learn something new.

I finally see the light at the end of the tunnel as my wife and kid are doing much better. Just a few days and I’ll get back to full speed, so that I can get started with my 2023 business (and personal) projects. I really need to get work done, and this is the right time to stop planning and start executing.

For all of those going to WC Asia, well, safe travels, enjoy and make the most of it. I’m sure it will be a success, and soon I’ll be there as a speaker – hopefully next year?

Anyhow, back to Woo now – enjoy!

Rodolfo


BUT FIRST… THANK YOU, STAGE SPONSOR!

GoDaddy PRO WordPress Ecommerce hosting with WooCommerce gives you the freedom to sell anything, anywhere online – from physical products to digital downloads, services and subscriptions. We’ve integrated WooCommerce into our Managed WordPress platform where you can choose from over 75 premium WooCommerce extensions included in your plan for as long as you host your ecommerce store with us. That’s nearly $6,000 in free premium extensions — at no extra charge — to build a powerful, customized ecommerce store.


1. Brand New WooCommerce Tips

WooCommerce: Bulk Search & Replace SKUs

Yes, you could use a plugin to bulk search and replace a given string inside the WordPress database… but today I want to show you a simple snippet you can use to bulk edit SKUs in your store (please test first on staging or a development site!). ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Hide Specific “Additional Information” Tab Attribute @ Single Product

Yes, you could completely remove the “Additional Information” tab all together, but sometimes you may need to just hide a specific attribute in this table, for whatever reason. Especially when you want to avoid your customers getting confused and abandoning your website. ~ Rodolfo Melogli, Business Bloomer


2. ICYMI: WooCommerce Articles

WooCommerce: Automatically Add Tag To Purchased Products

This functionality can be helpful to those who need to differentiate purchased products from non-purchased ones. Think about a way to automatically discount non-tagged products, in order to entice more sales; or a function that only shows purchased products via a custom shortcode. ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Limit Sales Of A Product Per Day

Yes, “manage stock” is a nice feature to make sure you don’t oversell a given product based on the stock you have in your warehouse. However, what if you also need to have a “daily sales limit” – say you can’t sell more than 3 of a given product ID in a given day? ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Search Products By SKU

Today, we’ll study how to alter the product search query, as well as the wc_get_product_id_by_sku() function, which is super helpful to determine the product ID for a given SKU number. ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Edit “Ship to a Different Address?” @ Checkout

The “Ship to a Different Address?” string may be confusing or may need further clarification, as not all customers are created equal. What about “I’d like to define a different shipping address” or “Ship to a different address than the Billing one“? ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Hide Products Based On Custom Field / ACF Value

We’ve already seen how to hide products based on IP addresses, hide products belonging to a specific category and even hide all products from the Shop page. Today I want to publish another version of those, but this time we’ll use a custom field / ACF in our conditional logic, so that we can toggle the product visibility based on its value. ~ Rodolfo Melogli, Business Bloomer

WooCommerce: Display All Single Variations (Shortcode)

As you know, each variable product is made of one or more “single variations”, and these are only visible in the single product page. Now, what if you want to display a grid of all “single variations” in a custom page / post? Well, a shortcode can be coded so that you can achieve just that. ~ Rodolfo Melogli, Business Bloomer


Enjoyed this issue?

Well, congratulations for reading this far – you’re one of a kind! There are many ways you can support WooWeekly and help us spread the word. Thank you in advance!

Share ithttps://wcwkly.com/newsletter-archive/

Invite friendshttps://wcwkly.com

Leave a reviewhttps://www.businessbloomer.com/shop/newsletters/wooweekly-free/

Become a sponsor for as little as $97https://wcwkly.com/sponsors/


WooWeekly is brought to you by...

  • Rodolfo Melogli

    Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza.

Leave a Comment

Proudly supported by

Join them?