CSV Field Description – ocmod.costaslabs.com

_ATTRIBUTES_

It is used to import and export attributes.

field format: Separated list of strings transfer attributes, one line = one attribute with values through a vertical bar.

attribute group|The name of the attribute|The attribute value

example:

CPU|No. of Cores|8
Memory|test 1|32GB
Screen|Screen resolution|1980x1280

The vertical line in the attribute name is not allowed.

_CATEGORY_

It is used to import and export goods categories.

field format: One or more rows recorded through transfer lines in one field.

Every single line is one category, including parental subcategories, for goods, delimited vertical bar “|”.

example:

category|Subcategory|Subcategory|product Category 1
category|Subcategory|Subcategory|product Category 2
category|Subcategory|Subcategory|product Category 3

If the category does not exist, it will be created automatically, including all parent subcategories.

The latter category (or the first, if only one line) He will be assigned as the product _MAIN_CATEGORY_ (only ocStore).

_CATEGORY_ID_

It is used to import and export goods categories.

field format: id categories separated by commas.

Enumeration id categories category_id comma separated in one line.

example:

34,45,78,89

The latter category (or the first, if only one) He will be assigned as the product _MAIN_CATEGORY_ (only ocStore).

_COLUMN_

It is used to import and export categories.

field format: Integer.

Number of columns in the drop-down menu of categories (only for the main parent categories).

_DESCRIPTION_

It is used to import and export of goods description, category or manufacturer.

field format: Text with HTML support in one or more rows.

_DISCOUNT_

It is used to import and export goods discounts.

field format: One or more rows recorded through transfer lines in one field.

discounts (one or more) It is written in the form of lines through transfer line, where one line = one discount with values separated by commas:

id group of buyers, number, priority, price, the date of the beginning, expiration date

Dates can be skipped

example:

1,2,3,999.00
1,10,2,799.00,2012-10-01
1,100,1,699.00,2012-10-01,2012-10-31

The values of the price must be indicated in the form of whole or fractional numbers, wherein the fractional part of the separator must be a point

_EAN_

Used for import and export. _EAN_ commodity.

field format: Text in one period.

European bar code standards (European Article Number).

_HEIGHT_

It is used to import and export goods height.

field format: A fractional number, where the decimal separator point (American standard).

This field allows you to import and export goods Dimensions Height.

_ID_

It is used for goods, categories or manufacturers.

field format: Integer.

Fields product_id, category_id and manufacturer_id are auto-incrementing data types and are limited by MySQL. product_id or manufacturer_id can only be imported in mode “only add” for new products or new producers.

_IMAGE_

It is used to import and export the main product image, category or manufacturer.

field format: Text in one period.

A detailed description of the import and export images, see the section Import and export images.

_IMAGES_

It is used to import and export goods more images.

field format: The text in one line in a listing of names of images separated by commas.

A detailed description of the import and export images, see the section Import and export images.

_PRODUCT_IMAGES_

It is used to import and export all goods pictures.

field format: The text in one line in a listing of names of images separated by commas.

A detailed description of the import and export images, see the section Import and export images.

_ISBN_

It is used to import and export goods.

field format: Text in one period.

ISBN (International Standard Book Number).

_JAN_

It is used to import and export goods.

field format: Text in one period.

Japanese Product number (Japanese Article Number).

_LENGTH_

It is used to import and export goods long.

field format: A fractional number, where the decimal separator point (American standard). Dimensions Length

_LOCATION_

It is used to import and export goods location.

field format: Text in one period.

location anywhere, somehow or what (…It is not known).

_MAIN_CATEGORY_

It is used to import and export of the main categories of goods (only ocStore).

field format: Transfer of parental subcategories and categories, recorded in one line with the vertical line separator “|”.

example:

category|Subcategory|Subcategory|product Category

If the category does not exist, it will be created automatically, including all parent subcategories.

_MANUFACTURER_

It is used to import and export goods manufacturer.

field format: Text in one period.

manufacturer's name (Brenda). If such a producer does not exist, the manufacturer will be created automatically.

_META_DESCRIPTION_

Used for import and export. meta descriptioncommodity, category or manufacturer.

field format: Text in one period.

Meta Description Tag description page (from the field: there is something about SEO-optimization).

_META_KEYWORDS_

Used to import and export product keywords, category or manufacturer.

field format: Text in one period.

Keywords meta tag keywords (from the field: there is something about SEO-optimization).

_META_H1_ (old name _HTML_H1_)

It is used to import and export goods, category or manufacturer.

field format: Text in one period. the old name: _HTML_H1_.

This field corresponds to the HTML-tag H1 (the same H1).

_META_TITLE_ (old name _HTML_TITLE_)

It is used to import and export goods, category or manufacturer.

