Hi @eggplanted
Quickest band-aid is use shopify-flow to make sure new products stay unpublished and don’t get autopublished until they get a “release” tag, etc such as from a team lead etc.
After that then read on, and build up the rest of the process validating metafields.
This is the type of stuff you want to bookend with checks before time of creation, with validation afterward as redundancy not the critical authorship step itself.
Getting emails should only happen IF something goes wrong, otherwise you don’t want staff getting constant emails to be a baked in part of the authorship process.
Email roundtripping can be the worst type of automation kludge avoid it or make it highly polished.
Upstream fix,
For product creation try to always fix it at the source such as instead of allowing admin access for every staff making product entry done through a spreadsheets that have constraint validation etc. And then do standard CSV product import from the spreadsheet
Or automate the import itself with online excel/gsheet spreadsheet and an app to automate the import of CSV rows only when valid.
Such as with mechanic scripting, matrifixy, or ez-exporter apps.
export examples https://tasks.mechanic.dev/?q=CSV&tags=CSV
If the data is part of other product data, such as descriptions or calculated from productOptions etc, then that is something to automate before allowing creation/publishing.
Unless there’s some reason the data cannot be generated until after a product is created published; i.e. apps that add tags or taxonomy categorization etc making it a downstream process.
Downstream fix,
You can kick of validation processes AFTER a product is created using shopify-flow or other automation apps but that still means there is a gap of time products are invalid and 1 more check you or staff still need human eyes on; compounded by any auto-publishing to channels by settings or apps etc.
sample tasks for mechanic https://tasks.mechanic.dev/?q=missing
If you need this type of process automation , or consulting then contact me for services
Contact info in forum signature.
ALWAYS please provide context, examples: store url, theme name, post url(s) , or any further detail in ALL correspondence.