Prices visible only by registered Customers

[Ian M]

Is there a global way of selecting products to enable switching off of the price view via the Retail Customer group mechanism, or via a design layout tweak.
I have a imported, from sage, product list totaling over 200o products and dont fancy going through every one to untick a box.

Regards Ian M

[Bruce]

Ian,

The following is a work around that was provided for v7 but will work for v8 as well...

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 off 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.

This is a bit clunky but the only way to do it without having to manually change it per product.

Kind regards,

[Ian M]

Thanks Bruce,

Unfortunately my customer requires quantity based pricing/discount on their products so I presume this rules out this fix.

Maybe this item for the wish list?

If the ability to enable disable price groups, by adding the Prices tab to the section details for the section, similar to the way the hierarchal product layouts work, with the ability to have a section default layout but able to override this at a product level, this would I’m sure find favour with a number of users.

Not being able to select a number of products to perform a similar action globally, is causing me a headache and exposing a major drawback within the software for the end uses and something that a number of us pointed out the recent Designer course I attended, any feedback on this?

Thanks again for the reply, later today I’m going on a well earned (my words ) holiday for a couple of weeks, but will pick up this thread on my return.


Regards Ian M


Regards Ian M

[Bruce]

Ian,

I will put this on the wish list for you.

Kind regards,