Import/export products - bulk change store offer.

The online store SOTESHOP has the possibility of mass changing the offer with the help of a spreadsheet. You can export the entire offer or part of it to a csv file, change the file for example in the Excel program, and then import it back to the store.

Table of Contents

In the admin panel, select ApplicationsProducts Products module icon

Export products

Select Export

Products export panel in Soteshop
  1. Select export format (encoding):
    • Export to CSV file (UTF-8),
    • Export to CSV file (Windows-1250),
  2. Select Profile,

    See how to add import/export profile.

  3. Press the Export button, Process of exporting products to CSV file
  4. Press the Download file button.

Settings for opening the import/export file

  1. Open the file, CSV file opening settings in LibreOffice
  2. Choose Character Set:
    • Unicode (UTF-8) for export to csv file (UTF-8),
    • Central Europe (Windows-1250/WinLatin 2) for export to csv file (Windows-1250),
  3. Choose Separator Options. Separated by:
    • Semicolon,
  4. Check all columns,
  5. Set Column Type as Text,
  6. Press Ok button.
View of the product file after opening in a spreadsheet

Product Import

Choose Import

Product import panel in Soteshop
  1. Choose import format (encoding):
    • Import csv file (UTF-8),
    • Import csv file (Windows-1250),
  2. Upload Data File,
  3. Press Import button.

Information about errors in the import file

  1. Import the file, Process of importing with errors
  2. Press the Display import errors link, Displaying the import errors table
  3. Check the errors,
  4. Correct the data in the import file.

Adding an import/export profile

Select Export

  1. Press the Manage profiles link, Product export/import profiles management panel in Soteshop
  2. Press the Add button, Adding a product export profile in Soteshop
  3. Enter the Name of the profile,
  4. Enter the fields you want to export,
  5. Press the Save button.

Description of the import/export file

The import/export is used for global:

Required fields of the import file to add a product

Pola wymagane do zaimportowania nowych produktów w arkuszu kalkulacyjnym

The file must contain the following columns in order for the product to be added:

  1. Code (Kod::code),
  2. Product name (Nazwa::name),
  3. Currency (Waluta::currency_iso),
  4. VAT rate (Vat::vat_value),
  5. Net and/or gross price (Cena netto::price_netto and/or Cena brutto::price_brutto),

    Use a dot as a decimal separator. Enter the price in the form of 123.45.

  6. Unit of measure (Jednostka miary::uom).

Deleting products

Anywhere in the file, add a new import_status column and enter the value d (delete = delete) for the products you want to delete.

Kolumna umożliwiająca usuwanie produktów za pomocą importu

Only the Kod::code and import_status columns are required to delete a product.

Assigning a category to a product

Enter the categories in the format:

Tree name | Category | Subcategory | Sub-subcategory Product category column in CSV file



See the categories documentation.

Assigning product options to a product

Enter the product options in the format:

