Hot-Folder Import Customization

[Former Member]

I need to import a csv file for StockLevel. But before it gets imported, I need to iterate over all Products/StockLevel and set the stock level status to forceInStock. Then I need to import the csv file.

[former_member582940 · Accepted solution]

Hello Archiesman,

you could do this via impex:

 UPDATE StockLevel[batchmode=true];warehouse(code)[unique=true,default=$warehouse];inStockStatus(code)
 StockLevel;;forceInStock

This will set the Stocklevel in the defined warehouse for every product to "forceInStock" without having to specify each and every single product first. (notice the batchmode=true)

[Former Member]

Perhaps this could be defined as a separate task, and executed after the header setup task.

[Former Member]

why over complicating this? what is stopping you from setting forceInStock as part of the same csv?

[Former Member]

The data I get is only for OutOfStock. That is the limitation of my ERP system from where i get the data. Any product that was outofstock earlier cannot be made in stock from the ERP. So I need to do that from my end before we run the new file everyday.