Importing inventory items from a CSV

When creating an inventory list in a CSV file.  Can one of the columns be for listing the category you want each item to be associated with?  Also can I include multiple price lists (include my own created lists)?

Lastly what order would the columns be in the CSV?

  • 0

    The column order is the same as the Help file indicates.

    No, Category is not one of the columns so you have to assign categories after import.

    Regular and Preferred pricing is part of the initial import, but the other custom prices lists are not.  You are able to use the File, Import/Export, Import Records to import price lists.  To find the format, Export the price list first and make sure when you import, the amounts have no more than 4 decimals.  Five or more used to crash the import but I haven't tried that in years.