Hi wickcheed,
You can use product attributes for this. First set up a new attribute at Products > Attributes called “artwork-id”, or something like that. Then in the terms for the attribute, list all of the possible artwork IDs. Next, you will assign this attribute to every product so they can be sorted.
Now that you have a sorting/matching framework in place, you can use the layered navigation widget to sort the product page by artwork ID. This step might take a little bit of custom work if you don’t want the customer to have to do it though. So you’ll need a way to save the customers artwork ID choice, and then automatically use the (likely hidden) widget to sort the through the products and show them only ones specific to their artwork ID.
Here’s the longer story. Customer logs in and they come from a particular school. Each school has a “job”. The customer can choose only artwork from their school’s job, and artwork from each job has their own specific pricing. Also, customers can upload their own artwork, so the artwork list is somewhat dynamic.
Do you know if the API/REST can be used to manage the artworkid attributes lists? We are using FileMaker Pro as the administrative database, and can push data to WP from there. Or does this all provide enough complication where I would need to hack some Woo code?
Again, thanks so much for your input!
This is definiltey possible to do, and shouldn’t require hacking core code. There are plenty of hooks and filters around to do what you need.
How the artwork selection process works will be up to you, and then you will essentially want to translate that process into just using the attributes and layered nav filter. So first they get their artwork ID’s, then you use the chosen artwork ID’s to filter the shop.