Delivery in with Excel

With Sitoo, you can make a delivery manually in Backoffice, through the import function in Backoffice or with the delivery function in Sitoo POS. A delivery should be made when you want to register completely new products in your warehouse or need to increase inventory on an already registered warehouse product.

Content

Definition of terms

The following list describes which column names are to be found in the excel file.

Create an import file

Here we will go through how to make a delivery to your warehouse through import from Excel.

1. Either use our import template found at the end of this article. Then you'll start of with an empty excel that you can fill with information.
2. Alternatively, you can use the existing warehouse/stock list.
3. If you choose to go with alternative number two, please log in to Sitoo Backoffice > Warehouse. 
4. If you have access to a number of warehouses, you must choose which warehouse you want to submit. In the upper right of the Warehouse view in Backoffice, your are able to select the warehouse that you want to submit. Tap the text to change warehouse.
5. Select the correct warehouse in the drop-down meny > OK.
6. Tap Export in the lower right corner. 
7. If you want to sumbit all of the products in you warehouse, please leave the all lines and filters untouched. If you want, you can filter the product list by Category, Product group, Manufacturer, and Condition.
8. Select file format for export. Both of them work, but we recommend CSV file (* .csv).
9. Tap Export.

Clear the excel file

1. The warehouse file is now downloaded to your computer. Often it will end up under downloaded files or similar folder on your computer.
2. Open the file.
3. Look at the excel file: In each row there is a product variant. Each column contains specific information about each product.
4. Delete unnecessary columns: Keep columns E and G. Select the columns you want to delete, right click and select Delete.
   

   Column E contains sku, which stands for article number. The product sku is unique for each product and is the single thing identifying the product in the system.

   Column G contains title, which stands for product name. This is important to keep in order to more easily know what product you submit.

   
   Note! When you are done working with the amounts you will need to delete the "Title" column before you are able to import the data.
   
   
5. Once you have the columns sku and title, add another column.
6. Place the mouse at column C and enter "decimalquantity". Use only lowercase letters.
   
   

Enter the amount

1. Make sure the products you want to deliver in are in the excel file.
2. The sku is a must in order to identify which product you are submitting.
3. Enter the amount of products that you have on each row in the column decimalquantity.
   

Import the delivery

1. Delete the "title" column.
2. Select the rows and columns containing data.
3. Right click on the the selected arean > Copy.
   
   
   Note!

   Do not select empty rows and columns.

4. Log in to Backoffice > Warehouse.
5. If you have access to more than one warehouse, you must select which warehouse you want to submit. You see a blue text in the upper right in the warehouse view > tap the text to change warehouse.
6. Select the correct warehouse in the drop-down menu > OK.
   
   
   Note!

   The warehouse that is set as your main warehouse is what you see here if you have not actively selected another warehouse.

7. Tap Import in the lower right corner > OK. 
8. Double check selected warehouse. In the top left, you will see the current warehouse.
9. Tap Import.
10. Right click in the white textbox.
11. 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.

    
    
12. Tap continue > Import > OK.
13. Now you have completed the import. Follow the steps below to complete the delivery. 

Pause the delivery

You can pause your delivery session to do something else in Backoffice and return later.

1. Tap Back in the lower right corner.
2. The delivery session will be paused. 
3. Resume the session by returning till the warehouse view in Backoffice and press the blue button in the lower right corner > Resume. 
4. You will the re-enter the the session and continue the delivery.

Complete the delivery

1. Press the blue button Finish in the lower right corner.
2. If you wish, you can leave a comment about the delivery.
3. Press OK to save and complete delivery.
   
   
   Note!
   If you press Cancel, you will return to existing delivery session. If you press Exit without saving, the delivery session will be canceled and no products will be added.

Import template

Click on the link below to download our import template. Please refer to this document when adding committing a delivery in by import in Sitoo. Note that there are several sheets in the document.