We can import stocks into our Magento warehouses automatically. For this from supplier we need a csv file.
We can import the file direct from ftp or an url.
We can also import local file on our server.
All we need in this file is that 1 column is ‘sku’ and that we have a column ‘quantity’
Now quantity need to be actual number. Starting at 0 til 999999 etc.
Negative quantity is not allowed.
Now we have a problem with a few suppliers. They do provide files for us to import.
But one of them is using also negative quantity and when they have more then 50 they give the value ‘50+’
So now we search for solution.
File supplier:
‘sku’ ; ‘qty’
‘skuexample’ ; ‘-9’
‘skuexample’ ; ‘2’
‘skuexample’ ; ‘4’
‘skuexample’ ; ‘50+’
We need to ‘change’ the values to something like:
‘sku’ ; ‘qty’
‘skuexample’ ; ‘0’
‘skuexample’ ; ‘2’
‘skuexample’ ; ‘4’
‘skuexample’ ; ‘50’
Can anybody advice on what is best way to reach this? So maybe some kind of app to download the file, make changes to values by some formula, send to our server and then import?
