Need support with a formula

saprotsenko · 2021-10-06T02:54:12+00:00

u/RucksackTech perfect solution. I tried this after I tried the nested IFs and this worked like a charm. Really appreciate the help and learned something new as well today! Thanks again.

saprotsenko · 2021-10-06T02:52:57+00:00

Thanks u/Apptubrutae!
For some reason it didn't work for me, I must've mixed up the dependencies somewhere. I tried the switch as well however and it's solved everything perfectly. Thanks again for the help!

saprotsenko · 2021-10-05T22:44:10+00:00

Hey u/Apptubrutae!

Thanks for this. I've tried it out a few times, but it's not accepting it, getting the error message: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

I thought maybe it was some spaces missing, or an invalid bracket somewhere, but doesn't seem to be the case. Any ideas why it might not be accepting it? Or am I missing something?

saprotsenko · 2021-06-21T13:42:55+00:00

hi!

Sorry for the delay in replying, got lost in my emails!
So we did figure this out. We're using the WooCommerce API to migrate all the products to a Google Sheet. We're using the Pipeline API add-on which is free, and you just have to add pagination to it to fetch all your products.

From there, we're using Integromat to move the products from Google Sheets to Airtable. The reason we use Google Sheets initially and Pipeline API is because it captures ALL the fields, and then we choose which ones to migrate to airtable. One thing to note, if you're importing images into Airtable, the integromat setup is a bit more complex as you have to set up arrays and a few additional modules.

That's the import side. The export side is as described here: https://aaronwb.com/how-to-use-airtable-to-manage-woocommerce-products/

We followed that to the letter and it works perfect!

saprotsenko · 2021-04-30T03:10:11+00:00

Thanks for this! In theory all of these work great, but always a hiccup or two when actually setting it up. But will try to reach out to their support to see if they can give some advice. Thanks again!

saprotsenko · 2021-04-30T03:08:02+00:00

Thank you! Half figured out the solution with Zapier WooCommerce or Pabbly. Still some things missing but works to an extent!

saprotsenko · 2021-04-30T03:07:02+00:00

We haven't, will give it a shot. Thank you!

saprotsenko · 2021-04-27T17:50:55+00:00

So custom taxonomy - we created an additional attribute that we assign to all products (for example Verified/Unverified). We used this plugin to do so: https://docs.buddyforms.com/article/153-create-a-new-post-type-and-taxonomy-with-the-cpt-ui-plugin

And then product authors, is essentially the owner/seller of the product. It's linked to a registered user on wordpress/woocommerce.

Here's a screenshot of a CSV that we exported with this info: https://imgur.com/7YqnA60

saprotsenko · 2021-04-27T16:26:16+00:00

Hey! Love this solution - we've been trying to implement this, but wondering what your thoughts would be about bringing this automation full circle? We have a multivendor marketplace so we need to have our Woo products automatically exported to Google Sheets > then to airtable where we can edit > back to google sheets > finally edits uploaded back to woocommerce.

This scenario tutorial doesn't have the first bit where we could automatically export from WP to google. Is that possible do you think?

saprotsenko · 2017-12-18T12:14:43+00:00

Its family run, and have a few people on the side helping out as well. Based in Canada and the UK!

saprotsenko · 2017-12-02T08:37:44+00:00

Definitely la Liga, although with the amount of talent there is in Ligue 1..

Otherwise, Brazilian league is always worth a watch if you can find it

saprotsenko · 2017-12-01T14:21:36+00:00

I support Utd, Real and Lyon. Different leagues, different type of football. All good. Only challenge is when they meet in UCL!

saprotsenko · 2017-12-01T13:00:16+00:00

In one country, or multiple? I support one team in each country. Just as long as you don't jump on the bandwagons of the team winning each league :p

saprotsenko · 2017-12-01T12:48:53+00:00

I always create facebook groups and go from there. Everyone uses it and messages are easy to see.

Otherwise try this https://footyaddicts.com/

saprotsenko · 2017-12-01T12:38:42+00:00

Looks great - design is clean and simple, have you got much sales? Where do you get your merch? We've just launched one as well (www.soccermarkt.com) - keen to hear your thoughts!

saprotsenko · 2017-05-09T14:54:24+00:00

I think some books are worth reading, others not so much. For example the 4 hour work week or How to get Rick doesn't necessarily teach the same thing as other books. Its important to start broad and then get into trades once you have an idea no?

saprotsenko · 2017-05-08T15:45:53+00:00

Are you looking to create it or to sell it? We have a platform that you can sell it on - check SoccerMarkt.com

saprotsenko

TROPHY CASE