Streamline Your Retail Pro 9 Data with DataMoving Agent (DMA)
DataMoving Agent (DMA) is a powerful data import tool developed by Retail IQ to simplify, automate, and manage complex data imports directly into Retail Pro 9. Whether you are updating inventory, processing Web Orders, or mapping multi-subsidiary data, DMA ensures accuracy and operational efficiency every step of the way.
Core Capabilities
Visual Data Mapping
DMA features visual map creation with user-defined, color-coded confirmation of field mappings to guarantee accuracy before you execute an import.
Comprehensive Import Areas
Easily map and import data across all critical retail operational areas, including Inventory (along with DCS and Vendors), Customers, Adjustments, Vouchers (including ASNs), Purchase Orders, Sales Orders (including Web Orders), and Transfer Orders.
Intelligent Field & Style Management
The system automatically provides default field contents for unmapped fields to ensure correct Retail Pro operation. It also supports company-specific key lookups, including style definitions for the correct lookup of style SIDs.
Calculated Fields
Transform and format your incoming data on the fly. DMA's powerful "calculated fields" feature allows you to create custom formatted outputs, ensuring your data fits your exact database requirements before it imports.
Flexible Inventory Handling
Process quantity imports seamlessly based on columns with size headers. DMA gives you total control, offering options to add new items, update existing ones, or do both, entirely dictated by your chosen import map.
Automated Imports & Alerting
Set up the auto import of default maps to eliminate manual data entry and keep your systems synced. DMA maintains detailed logs of all imports—including map details, fields mapped, items updated, and specific reasons for any failures—while sending automatic email notifications if an auto import fails.
Multi-Subsidiary Support
Manage complex enterprise structures with single or multi-subsidiary support, featuring subsidiary-specific random, UPC-based, or ALU-based SID generation. Retail Pro 9 items that exist in different subsidiaries are intelligently linked by their SIDs.
DataMoving Agent (DMA) Core Features
Feature
Description
Visual Data Mapping
Features visual map creation with user-defined, color-coded confirmation to verify field mappings before importing.
Comprehensive Import Areas
Supports mapping across Inventory (with DCS and Vendors), Customers, Adjustments, Vouchers (with ASNs), and Purchase/Sales/Transfer Orders.
Calculated Fields
Transforms and custom-formats incoming data on the fly to ensure it matches your exact database requirements before import.
Automated Imports
Streamlines operations via auto import of default maps, keeping your systems synced without manual entry.
Proactive Alerting & Logging
Provides detailed logs of all imports and automatically sends email notifications of failed auto imports so issues can be addressed immediately.
Flexible Inventory Handling
Processes quantity imports based on size header columns, offering options to add new items, update existing, or both based on your import map.
Multi-Subsidiary Support
Manages complex databases with single or multi-subsidiary support, utilizing subsidiary-specific random, UPC, or ALU based SID generation.
Intelligent Default Fields
Supplies default field contents for unmapped fields and supports company-specific key lookups (like style definition) to ensure correct Retail Pro operation.