CSV Import - PHP eSeller

Example file: in csv format or as a text file

csv is a text file where each field is separated by a comma character and each line represents a record.

• item_number

  Unique item number

• item_name

  Item name

• mc_gross

  Gross value which will be something like : 34.99

• item_title

  The title of the product

• item_description

  The brief item description

• item_description_full

  The item description

• maincategory

  The numerical value of the main category which must already exist in the database

• subcategory

  The numerical value of the sub category which must already exist in the database

• folder

  The folder on your web server where the file is located in the form /myserver/www/files/

• filename

  The file name of the digital file e.g. test.zip Note that this does not include the folder name

• filename_small_mp3

  The url of the mp3 clip in the form http://www.server.com/clips/test.mp3

• item_image

  The url of the small image in the form http://www.yourserver.com/image/test.jpg

• pagetitle

  The page title for the item

• metadescription

  The metadescription for the item

• keywords

  Any extra keywords to help searching

• sort order

  The sort order number for this product item. If it is listed by category, then the sort order will be sorted within the category listing

• Notes :

  You cannot use the comma character (,) in any field because it is used as the field separator in csv.

  You cannot update existing records, only create new records.

  The maincategory and subcategory are entered as numbers and they should already exists within the admin area of PHP-eSeller.

  The currency code (e.g. USD) is not defined in the csv file, but is taken as the default value in setup.

  The email texts are not defined in the csv file, but are assumed to be the default as defined in setup.

  You can only have one file attached to a product, although you can add more once the product has been created of course.