The following instructions will guide you through the steps for creating and uploading product files for your ecommerce database. You may wish to print this page for reference

Where Is It?
In eManager, in the Product Related Activities section, you will find a new item at the bottom of the drop-down menu called File Upload. Select this, and click on the Go button.

How Does It Work?
You must first create your database or text file using the file specifications outlined below.  You may use any database program that supports dbase III (.dbf) format, or any text editing program such as Notepad, Wordpad, or Microsoft Word to create a text (.txt) file.
You may also download your existing database file from your eManager and edit it if you wish.

If You Don’t Have A Database Program…
If you do not have a database program that supports .dbf files, some word processing programs, such as Microsoft Word 97, will let you open and edit the .dbf file you download from your eManager. However, please note that after opening the program in Word, you MUST save the file in plain text (.txt) format. Word will allow you to save changes you make to the file in the original .dbf format, but the system will not recognize it as a valid .dbf file and will not allow upload of a .dbf file edited in a text editor.

Download Existing Product File
To download your existing product file do the following:

• Select Download System Files from the Configuration and Setup section of your eManager and click on the Go button.

• Check the Products box on the file download page, and click on the Download Zip Files button.

• Select a location to save the file on your local computer and click the Save button.

• The .dbf file will be downloaded in a .zip compressed format. You will need to use a zip utility program to unzip the file. (If you checked more than one box on the Download Files page, the .zip file will contain all of the files you selected.)

File Formats
You may upload a tab delimited text (.txt) file or a dbase III (.dbf ) file which meets the product upload specifications. The local file name does not matter. The specifications are as follows:

Text Long - All Product Fields
Tab separated (delimited) text file with existing fields in the online database.
Required fields-> prodcode, descript, price
To see examples of this file setup go to File Upload in your eManager and click on the Specifications hyperlink at the top of the page.

Text Short - Minimum Product Fields
Upload a tab separated text file with either three fields, four fields, or five fields as shown below. The field order must be as specified below. The Category and Attribute fields may be blank. For example, if you wish to use the Attribute field, but not the category field, you MUST use all of the fields in the order shown for 5 Fields in order to include the Attribute field. However, you may leave the Category field blank.

3 Fields
Required fields in required order->prodcode, descript, price

4 Fields
Required fields in required order->prodcode, descript, price, catid

5 Fields
Required fields in required order->prodcode, descript, price, catid, attribs

To see examples of this file setup go to File Upload in your eManager and click on the Specifications hyperlink at the top of the page.

dbaseIII - Any table with any field names
The dbase importer allows field matching between your custom local table and your online products database.

Upload File
Once you have created your product file you can upload it. 

• In your eManager, in the Product Related Activities section, select Upload Products.

• Click the radio button that corresponds to the file type/format you are uploading.

• Click the Browse button to browse the files on your local computer and select the file you wish to upload.

• Click the Upload File button.

• When the upload is complete you will get a screen notifying you that the upload was successful.
  

Import Products to Database
Once you have successfully uploaded your product file to your eManager, the next step is to import the products into the database. Select from the following import options:

Append or Replace
If you select Append, the file you uploaded will be added to the existing file.  If you select Append, you will also need to select either Update or Ignore from the options on the opposite side of the Import panel.

Update If you select this option the file you upload will update all fields that contain different information for existing product records, and add new product records, if any, to the database.

Ignore  If you select this option the file you upload will be added to the existing file regardless if matching product codes already exist. It will make no changes to existing product records.

Replace
If you select Replace the file you uploaded will completely replace the existing file.

Match Fields
Check your upload file's fields (in the green table) against the existing file fields (the blue table) and be sure that they match up. Use the drop-down menu to select a specific record number to view/compare.

Import Products
Click the Import Products button to import your uploaded file to your product database. When the import is complete a confirmation screen will be displayed listing the number of products you imported, and the total number of new records created, if any.

Your product file upload is now complete!