How to upload products using the Item Template

How to upload products using the Item Template:

After logging into Commerce interface, click on the “Item Catalog” tab.

 The screen should look like this

Step 1:  Download the Item Setup form 

Step 2: Complete the Upload File: The directions are on the first tab of the file, Definition of the fields is on the second tab. Once the file is completed, save it as a CSV with a unique file name. (Tip: Save your file first as in an excel format, then do a “save as” and convert it to a CSV.) ***ALWAYS WORK OUT OF EXCEL FORMATED FILES*** 

Step 3: Upload the file: Click on “Upload Item Setup File”

Once the upload is complete, refresh the page it should look like this:

***If there was an error during the upload, under the “Export/ Import” tab, a number will appear. Click on the tab to see the details

Listed will be the file imported and an error report listed in the “Status” column. Download the file and it will explain the errors. Review the errors and correct them in the original .xlms file. Then re-save the file as a .csv to upload it.