Skip to main content

WooCommerce: Utilizing Custom Attributes

I must admit, I have a quite a love/hate relationship when it comes to WordPress.  As with some frameworks, it often takes a bit of rewiring to be not so... controlling.  On the other end of the spectrum, it has an enormous community, and you'll almost never be out of work when it comes to being able to build and support.  Plus, to be fair, it is not as targetted directly to developers unlike other Content Management systems like October CMS.

Back on topic, I have recently been given a requirement to integrate our internally developed product CRM with WooCommerce, and would like to cover one important aspect of it: custom attributes.  It has taken a lot of research to making it just the way we needed to, so allow me to share some of the things I have learned along the way.

First, we need to add our products with our custom attributes, this topic, while it was available, didn't seem to be as documented as attributes with set options (terms) attached to it, so it was a bit of trial and error.  So, that was done this way:

Take note of the name and value for the custom attribute "catalogue_id" - one of the problems I faced was that our products each belong to a separate catalogue, and needs to be filtered for the customer depending on the catalogue that applies to them only.  When products are being listed in the shopfront, the filter woocommerce_product_query_meta_query is triggered.  Therefore, in the functions, I have placed the additional filter:

Notice here how I am having to query not just one attribute, but all of them in the one query - which is why I have had to mask the value as _cid_####_ so it then would not incorrectly pick up another attribute.  This was a little annoying.

Finally, and this was one of the more tricker alterations of this implementation, this does not change the product counts in the category list widget.  It was of no surprise that this was primarily being performed by WordPress itself, and I didn't want to alter much of this code - so to suit, I designed my own query and rendered out the LI elements in the same way that WooCommerce would have:

As you can see, this gave me the added bonus of being able to put a category for "All Products" as well.

So there you have it!  We've covered a lot of bases with what can be quickly acheived with custom attributes.  Please share what experiments you come up with as well.

Comments

Popular posts from this blog

question2answer Wordpress Integration

 Today I want to journal my implementation of a WordPress site with the package of "question2answer".  It comes as self-promoted as being able to integrate with WordPress "out of the box".  I'm going to vent a small amount of frustration here, because the only integration going on is the simplicity of configuration with using the same database, along with the user authentication of WordPress.  Otherwise they run as two separate sites/themes. This will not do. So let's get to some context.  I have a new hobby project in mind which requires a open source stack-overflow clone.  Enter question2answer .  Now I don't want to come across as completely ungrateful, this package - while old, ticks all the boxes and looks like it was well maintained, but I need every  page to look the same to have a seamless integration.  So, let's go through this step by step. Forum Index Update This step probably  doesn't need to be done, but I just wanted to mak...

Running NodeJS Serverless Locally

 So it's been a long time, but I thought this was a neat little trick so I thought I'd share it with the world - as little followers as I have.  In my spare time I've been writing up a new hobby project in Serverless , and while I do maintain a staging and production environment in AWS, it means I need to do a deployment every time I want to test all of the API's I've drafted for it. Not wanting to disturb the yaml configuration for running it locally, I've come up with a simple outline of a server which continues to use the same configuration.  Take the express driven server I first define here: And then put a index.js  in your routes folder to contain this code: Voila! This will take the request from your localhost and interpret the path against your serverless.yml and run the configured function.  Hope this helps someone!

Getting all deltas from Auth0

Before I get in to the solution of this article, let me tell you how it started and fill you in on the problem that arose.  I wrote a procedure to get daily deltas of users - those of which who had created/updated their account on the given day (and including the day before for good measure on the GMT timestamp).  The simple search criteria was just the following: updated_at:[yyyy-mm-dd TO yyyy-mm-dd] Simple, right?  the []'s being the dates are inclusive, while using {} would mean exclusively.  Auth0 lets you mix these on either side depending on your use.  While this is all well and good, Auth0 will limit the number of results (even with paging) to 1000 only. So, your first option is that you could have your procedure create a user export job, and then parsing through the results and eliminating those which do not meet your updated_at search criteria.  I can tell you first hand that eventually the amount of users will just get to be too much and cumb...