Discounts and products

[newshopbloke]

Hi all,

As usual I have a couple of questions :

1: Is it possible to apply a discount to the entire shop that actually changes all the prices so that I can upload the whole shop with newer prices at say 10% cheaper ? Im using a cart based discount structure at the moment but would like to try 'no frills' shopping with my best prices displayed immediately.

2: I would like to have single products in different sections and as part of bulk buys, I know this is possible but would like Actinic to control stock accordingly - for example if I have 100 blue marker pens in stock and have them listed singularly and as a buy 2 get one free, will the single products stock be updated accordingly when either are purchased ?

Cheers

Mick

[newshopbloke]

Any ideas

Hi,

As I received no reply I thought I would simplify the question :

Is there a quick and easy way of lowering ALL of my prices without using the discount option ?

Cheers

Mick

[DaveT]

Updating prices

Hello

I did this once where I used Access to update all the prices to reflect a 5% discount.

I don't know if you are familiar with Access but it basically means opening the backend database and running a (carefully!) query aginst the product prices.

The other way you might try is to create an order level discount (applies to V7) based on an order value of the minimum amount such as say £0.01 as a trigger. Set the discount % to 10 and this should set a store wide reduction in prices in the shopping cart.

Hope this helps.

[Laylah]

You could also do your price adjustments in EXCEL and import the updated prices.

. . . and I know you specifically said without using discounts . . . but you could use the Design | Options | Shop Default Tab 'Page Header' field to prominently display a coupon code on every page which gives a store-wide discount. That would give you some flexibility for instant changes etc.

[I don't know what the character limit is for 'Header' and 'Footer' but they are nifty places to put quite a bit of !!< html code >!!

[newshopbloke]

Thanks for the replies.
Can someone give me a 'step by step' on applying a shopwide discount easily with access ?

Thanks

[DaveT]

Hi there

To do this, I would first do the following:

Make a backup of your ActinicCatalog.mdb database. Then make another one just to be sure.

Open Access and open up the ActinicCatalog.mdb file you will find in the Site1 directory.

Open the products table. You will see there are a number of tables, Products contains all product related stuff.

Create a new SELECT query (starts as default). From the field list, include product reference, short description and price.

Change the query mode to UPDATE from the Query menu at the top.

It will provide a field in the query with Update To: at the left. Under Price, enter the following, (ASSUMING you want to update all your retail prices by 5%):

=([Product]![Price]*1.05)

Press the Run button and it will give you a warning saying 'Are you sure you want to update XX rows?" If you are satisfied that it will be OK, press OK.

Then close Access and run Actinic with your new prices.

Like I say, be careful and test on one or two codes first. If it doesn't do what you want it to do, you can always copy the backup ActinicCatalog.mdn back into the Site1 directory.

No liability or warranty is accepted on my part. But hope it helps anyway!

DaveT.

[newshopbloke]

Thanks dave,

That worked very well but it made the prices go up instead of down Can you give me the code for making the prices go down instead of up ?

=([Product]![Price]*0.95) ??

Im not panicking as I have 2 copies of the old database

Cheers