Required CSV import fields and template of CSV files
When importing products or customers from a CSV file I create a sample exported CSV file from V7. My questions are:
- 1) Are the required/compulsory fields highlighted in blue?
- 2) Some fields are not highlighted in blue but when you expand them the sub fields are highlighted. If these sub fields are left out would the data import be compromised?
- 3) Does anybody have a set of demo import CSV files for importing? I would like to have a look at these so I don't duplicate or end up entering wrong info.
- 4) What would you recomend be imported? I am importing customers, products and take on balances. Other data will be created, however if you have other import files I would appreciate them as well.
- 5) If at a later time I do another import using partial fields, will only those fields be updated or will the entire product /customer details be changed. For example I do a stock import ommitting the storage location fields and after a few months I do another import where I change product categories only and add in storage locations.