Documents
HomeGlossary
System Admins
System Admins
  • Launchpad
  • Administration
    • Company
      • Create Product Store
      • Manage Product Store
      • Manage Shopify Shop
    • Users
      • Create Users
      • Manage Users
      • Manage User Permissions
      • Create Pickers
      • Troubleshooting
        • Application Access Issue
        • How to Bulk Import Employee
    • User Permissions
      • BOPIS App
      • Fulfillment App
      • Job Manager App
      • Receiving App
      • Picking App
      • Import App
      • Users App
      • Facilities App
      • Pre-Order App
      • Cycle Count App
    • Facilities
      • Add New Facilities
      • Manage Existing facilities
      • Add Facility Address
      • Manage Operating Hours
      • Manage Product Stores
      • Configure Online Fulfillment
      • Configure Fulfillment Capacity
      • Manage Facility Staff
      • Manage Locations
      • Disabling Facilities
      • Manage Parkings
      • Manage Groups
    • Delete Customers
    • SOLR Indexing
    • Data Manager
      • Data Import and Export
      • Configurations
      • Troubleshooting
        • Data Not Imported
        • SFTP Errors
        • Manual Data Import
        • Shopify MDM
        • Schedule Error Mail
  • Product Store
    • Configure Product Store
    • Add More Product Stores
  • Initial Setup
    • Add DBIC
    • Load Facilities
    • SFTP Configuration
    • Configure System Property Data
  • Inventory
    • Multichannel Inventory Setup
  • Fulfillment
    • Shipping Methods
      • Create Carrier
      • Create Shipping Boxes
      • Shipping Gateways
      • Map Carrier Shipment Methods
    • How to Map Shipping Method in HotWax Commerce
    • Configure Rate Shopping
Powered by GitBook
On this page
  • Scenario 1: Data Not Imported in OMS
  • Steps to Resolve
  • Scenario 2: Incorrect File Format
  • Steps to Resolve
  • Scenario 3: Empty Records
  • Steps to Resolve

Was this helpful?

Edit on GitHub
Export as PDF
  1. Administration
  2. Data Manager
  3. Troubleshooting

Data Not Imported

Troubleshoot data import issues in the HC OMS to ensure successful data loading and processing.

PreviousTroubleshootingNextSFTP Errors

Last updated 3 months ago

Was this helpful?

Scenario 1: Data Not Imported in OMS

You scheduled a job to import data into OMS, but the imported data is not loaded. This could be due to the job Process bulk imported files not being scheduled in the Job Manager application.

Steps to Resolve

  1. Verify Job Status:

  • Check the status of the job that imports data in bulk. Ensure it is scheduled and completed successfully in the Job Manager app.

  1. Schedule Process bulk imported files:

  • Navigate to the Miscellaneous page in the Job Manager application.

  • Locate the Process bulk imported files job and schedule it.

  • The suggested frequency is 15 minutes, but adjust based on specific requirements.

  1. Check Data Processing:

  • After scheduling the Process bulk imported files job, observe the Data Manager logs in the EXIM page of OMS to confirm that the imported data is being processed.

  1. Check Data Manager Logs in OMS:

  • Go to Hamburger Menu > MDM > EXIM > Import section.

  • Navigate to the import menu to find the files you have imported in OMS.

  • Check the status of the files; they should transition from Pending to Finished.

Scenario 2: Incorrect File Format

When importing data from external systems into HotWax Commerce, files must adhere to specific formats supported by the system. Failure to do so can result in import failures and data discrepancies.

Steps to Resolve

  1. Verification Steps:

  • Navigate to the Exim page from the MDM section via the Hamburger Menu.

  • Select the relevant import type (e.g., inventory import) to review import logs.

  • Identify and inspect the failed records column in the logs for error details.

  1. Checking File Format:

  • Download the uploaded file from the import log.

  • Verify that the file format is CSV, as HotWax Commerce supports CSV format for data imports.

  • If the format is incorrect (e.g., XLSX), investigate the data transformation process:

    • If handled by middleware, review the transformation flow.

    • Contact HotWax Commerce support to check Nifi flow if handled internally.

Scenario 3: Empty Records

Empty records in an imported file indicate that the expected data from the external system is not present or properly generated, leading to failed imports in HotWax Commerce.

Steps to Resolve

  1. Verification Steps:

  • Navigate to the Exim page from the MDM section via the Hamburger Menu.

  • Select the relevant import type (e.g., inventory import) to review import logs.

  • Verify if the imported file contains any data records.

  1. Checking File Records:

  • If the file format is correct (CSV), review imported records from the file.

  • Ensure the external system generates data records:

    • Access the SFTP path specified for file uploads.

    • Verify the existence of records in the SFTP directory.

Refer to for correct file paths and SFTP settings.

user manuals