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:

Open your QuickBooks Point of Sale company file and connect Zed Axis to it
Click on the Import tab and browse to the location of the Excel or text file that you wish to import
Add a mapping and map the columns in your import file to the corresponding fields in QuickBooks Point of Sale
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

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	Mandatory Name of the department
Desc1	Str 30	Default Identifier Primary description for the item (ie Name)
Desc 2	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 (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
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 Vendor Name

Article ID: 255, Created: 7/9/2014 at 7:21 AM, Modified: 7/6/2022 at 5:11 AM