Description
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.