UnoPim Custom XLSX Connector
UnoPim Custom XLSX Connector makes Excel product import export easy with custom mapping, reusable templates, and full control of product data.
- Flexible XLSX import and export with custom column mapping templates.
- Sync products, variants, categories, attributes, and media files.
- Multi currency pricing with automatic currency based columns.
- Channel and locale product data in a single spreadsheet view.
- Reusable templates for consistent and fast data work.
- Batch processing for large product catalogs with stable performance.
- Media export with optional file copy or path only mode.
- Configurable product support with super attribute mapping.
- Safe Excel export to prevent formula injection risks.
- Description
- Reviews
- FAQ
- Customers ()
- Specifications
- Cloud Hosting
- Changelog
UnoPim Custom XLSX Connector helps you import and export product data using Excel files with ease. It has a flexible column mapping system. This means you can match your data with any Excel file format.
It does not need a fixed template. You can use different Excel sheet designs without any trouble. This makes your work faster and simpler.
It connects all product information in one place. This includes product variants, categories, attributes, prices, and images. You can manage everything in one Excel file flow.
It also supports multiple languages and sales channels. You can use different currencies and local values for different regions. This helps build large product catalogs. It works well for large businesses that handle large volumes of product data in Excel.
Use the UnoPIM Dynamic Pricing Rule to manage pricing with ease. It helps set flexible prices and update them across your product catalog.

Highlighted Features of UnoPim XLSX Import Export Connector
Flexible Column Mapping Templates
Create your own Excel format. Match any column to UnoPim fields with ease.
Multi Entity Product Sync
Sync products, variants, categories, attributes, and families in one easy step.
Multi Currency Pricing Support
Add prices for different currencies. Each one has its own column for clear pricing.
Channel & Locale Data Handling
Manage many languages and sales channels in one Excel file. Keep all data in one place.
Media Import & Export Control
Import and export product images, files, and galleries. Use full files or only file paths.
Configurable Product Structure
Manage configurable products with ease. Supports main products, attributes, and linked variants.
Why do we need UnoPim Custom XLSX Connector?
UnoPIM Excel integration replaces fixed formats with flexible mapping that fits real business needs. This reduces manual work, errors, and slow product data updates.
Many teams also struggle with multi-language catalogs. Product variants and complex pricing are hard to manage in basic spreadsheets.
Get full control over Excel setup, mapping rules, and product links for smooth data migration. It fits your current workflow, so no changes are needed.
It improves product data accuracy and reduces manual effort in XLSX import export. Product data becomes easier to manage, even for large and growing catalogs.
It is built from real eCommerce PIM workflows. In these systems, easy and flexible data sharing is very important.
Improve product discovery with the UnoPIM AI Product Feed Connector for OpenAI Search. It uses AI tools to create product feeds and helps your products show better. It also makes catalog management simple.
Use Cases
-
Ecommerce Product Migration
Move large product catalogs from old systems into UnoPim. Use clean Excel templates for easy import.
-
Multi-Channel Catalog Management
Manage product data for many channels in one Excel file. Keep language and content structured and organized.
-
Marketplace Data Preparation
Create marketplace product feeds with Custom Mapping XLSX using flexible columns and mapping rules.
-
Bulk Product Updates via Excel
Update prices, attributes, and stock in bulk. No need to use admin panel.
XLSX Template Mapping
XLSX template mapping gives full control over how Excel columns connect to UnoPim data. It helps teams avoid fixed formats and match spreadsheets to their own workflow.
- Custom column names for all product fields
- Default values for empty cells in templates
- Separate separators for multi select attributes
- Custom labels for product and structure fields
- Reusable mapping templates for import and export

Media & Asset Handling
This feature controls how files, images, and galleries are imported and exported through Excel. It supports full file transfer or simple path based handling.
- Optional media packaging during export
- Image, file, and gallery support in Excel columns
- Path only mode for external storage systems
- Safe export without formula injection risk
- Clean handling of large media data

Localization & Channel Management
This helps manages multi language and multi channel product data in one Excel file. It ensures correct mapping and validation during import.
- Channel based attribute control
- Locale based product values per row
- Default fallback for missing data
- Validation against channel rules
- Single file for global catalogs

Pricing Management in Multiple Currencies
Pricing is handled across multiple currencies using Excel columns. It keeps structure simple and easy to manage.
- One column per currency (USD, EUR, etc.)
- Currency detection from headers
- Clean mapping back during import
- Supports multi market catalogs
- Easy global price updates

Category & Product Structure Control
This feature manages categories and product structure inside Excel. It supports flexible and complex catalog setups.
- Multiple category codes in one column
- Configurable product type handling
- Parent child variant linking support
- Template based category filtering
- Safe validation for category mapping

Support
For any query or issue, please create a support ticket here http://webkul.uvdesk.com/. You may also check our all UnoPim Extensions.
Specifications
Frequently Asked Questions
Move to Cloud Today
AWS Free tier hosting for one year by amazon web services, for more details please visit AWS Free Tier.
GCP Free tier hosting for one year with 300 credit points by google cloud platform, for more details please visit GCP Free Tier.
Azure free tier hosting for one year with 25+ always free services, for more details please visit Azure Free Tier.
In our default configuration we will provide tremendous configuration for your eCommerce Website which is fast to load and response.
Default Configuration Details of Server
- 1 GB RAM
- 1 Core Processor
- 30 GB Hard Disk
- DB with 1 GB RAM and 1 Core Processor
* Server Configuration may vary as per application requirements.
Want to know more how exactly we are going to power up your eCommerce Website with Cloud to fasten up your store. Please visit the Cloudkul Services.
Get Started with Cloud- - Feature Add (+)
- - Feature remove (-)
- - Bug Fixed (!)
- - Modification (*)
- + Compatibility bump — now supports UnoPim 2.0+, Laravel 12+, and PHP ^8.3.
- + Updated installation instructions to align with the latest UnoPim structure.
- + Service provider registration updated — now requires adding provider in bootstrap/providers.php (replacing legacy config/app.php method).
- + Module registration flow improved as per UnoPim 2.x conventions.
- - Minor stability improvements for rule execution and module bootstrapping.
- + Initial setup and feature implementation for UnoPim XLSX Connector.
- + Custom Mapping Templates: Create and manage templates to map UnoPim product attributes to specific XLSX/XLS column headers.
- + Comprehensive Attribute Mapping: Support for all major attribute types (text, select, multiselect, boolean, number, date, etc.).
- + Advanced Data Handling: Ability to map categories, families, family variants, and parent-child relationships.
- + Queue-Based Processing: Large dataset handling leverages UnoPim's background job queue.
- + Import/Export Functionality: Core logic for importing and exporting product data in XLSX/XLS format.