I’m looking for a way to automate creating & filling out products, ideally from a Google Sheet. Zapier does not seem to work with any fields aside from title & body (maybe featured image too but it’s unclear from Zapier’s forums).
I’m building out a WooCommerce store where I’m sticking to a boilerplate of sorts for the product description and a set of tags that are similar but customized depending on the product & niche. For example:
Title: [niche name] [product type]
Description: each product type has a description boilerplate, with the niche name & a couple of niche related details added (this is not ideal for SEO but I am not interested in SEO advice atm)
Category: based on product & niche
Tags: a set number based on niche & product type
Photos: already uploaded to WP, with a predefined naming convention
Maybe this requires a custom plugin? In an ideal world I’m imagining a spreadsheet with each cell in a row providing the variables for niche, product, tags, etc.