Import inventory items into QuickBooks POS

Overview of importing inventory items into QuickBooks POS

In QuickBooks POS an inventory item is used to track goods that you sell in your business.  Using Zed Axis you can import inventory items into QuickBooks POS from text or Excel files in batch

Steps to import inventory items

Import items into QuickBooks POS from text and Excel files using Zed Axis following these steps:
  1. Open your QuickBooks Point of Sale company file and connect Zed Axis to it
  2. Click on the Import tab and browse to the location of the Excel or text file that you wish to import
  3. Add a mapping and map the columns in your import file to the corresponding fields in QuickBooks Point of Sale
  4. Click import and Zed Axis will create the inventory items directly in QuickBooks Point of Sale

More help?

Sample item list data - Items.txt

Where the fields appear in QuickBooks POS

Import items into QuickBooks POS

Description of the fields on a customer list you can import:

QuickBooks POS FieldFormatDescription
ALUStr 20Alternate Lookup used to lookup the item
AttributeStr 12Used to describe item ie color, pattern, material etc..
COGS AccountStrCost of Goods Sold Account
CostAmtAverage cost for the item
DepartmentStrMandatory Name of the department
Desc1Str 30Default Identifier Primary description for the item (ie Name)
Desc 2Str 30Secondary description for the item
Income AccountStr Income account for the item
Is Eligible For CommissionboolWhether eligible for commission (true of false)
Is Printing TagsboolIs Print Tags selected (true of false)
Is UnorderableboolWhether item is orderable (true of false)
Is Eligible For RewardsboolWhether eligible for rewards (true of false)
Is Web ItemboolWhether a web item (true of false)
Item TypeenumThe type of item ie ( Inventory, NonInventory, Service, Assembly, Group, SpecialOrder)
Margin PercentintMargin percent for the item
Markup PercentintMarkup for the item (will force a recalculation of item price and margin)
MSRPamtManufacturers suggested retail price
On Hand Store 01....20quanQuantity of item on hand in inventory at Store 01 ....20
Reorder Point Store 01...20quanReorder point for inventory item at store 01 .... 20
Order By UnitStr 20Unit to order by
Order CostAmtCost to order the item
Price 1 ... 5AmtPrice for the item from 1 to 5
Reorder Pointquanreorder quantity
Sell By UnitStr 
Serial Flagenum 
SizeStr 12Size of the item
Tax Code  
Unit Of Measure  
UPC Universal Product Code (Can be used as the Item Identifier if UPC lookup option selected)
Vendor Name Vendor name
Web Desc Description for the web
Web Price Price for the web
WeightfloatWeight of the item
KeywordsStrKeywords for the web
Web CategoriesStrCategory for the web
UOM 1 ALU Unit of measurement 1 alternate lookup 
UOM 1 MSRP Unit of measurement 1 manufacturers recommend retail price
UOM 1 No Base Units Unit of measurement 1 number of base units
UOM 1 Price 1 .. 5 Unit of measurement 1 price 1 to 5
UOM 1 UOM Unit of measurement 1 unit of measurement
UOM 1 UPC Unit of measurement universal product code
......repeat for UOM 1-3  
Vendor 2 ALU  
Vendor 2 Order Cost  
Vendor 2 UPC  
Vendor 2 Vendor Name