I am trying to build a little module onto the product-archive template for WooCommerce that will accomplish one goal.
I have included custom meta fields on the category editor page so that I can paste in specific product SKUs on that page to have as Featured Products. However, I need to figure out a way to have WooCommerce query the current category of products and list the product that has the same SKU that I have listed in the category meta.
in other words...
Product Category -> Custom Meta Field (Product Sku) -> On Product Category Page, Display Product With Matching SKU from current category.
Is something like this even possible? I have been wracking my brain for hours trying to get this to work. Honestly, it doesn't seem like that crazy of an idea, but there is just nothing available that I can with a bit of guidance in the correct direction.