Question: Import Service Type Product Issue

Import Service Type Product Issue

Hello, I m trying to import a list of products exported by my sma system .these products are service type without quantities. Then I can't use POS screen to sell it. How can I import service

MB

Mehdi boudhir

Asked
Hello,
I m trying to import a list of products exported by my sma system .these products are service type without quantities. Then I can't use POS screen to sell it.
How can I import service products correctly?
regards
  • MS

    Mian Saleem

    Answered
    Hello,

    SMA can only import standard type products. There is no option to import service type products.

    If all the products are service type, you can update the type directly in database after import.

    Thank you
  • MB

    Mehdi boudhir

    Answered
    "you can update the type directly in database after import."
    How?
  • MS

    Mian Saleem

    Answered
    The query below will change all the products to service.

    ```
    UPDATE `sma_products` SET `type` = 'service';
    ```
  • MB

    Mehdi boudhir

    Answered
    thank you ,
    I did but I got an issue when I used scan products in Pos screen.I have to set unit also.it should be changed from 1 to null
  • MS

    Mian Saleem

    Answered
    You can update the any column as you need. Thank you
  • Login to Reply