Can anyone tell me how they did this???

[rcheltrvel]

I want to have a 'Sale' link on the my home page and when the user clicks on it, a page comes up with all the products that are on sale on it. Is this possible to do? I found a few sites that use 3dCart and they are doing it but I am not sure how. Here is an example....


http://www.forgetmenotkids.com/ (home page, top right... 'Shop Sale').

The only way I can think of doing this is to make a category called 'sale' and then manually link all sale items to that category. I don't want to have to do that, it would be a huge pain. Can it be automated in some way? I can't imagine this feature is not built into the cart. Almost every site out there these days has a 'sale' item area.

Thanks! Rachel

[cekman]

Sorry Rachel - the only way I know how to do this is with a category. I do this this (when I do it) the same way I do the Recently Added Items category discussed in the other post.

I have a check box in my MS Access database that allows my to mark if an item is on sale. If that box is checked then my import routine adds that product to the ON SALE category and then sets the sale price accordingly.

I haven't used this much at all yet. So far my sales have been in the form of promotions to my customers. I've just set a few items on sale by hand and haven't used the Sale category.

If you figured out how the New Items category worked -then this should work for you also.

I also wrote a query in my Access database that allows me to set an entire category or designer on sale and then states what percentage off the sale price will be. That allows me to quickly mark bulk items in my database - then my import routine handles it for 3-d Cart.

One problem I do have - when I want to take items OFF sale then I have more of a headache because I normally only import items that are new or the inventory has changed. So taking items off sale was 'by hand'. I can do it with my import routine but it was becoming bothersome - thus very few on sale items right now.

Hope this helps
Carla
http://cobwebcorner.com

[rcheltrvel]

Thanks for the response Carla. I can not believe that this feature is not included in 3dCart. It seems as if it is a feature that most everyone's sites have these day.

[cekman]

One other thing. If you haven't seen it already go to your home page in admin and under PRODUCTS there is a MUTLIPE UPDATE option. This will allow you to search on products and set the sale price and ON SALE tag a little quicker than going into each full product descritpion.

The ON SALE tag will simply display the item as a featured item in the category - it won't add it to an ON SALE category. But it will display the sale items to your customers first before other products.

Play with it and see if that helps at all.

Carla