This repository provides ready-to-use integration templates for connecting various ERP and inventory management systems with Luminovo. The templates are designed to streamline the process of extracting, transforming, and importing data such as parts, inventory, and pricing into Luminovo’s platform. Currently, the following integration templates are available:
CSV Integration
PartsBox Integration
SelectLine Integration
Below, we describe the functionality and configuration options for each template and explain how users can customize price and inventory calculations.
1. CSV Integration Template
Purpose:
The CSV integration template allows users to import parts, inventory, and pricing data from a CSV file into Luminovo. This is ideal for organizations that export data from their ERP or inventory system in CSV format.
Functionality:
Reads a CSV file containing parts and inventory data.
Processes and transforms the data into the format required by Luminovo.
Sends the processed data directly to Luminovo via its API.
Configuration:
CSV File Path: The script can be configured to read from a specific CSV file. Adjust the file path as needed.
Column Mapping: If your CSV columns differ from the default, you can adjust the mapping logic in the script.
Environment Variables: API keys and Luminovo tenant information are typically set via environment variables.
Customizing Price and Inventory Calculation:
Look for functions or logic blocks in the script that process price and inventory columns. You can adjust how prices are parsed, converted, or calculated (e.g., applying discounts, currency conversion).
Inventory calculation logic (e.g., summing stock across locations) can also be customized in the data processing section.
2. PartsBox Integration Template
Purpose:
The PartsBox integration template connects directly to the PartsBox API to fetch parts, inventory, and pricing data, then imports it into Luminovo.
Functionality:
Authenticates with the PartsBox API using an API key.
Fetches all parts and associated inventory/pricing data.
Processes the data into Luminovo’s required format.
Optionally saves the processed data for review.
Sends the data to Luminovo via its API.
Configuration:
API Credentials: Set
PARTSBOX_API_KEYand optionallyPARTSBOX_BASE_URLin your environment variables.Pricing Method: The environment variable
PARTSBOX_PRICING_METHODallows you to select the pricing strategy (e.g.,most_recent,average, etc.).Luminovo Credentials: Set
LUMINOVO_TOKENin your environment.
Customizing Price and Inventory Calculation:
The logic for parsing and transforming data is typically found in the
data_processormodule (e.g.,parse_partsbox_components,parse_partsbox_inventory).To adjust how prices are calculated (e.g., which price tier to use, how to handle missing prices), modify the relevant functions in
data_processor.py.Inventory calculation (e.g., which stock levels to include) can also be customized in these functions.
3. SelectLine Integration Template
Purpose:
The SelectLine integration template is designed for users of the SelectLine ERP system, enabling them to export and import parts, inventory, and pricing data into Luminovo.
Functionality:
Connects to SelectLine’s data export (typically via CSV or direct database access).
Processes and transforms the data for Luminovo.
Sends the data to Luminovo’s API.
Configuration:
Data Source: Configure the script to point to the correct SelectLine data export or database.
Environment Variables: As with other templates, API keys and tenant information are set via environment variables.
Customizing Price and Inventory Calculation:
Adjust the data processing logic in the script or associated modules to change how prices and inventory are calculated.
For example, you might want to use a specific price list, apply markups, or filter certain inventory locations.
Where to Adjust Price and Inventory Calculation
For all templates, the core logic for price and inventory calculation is typically found in the data processing modules (e.g., data_processor.py). Look for functions such as:
parse_partsbox_inventoryparse_csv_inventoryparse_selectline_inventory
Within these functions, you can:
Change which fields are used for price and inventory.
Apply custom business logic (e.g., discounts, markups, currency conversion).
Filter or aggregate inventory data as needed.
Tip:
Always review and test your changes with a small data set before running a full import to Luminovo.
Conclusion
These integration templates are designed to be flexible and easily customizable for your organization’s needs. By adjusting configuration options and modifying the data processing logic, you can tailor the import process to match your ERP system’s data structure and your business rules for pricing and inventory.
For more details, refer to the code comments and documentation within each script. If you have questions or need help customizing your integration, feel free to reach out or open an issue in the repository.