1. I have android app on signup as an customer I want to update new table called staticcustomerid
This staticcustomerid table contain 2 columns 1st column will be staticid & 2nd column will be customerid. Static ID will be sent from App for example ABCD. So when customer signup ast column updated will have value ABCD & 2nd column will have primary id of the register user for example 999.
Stasicid | customerid
ABCD | 999
There will be one table already maintained which is staticsellerid which will have 2 columns 1st is staticid & 2nd will be seller ID for example 123.
Stasicid | sellerid
ABCD | 123
so on signup I want to update additional table called drlink. 1st column of this table will be updated with matching seller id from staticsellerid table so appis sending static id ABCD then this column will be updated as 123. second column of this table will be updated with signup id for example 999.
So in call 2 table will be updated on signup as customer. 1st is staticcustomerid & 2nd table is static customer id.
2. forgot password functionality is not working. When signup user forget password he click on forgot password then user received email link to setup password. When user enter new password login not work.
3. filtering on page product category based on static id received from the app on login.
Product category will have product of various sellers.
for example seller 123 has product category called television. Seller 321 has product category called Automobile.
123 | Television
321 | Automobile
Signed up customer if have entry for both the seller in drlink table for example below entry
123 | 999
321 | 999
So when user login from app and execute product category page . Static id will be checked for example if it is ABCD then related seller id will be checked from staticsellerid which is 123. then product category created by 123 will be only shown which is Television.
Sample page of product can be seen on website as well which [url removed, login to view] login with evfck@[url removed, login to view] & Password as Kcfve999* & click on product category