- Product Code / SKU 
A product with the same Product Code from the uploaded price list will be overwritten.
If the product code is not specified and it is necessary to overwrite product information, you can use the product ID. Attention! If the product ID is specified, it is used with higher priority than the product code and also allows overwriting the PRODUCT CODE.
- Product ID (update existing product)
To update a product or variant by ID, you can specify the value in this field. If the product ID is found, the product will be designated for updating its information. Attention! If the product ID is specified, it has higher priority than the product code and allows overwriting the PRODUCT CODE in the product card.
- Price
Currency during import can be replaced if the price contains respective currency symbols, namely:
- $ USD doll $ dollar - ()
- € EUR euro &#8364 euro - ()
- Br BYN BYR br rub. р. - ()
- ₽ rub RUR RUB р. руб. ruble ₽ - ()
- ₴ UAH hryvnia grn hrn ₴ - ()
- tenge KZT teng tng tg tenge teng ₸ - ()
- zł PLN zlot zł Zł Zł - ()
- Markup
Markup is defined by a mathematical expression relative to the previously specified Price.
The following values are allowed:
+XX plus-XX minus/XX divide*XX multiplyXX% percentage of the amount+XX% plus percentage of the amount-XX% minus percentage of the amount/XX% divide by percentage of the amount*XX% multiply by percentage of the amount- If the price or markup contains a non-integer number, the result will be rounded to two decimal places.
- Wholesale Price
Wholesale price is specified using semicolon separators. To activate wholesale pricing, the "Minimum wholesale order" must be specified. For example, if the "Minimum wholesale order" field contains 5;10 and the "Wholesale price" contains 20;10, then when adding more than 5 items to the cart, the price will be 20, and when adding more than 10 items, the price will be 10.
- Product Availability (Yes/In Stock/No/On Order/Check/Hide/Lock)
0 In stock1 No2 On order3 Hide4 Prohibit adding to cart5 Check availability
The following values are also automatically recognized: Yes,
In stock,
No,
available,
+,
- and
On order.
To hide a product from the list, you can specify:
Hide,
Нет в наличии (No stock + Hide product from list), or
Hide.
To prohibit adding a product to the cart, use:
Lock,
Запретить, or
Нет в наличии (No stock + Prohibit adding to cart).
For the "Check" option, you can specify:
Check availability,
Уточняйте, or
Наличие уточняйте.
- Quantity Available
The following values are allowed:
XX Numerical value+XX plus (to previous stock quantity)-XX minus (from previous stock quantity)
- Price per
Available options:
1 pcs or 1 — for 1 piece100 pcs or 2 — for 100 pieces1000 pcs or 3 — for 1000 pieces1 package or 4 — for 1 package1 pair or 45 — for 1 pair1 dozen or 46 — for 1 dozenSet or 10 — for set1 kg or 5 — for 1 kilogram1000 kg or 6 — for 1000 kilograms100 g or 38 — for 100 grams1 lb or 39 — for 1 pound1 g or 40 — for 1 gram10 kg or 41 — for 10 kilograms1 centner (100 kg) or 42 — for 100 kg1 ton or 43 — for 1 ton1 ml or 30 — for 1 milliliter1 l or 31 — for 1 liter1 km³ or 32 — for 1 cubic kilometer1 m³ or 33 — for 1 cubic meter1 dm³ or 34 — for 1 cubic decimeter1 cm³ or 35 — for 1 cubic centimeter1 mm³ or 36 — for 1 cubic millimeter1 hl or 37 — for 1 hectoliter1 gallon or 47 — for 1 gallon1 barrel or 48 — for 1 barrel1 m² or 7 — for 1 square meter1 are or 44 — for 1 are1 hundred sq.m. or 15 — for 100 sq.m.1 acre or 16 — for 1 acre1 hectare or 17 — for 1 hectarePlot or 18 — for 1 plotObject or 19 — for 1 object1 meter or 8 — for 1 meter1 km or 9 — for 1 kilometer1 linear meter or 55 — for 1 linear meter1 hour or 11 — for 1 hour1 day or 12 — for 1 day1 month or 13 — for 1 month1 year or 14 — for 1 year1 minute or 49 — for 1 minute1 week or 50 — for 1 week1 service or 51 — for 1 service1 trip or 52 — for 1 trip1 person or 53 — for 1 person1 car or 54 — for 1 car
- Short description
Displayed as text in product listings (categories, search, new items blocks) if it is not hidden in style settings.
- Meta title
Title tag. Displayed in the browser tab and serves as the page title.
- Meta description
Description tag. A short text under the link in search results. Helps search engines understand the page content and affects the click-through rate (CTR).
- Meta keywords
Keywords tag. A set of keywords or phrases separated by commas by which users can find this product. Entered words are used in internal site search.
- Product name / Product title
The main product name on the site. Used to generate the H1 heading and names in cart/orders.
- Full description
The main product text. Displayed in the block specified in the site design settings (block position may vary). Can include HTML (lists, tables, text, video).
- Description tabs
Allows creating additional information sections (e.g.: «Full product description», «Specifications», «Delivery», «Video reviews»). You can import both plain text and complex HTML with tables, YouTube iframes, or specifications. Tab names are configured in the admin panel.
- Category ID (Your category ID)
Specify your personal Store category IDs. If such category is not found on your site, the value will be ignored. When using personal categories, existence is checked. If the specified category does not exist on this site, the value will be ignored.
- Category Title (Your category title)
The data from this field is compared with the internal category title. If the category matches, this category ID is set. If a personal category ID is specified beforehand, it has priority over the category title. When using personal categories, existence is checked. If the specified category does not exist on this site, the value will be ignored.
- Manufacturer ID (Your manufacturer ID)
Specify your manufacturer category IDs. If such manufacturer is not found on your site, the value will be ignored. Manufacturer existence is checked. If the specified manufacturer does not exist on this site, the value will be ignored.
- Manufacturer Title (Manufacturer title)
The data from this field is compared with the internal manufacturer category title. If matched, the ID is set. If manufacturer ID is specified beforehand, it has priority over the manufacturer title. Manufacturer existence is checked. If the specified manufacturer does not exist on this site, the value will be ignored.
- Collection ID (Your collection ID)
Specify your collection category IDs. If such collection is not found on your site, the value will be ignored. Collection existence is checked. If the specified collection does not exist on this site, the value will be ignored.
- Collection Title (Collection title)
The data from this field is compared with the internal collection category title. If matched, the ID is set. If collection ID is specified beforehand, it has priority over the collection title. Collection existence is checked. If the specified collection does not exist on this site, the value will be ignored.
- Synonym Products
This option allows you to display a group of products similar by characteristics, for example, the same product in different colors. Products will be displayed in the description as links and images.
For example, this product list can be used if you have the same product in many sizes and colors, with size specified in "Variants" and grouped in the "Synonym Products" field. Add "Sizes" to "Variants", and other colors to this field. This way, the customer can select both "Color" and "Size" of the product.
- Shipping: Specify shipping parameters
1 — specify0 — do not specify
Also, the following values are automatically replaced:
да, yes, true, есть, указать — replaced with 1нет, no, -, delete, скрыть, hide — replaced with 0notes only, text only, indicate only a note about delivery, text — are replaced by 3
- Shipping: Available/Not Available/From general settings/Note only
1 — available0 — not available2 — use from general settings3 — specify only note about shipping
Also, the following values are automatically replaced:
yes, +, есть, да — replaced with 1none, -, нет, no — replaced with 0из общих настроек, =, общие настройки, default — replaced with 2
- Shipping: Shipping cost
Shipping cost
- Shipping: Shipping notes
You can specify shipping terms. HTML is allowed in this field.
- Shipping: Delivery time
Delivery time. Displayed in shipping information.
The following values are automatically replaced:
0 — delivery on order day (today)1 — delivery the next day (tomorrow)- You can also specify a period
from — to days, e.g., 2–4.
- Delivery: Product Dimensions and Weight
The following unit values are automatically converted: - Size:
0 — centimeters1 — meters
- Weight:
- Supplier (Supplier Header)
The data from this field is matched against the list of Suppliers. If the category matches, the ID of that category is set. If the specified supplier does not exist on the site, the value will be ignored. If the Supplier ID is provided, it will have priority.
- Image URL (Main) (It is mandatory to specify the main image before uploading additional ones)
You can specify a URL to an image file, which will be downloaded. The upload occurs only if the "Update only" checkbox is not set. If the file already exists in the product's image folder, it may be overwritten. To enable this, set "Overwrite images if found". Additional images ("Image URL (additional...)") are uploaded similarly.
- Image URL (Additional 1-16)
- Overwrite images if found
If the product already exists and has images, you can specify the action to perform. Whether to delete the old images or not. Do not overwrite — 0, Overwrite — 1; also text values Yes, true and No are automatically converted.
- Related Products
You can create a list of related products for each product, which will be additionally displayed on the main product page. Specify IDs or codes/SKUs separated by commas.
- Tags
You can create a list of tags for each product, which will be additionally shown on the main product page and will help with SEO promotion and site navigation. Enter tags separated by commas. TO REMOVE TAGS enter 0 (zero), a space, or delete.
- Configuration Header / Variant Header
The header displayed above the list of variant options. For example, Select color.
- Variant Update
You can create your own list of variants/options for each product, which will be additionally shown on the product page.
Below is the description of how to format and update variants during import:
-
You can upload an import file where data is divided into main Products and their Variants/Configurations.
To have the system recognize a row as a variant, set the value 1 in the "Variant Update" cell.
Only the following fields will be considered: Product code, Availability, Access, Name, Price, Wholesale price, Purchase price, Dimensions, Weight.
These correspond to the main columns of the import price list (except the "Access" field, which manages variant visibility, e.g., allows hiding it).
If a "Variant ID" is specified, that variant will be updated (if it exists). You can also update variants by Product Code or Name*. If no matches are found, a new variant will be created.
To delete a variant, enter any non-empty value in the "Delete" column, for example 1 or delete.
If the "Variant Update" field is empty or equals 0, the row will be treated as a separate product, not a variant.
If needed, you can export variants separately — check "Split variants" on export, and you will get a file with variants only.
For example, you can export products to see how variant parameters are indicated and updated.
To delete a variant, enter any value delete or 1 in the "Delete" column.
*You can update an existing variant by Product Code.
To do this, after uploading the import file, enable the option "Update variant by product code".
How variant update works via Excel cells:
If a product has variants and the product code in the import row matches, fields such as Price, Availability, Stock quantity, Sort order (priority), Wholesale price, Minimum wholesale order, Old price, Dimensions, and also variant deletion will be updated.
Variant fields correspond to the main import fields for the product. To manage visibility (show, hide, or show inactive button), use the "Access" column. Value off — hides the variant.
If you need to fully update a variant (including name and styles) — use the "Variant" column and enable "Consider variant" during import. This allows bulk updating of all variant data by product code.
Important! If both "Update variant by product code" and "Consider variant" are enabled simultaneously, the variant will be overwritten twice, which may cause data conflicts. Therefore, it is recommended to use only one method at a time: either update by product code or update via the "Variant" column.
You can import a file with separated fields for Products or Configurations/Variants.
The import function for these data is available only for sites with paid hosting and parked domains.
- Variants (compressed format)
Variants in compressed format is an additional way to check variants. The field contains variants in compressed form: {VARIANT ID|Price|SKU|Priority / Position sorting|TITLE|Access|Stock|Show stock - param|Stock quantity|Image number|bulk price (split ;)|bulk price quantity (split ;)|Old Price|Cost Price|Width|HEIGHT|Length|centimeters -0 / meters -1|Weight|gram -0 / kilogram -1|Delete|Description / Text}
The import function for these data is available only for sites with paid hosting and parked domains.
- Product Type and Characteristics
You can assign values for search filters (Product Type and characteristics) to each product.
To import characteristics, first export products to get the list of cells with characteristics.
The data is validated during import, and if a matching value is found, it is applied.
This import function is available only for sites with paid hosting and parked domains.
- Delete
If the product already exists and needs to be deleted, set the value in the Delete field to: 1, Yes, or delete
- New, Bestseller, Discount, Price Reduced, Promotion
To activate these fields, use the following values: 1, Yes, or true, or the corresponding field values like New, Bestseller, etc.
Any text value can be used for the Discount field (this is an information-only field and does not perform any calculations)
- Do not export to YML & RSS & XML
Do not export in YML, RSS, XML formats. Allowed values: 1, Yes, or true — do not export; or 0, empty — export.
- Promotion: Promotional Offer (text)
Text of the promotional offer. Up to 5000 characters, supports HTML. To display the promotional offer, the "Promotion" field must be activated.
- Promotion Timer: End Date and Time
Date and time in the format 08.07.2015 12:59:33
- Promotion Timer: After Expiry
Actions after the promotion expires:
0 - Do nothing (hide timer)-
1 - Move "Old price" to main price and delete old price -
2 - Remove "Promotion" label -
3 - Move "Old price" to main price and remove "Promotion" label -
5 - Restart timer for 1 day -
6 - Restart timer for 10 days -
7 - Restart timer with previous duration (timer date minus last edit date) -
8 - Remove "Promotion" label and delete "Old price"
- Priority (Display order)
This option affects the order number when viewing the product list in your store. By default, products on the shop page are sorted by id. The higher the number, the higher the product will be positioned. You can change the default sort order in the settings, under the Shop tab.
- Minimum quantity for purchase
The minimum required quantity for purchase. By default, the specified minimum quantity will be added to the cart. When placing an order, the buyer will be informed to add more items if the quantity in the cart is less than specified.
- Watermark protective image
Set a protective image watermark, which is preconfigured in the site's general settings. Allowed values: 1, Yes, or true — export; or 0 and empty — do not export.
- Variant Type for Google Merchant XML
Allowed values:
0 - size1 - color2 - pattern3 - material4 - age_group5 - gender
- Access
If necessary, you can hide a product from visitors and search engines.
Available values:
0, No, Off, false — Off;true, 1, On, empty — On.
- And other fields