Automatic importBrowser Info Environment
Would it be possible for your module to check a location on the website for a file and then automatically do the update without any human involvement? I’d certainly pay a bit more for that feature and I’m sure other people would.
In the dashboard, you have to use checkboxes to indicate which fields you wish to update. This is so you do not have to remove too many fields from the data in order to update a single field. With an automated upload, this won't be possible.
I would guess that the thing to do would be to only update columns that are present in the file. My thinking here is that the data file will most probably be automatically generated by a foreign system, which hopefully can be tuned to output only the fields that are required, e.g. ID, qty and price. You most probably would not want to update pricing tiers every day.
Processing all the column headings that the software
recognises has to give users the most flexibility. I suspect that most
people will only want to update stock on a daily basis. That said a little
while back the people we bought solder from gave us the price for that day
because the market was so volatile so there may be people that want to
automate a price import. If the CSV has to only contain column headings
that can be imported I can't see that being an issue, I've got our
database to output the CSV file and can easily choose what is in it. The
same has to be true of anyone else that is going to be able to automate
generating a CSV file and get it FTP'd on to a website.
Note that the file is not removed after processing, so your FTP/batch files will need to handle that.
Your import feature has been working great for the last month or two, however we've just changed the way we are using our website. Now most products are on limited stock, but negative quantities are allowed, however some stuff it is set to not allow negative quantities. Previously all products were set to use system defaults, now some don't and are forced to not allow negative numbers. The problem I have is that when it does an automatic update of stock levels for some reason all the products revert to using system defaults and there's no reason why the update should change this. But this then means that people can order items we don't have. The same thing happens if the update is done manually. I don't think it should be changing the "allow negative quantity" field, any ideas?