Importing Items

Importing Items

Importing Items


When setting up either product or service based companies, creating items in inventory allow you to put them on Sales and Purchases Orders, Sales Invoices and Bills, and Time-tracking records. Wait! Time-tracking records? Why would you want to put an item on a time tracking record? Think about every thing you sell as an item – even time. In this case, the item might be consulting and the unit of measure might be hours.

There are several things to think about before uploading items. You may have already thought about these when you completed the settings set-up, but it doesn’t hurt to think about these again to ensure everything gets set-up right in the beginning.

★ Does your company buy or sell things in fractional amounts? If so, ensure you have set the number of decimals in the Quantity Field Decimals setting.

★ Does your company buy or sell items in one unit of measure and sell in another? If yes, ensure that you have enabled Advanced Units of Measure and that a unit of measure set has been created that is applicable for all of your items.

★ When pricing items, do always set prices using two decimal points or are there more? If yes set the Pricing Precision feature.

★ Do you have logical groups of items that are priced similarly or grouped together for other reasons? If so, consider creating Item Categories.

    • Related Articles

    • Item Categories

      Overview Items can be grouped logically using categories.    Categorizing items can provide the following benefits: Reporting Pricing Categories in Reporting Reports that list multiple items are grouped by their category.  This can be helpful when ...
    • How to create a service item?

      Creating a Service Item Service items differ from product items in that are not tracked in inventory. To create a service item : Navigate to Inventory → Item. Click Create. Enter an Item Code (product number, sku, etc). Enter a Description for the ...
    • How to create a product item?

      Creating a Product Item CustomBooks™ has two types of items: Product and Service. The big difference is that Product items are tracked in inventory. To create an product item : Navigate to Inventory → Item. Click Create. Enter an item Code (product ...
    • Item Categories

      Item Categories Item Categories allow you to group products and services for the purpose of organization, pricing and reporting. It may be used in conjunction with the Price Matrix to create a complex pricing structure or to simplify the entry of ...
    • Item Categories

      Item Categories Item Categories allow you to group products and services for the purpose of organization, pricing and reporting. It may be used in conjunction with the Price Matrix to create a complex pricing structure or to simplify the entry of ...