Importing materials/price books into NextMinute

In this article we will take you through the steps to import materials into your NextMinute subscription.  You can easily import your supplier price books into NextMinute to quickly add materials to jobs, quotes, orders and invoices.

Step 1: Navigate to Materials, select More and Import Materials Sale Items

Step 2: Download the Generic File and when happy select Choose File

See the Generic Template section after Step 9 for more information on entering your materials into the generic CSV file to import into NextMinute.

Step 3: Select your CSV file and Open

Once you have entered all of your materials into the correct columns of the generic template and saved as a CSV file, select Choose file from the import page (shown in Step 2 above), select the file and Save.

Step 4: After selecting and opening the file select Next

Step 5: Select the Supplier that links to the Materials you are importing

If you are importing a generic materials list go to Step 7.

Step 6: Select the Supplier from your list or select Add

You may have already added or imported all of your Supplier contacts into NextMinute, you can select the Supplier that relates to the price book from your list or create a new Supplier contact.

Enter the Supplier contact details and Save

Step 7: Select Preview

The Supplier will show under the Supplier header, as shown below.  If you are importing a generic materials list, that doesn't need to link to a supplier contact, you can leave blank and go straight to preview, as mentioned in Step 5.

Step 8: Review your list and select Import

Make sure you have entered all your data into the correct columns and when happy select import.

Step 9: You have successfully imported your Materials List!

Generic Template

You will need to sort your product information into the columns shown below:
  1. Internal Code is any code (100 characters MAX) that you want to use internally.
  2. Supplier Code is any code (100 characters MAX) that represents the code your supplier users for this product.
  3. Name is any name for the product.
  4. Unit relates to how you sell a product by Item (Each), by Metre etc.(50 characters MAX)
  5. Buy and Sell Price is your buy and sell for this product.
  6. Category can be added if you want to organise your products into product groups. This is helpful when searching and filtering by category, making it easier to view in smaller subsets later.
  7. Description is any description for the product. This transfers to invoices and quotes as well. If a column description is not relevant for your business leave it blank. 
Note: any file created in Excel can be saved as a CSV (comma, separated version) file.

After copying over or entering all of your product data into the columns save as a CSV file.  

Save as:  You will need to name the template, you may want this to be something along the lines of "Supplier Name pricebook for NextMinute" so you can easily find when importing.
Where: Save your CSV file in a folder where you can easily find it when importing into NextMinute or for when you need to update in the future.
File Format: Comma Separated Values (.csv).

Use the Supplier Filter to find the Materials we just imported

Step 1: Within Sale Items - Materials, navigate to Filters

Step 2: Turn on Supplier, select Add and find the supplier from your list and tick as shown below

Feedback and Knowledge Base