5.2 Tools


5.2 Tools  <<  5.2.1  >>  5.2.2 Export 

5.2.1 Import

With this tool you can import a .CSV file containing product information into Workspace. You can save files in .CSV format in spreadsheets programs, such as Excel. With this function, you can move your old product list, for example, into Workspace.

Select CSV file for import
Picture 5.15 : Select CSV file for import





  • Click the Browse button and select the desired file. Then click Upload button. Every product in the .CSV file must contain atleast itemCode.

  • Select file encoding for CSV file. Default encoding is UTF-8.

  • Click the Next button.

    Select product group
    Picture 5.16 : Select product group




  • If you select nothing from the drop down menu products will be inserted (or moved if updated) to path in the CSV file (the original path). If you select a product group products will be inserted under that group (with the original path).

  • Click the Next button.

    Add all selected products to shop
    Picture 5.17 : Add all selected products to shop




  • Workspace now shows how many of the products were new (there were no products with the same item code in the shop yet), how many of them has to be updated (there is already a product in the shop with the same item code) and how many of them were faulty (data in the CSV file has to be changed/fixed).

  • If you want to add all the new products into the shop, and update all the existing ones (and ignore all the failed ones), click the "Add or update all selected products" button. New data will appear in the shop.

  • If you don't want to add or update all of the products from the CSV file, click "x products for add to database" to open a list of addable products or click "x products to update in database" to open a list of updatable products. (Additionally, by clicking "x products failed" you can see which products were failed. You can see the error description on the right side of the page.)

    Select which products will be added/updated
    Picture 5.18 : Select which products will be added/updated




  • In the list you can select which products will be added/updated. You can remove the selection (from the check boxes) from the products you don't want to add/update.

  • If you click "Add/Update all selected products" in the list you opened, products will be either added or updated (according to which list is open) and the new data will appear in the shop. If you, however, want both to add and to update products on the same (import) time, click Previous button to return to the previous page. After this click to open the another list and make the necessary changes to check boxes in there and return to the previous page. Finally, click the "Add or update all selected products" button and the new data will appear in the shop.

    Add more products
    Picture 5.19 : Add more products




  • Click Add more products if you want to add more products.