VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Products not showing in Admin
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Joff
Starting Member

United Kingdom
43 Posts

Posted - April 19 2007 :  06:14:11  Show Profile  Reply with Quote
I've started to populate my 6.50 installation with categories and products, but couldn't find the example products (office furniture, DVD cases, etc) in the Admin anywhere.

I tracked the problem down to the "userid" field in "products" table having the userid of "admin", where I'm now using a different userid.

To be honest, I think the problem was self-inflicted as I may have just updated the userid manually within "tbluser", but it's worth considering if anyone else has missing products within the admin that can be seen on the website.

Kidd
VP-ASP Super User

Australia
373 Posts

Posted - April 19 2007 :  10:21:42  Show Profile  Reply with Quote
whats the sql statement for your products page looks like? turn xdebug to Yes

it should be something like
select * from products

yours probably will be something like
select * from products where userid.....

you need to modify that sql statement and remove the user id clause
Go to Top of Page

Joff
Starting Member

United Kingdom
43 Posts

Posted - April 19 2007 :  11:25:55  Show Profile  Reply with Quote
Turns out it was DoRestrictProducts in shopa_editdisplay. Can this be set within admin? I've just commented it out for now.
Go to Top of Page

support
Administrator

4266 Posts

Posted - April 19 2007 :  18:41:50  Show Profile  Visit support's Homepage  Reply with Quote
Hi Joff,

Go back to the Admin Users section of the admin and check if your log in is restricted or a super user.

The restricted user is so you can have people access the admin and be bale eto see products or categories that are assigned to their log in.

Super Users see everything.

Thanks
Cam

VP-ASP Support
Go to Top of Page

Joff
Starting Member

United Kingdom
43 Posts

Posted - April 20 2007 :  03:12:19  Show Profile  Reply with Quote
Thanks Cam, the user was down as restricted, now set it to super and it's working fine :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000