How to import warehouse locations | ParagonERP

Importing warehouse locations

If you have multiple warehouse locations that you want to add to Paragon's warehouse setup, you can import the information using the Universal Translator tool through the Location module. If you are unfamiliar with importing and transferring data using the universal translator, you can follow the step by step instructions that are available here.

Default columns

Listed below are the default column headings in the universal translator for locations that must match the column headings in your import file.

  • locationID
  • status
  • location type
  • warehouse address


The column headers above reflect the correspondingly named fields that you see in the locations screen. Note that locationID represents the location field and must be unique. There can be no duplicates.

Custom attributes

The columns of your import file will also reflect the custom attributes that are in your locations module. You can read more about custom attributes here. If you need to customize the location attributes, you can learn how to do so here.


Following the above example, the column headings will be:

  • aisle
  • rack
  • warehouseSection
  • warehouses

The resulting structure of your import file should include all default fields and custom attributes. An import file should resemble the following:


Do not modify the names of columns. As explained, the columns are mapped to attributes that are set up on the module you're exporting.


    • Related Articles

    • Costing by warehouse location

      Many businesses operate with more than one warehouse location. Often times the landed cost of a given Item ends up being different when that item is received into each location / warehouse. You would like your ERP system to do costing by warehouse ...

    • Importing, exporting, or transferring my data

      Introduction The universal translator is a powerful tool that can be used to import or export large amounts of data to and from Paragon. You can mass update your reference modules and you can also export and import transaction data. As an example, ...

    • Adjusting stock by importing inventory

      In Paragon, you can import and export files containing reference items or transactions. Here, we will show you how to make this task that much easier by exporting, editing, and re-importing inventory, thereby allowing you to complete mass ...

    • Importing journal entries

      If you have a lot of information for the general ledger, and you don't want to manually enter each record, you can use our universal translator to load the information quickly. Here, we'll walk you through how to import journal entries. If you would ...

    • How to import products, vendors, and customers from QuickBooks to Paragon

      So you've purchased Paragon for all your ERP needs (good for you!) and you've activated your QuickBooks integration.  Fantastic.  Time to get down to business.  First things first - you need to have all the relevant data from QuickBooks Online to be ...