Confused: “ANY of” vs “is ALL of” (filtering search)

“All” will mean that products that match ALL of the filters will be returned while “Any” will mean that products that match ANY filter of the filters will be returned.

Let’s say you have 2 products:

• White Hat
• Blue Hat

Now suppose you have 2 filters:

• Product Name Contains “Hat”
• Product Name Contains “White”

Using “Any” will return 2 products because they match at least one of the filters (“Hat” OR “White”):

• White Hat
• Blue Hat

Using “All” will return 1 product because it matches all of the filters (“Hat” AND “White”):

• White Hat

To clarify further…Am I approaching this incorrectly? In my case I have 47 products, each with 3 product attributes: package, qty, shipping. I want to, across the board, increase standard shipping from $3 to $3.50.
Within shipping, the ‘terms’ are: Standard, No shipping (digital file), or Express.

If Bulk Edit is the correct way for me to do this….
If I have only one filter criteria, and want to increase the Standard shipping by 50 cents, then it seems ‘Shipping’ ‘is any of’ ‘Standard’ would be same as ‘is all of’…? (along with ‘match all of the following rules’). And then there’s ‘Show all variations for variable products’ – all of my products are variable.

Also, when I do ‘any of’ search, I get ‘max 1,000 records found’. (with ‘all of’, I get my 47 products). My 47 products have 372 variations each (quantity, custom sizing, and shipping method). How would I then capture beyond the 1st 1,000 records to increase the price?

Thank you!

Hello,

Changing the price of shipping is done from within WooCommerce config:

WooCommerce -> Settings -> Shipping -> Shipping zones -> <your shipping zone>

Typically the zone is “Everywhere” unless you have shipping setup for different zones. When you are editing the zone you will see the shipping methods. Click the appropriate method (probably “Flat Rate”) and then set the “Cost” field to 3.50

You won’t need the bulk editor to change anything since shipping cost is stored at the high level.

Hope this helps, let me know if you have any other questions!

Thank you, but it’s more complex for me.
Under WooCommerce/General/Store Address/Shipping Locations I have ‘Disable shipping and shipping calculations’**. Also then, under Product Data for variable product, ‘Shipping’ now shows nothing. (weight, dimensions, class). Attributes shows ‘Shipping’ as one of 3 options which I mentioned, one of which is my ‘Standard’, which is “Used for Variations”. Then every product (all are variable in this manner) has the ‘standard’ shipping rate of $3.00 (currently) plugged in. (as well as my product variations of “Qty” and “package” (mini labels or fronts only, etc.)

**My tech guys advised this for multiple reasons I believe… I had no need to weigh packages (wine labels, very light) and because of no shipping needed as well -for digital file option.

I remember now how I need to do this…my Standard shipping price is like the default and so was initially figured into the item price, as if shipping were free. (whereas Express items had added $ and digital file was $0 added). So I need to increase the price for all products/variation = standard shipping, by 50 cents. And I need to do this in batches since otherwise I reach the maximum records of 1,000. So not as easy as other bulk edits, but manageable.

Thank you, I think I’m good on this.

Great, glad you got it sorted out! Let me know if you need anything else.

One more thing, an error code came up twice while I was doing filtered searches for increasing my variable item prices. “Error while filtering, 405 not allowed”. (I couldn’t recognize any consistency in the 2 times). I searched in forums for this topic but did not see it. So I clicked OK on this, then after the “saving” (of changes made) message, it’s always followed by “searching” again (don’t know why?) and it gets stuck in this “searching” mode. I have been able to stop it manually and move on to next change. But…not knowing what this error is about, it makes me a little nervous that all my changes may not have been made.

Also, because my products all have variations, when I search, the “parent” record shows up and I have to uncheck/back these out before I do my edit/change of all the other records. What, if anything, could I state, via filters, to eliminate these showing up, to save me time?
Thanks!

Hello, the “Error while filtering, 405 not allowed” is a server error that can occur if your session times out or if you open another browser window and login (this will invalidate your current session). You should double check the products after this error occurs to make sure everything was updated. You should be able to use the filters to check for the updates, depending on what you’re changing.

The parent Variable Product will appear for any variations, this isn’t something that can be changed. However, when doing a bulk edit, these rows are skipped if you are changing a variation-only field.

Alternatively, you can sort the result by the “Product Type” column (click on the column header, then “Sort Ascending”).

Once sorted, you can click the checkbox next to the first Variable Product. Then hold the Shift key on your keyboard and click the checkbox next to the last Variable Product. All the checkboxes in between will be unchecked. You are now able to bulk edit the checked variations.