Product code | string up to 25 characters | The product code (article) is necessary for a quick and easy search for the desired item on the company's website and in your personal account when a client calls by phone. The length of the article is 25 characters (numbers, Cyrillic, Latin, signs "-", "_", ". ", "/" and space). |
Position_name | string up to 100 characters | The name of the product or service. Obligatory field. |
Search_queries | string up to 255 characters | Search queries are used to search the portal directory. Obligatory field. Contains search queries for the position, separated by commas (no more than 255 characters). The length of each word is no more than 50 characters. |
Description | string up to 12160 characters | Description of this product or service. Obligatory field. |
Product_type | line | The field determines if the product belongs to wholesale, retail or services. For a correct definition, it is recommended to set the name of the category and the product's belonging. r - the product is sold only at retail w - products are sold only in bulk u - products are sold wholesale and retail s is a service |
Price | number | The price of a product or service |
Price from | line | The field defines whether "price from" is set for the item. Takes one of two values: - + — "price from" is set;
- - — "price from" is not set.
|
Currency | line | Currency, monetary unit of the price USD | USD | EUR | CHF | RUB | GBP | JPY | plz | other | BYN | KZT | MDL | p | rub | dol | $ | UAH |
Unit of measurement | line | unit of measurement 2g | 5g | 10 g | 50 g | 100g | 10cm | PCS. | 10 pieces. | 20 pcs. | 50 pcs. | 100 pieces. | ampoule | balloon | bank | blister | bobbin | barrel | bottle | bay | watt | bucket | departure | g | ha | gigacalorie | year | g/sq. m | gave | two months | day | dose | units | kW | canister | carat | sq. dm | sq. m | sq. cm | sqft | quarter | kg | kg/sq. m | km | kit | box | cubic dm | cubic meters | l | sheet | m | mW | month | bag | minute | ml | mm | skein | set | week | number | object | pallet space | couple | party | patch | linear meters | half a year | seed unit | bird place | flight | roll | section | word | cm | change | weaving | glass | page | day | t | t. c. p. | t/km | tablet | circulation | thousand pieces | thousand | tube | packaging | service | vial | hour | people | syringe tube | yard | box |
Minimum_order_quantity | number | MOQ |
Wholesale price | number | Wholesale prices separated by semicolon ― ';' |
Minimum_order_wholesale | number | The minimum order quantity corresponding to wholesale prices is also separated by ';' |
Quantity | number | Used to indicate the balance of products in stock. |
image_link | line | Link to the image on the Internet (URL). There may be several links. Must be separated by commas with a space (example: http://example.com/box.gif, http://example.com/box-foto2.gif) The first image from the list is considered the main one and will be displayed in the catalog. Please note: You can import images from Google Drive. To do this, you need to give access to the image file to the address import@uaprom-prod-1495098375216. iam. gserviceaccount.com . |
Availability | line | Availability of products in stock "+" — available "!" — availability guarantee (for certified companies) "-" - not available "&" - expected "@" - service a number, for example, "9" - the number of days for delivery, if the products are on order Important! If the field is empty, the status of your product will become "Out of stock". |
Discount | Positive number or number with % | If the product has a discount, this field indicates the discount amount or percentage. Example: 12. 5, 30%. |
Discount period from | the date | Start date of the discount. |
Discount valid until | the date | End date of the discount. |
Label | line | Product label. If the "Label" column is filled in the file, then its value will always be updated, even if the "Force update" setting is not set. |
Manufacturer | string up to 255 characters | The brand, trademark or name of the manufacturer under whose name the products are manufactured (possibly the value "Own production"). The name of the manufacturer is imported into the description of the characteristics of the product, the field "Manufacturer". Attention! The manufacturer you specify will be imported if it is in the portal's manufacturers database. You can check the presence of a manufacturer or add a new manufacturer when adding/editing a product. |
Producing country | string up to 255 characters | It is imported into the description of the characteristics of the goods, the field "Country of origin". |
HTML_header | string up to 250 characters | HTML header of product SEO settings The product SEO settings group is available if the "SEO settings" application is enabled. When importing, the product SEO settings values are updated only if the fields are filled in. If the fields are empty during import, then the product SEO settings values are not updated. When exporting, these fields are unloaded only if custom settings are specified. By default, the fields will be empty. If all SEO fields are set and meet the requirements, then the "Use custom settings" setting will be automatically set. If all fields do not meet the requirements or are not set, the setting "Default values by templates" is set. |
HTML_description | string up to 250 characters | HTML description of product SEO settings |
HTML_keywords | string up to 250 characters | HTML keywords for product SEO settings |
Gifts | line | Line numbers or product IDs in the current file of those products that are gifts. The numbers are separated by a semicolon (for example, 3;4). They can be indicated not only for the main product, but also for varieties.
|
Related | line | Line numbers in the current file of those products that are related. The numbers are separated by a semicolon (for example, 3;4). They can be indicated not only for the main product, but also for varieties. |
ID_Gifts | line | The ID of the items that are gifts. The numbers are separated by a semicolon (for example, 1095011184; 655298076). If the "Export gifts" setting is set during export, then this field has priority. If no value is specified in this field, gifts are taken from the "Gifts" field according to the line number in the file. They can be indicated not only for the main product, but also for varieties.  |
Related_ID | line | ID of the products that are related. The numbers are separated by a semicolon (for example, 1095011184; 655298076). If the "Export related" setting is set during export, then this field has priority. If a value is not specified in this field, related ones are taken from the "Accompanying" field by the line number in the file. They can be indicated not only for the main product, but also for varieties. |
group_number | number | Allows you to place a product in a specific group on your site. |
group_name | string up to 255 characters | The name of the group of goods/services. This field is not imported when uploading a file to the company's website. |
subsection_address | line | Directory subsection address. For example, for the "Laptops" section: http://prom.ua/Noutbuki. For convenience, you can use the search or rubricator and select the final section of the product. |
Possibility of delivery | number | Possible volumes of deliveries |
Delivery time | line | Period of measurement of possible supply volumes day | week | month | quarter | year |
Packing_method | string up to 500 characters | Goods packaging method |
Personal_notes | line | Personal notes separated by commas |
Product_on_site | line | Product address on the company website |
Marking_code_(GTIN) | line | Global Logistics Marking and Inventory Code (GTIN) for Google Merchant Center feed |
Device_Number_(MPN) | line | Device unique (catalog) number (MPN) for the Google Merchant Center feed |
Item_ID | string up to 255 characters | The identifier is required to uniquely match the product in the import file with the same product on the company's website. May contain characters and numbers. Obligatory field. |
Unique identificator | positive number | A unique product identifier is service information that is used to identify a product or service exclusively on our portal. This identifier is filled in automatically during export and should not be changed manually. The value of the unique identifier is a number that can be found in the link to the product on the portal or on the company's website. |
subsection_id | line | Technical information about the subsection ID. It is not recommended to change this setting ever. This parameter is filled in automatically when exporting data from our system. |
group_id | line | Technical information about the product group ID in your system. Indicates a product/service category on your company's external website or in another system. Used in the import system from XML and YML files. This field will be used when uploading data from the portal catalog and importing it back into your system. |
variety_group ID | line | Item ID. All products with the same "ID_group_varieties" number and filled in the fields "Name_Features" and "Value_Features" are considered varieties of the main product. In this case, the main product has the same ID_group_varieties number as the varieties, but the fields “Name_Characteristics” and “Value_Characteristics” are not filled in for the main product. |
Name_Features | line | The name of the product feature from the category in which the product is placed, or the name of a custom feature. You can copy the exact name of a category characteristic from the "Characteristics" block on the page for adding/editing a product or by going to the appropriate category on the portal: see example. An example of a category characteristic name for a product from the Executive Chairs category: Number of wheels. To add multiple features, copy this column along with the "Dimension_Features" and "Value_Features" columns multiple times. The order in which characteristics are specified does not matter (category characteristics can be mixed with custom characteristics). Attention! In the import file, the description columns for each individual characteristic must always follow this order: "Name_Characteristic", "Dimension_Characteristic", "Value_Characteristic". Note: The feature import format described in this manual is the third version. The portal supports backward compatibility of import formats - characteristics described in the import file in one of the previous formats will be successfully imported. However, characteristics are always exported in the new format described here. We recommend that you always describe the characteristics in the import file according to these instructions. |
Dimension_Characteristics | line | A unit of measurement for a product characteristic from the category in which the product is placed, or a unit of measurement for a custom characteristic. You can copy the exact name of the unit of measurement of a category characteristic from the "Characteristics" block on the page for adding/editing a product or by going to the appropriate category on the portal. For custom characteristics, we recommend that you specify standard units of measurement: see example. An example of the name of a unit of measure for a product from the category " Armchairs for executives ": pcs. To add multiple features, copy this column along with the "Feature_Name" and "Feature_Value" columns multiple times. The order in which characteristics are specified does not matter (category characteristics can be mixed with custom characteristics). Attention! In the import file, the description columns for each individual characteristic must always follow this order: "Name_Characteristic", "Dimension_Characteristic", "Value_Characteristic". Even if the "Dimension_Characteristics" column is empty, it must still be present in the import file to avoid errors. Note: The feature import format described in this manual is the third version. The portal supports backward compatibility of import formats - characteristics described in the import file in one of the previous formats will be successfully imported. However, characteristics are always exported in the new format described here. We recommend that you always describe the characteristics in the import file according to these instructions. |
Value_Characteristics | line | The value of a characteristic of a product category or the value of a custom characteristic: see example. The value of characteristics can be simple or plural. An example of a multiple value for the characteristic "Case Material": Aluminium, Plastic; for the characteristic "Communication standard": GSM, CDMA, EDGE. The values of multiple characteristics in the import file are separated by the "|" symbol. Example: "Aluminum|Plastic" or "GSM|CDMA|EDGE" (quotes are not needed in the import file). To add multiple features, copy this column along with the "Name_Features" and "Dimension_Features" columns multiple times. The order in which characteristics are specified does not matter (category characteristics can be mixed with custom characteristics). Attention! In the import file, the description columns for each individual characteristic must always follow this order: "Name_Characteristic", "Dimension_Characteristic", "Value_Characteristic". Note: The feature import format described in this manual is the third version. The portal supports backward compatibility of import formats - characteristics described in the import file in one of the previous formats will be successfully imported. However, characteristics are always exported in the new format described here. We recommend that you always describe the characteristics in the import file according to these instructions. |