SKUs to Item

SKUs to Item

Your items are mapped with a variety of fields; make sure each field is appropriate for each item.

  • Item Name: Populates based on the selection you made in the previous step.
  • Item Description: Populates from the data you uploaded.
  • Select Item Name
    • Map your existing QuickBooks items
      • When you want to use the same Item for all of the rows:
        1. Select the Item Name on the first row and then check the box titled "Use same Item".
    • Or create one in QuickBooks and click "Sync" in HammerZen
      • When you want to use the same Item for all of the rows:
        1. Select the Item Name on the first row and then check the box titled "Use same Item".
    • Or create new ones right in HammerZen for each row
      • Select the appropriate choice for each field when creating a new item in HammerZen:
        • Item Type: Select only if you are creating new items. Choose from Inventory, Non-inventory, or Service.
        • Income Account: Select from the drop-down menu.
        • Asset Account: Only available if you are entering the Item Type as Inventory.
        • Expense Account: Select from the drop-down menu.

Click "Next."

(All the linking and mapping will be saved for future imports.)


    • Related Articles

    • Departments & SKUs

      Before you enter the items, you must understand the basics: Home Depot departments (available in the Purchase Details) Types of Items in QuickBooks How to enter new items in QuickBooks or map existing items in HammerZen You also need to decide how ...

    • Classify and Verify

      Congratulations! You've made it to the last step. Now all you need to do is classify and verify your fields. Item Name: Select the Item Name that relates to the purchase. If you cannot find an item name, go into QuickBooks and create a new Item name, ...

    • QuickBooks Must-Have's

      These are the QuickBooks must-haves—if you do not have the following names and accounts, then you must create new ones: Account Name: You may make a payment via debit or credit card, so make sure you have a name for each bank account and credit card. ...

    • Verify and Post

      Congratulations! You've made it to the last step. Now all you need to do is classify and verify your fields. Item Name: The name will auto-populate from previous screens, but you can change it as needed. When you want to use the same Item for all of ...