Importing a database



Importing a database allows multiple products to be imported or updated in eComm at one time. Most databases and spread sheet programs have an "export database to delimited file" function. This file is use by eComm.

To import product data, select the shelf or category to import the products into. Select Import from the File menu. Locate the file you wish to import from and click the OK button.



Field Delimiter
Any character can be used to separate the fields in the text file. Commas are the standard character used by most applications and are default in eComm Store/PRO. The delimiter character can be changed by entering the appropriate character in the Field Delimiter field.

Quote Character
The Quote characters is the character used to signify the start and end of a string if the delimiting character is used in a sentence. The example above uses the colon : character as the delimiter. This sentence uses the colon character.

SubmitWolf PRO is an easy to use, professional website promotional tool, which automates the process of promoting your web pages on the Internet. Languages available: French, German, Dutch, Japanese, Italian.

To use this string as one field in eComm, use the quote character, which is ".

"SubmitWolf PRO is an easy to use, professional website promotional tool, which automates the process of promoting your web pages on the Internet. Languages available: French, German, Dutch, Japanese, Italian. "

eComm ignores the colon in the middle of the string and includes the whole string as the one field to import. The quote character can be changed by entering the appropriate character in the Quote Character field.

Quote Escape Character
This field defines the character used to represent the closing quote character. Usually this is the same as the Quote Character. The quote escape character can be changed by entering the appropriate character in the Quote Escape Character field.

Decimal Point
This field defines the character used to represent a decimal point. The decimal point character can be changed by entering the appropriate character in the Decimal Point field.

Columns data fields
To give the column headings a field name, right click the column heading and select a value from the menu.



To import the product list, select the products to import by holding down the control key and clicking the products you wish to import.



When all required products are selected, click the Import button to import the data into the current category or shelf in eComm.

Updating Data
To update existing eComm product data select the shelf or category where the products requiring updating are located. Select Import from the File menu. Locate the file you wish to import from and click the OK button. Select the products to update and click the Update button. If the products being updated have the same Product Code as an item already in the eComm database, the data for each item with a matching Product Code will be updated.