Working with CSV files gives you total control over what's contained in the document you are working with. Today, we are going to show you how to use CSV files to update the products in your product catalog using our Import Products feature.
Reaching the Update Products with CSV Screen
First, we want to navigate to our Product Catalog using our main menu on the left-hand side.
Next, let's make sure we are in the All Products section of the catalog.
Now let's go up to the top right-hand corner of the screen and open the Import Products menu. Click on it and let's choose the bottom option Update Products with CSV.
This brings us to our workspace where we can update our products using CSV files.
Choosing your CSV File
Next, we want to choose the location of the CSV file we are using to update our products. EasyChannel gives us three options. Option 1 is to upload the file from off your computer.
To do this just locate the drive or folder your CSV file is saved in, select it, and click open.
The second option is to use the URL of your CSV file to retrieve it. To do this click Upload from HTPPS Link.
Next, enter the HTTPS address of your CSV file in the provided field and then click Get File to retrieve your CSV file.
The last option is to Upload your file from FTP. To do this click Upload from FTP and fill out your Remote Path to your CSV file and your Host. The rest of the information should AutoFill.
Select the Test Connection button to test your link and the Save button to save and exit once it works to your satisfaction.
Now that we have our CSV file chosen let's move on.
Mapping Your CSV Import
The next thing we need to do is map our import so that EasyChannel knows what fields of our CSV file to import, what fields not to import, and what imported fields go to which EasyChannel Product Fields. Once you have your file chosen your mapping screen should look like this.
On the left we have our EasyChannel Product Fields. These are the fields that are represented in our product catalog inside of EasyChannel.
The middle column is the Matching Field from the Uploaded CSV field. This is where we have to decide whether we are updating the information in the EasyChannel field to the left and if so, what CSV field we are pulling the data from. If you are not updating the field, select Don't Import.
If you do want to update the field, select the field from the CSV file that you want to pull the updated data from. So, for the Title field, we will select Title. Note, not all fields have corresponding names in EasyChannel and your CSV file so you may have to look in your CSV file and find the correct field to select.
The third row is the Fallback row. This row can be used to add in a value if your CSV file is missing a row. You can input the value into the Fallback row, and it will update all the products to the selected value.
Once you have everything set the way you like you can save the mapping settings for future use. Do so by clicking the Save Mapping Presets button.
Updating your Listings
Once you have set all fields the way you like you are ready to import your Updates. To start the import, click the Start Import button.
You will see a Success message in the lower right-hand corner of your screen letting you know the import has begun.
Once the update is complete you will receive a notification in your notification tab letting you know the import is complete.
Suggested Reading: