Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to import inventory items with CSV
01-14-2014, 12:45 AM,
#1
How to import inventory items with CSV
I am attempting to import a list of over 1000 inventory items using the "Import stock items from csv" item in the Utilities/Maintenance menu. I have figured out that the first line header needs to match the "template" (which best I can tell is just a string of characters I copied and pasted into my spreadsheet).

Now I have all the headers setup exactly as the template suggests, but I am still getting an error of "ERROR Message Report : File contains incorrect headers (DESIMALPLACES != . Try downloading a new template."

Here is my the first two lines of my csv file:
StockID,Description,LongDescription,CategoryID,Units,MBFlag,EOQ,Discontinued,Controlled,Serialised,Perishable,Volume,grossweight,BarCode,DiscountCategory,TaxCat,DesimalPlaces,ItemPDF
001B,"END CAP, BLUE BULLNOSE","END CAP, BLUE BULLNOSE",MAIN,Each,,,,,,,,,,,,0,

Any help?? I can't seem to find any documentation on importing inventory items from csv.

Thanks,
Reply


Messages In This Thread
How to import inventory items with CSV - by karlboer - 01-14-2014, 12:45 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)