Category Specific Access Restriction (CSAR) - [Support Thread]

[frank18]

Simon

Suggest you click on one of the test products. Don't click on anything else. Take note of the approximate time when you clicked on the test product. Now download the content of your logs folder and post the debug file that has the corresponding approximate time (should be last file in the store/logs folder).

I also noted that the listing of New Products shows the prices of your test products. Same in the All Products listing. That is a clear sign that you did not upload and/or merge all files contained in the package.

Frank

[clausont]

Thanks Frank - that worked. Apparently I didn't understand what this plugin does. I was looking for a way to have some products - 1 category - available without having to log in or something like that anyway. Is there a way to emulate that with this plugin?
Thanks

[frank18]

Thanks Frank - that worked. Apparently I didn't understand what this plugin does. I was looking for a way to have some products - 1 category - available without having to log in or something like that anyway. Is there a way to emulate that with this plugin?
Thanks

CSAR is designed to have most products open to the public (no login required until they want to check out) *but* restrict some categories/products.

As I see it, you are looking for the reverse way to CSAR: you want *all* products under lock and key (customer must be logged in to browse and purchase) BUT for one category.

To achieve that you first need to set Customer Shop Status - View Shop and Prices = 1 and then do some coding to excempt just the one category.

So the approach is entirely different to CSAR.

Alternatively, and depending on how many categories you have, you could use CSAR, leave Customer Shop Status - View Shop and Prices = 0 and then restrict all categories execept the one you want to keep open. Tedious but it would work.

[clausont]

Well, I think that may solve the problem, but brings up two others. I had the catalog displaying three columns per row and after merging everything, it is a single row. I'm pretty sure that is because I had another module installed that allowed column display but forgot about it.
The part that I have to ask about is in the instructions:

Please note that you still need to assign special privileges to certain customers you want to allow access to products of categeories / manufacturers you configured in points 2. and 3. in this segment.

To grant access to these customers go to Admin > Customers > Customers and individually open the details of your chosen/approved customers.

In your list of customers you will see a new column on the right hand side headed Privileges. By default the icon is a red cross. You can sort this column to find which customers are 'privileged' or not.

Near the top of each customer's personal details you find a dropdown called Customers Special Privileges Status. The default is 'None'. Set this to 'Has Special Privileges'.

Update the customer file - done

The icon in the customer listing is now changed from a red cross to green indicating that the customer has special privileges.

As I understand it, I would have to go and update all 1,600 customers individually to access the logged in products?
Can you tell me what file to edit to default it to "'Has Special Privileges" rather than "none" or am I mis-understanding this?
Thanks

[frank18]

Well, I think that may solve the problem, but brings up two others. I had the catalog displaying three columns per row and after merging everything, it is a single row. I'm pretty sure that is because I had another module installed that allowed column display but forgot about it.

Naturally the merging must take individually installed mods into consideration.

The part that I have to ask about is in the instructions:

As I understand it, I would have to go and update all 1,600 customers individually to access the logged in products?
Can you tell me what file to edit to default it to "'Has Special Privileges" rather than "none" or am I mis-understanding this?
Thanks

If you wanted all customers to have special privileges then you really don't need this mod. In Admin > Customers > Customer Approval Status you could set this to 1= Must be Authorized to Browse.

But your equirements may different to here is an SQL statement to run in phpMyAdmin:

Backup your DB !!!

In phpMyAdmin select your DB and click the SQL tab at the top.

Run this statement

UPDATE 'customers' SET 'customers_privileges'= 1

WARNING: This will set privileges of ALL customers to 1, meaning ALL customers will now show 'Has Special Privileges'. New customers will initially still be set to 'none' until you make individual changes to their data.

[clausont]

Thanks Frank - I appreciate the help here. To be sure I understand correctly before I run the sql statement:
My objective here is as follows. Currently the catalog has only two categories - private and retail. The vast majority of products are private with only a few retail products available to the public and should be available without logging in. All private products must be logged in to purchase or see prices.
Any non-logged in or logged in customer should be able to view retail products and buy retail products, but should not see the prices of the private products if they are not logged in (seeing the products is fine, just not the prices and not be able to add to cart). Any logged in customer should be able to see and purchase any product regardless of which category.
Am I on the right track with the customer privileges? It sounds like it, but just want to confirm first.

[frank18]

............Am I on the right track with the customer privileges? It sounds like it, but just want to confirm first.

Yes, you are on the right track!

[rbarbour]

I just got around to playing with this, huge difference from similar or previous versions.

from me on this, love it's flexibility!

Awesome job Frank!

[frank18]

I just got around to playing with this, huge difference from similar or previous versions.

from me on this, love it's flexibility!

Awesome job Frank!

Thanks mate - just have to get around and iron out a few bugs such as the auto increment gID. My time is currently *very* limited so your input to fix the install-sql file would be much appreciated

[storm007]

Simon

Suggest you click on one of the test products. Don't click on anything else. Take note of the approximate time when you clicked on the test product. Now download the content of your logs folder and post the debug file that has the corresponding approximate time (should be last file in the store/logs folder).

I also noted that the listing of New Products shows the prices of your test products. Same in the All Products listing. That is a clear sign that you did not upload and/or merge all files contained in the package.

Frank

Hi Frank,

Here is the log.

www.neilson-hydraulics.co.uk 80.229.41.38 - 2013-06-10 14:16:11 GET /store/ - 200 5728 http://www.neilson-hydraulics.co.uk/...order=1&page=6 Mozilla/5.0+(Windows+NT+6.1;+rv:21.0)+Gecko/20100101+Firefox/21.0
www.neilson-hydraulics.co.uk 80.229.41.38 - 2013-06-10 14:16:23 GET /store/index.php main_page=index&cPath=160 200 5066 http://www.neilson-hydraulics.co.uk/store/ Mozilla/5.0+(Windows+NT+6.1;+rv:21.0)+Gecko/20100101+Firefox/21.0

Also, i have noticed the prices are being displayed on All and New Products. The only files i had to modify were Product_listing.php and tpl_product_info_display.php. Are their more files to modify?

Kind regards
Simon