Question: Set Service Product Only Visible To One Warehouse

Set Service Product Only Visible To One Warehouse

Hello there, I need to set up 3 stores. Each store I think should be called a warehouse in the system, so I will create 3 warehouses. We provide services to customers, so I should choose "S

H

Harry

Asked

Hello there,

I need to set up 3 stores. Each store I think should be called a warehouse in the system, so I will create 3 warehouses. We provide services to customers, so I should choose “Service” as the product type when adding new products to the system.

I will need to create 3 staff accounts, each account should set the default warehouse to its own store, so each staff can only see products(services) that are available to his own store.

Because there is no such “stock” thing for service product type, what should I do to make the product(service) only available to one warehouse?

The expected result is when using the point of sale, staff can only select products(services) available to his own store.

Another question, there is no stock required for us to manage the product(service), so no need to manage the stock. Do I need to change the setting to allow “over selling” or anything else I should change? If you do have a booking/scheduling add-on, happy to check it out.

If currently no option to do that, can you please suggest a workaround way to achieve that? I can do some lightweight coding if required.

Please help! Thank you!

  • MS

    Mian Saleem

    Answered

    Hello,

    All the data is system level, not warehouse. If you assign the staff a warehouse, he can only sale the item for that warehouse. But the products will show up on list products page. If you are using server product type, then no quantity is track and staff should be able to sell any product.

    The only way I can think of is to use standard products and set the stock to warehouse where you want to sell and disable overselling. So, the product can only be sold from warehouse which has quantity/stock.

    If you don’t want to allow other warehouses to sell the product, then overselling need to be disabled. If enabled all warehouses can sell the product.

    For servers there is no stock tracking that allows all warehouses to sell, so only standard products with some extra stock can be the alternate.

    I am sorry as I don’t have a booking module. This item is in queue for rewrite and as it’s grown quite bug so the rewrite will take quite long time. We are not adding features to the current release but only fixing the bugs/errors at the moment.

    Thank you

  • H

    Harry

    Answered

    Hi Mian,

    Thanks for your reply.

    I will do what you suggested. So I will create 3 standard products, disable overselling, and only add stock to one warehouse for each product. Then create 3 staff accounts, and assign only one warehouse for each staff.

    I am providing services to the customers, so there are unlimited services I can provide. Because we are going to use the standard product to represent the services I am going to provide, and also because we need to disable overselling due to the above reason, so I will just set the stock of the standard product to be 9999 or some number big enough for me to always have enough stock to sell for a long time.

    Is my understanding above correct?

    Is there a simple way by changing the PHP code to hide a product from displaying on the POS screen for a staff? so staff can’t see the product?

    I actually only need 3 products in total to use this POS system, only need to add 3 staff to the system. so hardcode is fine, would you please tell me which PHP file should be modified for this purpose? I can do lightweight coding myself, just need to find the right php file.

    Thank you! Regards,

  • MS

    Mian Saleem

    Answered

    Hello,

    Yes, that’s correct.

    For modifications, you can hire any developer to help you. He needs to add a warehouse (id) column to the products table and give you the option to select warehouse while adding/editing products. Lastly use that column to get/filter products on pos for the selected warehouse only.

    For the files, the (products & pos) controllers is app/controllers/admin/ and the view files in themes/default/admin/views/ folder.

    Thank you

  • H

    Harry

    Answered

    Thanks for your reply! That’s very helpful!

  • Login to Reply