This is a database management feature that allows you to add, remove and update some or all of the records in your product database whenever you like, and as often as you like. You can even elect to update one or more specific fields!
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
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
You may also download your existing database file from your eManager and edit it if you
If You Dont 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
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.)
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.
Required fields in required order->prodcode, descript, price
Required fields in required order->prodcode, descript, price, catid
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
Once you have created your product file you can upload it.
In your eManager, in the Product Related Activities section, select
Click the radio button that corresponds to the file type/format you are
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.
If you select Replace the file you uploaded will completely replace the
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.
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!