Display prices for registered customers only...

[matperino]

Hi,

It seems impossible to me, but maybe there's a specialist who will have an answer :

Is it possible to display prices for registered customers (ordering being allowed), and to hide prices for unregistered customers (ordering being disallowed)?

Thanks for any advice,

Mathieu.

[Nadeem]

Hi Mathieu,

This should be possible to do in the Actinic software, if you simply select the product you want to show prices for Trade customers, then click on the "Prices" tab in "Product Details". Untick "Enabled" for "Retail" group. Now when you update the unregistered customer will not see the price, but instead a prompt saying "This product is only available to registered customers".

Kind Regards

[matperino]

Hi,
Thanks for this idea, but I'm afraid it might be too long to do that manually for my whole catalog !

Is there a way to set this directly in the export file?

Thanks

[Robert_Taylor]

Hi Mathieu,

Yes this is possible using the hierarchical export file of your catalog data within Actinic.
Once you have exported the hierarchical file you would need to filter the data and find all entries with Retail in column B and then edit its corresponding entries in column E from 1 to 0.
Test it first by changing it for one specific product and check if it works and then you could modify the entire column.

Regards,
Robert.

[StevenG]

Hi Robert,

I came across a problem while trying to use the method you described.

I have 2 customer groups set up, the standard Retail and a Wholesale account. As we only supply to the trade I also wanted to prevent unregistered users from seeing our pricing structures and so set about unticking the enabled box for the Retail group in each product. This is a very long and laborious method when you have 10,000 products and so I decided to try the method you described.

I exported the hierarchical Catalog information to a csv file but when I opened it the only rows that contained the Reatil group information were those which I had already altered manually.

Any ideas how to get round this problem?

Steve

[Robert_Taylor]

Hi Steve,

The above solution will not work if you are using quantity based discounts. I see that you have called Actinic support and our developers are finding out a way to resolve this using an sql query and you should receive an update soon.

Regards,
Robert.

[StevenG]

Hi Robert,

The problem has now been resolved by the tech support people using a sequence of sql commands run in MS Access. Below is the workaround I received:

With regards to your issue of unticking the 'Enabled' field of all the Retail Prices, our development team have come up with a work around. Its a bit fiddly but I have tried it and it works. Please note that this will only work if you are not using quantity based pricing on any of your products.Also note that you will have to get rid of any Retail Price records from the ProductProperties table in the ActinicCatalog.mdb database. (The first query below will do this for you).If you are using Auto-Generated product references,You need to turn iff this feature. ( View | Business settings | Options | Product References, make sure that Auto-Generated Product References is unticked).You can turn it back on after applying these changes.

Please backup the database before doing these changes:

Open ActinicCatalog.mdb with Access2000

Run the following SQL to remove any Retail Price records...

DELETE ProductProperties.sProductRef, ProductProperties.nType,
ProductProperties.nValue1, ProductProperties.bFlag2 FROM ProductProperties
WHERE (((ProductProperties.nType)=4) AND ((ProductProperties.nValue1)=1)
AND ((ProductProperties.bFlag2)=0));

To run the above SQL query you may follow the steps given below:

1. Go to MS Access 2000 and then to Insert | Query.
2. Highlight 'Design View' and click 'Ok'. If the Add table window pops up, just close it.
3. Now go to View | Sql View and copy and paste the above given Query in to the SQL window, overwrite any existing contents and save it.
4. Make sure that Actinic is closed.
5. Go to View | Database Objects | Query.
6. Run the query by double clicking on it.

Add the following SQL Query to generate the import data and save it as a Query
called 'GenImport'.

SELECT 'Product,"'+[Product reference]+'"
Price,Retail,1,0,2' AS Line1
FROM Product;

Select (don't open) the Query GenImport, right click and select export.
Export the query as an HTML Document GenImport.html.

Open GenImport.html with IE

Select the whole page except the title GenImport and copy to the clipboard.

Open Notepad and paste from the clipboard

At the top of the file insert:-

Header:Product,Product reference
Header:Price,Customer Group,Generated,Can be Ordered,Min

The file should look something like...
Header:Product,Product reference
Header:Price,Customer Group,Generated,Can be Ordered,Min
Product,"5"
Price,Retail,1,0,2
Product,"6"
Price,Retail,1,0,2
Product,"7"
Price,Retail,1,0,2

Save the file to Import.txt

Close Access2000
Open Actinic
Import as Hierarchical Import the saved file Import.txt (In Actinic go to File | Import).
Select 'Update' rather than replace file when you Import it.

Close Actinic
Open Access2000

Create and run the following SQL Query to make the imported changes apply to the default
Retail prices.

UPDATE ProductProperties SET ProductProperties.sString1 =
"", ProductProperties.sString2 = ""WHERE (((ProductProperties.nType)=4)
AND ((ProductProperties.nValue1)=1) AND ((ProductProperties.bFlag2)=0));

Close Access2000
Open Actinic

The Retail prices should now be disabled for all products.

However, if anyone else wishes to resolve this problem in this way and has several thousand products in their database, I would advise installing an alternative browser to MS IE as this was unable the handle the 20+ thousand lines generated by the GenImport report. I installed Firefox to do that step of the process and found that, while it did take a couple of minutes to highlight all the pertenant text, it did, in the end, work

Thanks for the help

Steve