CSV Import ....
This section describes the file format to bulk import product items into the application using a csv file format.
File Format
Example file : in csv format or as a text file
csv is a text file where each field is separated by a comma character and each line represents a record.
| item_number | Unique item number. | |
| item_name | Item name. | mc_gross | Gross value which will be something like : 34.99 |
| item_title | The title of the product. | |
| item_description | The brief item description. | |
| item_description_full | The full item description. | |
| maincategory | The nummerical value of the main category which must already exist in the database. | |
| subcategory | The nummerical value of the sub category which must already exist in the database. | |
| folder | The folder on your web server where the file is located. | |
| filename | The file name. |
Notes : You cannot use the comma character (,) in any field because it is used as the field separator in csv. You cannot update existing records, only create new records. The maincategory and subcategory are entered as numbers and they should already exists within the application. The currency code (e.g. USD) is not defined in the csv file, but is taken as the default value in setup. The email texts are not defined in the csv file, but are assumed to be the default as defined in setup. You can only have one file attached to a product, although you can add more once the product has been created of course. |

