Products import / export

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,

Check out how to add a new profile.

3. Press Export,

4. 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),

Use the dot as the decimal separator, enter the price as eg. 123.45.

6. 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.