Skip to main content
Skip table of contents

PowerLocator Inventory Import

The PowerLocator Inventory Import utility allows the import of store address codes with inventory quantity for Where To Buy (for the File Name selected) for a specific locator rule (specified in the Rule field). The PowerLocator rule must be of type Inventory to import information. The file you are importing must be a tab-delimited text file (.txt) in the following order:

  • Address Identifier (links to address table; text up to 40 characters)

  • Locator Category 1 (the value for the 1st category defined on rule, e.g., product; text up to 40 characters)

  • Source Date (part of inventory information; in date/time format)

  • Source (part of inventory information; text up to 40 characters)

  • Quantity (part of inventory information; decimal format)

  • Locator Category 2 (the value for the 2nd category defined on rule, i.e. text up to 40 characters)

Imported codes are validated against the address_code column of the address table and the value must be present before the data will be imported into the PowerLocator Rule.

To access the PowerLocator Inventory Import Utility:

  • From the Application Function Bar, select Utilities > Address Utilities > PowerLocator Inventory Import.

Utility Options

The following options are available for this utility:

Field

Description

File Name

Enter the path and name of the import file.

Rule

Select the rule to associate with these addresses. For example, "All Stores within 50 miles."

Skip First Row

If the first row of the import file is column headers, then select this check box.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.