Accounting Features

Invoiceit!Pro Products Import Guide in detail


How to import or update products lists

Prepare the data:
    Setup Menu - Import/Export button - Data Import/Export screen:

  1. From the 'Select Data Type' dropdown, select Spreadsheet
  2. From the green dropdown, select 'Products'
  3. Double-click the large panel at the bottom to open the product import template (it is located in your program folder ...invoiceit!Pro52import).
  4. From the File menu, select 'Save As' and select a destination or new name and click Save. A backup has now been made of the template.
  5. From File Menu, select Open and locate your old data spreadsheet and double-click it. Your existing data should be in XLS or CSV format.
  6. Click anywhere in existing data, press Ctrl+A (to select all) - all cells are highlighted
  7. Switch back to the import template

    On Import template ImportProducts.xls:
        (to use CSV file refer the entry bottom of page)
  8. Click on OldData tab at the bottom
  9. Select Cell A1 and press Ctrl+C (to paste all data into this worksheet) Copy one column at a time from OldData to Import, ensure you match each column by content. Alternatively, arrange the columns of OldData, so they are in the same order as those of the Import tab, then copy all columns to Import tab in one go.

    To move a column:
    1. Select a column you want to move (click on Letter at top of column)
    2. Press Ctrl+X (to cut the column data)
    3. Select a column to the right of where you want to move your selection
    4. From the Insert menu, select 'Cut Cells'. (column and data has been moved)


    Copy ALL data from OldData to Import tab (must be in same order as Import tab)
    1. Click anywhere in OldData, press Ctrl+A (to select all), then Ctrl+C (to copy all)
    2. Switch to the worksheet 'Import' (the tab at the bottom), click on cell A2 and press Ctrl+V (to paste all). You now have transferred your data to the import template. If your old data contained column headers, delete them now (select Row 2 and delete)

      Complete Import:
    3. From the File Menu, select 'Save' (or press Ctrl+S).
    4. Close the spreadsheet and switch back to invoiceit!
    5. Click on the Import button and it's done.



Destination columns in detail

Number fields: do not use currency or percent symbols Fields marked Y in column "update" will be updated, when Import finds that this product ID already exists.
You can therefore use the Import function to update your product list periodically from external sources Price fields will be updated in all cases. If you leave a price blank, it means the existing price will be deleted, except for ListPrice, which will default to 0 if left blank.
Cost field will only be updated when you have entered a value. Blank cost fields will be ignored.

Column Field Name

update

Type/Size
A ProductID   Text/15
B PType   Number
C PName Y Text/150
D GroupID   Text/3
E LocationID   Text/5
F VendorID   Number
G ListPrice Y Number
H Price2 Y Number
I Price3 Y Number
J Price4 Y Number
K Price5 Y Number
L Cost Y Number
M TaxRate1   Number
N TaxRate2   Number
O TaxRate3   Number
P TaxRate4   Number
       
Q Monitor   Text/5
R MinStock   Number
S MaxStock   Number
T CurrentQty   Number
U CurrentValue   Number

Using CSV file: a CSV file (comma-separated values) opens with Excel or equivalent spreadsheet program. It does not have tabs at the bottom so you need to paste each data column from your original into the appropriate column of the Import template.