tl;dr: Is there a way to automate the creation of repetitive but slightly different products?

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 ...

zapier wordpress

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.

Arp Laszlo
Hi, I’m Arp! I got diagnosed with ADHD at 49, and now I'm trying to figure out what's me, what's masking, and just about everything else. I make comics (when imposter syndrome isn't striking) and write about life as a creative Indian-American. I’m self-taught, self-employed, and self-flagellating.

More from the Blog

zapier wordpress

tl;dr: Is there a way to automate the creation of repetitive but slightly different products?

I’m looking for a way to automate creating & filling out products, ideally from a Google Sheet. Zapier does not seem to work with ...
Complaints about Merchize print on demand

Complaints about Merchize

I’m starting a print-on-demand merch business I’ve previously used #Printful, which has a brilliant and easy user experience. But they don’t have some products ...
RIP Shane MacGowan

RIP Shane MacGowan

I’m crushed. Not that it wasn’t expected; he just left the hospital last week after months. It’s a miracle he made it to 65 ...

Leave a Comment


This site uses Akismet to reduce spam. Learn how your comment data is processed.