custom matching filenames within a single folder

Hi all. Newish to hazel and love it.
I am setting up a workflow for a digital e-commerce photo studio.
Hazel has already allowed me to streamline my workflow, but have a question whether what i am trying to do is even possible at this point.
Background:
We capture using Capture1.
Capture1 generates the following folder structure:
Capture1 Session Folder/Capture
Capture1 Session Folder/Output
Capture1 Session Folder/Selects
Capture1 Session Folder/Trash
The RAW files are named: CompanyName_ProductID_4digitSerial
Digital Raw captures are shot into "Capture1 Session Folder/Capture" and then organized into subfolders based on product shot. i.e. Capture1 Session Folder/Capture/CompanyName_ProductID
Hazel is taking care of my subfolders (so i don't have create 50+ folders a day manually) with the following rule:
If all of the following are met:
Name matches using Custom Matching Tokens - (Company)_(Style)_(Serial)
Do the following to matched file or folder:
Sort into subfolder with pattern (Company)_(Style)_(Serial)
I have a similar recipe setup to organize processed jpgs in another folder
All of this works great, but i have to run it manually as i don't want hazel moving files around while i am capturing or processing RAW files into jpgs. I am wondering if there is a way to make hazel automatically move the previous "look/product shot" when the next shot is begun.
In theory it would have this sort of logic included:
If File Name (Company)_(Style) doesn't match all other files in the same folder with name (Company)_(Style)
Then sort oldest into Subfolder (Company)_(style)
If this is confusing, i basically want only the most recent product shot in the "Capture" Folder, anything else should be organized automatically in to sub-folders ( Capture1Session/Capture/(Company)_(Style) ) so that when I am capturing I only see the images of the current product and don't have to wade through thousands of others.
Thanks in advance.
I am setting up a workflow for a digital e-commerce photo studio.
Hazel has already allowed me to streamline my workflow, but have a question whether what i am trying to do is even possible at this point.
Background:
We capture using Capture1.
Capture1 generates the following folder structure:
Capture1 Session Folder/Capture
Capture1 Session Folder/Output
Capture1 Session Folder/Selects
Capture1 Session Folder/Trash
The RAW files are named: CompanyName_ProductID_4digitSerial
Digital Raw captures are shot into "Capture1 Session Folder/Capture" and then organized into subfolders based on product shot. i.e. Capture1 Session Folder/Capture/CompanyName_ProductID
Hazel is taking care of my subfolders (so i don't have create 50+ folders a day manually) with the following rule:
If all of the following are met:
Name matches using Custom Matching Tokens - (Company)_(Style)_(Serial)
Do the following to matched file or folder:
Sort into subfolder with pattern (Company)_(Style)_(Serial)
I have a similar recipe setup to organize processed jpgs in another folder
All of this works great, but i have to run it manually as i don't want hazel moving files around while i am capturing or processing RAW files into jpgs. I am wondering if there is a way to make hazel automatically move the previous "look/product shot" when the next shot is begun.
In theory it would have this sort of logic included:
If File Name (Company)_(Style) doesn't match all other files in the same folder with name (Company)_(Style)
Then sort oldest into Subfolder (Company)_(style)
If this is confusing, i basically want only the most recent product shot in the "Capture" Folder, anything else should be organized automatically in to sub-folders ( Capture1Session/Capture/(Company)_(Style) ) so that when I am capturing I only see the images of the current product and don't have to wade through thousands of others.
Thanks in advance.