Today we are going to be working with CSV files to create brand new product entries for our EasyChannel Product Catalog. CSV files are fairly simple to work with but can be confusing if you've never worked with them before, so, we are going to take you step-by-step through the process.
Reaching your Create New Products with CSV Screen
First, reach your Product Catalog by choosing Products from the main menu on the left-hand side of your screen.
Next, make sure you are in the All Products section of your catalog.
Now we find the Import Products menu in the top right-hand corner of the screen and select Create New Products from CSV.
We should now find ourselves at the Create Product with CSV screen.
Choosing your CSV File
Next, we need to choose our CSV file that we want to use to import our new product(s). EasyChannel gives us three options for doing this. The first option is to select our file from its location on our computer. Do this by selecting Upload File From Computer, selecting the file from the folder it's in, and selecting Open.
The second option is to upload your CSV from it's https URL. To do this you must know the URL of your CSV file. Select Upload File From https Link and a pop-up will appear. Enter the URL in the space provided and hit Get File.
The last choice is to upload from FTP. To do this select Upload From FTP and enter the Host and Domain. The rest of the information should AutoFill.
When finished you can select Test Connection to test the link and then Save to exit when you are finished.
Now that we have our CSV file chosen, we can move on to the mapping section.
Mapping your 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 filling in the information in the EasyChannel field to the left with anything and if so, what CSV field we are pulling the data from. If you are not placing a value in the field, select Don't Import.
If you do want to place a value in the field, select the field from the CSV file that you want to pull the 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 set 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.
Creating your Products
When your mapping is complete and you are ready to create your products click Start Import to begin creating your products.
You will receive a Success message in the lower right-hand corner letting you know your import has begun.
Once complete, a notification in your notification center will inform that your import is finished.
Suggested Reading: