My aim was to use Airtable to manage all products on WooCommerce seamlessly – I did not want to be manually importing CSV files or even logging into WordPress after the initial setup.
I wanted to have all the ease of use of Airtable when updating products and never have to think about diving into WordPress.
For me I was starting with a current set of products that had been manually entered into WooCommerce. I used WP All Export (WordPress plugin) to export all of my WooCommerce products to a CSV file which I then imported into Airtable and began cleaning up the categories and tags, changing field types to single and multi select, renaming fields and deleting those I would never use.
🎯 The goal here was to make the Airtable base as user friendly as possible, without compromise!
You can make your Airtable base any way you like, we will be manually mapping each field so names etc. don’t really matter to the import…
If you don’t quite know where to start exactly, I would recommend first creating a few products in WooCommerce and seeing exactly what fields you’ll want to use Airtable to edit.
Here is where we finalize the automatic imports based off of any schedule you might want.
And that’s it – If every step here went well as you did it then this should work out great… Now head back to your Airtable base and do a test edit and then sit back and wait for the schedule to run!
If like me you’re impatient and want to check every step works, you can make an edit in Airtable, click run in your Google Sheet at the Coupler.io dashboard and then just paste the trigger URL into a web browser – when that completes paste the Processing URL in and hit enter…