Trade Only site

[paul in london]

Hi All

I have decided to sell to Trade customers only and would like to have no prices shown, but still have the products visible as now.

Trade customers could then log in and see the prices.

How could this be done?

Any help much appreciated.

Thanks, Paul

www.flooringsales.co.uk

[Bruce]

Paul,

One method of doing this would be to click on the prices tab of a Product and then unchecking enabled against 'Retail'. If you have a lot of products this could become a very time consuming affair.

There is a work around to remove all Retail prices at one go.

Please note ** The solution will not work if you use quantity discounts i.e. 1
@ £3.00, 2-4 @ £2.00, 5+ @ £1.00 etc. You need to do this with Auto-Generate off, this can be turned back on afterwards.

The solution, requires Access2000 and can only be used if the above conditions are met.

Close Actinic backing up the database. The backup may be required if the following goes wrong.

Open ActinicCatalog.mdb with Access2000

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

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

Add the following SQL 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, righ click and select export.
Export the query as an HTML Document GenImport.html.

Open GenImport.html with IE or FireFox

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 the saved file Import.txt, as a Hierarchical Import.

Close Actinic
Open Access2000

Run the following SQL 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.

You will have to update the site for changes to apply.

Please remember to make a database backup before going any further.

Kind regards,

[paul in london]

Thank you very much Bruce.

Paul