We have over 500 products listed on our prestashop website and we have been updating each of these manually...such a time consuming task that it is never ending. We have an inventory database that contains most of the fields in prestashop but not all of them. Eg: our database contains the product reference code and name but does not contain the short description, meta tags etc. We already have this information in prestashop so what I want to do is use the CSV file import to only update specific information while keeping other data such as short description, tags and features, as it is currently. Right now, we only want to update the combinations and quantities from our inventory database and keep all other data unchanged in our website. We will use the ID field to map data between our inventory database and prestashop.
I have watched many tutorias on CSV imports and they all show the mapping tool but none of them explain whether you can choose to update only certain fields and not others without impacting existing data and I could not find this information in the prestashop documentation for 1.6. I have seen how you can skip the first row but not how you can skip a column.
Does anyone know the answer to this question.
Your assistance would be greatly appreciated!