1and1 Help Centre Categories

print article

A sample example of CSV import file.

You will need a CSV file to import an item. And also please note the following:
1. There must be a blank space after "fieldlist: "
2. Please ensure that all the words after fieldlist: are lower case
3. Ensure that you use the same separators throughout, i.e. all commas or all
semi-colons.
4. The items complete description should be in one line. Therefore no hard carriage returns.
5. Don't enter currency symbols (£89.00) in price, percentage sign (%) in tax settings.

Category CSV import"category_fieldlist: name";"description";"image"
"category: Mobile Phones|Nokia";"Great Nokias";"http://s97766685.oneandoneshop.co.uk/bs_shopdata/img/eshop_item_image.jpg"
"category: Mobile Phones|Motorola";"Motorolas";"http://s97766685.oneandoneshop.co.uk/bs_shopdata/img/eshop_item_image.jpg"
"category: Mobile Phones|MyOwn";"the best";"http://s97766685.oneandoneshop.co.uk/bs_shopdata/img/eshop_item_image.jpg"

A main category called "Mobile Phones" will be created. And it will have 3
sub-categories - Nokia, Motorola and MyOwn.

Item CSV import"fieldlist: category";"title";"price";"item_number";"description";"image";"detail_description";"detail_image"
"Mobile Phones|Nokia";"Nokia 7610";"500.00";"NK-0001";"7610 Nokia - beautiful phone";"http://your_domain.com/bs_shopdata/img/nok7619_thmbnail.jpg";"A great looking phone. Cool features";"http://your_domain.com/bs_shopdata/img/nok7619.jpg"
"Mobile Phones|Nokia";"Nokia 6610";"500.00";"NK-0002";"6610 Nokia - beautiful phone";"http://your_domain.com/bs_shopdata/img/nok6619_thmbnail.jpg";"A great looking phone. Cool features";"http://your_domain.com/bs_shopdata/img/nok6619.jpg"
"Mobile Phones|Nokia";"Nokia 6610";"220.00";"NK-0002";"6610 Nokia - beautiful phone";"http://your_domain.com/bs_shopdata/img/nok6619_thmbnail.jpg";"A great looking phone. Cool features";"http://your_domain.com/bs_shopdata/img/nok6619.jpg"
"Mobile Phones|Motorola";"Moto xxxx";"100.00";"MT-0001";"xxxx Moto - beautiful phone";"http://your_domain.com/bs_shopdata/img/motoxxxx_thmbnail.jpg";"A great looking phone. Cool features";"http://your_domain.com/bs_shopdata/img/motoxxxx.jpg"

Items Nokia 7610 and Nokia 6610 will be created under Nokia sub-category under Mobile Phones.
Items Moto xxxx will be created under Motorola sub-category under Mobile Phones.

Note: The image path, make sure you first check the FAQ: How to import imagesYou can also set up item attributes in Professional and Developer eShop in the CSV file.

"fieldlist: category";"title";"item_number";"price";"description";"color"
"Mobile Phones|Nokia";"Nokia 9910";"NK-9910";"600.00";"Great looking phone in various colors";"selection: blue|green|yellow"

So now, Nokia 9910 will have a drop-down box with the 3 colors that shoppers can
choose from.