/media/djcatalog2/import/images/
/media/djcatalog2/import/files/
cat_id
value (or column, at all) for a product, then chosen 'Default Category' will be used instead.
List of valid column names and their description:
Column name | Required | Notice |
---|---|---|
id
|
No |
If provided, has to point to existing product. Product will be updated then with the provided data for CSV file. If ID is empty (or 0), a new product will be created. |
name
|
Yes | Should be unique within product's category, because based on product's name, an alias is being generated. Therefore there cannot be two products with the same alias. |
alias
|
No | --- |
group_id
|
No | ID of product's field group. |
cat_id
|
No | ID of product's category. |
producer_id
|
No | ID of product's producer. |
description
|
No | Full description. Can contain HTML code. |
intro_desc
|
No | Short description. Can contain HTML code. |
price
|
No | Regular price. Should be a valid floating point number or an integer. Dot should be used as decimal point, e.g. 1099.95 |
special_price
|
No | Discount price. Should be a valid floating point number or an integer. Dot should be used as decimal point, e.g. 1099.95 |
metatitle
|
No | meta-title. |
metakey
|
No | meta-keywords. |
metadesc
|
No | meta-description. |
published
|
No | State [0/1]. 0 = un-published, 1 = published. |
featured
|
No | Featured product flag [0/1]. 0 = not featured, 1 = featured. |
ordering
|
No | Integer number indicating product's order within its category. |
created
|
No | Creation date in Date-Time format: [RRRR-MM-DD HH:MM:SS] or [RRRR-MM-DD]. |
created_by
|
No | ID of the Joomla! user who should be the owner of the product. |
images
|
No | Comma-separated list of file names that should be located in /media/djcatalog2/import/images/ directory. For example: image1.jpg,image2.jpg,image3.jpg |
files
|
No | Comma-separated list of file names that should be located in /media/djcatalog2/import/files/ directory. For example: chart1.pdf,manual.pdf |
name | description | intro_desc | price | special_price | featured | images | files |
---|---|---|---|---|---|---|---|
Crystal vase | Very beautiful crystal vase from XVI century. | Nice crystal vase. | 1200.00 | 99.95 | 1 | vase1.jpg,vase2.jpg | |
TV set | 40", Full HD LCD television set | Real must-have | 2999.00 | 2699.95 | 0 | tv40.jpg | manual.pdf,chart.xls |
id | cat_id | producer_id | name | price |
---|---|---|---|---|
24 | 2 | 4 | Updated product | 599.00 |
25 | 2 | 5 | Updated product #2 | 499 |
2 | 6 | New product #1 | 1999 | |
2 | 6 | New product #2 | 300.00 |
List of valid column names and their description:
Column name | Required | Notice |
---|---|---|
id
|
No |
If provided, has to point to existing category. Category will be updated then with the provided data for CSV file. If ID is empty (or 0), a new category will be created. |
name
|
Yes | Should be unique within category's parent category, because based on category name, an alias is being generated. Therefore there cannot be two sibling categories with the same alias. |
alias
|
No | --- |
description
|
No | Full description. Can contain HTML code. |
metatitle
|
No | meta-title. |
metakey
|
No | meta-keywords. |
metadesc
|
No | meta-description. |
published
|
No | State [0/1]. 0 = un-published, 1 = published. |
ordering
|
No | Integer number indicating category's order within its parent category. |
created
|
No | Creation date in Date-Time format: [RRRR-MM-DD HH:MM:SS] or [RRRR-MM-DD]. |
created_by
|
No | ID of the Joomla! user who should be the owner of the category. |
images
|
No | Comma-separated list of file names that should be located in /media/djcatalog2/import/images/ directory. For example: image1.jpg,image2.jpg,image3.jpg |
id | parent_id | name | description | images |
---|---|---|---|---|
1 | Cars | All available cars. | cars.jpg | |
1 | Motorbikes | Full range of our motorcycles. | bikes.jpg | |
1 | Trucks | The biggest 18-wheelers. | truck.png |
List of valid column names and their description:
Column name | Required | Notice |
---|---|---|
id
|
No |
If provided, has to point to existing producer. Producer will be updated then with the provided data for CSV file. If ID is empty (or 0), a new producer will be created. |
name
|
Yes | Should be unique, because based on producer's name, an alias is being generated. Therefore there cannot be two producers with the same alias. |
alias
|
No | --- |
description
|
No | Full description. Can contain HTML code. |
metatitle
|
No | meta-title. |
metakey
|
No | meta-keywords. |
metadesc
|
No | meta-description. |
published
|
No | State [0/1]. 0 = un-published, 1 = published. |
ordering
|
No | Integer number indicating producer's order. |
created
|
No | Creation date in Date-Time format: [RRRR-MM-DD HH:MM:SS] or [RRRR-MM-DD]. |
created_by
|
No | ID of the Joomla! user who should be the owner of the category. |
images
|
No | Comma-separated list of file names that should be located in /media/djcatalog2/import/images/ directory. For example: image1.jpg,image2.jpg,image3.jpg |
id | name | description | images |
---|---|---|---|
1 | Car manufacturer 1 | Lorem ipsum dolor sit amet... | cf1.jpg,cf2.jpg |
2 | Car manufacturer 2 | Lorem ipsum dolor sit amet... | cf3.jpg,cf4.jpg |
Car manufacturer 3 | Lorem ipsum dolor sit amet... | cf5.jpg | |
Car manufacturer 4 | Lorem ipsum dolor sit amet... | ||
Car manufacturer 5 | Lorem ipsum dolor sit amet... | cf6.png,cf7.jpg |