EasySearch - Smart CSV Column Mapping for Database Imports

EasySearch

EasySearch - Smart CSV Column Mapping for Database Imports

We've significantly improved the CSV import experience in the EasySearch Year Make Model Search app with an intelligent column-mapping interface that speeds up database setup and makes it more straightforward.

EasySearch - Smart CSV Column Mapping for Database Imports

What's New:

1. Visual Column Mapping Interface: The new import wizard now displays an interactive preview of your CSV data with dropdown selectors for each column. Simply match your file's columns (Year, Make, Model, Attachment, Product handle, SKU, etc.) to your database structure with a few clicks.

2. Flexible Column Recognition: Your CSV columns no longer need to be in a specific order. The app intelligently suggests matches based on column headers, and you can easily override any mapping to fit your exact file structure.

3. Live Data Preview: See exactly how your data will be imported before committing. The preview table displays your actual CSV rows, so you can verify everything looks correct before hitting the Import button.

4. Advanced SKU Handling: Enable the "Look for SKUs in the Attachment column" option if you're using product SKUs in your database file. This feature streamlines imports for merchants working with SKU-based product matching.

Benefits:

  • No more CSV reformatting - Upload files in your existing format
  • Reduced import errors - Visual confirmation before processing
  • Faster database setup - Map columns in seconds, not minutes
  • Greater flexibility - Support for various file structures and naming conventions

How to Use:

  1. Navigate to the EasySearch appDatabase tab
  2. Click “Import options” → "Import Database"
  3. Upload your CSV file
  4. Use the dropdown selectors to map each column to your database fields
  5. Enable "Column titles in the first row" if applicable
  6. (Optional) Enable SKU lookup if using product SKUs
  7. Review the preview and click "Import Database"

This update makes it easier than ever to get your Year Make Model database up and running, especially for merchants migrating from other systems or working with distributor data exports.