Instructions for product import

Introduction

This article is intended to serve as a guide and help you prepare your products for import by saldia. In addition to this guide, we will provide you with a sample file and template. Please fill in your data into the template using these instructions.

You will find both files for download at the end of this post, at the bottom of the web page.

 

General

If you sell multilingual products, you must enter them individually. The different languages that you fill out in this table per product are only for display in the shop. The product remains the same despite the translation.

 

Product code

The first column is filled with the product code. This serves to identify the product. It can be a text, a number, or a mixture of both. Note that the product code should be unique. If you run a multilingual shop, do not translate the product code into the other languages and only fill it in for your main language.

 

Language

If you run a multilingual shop, you can translate your products into the following 4 languages. To translate a product into another language, add a line under the main product and add the corresponding abbreviations in the "Language" column.

 

 

Price

This column shows the sales price in CHF. Euros or dollars are not supported. It is sufficient to enter the price in the line of the main language. 

 

Product name

The product name is the display name in the online shop. It is also taken into account in product searches. You can translate the product name into all languages available in your shop and enter it in the corresponding line.

 

Image URL

In order to store a product image, it must be saved on a server. If this is the case, you need the complete URL to the image. Then insert the URL in the following layout in the column of the main language only. It is not possible to include images in different languages.

https://www.example-server.ch/pictures/examplepicture.png

 

To add several product images, divide the URL by three separators "///".

https://www.example-server.ch/pictures/examplepicture_1.png///https://www.example-server.ch/pictures/examplepicture_2.png

Category

The categories must already be created in the backend before synchronization. As soon as this is done, the corresponding category can be stored in the line of the main language of the product. Subcategories are separated from the main category with "///". The entire hierarchy up to the desired category must be entered. If the category is in the main level, the category name is sufficient.

Main Category///SubCategory///SubSubCategory

Taxes

It is sufficient to enter the VAT in the column of the main category. The following entries are supported:

• MwSt 7.7
• MwSt 2.5
• MwSt 3.7
• MwSt 0

 

Important! The VAT must match exactly the format of the entries given here. If the entries do not match any of the above, the VAT will not be imported correctly.

 

Quantity

The stock quantity has to be entered only once per product. Store this in the column of the main language. 

 

Features (brand & product variants)

You can store features in the product import. To do this, you must completely create the desired features in the backend before the product import. 

 

To assign a product to a feature, add a column in the table and assign the name of the feature as the title.

 

Now add the property to the product in the main language column. For example, for different brands, fill in the brand name. For different variations, fill in the variation, etc.

 

You can use the template as a reference (brand & product variations).

 

The properties created in the template can be extended or deleted as desired. If you want to add more properties, make sure that they are positioned in the order after "Quantity" and before "Variation group code".

 

Variation group code

Add a variation group code. This code works in the same way as the product code. It can be a text, a number, or a mixture of both. Note that the variation group code should only be added to the members of a variation group.

 

Description (no html)

Add the description of your products in this column. The text from this column is processed purely as text. Any HTML (for e.g. images, videos or iFrames) will not be displayed as HTML code.

 

SEO name

This name will be used in the URL of the product. 

https://www.beispiel-shop.ch/Category/SEO-name/

 

Page title

The page title is generated automatically. If you do not want to set your own page title, the category name and product name will be used for this. 

The page title is displayed in 2 places. 

 

1. As tab name 

2. As a title for the search suggestion of a search engine (e.g. Google)
   

 

Meta keywords 

Meta keywords are used for SEO so that your products are better displayed in search engines (e.g. Google). Well executed meta keywords improve the SEO of your products and your shop.

 

Meta description

The meta description is displayed as text for a search suggestion of a search engine (e.g. Google). This text should describe your product in a few words to interest potential customers.