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
  • Data Manager Configurations Guide
  • Accessing the Data Manager Configurations Page
  • Add a New Configuration
  • Edit Configurations
  • Verify the Data flow
  • SFTP User Integration in Data Configuration

Was this helpful?

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

Configurations

Discover how to manage data flow with HotWax Commerce's Data Manager Configurations.

Data Manager Configurations Guide

The Data Manager Configurations page in the OMS empowers users to effectively manage data flow into and out of the OMS. This guide provides step-by-step instructions on adding and editing configurations, as well as integrating SFTP details into the configurations.

Accessing the Data Manager Configurations Page

  1. Go to the Hamburger menu.

  2. Select Settings.

  3. Click on Data manager configurations.

Add a New Configuration

Adding a new data configuration in OMS enables users to specify how data is imported and exported.

Steps:

  1. Click the Add button on the configurations page.

  2. In the modal that appears, provide information for fields such as Config ID, Description, Import Service, Import Path, Export Content ID, Export Service, Export Path, File Name Pattern, and Multi-threading.

  3. Click Add again to save the new configuration.

Configuration Information Table:

Field
Description

Config ID

A unique identifier for the configuration.

Description

A brief description of the configuration.

Import Service

The OMS service for importing data into OMS.

Import Path

The path from which the data is kept for OMS to import.

Export Content ID

Content ID for exporting data.

Export Service

The OMS service or workflow for exporting data.

Export Path

The path to which the data will be exported.

File Name Pattern

A pattern for naming files.

Multi-threading

Y/N configuration for processing multiple files.

Use Cases of some configurations:

  1. File Name Pattern:

    • Scenario: Multiple file types share the same path on an SFTP server.

    • Purpose: Uniquely identify and categorize files for accurate processing by the import service.

  2. Multi-threading:

    • Scenario: Large data imports, e.g., product inventory resets with files exceeding 20 MB.

    • Purpose: Speed up processing by grouping data and allocating multiple threads simultaneously.

    • Note: Default value is 'N' (No)

  3. Export Content ID:

    • Scenario: HotWax uses content templates for exporting data with specific field values.

    • Purpose: Specify a unique identifier (Content ID) to ensure the export service selects the correct template for accurate data rendering and export.

  4. Export/Import Path:

    • Scenario: Data communication between OMS and external systems through SFTP.

    • Purpose: Specify accurate paths for file import/export; incorrect paths can result in failed data communication.

Edit Configurations

Editing an existing Data Manager Configuration allows users to update configurations based on evolving business needs or changing data sources.

Steps:

  • Search for the desired configuration by name or ID.

  • Click the Edit button at the end of the search result.

Config ID cannot be changed after creation. Create a new Config if a new Config ID is needed.

Verify the Data flow

In HotWax Commerce, the ability to view data logs is crucial for verifying the accuracy and completeness of imported data. These logs offer insights into the status of imported data, allowing users to verify the success of operations during the verification process.

Steps

  1. Locate Desired Configuration:

  • Navigate to the search bar within the HotWax Commerce Data Manager Configurations page.

  • Search the configuration with the service/keyword or locate the desired service from the list.

  1. Open the Data manager logs for the Configurations:

  • Identify the relevant configurations in the search results.

  • Click on the open link icon located in front of the service name.

  1. Check the Status of the Service:

  • Review the displayed information to check the status of the service.

  • If any of the services fails, users can read the failed records through the data logs. Failed records are simply JSON/CSV file which has the failed reason appended at the end of the record, which can be used for troubleshooting.

View Logs for Detailed Information:

  • Click on the Log button in the Import data page to access detailed logs related to the service.

  • Use the logs to gather information about the service flow and identify the cause of any potential failures.

  • Non-technical users can utilize AI tools like ChatGPT to interpret log information and understand the service status.

SFTP User Integration in Data Configuration

In the OMS data import/export process, setting up SFTP users is essential for smooth operations. Server paths, beginning with the SFTP username (e.g., dummySftpUser/HotWax/SalesOrders/), follow a consistent convention. HotWax simplifies user integration, minimizing manual errors. This streamlined setup is crucial for bulk user integration, allowing easy association with diverse import paths. By incorporating specific SFTP users into configurations, users can efficiently manage data flow, ensuring secure and error-free transactions within the OMS.

Steps:

  1. Select Add SFTP User to Config.

  2. Choose the SFTP user configuration path.

  3. Select the FTP Config and Config ID.

  4. Save the configuration.

By following these steps, users can manage data configurations within the OMS, ensuring efficient data flow and integration.

PreviousData Import and ExportNextTroubleshooting

Last updated 3 months ago

Was this helpful?

The system will open the for the selected service.

Ensure that the status of the service is finished. You can view different data status types

Import Data page
here.