Google Sheets Synch Products to WooCommerce

[DashDash]

Hi

I'm looking to build an affiliate website that gets its daily product updates from Google Sheets.

I see you have this tutorial

on how to import to WooCommerce everytime a new row is added but do you have a way to remove products from WooCommerce if they no longer show in the Google Sheets?

In other words totally synchronize what products are listed based on the Google Sheets, this way I don't need to manually delete items that are no longer sold.

 

[DashDash]

Okay i have this part figured out, but I am adding external products with external product links.

How do I add the external links with Pabbly?

 

[Pabblymember11]

Hey @DashDash

Could you please elaborate on your use case once, so that we can assist you accordingly?

Thanks!

 

[DashDash]

Hey @DashDash

Could you please elaborate on your use case once, so that we can assist you accordingly?

Thanks!

Hi, in addition to using WooCommerce to run a store, you can also use it to list affiliate marketing products by changing the product type to external rather than simple. External allows you to add URLs to 3rd party websites, a.k.a affiliate links.

 

[DashDash]

While Pabbly Connect allows you to define product type as external, it does not include a place to insert a product url.

 

[Pabblymember11]

Hey @DashDash

Thanks for the details. We are currently looking into your concern and will inform you with an update soon.

 

[DashDash]

Any progress?

 

[Pabblymember11]

Hey @DashDash

Could you please tell us that you want the External_URL field in the action event?

 

[DashDash]

I want the external url field in the action field.

 

[Pabblymember11]

Hey @DashDash

As per the API documentation, we have added the External URL field in the WooCommerce: Create a Product action event.

Kindly review that and let us know if it is helpful to you.