CSV manipulation and WooComerce sync/import for inventory

I am trying to sync a CSV from a distributor with WooCommerce to keep inventory up-to-date. The CSV is updated daily.

The difficult part, is that when the distributor sells out of a product, they just delete that product/row from the CSV rather than setting it to 0.

Is there some way that Pabbly Connect could check between the current CSV and the previous one, so that it could set the inventory of that product to zero. Or even just create a live Google Sheet from the CSV, where this product line would be set to zero?

Hi @primitive,

I'm afraid this particular use case doesn't seem to be possible at the moment.

I am trying to sync a CSV from a distributor with WooCommerce to keep inventory up-to-date. The CSV is updated daily.

The difficult part, is that when the distributor sells out of a product, they just delete that product/row from the CSV rather than setting it to 0.

Is there some way that Pabbly Connect could check between the current CSV and the previous one, so that it could set the inventory of that product to zero. Or even just create a live Google Sheet from the CSV, where this product line would be set to zero

How many products we are talking about?

It's 60 products with 1-2 variations per product (probably around 100 total items)