{ "price_type": "netto" }
Size { "filter": 1, "default": "L" }
Size | XL | Color { "filter": 2, "default": "Red" }
Size | XL | Color | Red { "price": "", "old_price": "0.00", "stock": "0.00", "weight": "", "code": "", "pum": "0.00", "image": "", "option_color": "#543554" }
Size | XL | Color | Blue { "price": "+10", "old_price": "200.00", "stock": "5.00", "weight": "+2", "code": "AXC-234", "pum": "1.00", "image": "lozko-metalowe-kute-90x200cm-agnes-biale-wp1.jpg", "option_color": "#1b89de" }
Size | L | Color { "filter": 2, "default": "Yellow" }
Size | L | Color | Red { "price": "", "old_price": "0.00", "stock": "0.00", "weight": "", "code": "", "pum": "0.00", "image": "", "option_color": "#2c8a4a" }
Size | L | Color | Yellow { "price": "", "old_price": "0.00", "stock": "0.00", "weight": "", "code": "", "pum": "0.00", "image": "", "option_color": "#cccccc" }
Size | M | Color { "filter": 2, "default": "Red" }
Size | M | Color | Red { "price": "", "old_price": "0.00", "stock": "4.00", "weight": "", "code": "", "pum": "0.00", "image": "", "option_color": "004_button_2_bold.jpg" }
Size | M | Color | Green


  • price_type / typ_ceny - type of price entered (values: netto/brutto)
  • filter / filtr - Filter ID (available only for Option Name)
  • default / domyslna - Default selected option (available only for Option Name)
  • price / cena - modyfikator - Product price modifier (only for Option Value)
  • old_price / stara_cena - Old product price (only for Option Value)
  • stock / magazyn - Product stock state (only for Option Value)
  • weigh t /waga - Product weight (only for Option Value)
  • code / kod - Product code (only for Option Value)
  • pum / ijm - Product unit of measure quantity (only for Option Value)
  • image / zdjecie - Product image (only for Option Value, this value is currently required only in case of export/import when creating new options we don't have to provide this value)
  • option_color / kolor_opcji - Color (only for Option Value, '#cccccc' - option color, 'name.jpg' - ID or URL of imported image. In case of adding image it should be placed in the directory:
    • In standard shop version: uploads/assets
    • In admin version: web/uploads/assets)
Product options column in CSV file


{ "typ_ceny": "netto" }
Color { "filtr": 1,  "domyslna": "black matte" }
Color | red { "cena": "",  "stara_cena": "0.00",  "magazyn": "10.00",  "waga": "",  "kod": "orange",  "ijm": "",  "zdjecie": "71",  "kolor_opcji": "thermal-mug-red.jpg" }
Color | black matte { "cena": "",  "stara_cena": "0.00",  "magazyn": "8.00",  "waga": "",  "kod": "",  "ijm": "",  "zdjecie": "69",  "kolor_opcji": "thermal-mug-black.jpg" }
Color | Blue { "price": "",  "old_price": "0.00",  "stock": "0.00",  "weight": "",  "code": "",  "ijm": "",  "photo": "69",  "color_option": "kubek-termiczny-nieb.jpg" }
Color | Silver { "price": "",  "old_price": "0.00",  "stock": "0.00",  "weight": "",  "code": "",  "ijm": "",  "photo": "72",  "color_option": "kubek-termiczny-srebr.jpg" }

Assigning Photos to a Product

The first photo is the default product photo. Uploaded photos should be placed in the directory:

  • In the standard shop version: uploads/assets
  • In the admin version: web/uploads/assets

There are two methods of attaching photos:

  1. Enter the file names with extensions (if uploaded to the server). Example:

    watch.jpg | watch-1.png | watch-2.png | watch-3.png Assigning photos to a product from the uploads/assets/ directory
  2. Enter the URL address of the photo (leading to any photo on the Internet, e.g. to a photo from the manufacturer's website). Example: | Example of a URL address leading to a product photo in a .csv file

After exporting products to a .csv file, the product_images column will also contain links to images from the internet.

Hiding product price

Product price hiding values:

  • 0 - according to global configuration,
  • 1 - price hidden for all customers,
  • 2 - price hidden for unlogged customers,
  • 3 - price hidden for unverified customers,
  • 4 - disabled,

Allowing / excluding delivery for product

Product delivery column in CSV file

Excluding delivery W | id_delivery


W | 1, 2, 3

Allowing delivery Z | id_delivery


Z | 1, 2, 3

Importing selected columns

Columns that are not to be imported must be removed. If you only remove the record content, but the column remains, empty data will be imported.

It is best to use the creating import / export profile function.

Saving CSV file

The file should be saved in the same format in which it was opened, i.e.

  • Field separator: ;
  • Text separator: "

If the file is not saved in this format and an error message appears when trying to import

Data file Incorrect file format

you can edit the formatting when saving in LibreOffice

  1. Select FileSave as,
  2. Select the Edit filter settings option,
    Save as options for CSV file in LibreOffice
  3. Click Save,
  4. Set the options in the Field Options window as follows:
    • Character set: Unicode UTF-8
    • Field delimiter: ;
    • Text delimiter: "
    • Quote all text cells: Checked
    CSV filter settings in LibreOffice
  5. Click OK.

Related Documentation

SOTE YouTube

Stay up to date with the latest SOTESHOP program updates. Subscribe to the SOTE YouTube channel.