Products import / export

In administration panel go to Offer => Products


Exporting the products

Select Export

  1. Select an export format:
    • Export to Microsoft Office 2003 file,
    • Export to csv file (UTF-8),
    • Export to csv file (Windows-1250),
  2. Select a Profile,
  3. Check out how to add a new profile.

  4. Press Export,
  5. Press Download the file.

Settings to open import / export file

  1. Open a file,
  2. Select Character setw:
    • Unicode (UTF-8) for csv file (UTF-8),
    • Western Europe (Windows-1250/WinLatin 2) for csv file (Windows-1250),
  3. Select Separator options. Separated by:
    • Semicolon,
    • Space,
  4. Select all the columns,
  5. Set Column type as Text,
  6. Press Ok.

Importing the products

Select Import

  1. Select an import format:
    • Import Microsoft Office 2003 file,
    • Import csv file (UTF-8),
    • Import csv file (Windows-1250),
  2. Upload Data file,
  3. Press Import.

Information about errors in import file

  1. Import a file,
  2. Press Display the import errors,
  3. Check out the errors,
  4. Correct the data in import file.

Adding import / export profile

Select Export

  1. Press Manage the profiles,
  2. Press Add,
  3. Enter a profile's Name profilu,
  4. Select the fileds you want to export,
  5. Press Save.

Description of the import / export file

In the generated file you can:

  • Add the products,
  • Change an each field value,
  • Delete the products.
  • Anywhere in a sheet, add a column called import_status. Enter d (delete) in the line of the record that you want to delete.

Required fields to import a product

An import file has to contain the following columns to add a product to a shop:

  1. Code (Code::code),
  2. Product's name (Name::name),
  3. Currency (Currency::currency_iso),
  4. Tax rate (Vat::vat_value),
  5. Net price and / or gross price (Price netto::price_netto and / or Price brutto::price_brutto),
  6. Use the dot as the decimal separator, enter the price as eg. 123.45.

  7. Unit of measure (Unit of measure::uom).

Assigning a product to a category

Enter the categories in the format:

Category tree name | Category | subcategory | sub-subcategory

Example:


Categories|Audio|Speakers
Menu|Special Offers|Audio
Menu|Special Offers
Menu|Electronics|Speakers
Menu|Electronics
Categories|Audio
    

Check out categories documentation.

Assigning the 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": "steel-bed-90x200cm-white-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 | Greed
    

Where:

  • price_type - price type (values: netto / brutto)
  • filter - filter id (available only for Option name)
  • default - default selected option (available only for Option name)
  • price product's price (available only for Option value)
  • old_price - product's old price (available only for Option value)
  • stock - product's stock (available only for Option value)
  • weight - product's weight (available only for Option value)
  • code - product's code (available only for Option value)
  • pum - number of units of measure (available only for Option value)
  • image - image (available only for Option value; required for export / import; when creating new option you don't have to enter a value)
  • option_color - Color (only for Option value, '#cccccc' - Options color, 'name.jpg' - ID of imported image, an image file has to be located in folder soteshop/web/uploads/assets)

Check out products options documentation.

Example:


{ "price_type": "netto"} 
Color { "filter": 1,  "default": "black"} 
Color | black { "price": "",  "old_price": "0.00",  "stock": "6.00",  "weight": "",  "code": "",  "pum": "",  "image": "",  "option_color": "big-czarny-.jpg"} 
Color | silver { "price": "",  "old_price": "0.00",  "stock": "4.00",  "weight": "",  "code": "",  "pum": "",  "image": "",  "option_color": "thermal-mug-silver-36613-3.jpg"} 
Color | blue { "price": "",  "old_price": "0.00",  "stock": "0.00",  "weight": "",  "code": "",  "pum": "",  "image": "",  "option_color": "thermal-mug-blue-470-ml-36484-2.jpg"} 
Color | red { "price": "",  "old_price": "0.00",  "stock": "10.00",  "weight": "",  "code": "",  "pum": "",  "image": "",  "option_color": "thermal-mug-red-36614-1.jpg"} 
    

Assigning the images to a product

Enter the images in the format:

Image 1 (product's main image) | Image x | Image y | Image z

The first image is a product's default image. The imported images files have to be located in folder soteshop/web/uploads/assets.

Example:

watch.jpg | watch-1.png | watch-2.png | watch-3.png

Hiding a product's price

The values of hiding the prices:

  • 0 - according to the global configuration,
  • 1 - hidden price for all clients,
  • 2 - hidden price for not logged in clients,
  • 3 - hidden price for unverified clients,
  • 4 - disabled,

Allowing / excluding shipping methods for a product

Excluding shipping methods E | shipping_method_id

Example:

E | 1, 2, 3

Allowing shipping methods A | shipping_method_id

Example:

A | 1, 2, 3

Importing the selected columns

Columns that you don't want to import, must be removed from a sheet. If you delete only the contents of the record and leave the column empty, you will import the empty data.

The best way is to use import / export profiles.