Home > SI5 Documentation > User Guide > Product Data > MMPD > Importing Products > EZ Match Import

EZ Match Import

Table of contents

Importing via EZ Match

EZ Match allows you to import a spreadsheet where Category values are not present.  This option is nice for when you have a spreadsheet directly from a manufacturer or even from another application.  Most other applications do not provide a Category field, or if they do, they may not match your SI5 Category list.  Category is a required field in SI5 so this option allows you to assign category during the process.  When you click the [EZ Match] button on the main Import screen, the following screen will display:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image013.jpg

The example below demonstrates what to do when not all of your fields from your CSV file match the database fields in SI5.  To simplify things, you may want to copy and paste the data from your spreadsheet into the SI5 CSV Import Template.

Step 1 is to browse to the .CSV file you want to import.  From my CSV file, only two columns were mapped to the SI 5 database: Model and Description.

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image014.png

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image015.png

Step 2 allows you to see what fields match exactly, which are close, and which are unmapped.  You can override or assign new mappings using the dropdown menu in each row.

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image016.jpg

Step 3 will show you either exact matches or close matches for the manufacturer names in your spreadsheet:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image017.jpg

Step 4 shows you exact matches to existing products in your SI 5 database, in my example I have none.

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image018.jpg

Step 5 will show you close matches to existing products in your database. 

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image019.jpg

The "Close Matches" column shows you how many products were found to be close matches.  Click the "Details" link in the "View" column for each products listed in the grid to open another interface that will allow you to choose which existing product in your database you wish to update.  If none of the close matches are what you are looking for, right-click the product and choose "Unmatch":

File:Si5Wiki/SI5/05Product_Data/2MMPD/4Importing_Products/02EZ_Match_Import/ez_match_unmatch.jpg

 

Step 6 shows you unmatched products from the spreadsheet.

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image020.jpg

If you can’t find the products via the Details link, discussed below, you will need to assign the products a Category, one of SI 5’s required fields, if you wish to import them.  Use the dropdown in the Category column to assign this for one or multiple products (use [Ctrl] or [Shift] to select multiple rows):

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image021.jpg

In Steps 4-6 you have the following common options:

Details – this link in the View column opens a window that allows you to choose any other product from your database to match the selected import record.

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image022.jpg

Select All/Deselect All buttons allow you to choose the products to import.  You can also individually check the desired rows.

Step 7 allows you to verify your selections for import, when ready, click the [Import] button:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image023.jpg

You will receive a confirmation of the import:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image024.png

 

 

Last modified
13:45, 26 Nov 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.