Support » Plugin: User Role Editor » Hide Others Orders?

  • Amazing plugin!

    I have a site where wholesale users login and create orders. I want the ability for those users to see only the orders they create. Is this possible?

    I’m happy to buy the pro plugin if we can do this.

    Regards,
    Shaye

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Vladimir Garagulia

    (@shinephp)

    Hi Shaye,

    Look at the database with this command:

    
    SELECT ID, post_author FROM wp_posts WHERE post_type='shop_order';
    

    If post_author field contains your wholesale users ID, then it’s possible to solve your task with URE Pro “edit access” add-on. Just turn ON “Own data only” option for user or his role.

    Thread Starter shayeryan

    (@shayeryan)

    I’m a little bit of a novice when it comes to editing database tables with commands.

    This pro addon looks like a manual process of editing access. I need this to happen automatically. Sales people will be logging in and making orders on a regular bases. So the hiding of others orders needs to happen automatically. Is this possible?

    Regards,
    Shaye

    Plugin Author Vladimir Garagulia

    (@shinephp)

    My question with “SELEСT” command is not related to the pro add-on. I just wanted to be sure that add-on will work in your case. If order has valid author user ID attribute and you restrict role to see own data only, it will work automatically.

    Thread Starter shayeryan

    (@shayeryan)

    Hi Vladimir, sorry I’m just now getting back.

    Can you elaborate on how I look at the database with this? Do I run a query in phpMyAdmin?

    Plugin Author Vladimir Garagulia

    (@shinephp)

    Hi Shaye,

    Yes, you can use phpMyAdmin for this purpose.

    Thread Starter shayeryan

    (@shayeryan)

    Hi Vladimir, this is the result that is coming back. Not sure what to make of it.

    https://postimg.cc/MMkKQKvR

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.