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.
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
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.
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?
Hi Shaye,
Yes, you can use phpMyAdmin for this purpose.
Hi Vladimir, this is the result that is coming back. Not sure what to make of it.
https://postimg.cc/MMkKQKvR
