If you do not want to add products manually in Backoffice, you can import products with the import function. Once you get started and learn how to use the import function, you can save a lot of time the next time you need to update your products assortment. We recommend that you first read about the terms in the import file and how it looks.
Before importing new products, we recommend that you first:
- Set up the navigation (Sitoo POS menu structure)
- Add manufacturers/brands (if this is necessary for you)
- Set up product groups
Content
Definition of terms
| Column name | Description |
|---|---|
| pricelistid (Price list) |
The ID number for the price list you want to update. Normally we recommend leaving the value as 1, which means that the standard price list will be updated. |
| productid | The product's ID number in the Webshop. This ID is unique for each product and normally there will be no need to alter it. When you export your products the productid field will have data filled in for each product. If you want to add a new product you should enter a 0 in the field. Note that the sku (article number) field will have to be changed to a new one or left empty). |
| sku (article number) |
The product's article number. If productid is set to 0 this field must be unique or empty. |
| skumanufacturer (The manufacturers article number) |
Manufacturers article number, not obligatory. |
| title (Name) |
The product name. Is shown in all product lists and product pages. |
| descriptionshort (Short description) |
A short description of the product. Is visible on the product pages. |
| description (Long descroption) |
A longer, more detailed description of the product. |
| descriptionhtml (Html-description) |
A description field that can contain HTML-code. Enables the use of, for example, YouTube-movies, images or links to other pages or documents. |
| deliverystatus (Delivery status) |
Delivery status can be, for example, "In Stock", "Few left", "2-3 days". |
| pricelistshowtype (Show type) |
Found under "Products" > "Prices" 0=Do not show 1=Show 2=Show only price (product can't be bought) 3=Show without price (product can't be bought) 4=Show offer price |
| priceisinclvat | Set true if price is including VAT. Otherwise set false. |
| moneyprice (Price) |
Price for the product. Make sure that the price entered is either with VAT included or excluded, depending on what value you entered in priceisinclvat. |
| moneypriceorg (Recommended price) |
Recommended price for resellers. |
| moneypricein (Purchase price) |
Purchase price. Used to calculate margins and stock value. Should be entered excluding VAT. |
| unitlabel (Order unit) |
Enter the order unit for the product, for example kg, lbs, pcs, cm, etc. |
| allowdecimals (Allow decimal input) |
Enter true or false depending on whether you want to allow decimal input in the order unit. For example if you want to be able to sell 10,5 lbs of a product. |
| deliveryinfo (Delivery information) |
This text will appear on the order confirmation under the product. |
| externalinputtitle (Input when ordering) |
Enter a name for an extra field where the customer can enter custom text. For example applicable on products that can be engraved. You can have two or more separate fields by separating each field name with a so called pipe-sign. For example, if you type "Desired text|||Engraving" (without quote marks) there will be two fields, where one is called "Desired text" and the other "Engraving. Leave empty if not needed. |
| offerisenabled (Activate campaign) |
If you want to activate a campaign on the product, enter true, otherwise false. |
| moneyofferprice (Campaign price) |
The campaign price for the product. |
| offertitle (Name of the campaign) |
Campaign name. Will appear on labels and the product page. |
| offerdatestart (Campaign start date) |
Assign a start date here if you want the campaign to be valid from a certain date. (offerisenabled must be set to true). Separate year, month and day with a comma. For example 2018,01,25. If this field is empty the campaign will be valid immediately. |
| offerdateend (Campaign end date) |
Assign an end date here. Separate year, month and day with a comma. For example 2018,03,25. If this field is empty the campaign will be valid immediately. |
| active (Activated) |
Enter true if the product should be active or false if it should be inactive. Deactivating a product does not remove it from your system. It is just removed from product lists on your webshop. It is still accessible with a direct link and if it is in stock it can be bought. If you want to completely disable a product without removing it, use pricelistshowtype (see above). |
| activepos (Activated in POS) |
Only applies to the POS. Enter true to activate a product and false to deactivate it. |
| skumanufacturer (Manufacturers article number) |
Not obligatory. |
| vatid (Sales group) |
Enter the ID for the sales group you wish to assign to your product. |
| deliveryclassid (Delivery class) |
Enter the ID for the delivery class you want to assign to your product. 1=None 2=A 3=B 4=C 5=D 6=E |
| defaultcategoryid (Main category) |
ID number for the category you wish to apply to your product. |
|
manufacturerid (Manufacturer) |
Enter the ID number for the manufacturer you wish to apply to your product. |
|
manufacturerurl |
Link to the manufacturers webpage for the assigned product. |
| custom1 (Egen 1) |
Can be used to add more info about the product in Sitoo POS, ex Season or Brand. |
| custom2 (Egen 2) |
Can be used to add more info about the product in Sitoo POS, ex Season or Brand. |
| custom3 (Egen 3) |
Can be used for keywords. |
| custom4 (Egen 4) |
Can be used for keywords. |
| custom5 (Egen 5) |
Can be used for sorting of products. |
| stockcountenable (Activate stock count) |
Enter true if you want to activate stock handling, otherwise enter false. Backorder, Stock Reorder Point and In Stock values are dependant on this setting being activated. |
| stockallowbackorder (Allow back order) |
Enter true to allow backorder, otherwise false. Backorder enables a customer to purchase a product even if that would bring the stock amount of the product a negative value. For example, if there are 2 products left in stock and the customer orders 4, they will be able to do so, resulting in the stock of that product becoming -2. Note: This setting requires that stockcountenable is true. |
| friendly (Friendly name) |
The data entered here will be the URL to the products in the link. If you for example enter contact-us (this setting can't contain special letters such as ÅÄÖ or spaces) the adress to will become www.yourpage.com/contact-us. This is usually automatically assigned by the system. Note: This setting must be unique. Two pages or products can't have the same adress. The setting also can't be empty. Only in the case of your start page should this field be empty. |
| seo_title (HTML-title) |
HTML-title is the name of the page visible in the web browser window. If the browser has several tabs the title will be displayed in the tab. This is also the data indexed by for example Google. |
| seo_keywords (Keyword (meta)) |
A list of words describing the page/product. Words are separated by comma. This list is indexed by search engines and helps to improve your search result ratings. |
| seo_description (Description (meta)) |
|
| barcode (Barcode) |
Only applies to POS. The barcodes must be unique. |
Columns that end with ID - what does it mean?
Some fields require an ID number to identify a setting. For example defaultcategoryid (main/menu category). If you wish to connect a product to a category you can't simply type the cateogory name in the cell, you will need to enter the ID for the category. This ID is located in your Backoffice.
The ID numbers is located in the same way, regardless of setting. Click the editing icon on an item in Backoffice, then look in the adress bar of your browser. The URL will end with ?item= and the number after = is your ID number. You can also find the ID by hovering your mouse pointer over the editing icon and then look in the footer of your browser to see the adress. Locate the ID in the way described above.
Create the import file
- Log into Backoffice > Products.
- Tap Export in the lower left corner. The product file is now downloaded to your computer. Often it will end up under downloaded files or similar folder on your computer.
- Open the file.
Look at the excel file: In each row there is a product variant. Each column contains specific information about each product. - The varianttext column here must be adjusted according to information found below in the section "Create and import variants". It cannot be used as is to import variant data.
- Please make sure that you understand what each column mean.
- You can choose what kind of information you want to apply to your new products. For example, if you only want to enter the product sku, name and price - just remove the remaining columns and keep the column sku, title and moneyprice.
- To remove columns, right click on the top of the column so that the entire column is selected > Delete.
When you finish editing your excel file, it's time to import the products.
If you for example only keep and edit 5 columns of information in your excel file, only these 5 product features will be added to the product when imported. Remaining product features and settings will remain untouched.
Create and import Variants
When creating variants it is important to note that you will need to define the variants and assign them a variantkey in order to group them together.
For example, a t-shirt that has 4 different sizes will need to have a variantkey assigned to each of the sizes. The variantkey can be any value you wish but it must be shared by all the products that you wish to bundle together.
In the above screenshot we have three different products, along with their variants. We have ha white shirt, a black shirt and a belt. If you inspect the variantkey column you will find that the different products all have a common denominator, grouping them together. Again, this value need not be the title and can be anything you wish, as long as it is shared. This value is only used while importing and cannot be exported.
The next column of interest is the variant:Size column in this case. Size is the name of the variant group that will be created after importing the above data.
If you would like to add another variant group to the import, simply add a new column and name it variant:YourVariantGroup
It is also important to note that you cannot have duplicates of variants. Each bundled product must have a unique value in their "variant:"-column.
But if you have several "variant:"-columns only one of them needs to be unique. For example if you have variant:Size and variant:Color you can have the different sizes assigned in the variant:Size column and then enter "Blue" to all the columns in variant:Color.
If you inspect the above screenshot you will see that all the values are unique on the variant:Size column per variantkey grouping. This is important because as you can see we are using the sizes twice in this import and that is because we are using more than one grouping with variantkey values.
Each grouping must have at least one column with unique values (in this case Size).
Import the file
- Select the rows and columns containing data. Remember not to select empty rows and columns.
- Right click on the the selected area > Copy.
- Log into Backoffice > Products.
- Tap Import in the lower right corner.
- Right click in the white textbox.
- Paste the information that you previously copied from your excel file.
Note!It is important that the cursor is just behind the last character. Remove any spaces.
- Tap continue > Import > OK.
You might in the next step receive information about the number of products that will be updated through the import in this step. If the system does not recognise a specific sku, the system will consider it as a new product. We recommend that you double check this sku and product.
Import prices
With imports, you can import sales price (moneyprice), purchase price (moneypricein), rack price (moneypriceorg) and promotional price (moneyofferprice). When you import these pricing information, you also need to specify if the price you're importing is including or excluding VAT (priceisinclvat).
If all price columns are including VAT or all are excluding VAT, you can import all price columns in one single import session. If you wish to import different types of pricing information, some including VAT and some are excluding VAT, you need to divide the imports into two imports. This is because there is only one column that indicates if all prices in your import file are included or excluded VAT.
Often, the sales price are presented including VAT and the purchase price are presented excluding VAT. Therefore, we recommend that you import prices in two steps; one with prices including VAT and one with prices excluding VAT.