field format: Text in one period.

the old name: _HTML_TITLE_.

_MODEL_

It is used to import and export goods model.

field format: Text in one period.

Export or import models (Model) commodity, if available.

_MPN_

It is used to import and export goods MPN.

field format: Text in one period.

Part number (Manufacturer Part Number).

_NAME_

It is used to import and export goods, category or manufacturer.

field format: Text in one period.

Name of product, category or manufacturer, imported or exported, depending on the selected language (Localization option).

_OPTIONS_

Used to import and export product options.

field format: One or more rows recorded through transfer lines in one field.

This field allows you to add or update product options. For a detailed description of import options, see page Import and export options.

_POINTS_

It is used to import and export of the goods points.

field format: Integer.

The price of the product in points or the number of points for the purchase of goods.

_REWARD_POINTS_

Used to import and export accrued product points by groups.

field format: One or more rows recorded through transfer lines in one field.

example:

Default:400
VIP1:500
VIP2:500

_PRICE_

It is used to import and export goods prices.

field format: A fractional number, where the decimal separator point (American standard).

example:

2341.9999

In the OpenCart database, the price is stored in decimal format (15, 4):”0.0000″
To export in format “0.00”, you need to configure the product export configuration file system/config/csvprice_pro/csvprice_pro_product_export.php

_PRODUCT_TAG_

It is used to import and export goods tag.

field format: Text in one period.

product tags, a list of words or phrases separated by commas.

_QUANTITY_

It is used to import and export goods quantity.

field format: Integer

Quantity of goods (keeping the store warehouse).

_RELATED_

It is used to import and export of related products.

field format: A string in the form of transfer of goods ID separated by commas.

Related products / Related Products (tab Connections in editing a product).

example:

34,12,45,33

It can also be used the other header and item data:

_RELATED_ID_ – line in the form of transfer of goods ID separated by commas (synonym for _RELATED_);
_RELATED_NAME_ – line in the form of transfer of items of goods, separated by commas;
_RELATED_MODEL_ – line in the form of goods listed models, separated by commas;
_RELATED_SKU_ – enumerated string SKU (artikulov) products separated by commas;
_RELATED_MPN_ – enumerated string MPN products separated by commas;
_RELATED_EAN_ – enumerated string EAN products separated by commas;
_RELATED_JAN_ – enumerated string JAN products separated by commas;
_RELATED_ISBN_ – enumerated string ISBN products separated by commas;

_SEO_KEYWORD_

Used for import and export. SEO Keyword commodity, category or manufacturer.

field format: Text without spaces or delimiters.

This field matches SEO Keyword, this is part of the url, which identifies a specific page on a website in a readable form, must be unique throughout the system.

_SHIPPING_

It is used to import and export goods shipping status.

field format: Integer (0 or 1).

delivery Status (required delivery), 0 = No, 1 = Yes.

_SKU_

Used for import and export. SKU (article) commodity.

field format: Text in one period.

Marking of goods (arbitrarily or on the basis of your warehouse such as).

_SORT_ORDER_

It is used to import and export goods, category or manufacturer.

field format: Integer.

The sort order (Who said, that they will be at the forefront….)

_SPECIAL_

It is used to import and export goods stocks.

field format: One or more rows recorded through transfer lines in one field.

This field allows you to add or update the goods stocks. The format of a list of actions separated by line break, = one row one action with values separated by commas:

ID group of buyers, priority, price, the date of the beginning, expiration date

Dates can be skipped

example:

1,3,999.00
1,2,799.00,2012-10-01
1,1,699.00,2012-10-01,2012-10-31

_STATUS_

It is used to import and export goods, category or manufacturer.

field format: Integer (0 or 1).

status of goods, category or manufacturer, Where 0 = off, 1 = included.

_STOCK_STATUS_ID_

It is used to import and export goods id status of stock.

field format: Integer.

ID status (AVAILABILITY), in the OpenCart database it is stock_status_id in SQL table oc_product.

_STOCK_STATUS_

It is used to import and export appellation status of stock.

field format: Text in one period.

Status, displayed to, when the product is no longer in stock (AVAILABILITY), created automatically if this status is not in the store base. In SQL table oc_product a numeric value is written stock_status_id

_TOP_

It is used to import and export categories.

field format: Integer.

Show the main menu (only for the main parent categories).

_UPC_

Used to import and export UPC (barcode) commodity.

field format: Text in one period.

Barcode Product (Universal Product Code).

_WEIGHT_

It is used to import and export of goods weight.

field format: A fractional number, where the decimal separator point (American standard). Dimensions Product weight (kg, mg, etc.).

_WIDTH_

It is used to import and export products Width

field format: A fractional number, where the decimal separator point (American standard). Dimensions Width.