Auto delete or put a personalised value when a product is not in csv source file

Hello, i use Itscope data for manage my stock but i take just product are in stock > 0 in csv source file.

How can i delete entries on my database when a product is not in source file

or alternativement put stock 0 to database entries are not in csv source file.

Thank you in advance.


you can use the untouchedRecords output of the SpreadsheetDatastoreWriter step to set stock of all datastore record to 0, which are present in your datastore but not present in the current product export.

Please add a second SpreadsheetDatastoreWriter after your current SpreadsheetDatastoreWriter Step and use untouchedRecordsspreadsheet as input. Add your Stockcolumn to the mapping and set the value to 0.