Importing Data Into Nexudus

This article details how you can import data from your space into Nexudus. Importing data into Nexudus is a four-step process: 

Step 1. Downloading the Import Template File

The first step of the process is to download an import template file from your Nexudus account.

  1. Log in to your Nexudus account if you aren't already logged in.
  2. Click Settings > Imports
  3. Click the tab that corresponds to the element you want to import into Nexudus. 

    mceclip0.png

  4. Click Download template

    mceclip1.png

The download start immediately and you can find your template file in the Downloads folder of your computer. The file name is always Nexudus_importelementname_Import_Template.

Step 2.  Editing the Import Template

In this step, you add your data to the import template. The example below illustrates how to do this in Excel, but you can use any spreadsheet tool that can open and edit CSV files. 

  1. Open the import template file you've downloaded in Step 1. 

    mceclip2.png


    You should see the column headers in row 1 and a few rows of dummy data underneath. 

  2. Add your space's data in each column.

    For more information on what each column means and the correct data formats to check out this article

  3. Remove the dummy data rows from the import template, making sure you don't remove any of the column headers. 
  4. Save your changes.

You're now ready for the next step of of the process which is formatting your data in the import template. 

Step 3. Formatting the Import Template Data

The data in your import template has to be properly formatted to ensure a successful import in Nexudus. There are three formatting elements you need to check before uploading your import template.

Date Columns

All columns that include a date should be set to the yyyy-mm-dd hh:mm format. This format isn't available by default in most spreadsheet tools, but you can add this custom format to your date columns in a few clicks. 
Here's how to do it in Excel:

  1. Select the entire date column in your import template.
  2. Right click the column. 
  3. Select Format cells
  4. Click Custom.
  5. Enter the yyyy-mm-dd hh:mm format in the Type field.
  6. Click OK.

The dates in your column should now appear in the right format, for example 2021-10-11 16:00. Repeat the process for every column that includes a date in your import template.

YES or NO Columns

All columns that include YES or NO should always be uppercase. 

Columns Including Existing Nexudus Items

All columns that include the name of items that already exist in your Nexudus account must always be an exact match in your import file. The spelling is case-sensitive and includes spacing. 

For example, if a product's name in Nexudus is Granola Bar, the product name in your import file must be Granola BarUsing alternative spellings such as GranolaBar or granola bar will result in an import failure. 

  Make sure you don't reopen your import file once you've saved all your changes and closed the file. Doing so will automatically reset the custom date format you've just added and you'll need to customize the column format again.

Step 4. Uploading the Edited Import Template File

In this last step, you just need to upload your edited import template file to Nexudus. 

  1. Log in to your Nexudus account if you aren't already logged in.
  2. Click Settings > Imports
  3. Click the tab that corresponds to your edited import template file.
  4. Click Upload file

    mceclip6.png

  5. Select your edited import template file from your computer. 
  6. Click Open

    The upload can take some time, depending on the size of your import template file.
  7. Click Import

    mceclip9.png

  8. Click Yes to confirm your choice. 

You've successfully imported your data into Nexudus. 

If you didn't manage to import your template file, check out our article that covers the common issues that cause an import failure or get in touch with our support team.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.