Import inventory items into QuickBooks POS

Import inventory 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
Import items into QuickBooks POS
 
Description of the fields on a customer list you can import:
 
QuickBooks POS Field Format Description
ALU Str 20 Alternate Lookup used to lookup the item
Attribute Str 12 Used to describe item ie color, pattern, material etc..
COGS Account Str Cost of Goods Sold Account
Cost Amt Average cost for the item
Department Str Name of the department
Desc1 Str 30 Primary description for the item (ie Name)
Desc2 Str 30 Secondary description for the item
Income Account Str  Income account for the item
Is Eligible For Commission bool Whether eligible for commission (true of false)
Is Printing Tags bool Is Print Tags selected (true of false)
Is Unorderable bool Whether item is orderable (true of false)
Is Eligible For Rewards bool Whether eligible for rewards (true of false)
Is Web Item bool Whether a web item (true of false)
Item Type enum The type of item ie ( Inventory, NonInventory, Service, Assembly, Group, SpecialOrder)
Margin Percent int Margin percent for the item
Markup Percent int Markup for the item (will force a recalculation of item price and margin)
MSRP amt Manufacturers suggested retail price
On Hand Store 01....20 quan Quantity of item on hand in inventory at Store 01 ....20
Reorder Point Store 01...20 quan Reorder point for inventory item at store 01 .... 20
Order By Unit Str 20 Unit to order by
Order Cost Amt Cost to order the item
Price 1 ... 5 Amt Price for the item from 1 to 5
Reorder Point quan reorder quantity
Sell By Unit Str  
Serial Flag enum  
Size Str 12 Size of the item
Tax Code    
Unit Of Measure    
UPC   Universal Product Code
Vendor Name   Vendor name
Web Desc   Description for the web
Web Price   Price for the web
Manufacturer    
Weight float Weight of the item
Keywords Str Keywords for the web
Web Categories Str Category 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 VendorName    

Add Feedback