CATALooK.netStore A powerful easy-to-use shopping cart and renting / letting system - eCommerce solution for DotNetNuke > Support &<br> Service

Forum Home

DotNetNuke

CATALooK.netStore

Buy product A g...

Buy product A get product B free

11/15/2006 1:23:26 PM

Zone

1 posts

Buy product A get product B free
Modified By Zone on 11/17/2006 2:47:02 PM)

Been trying to set up a coupon where a customer buys product A and gets 1 or 2 of product B for free.

any help would be appreciated

12/23/2006 10:50:15 AM

host

1831 posts

Re: Buy product A get product B free

1. Create Product A and B, insert the coupon code e.g. 'ABC123' into field: 'ZIP Password' and activate the 'Enable Download' checkbox.
2. Host -> Languages -> Language Editor -> expand Local Resources -> DesktopModules -> CATALooKStore -> App_LocalResources -> _orderdetails.ascx -> search for 'ZIP Password' and change it to 'Coupon'.
3. Create Product C. After you have added the product, you can select: Attributes -> Text Options / data-entry forms -> Create New -> Name / Title = Coupon; Selections = leave blank; Status = Optional; Control Type = Coupon Code Entry Field -> Add -> Select the Coupon option from the Available Options list box -> Assign. The coupon entry field will be displayed on the product detail site.
4. Module CAT_PriceRules -> 'Add Price Rule' -> Select Product C for 'Product' -> Enter 'ABC123=Price of product C' into the 'Coupon Codes' field -> Add

After your customer has paid for product A or B, he will be redirected to the order details page where he can see the coupon code. You should add a Text/HTML module to this page and enter some information about how to get product C for free and a link to product C.

_________________________________________________________________

Thanks for the reply. Unfortunately, we do not want the customer to incur 2 shipping charges, so we want the free bars to go along with the order of Product A or product C.

Original Scenario: Buy either product A OR Product B and get 1 or 2 boxes of Product C (Depending on coupon code) for free.

As I understand it, the limitations are as follows:

1. At the product level, a price rule can be applied to Product C, but there is no way to enforce the purchase of product A or product B and include all products in the original order. Your scenario below would require that the customer get product C after the fact in another shipment. We want to include the free items with the original order.

I have a scenario that perhaps you could comment on.

1. A price rule is put on Product A and Product B which discounts either product A or B by the amount of product C. In effect giving away product C for free. The problem with this scenario is that we must ensure that product C is added to the cart, other wise we could end up potentially giving the customer a credit. I know a customer will figure this out and abuse it:

Example with bars in cart: THIS IS OK

Item Qty Original Price Discount Amount

Fish Oil 1 $50 $56 -6 (Price Rule - discount amount of the bars based on coupon code)

Bar 1 1 $28 $0 $28

Bar 2 1 $28 $0 $28

Total $50 (original amount of the Oil)

Example A with no bars in cart: THIS IS NOT OK

Customer figures out that they can order just the Oil

Item Qty Original Price Discount Amount

Fish Oil 1 $50 $56 -6 (discount the amount of the bars based on the coupon code)

Total $-6 (original amount of the Oil)

_______________________________________________________________

'A price rule is put on Product A and Product B which discounts either product A or B by the amount of product C. In effect giving away product C for free. The problem with this scenario is that we must ensure that product C is added to the cart, other wise we could end up potentially giving the customer a credit. I know a customer will figure this out and abuse it:'
-> Great idea! You can create a price rule for that as follow:
1) Module CAT_PriceRules -> select 'Add Price Rules' from the module menu
2) Select 'Fish Oil' for 'Product'
3) Select 'Bar' for 'Also purchased Product'
4) Enter -28 into the 'Formula' field
5) Click on the 'Add' link

Now the price of Fish Oil will be reduced by $28 if there is also the product 'Bar' in the cart.

Probably this scenario is more clear for the customer:
1) Module CAT_PriceRules -> select 'Add Price Rules' from the module menu
2) Select 'Bar' for 'Product'
3) Select 'Fish Oil' for 'Also purchased Product'
4) Enter 0 into the 'Formula' field
5) Click on the 'Add' link

Now the price of product 'Bar' will be 0 as soon as also product 'Fish Oil' has been added to the cart.

_______________________________________________________________

Scenario 1

I created a price rule as you suggested - selected bar for product and oil for also purchased. I entered -28 in the formula field and it works. except that I can then go into the cart and change the quantity of the bars to any number and get the bars for free. So I thought let me use ranges. 1-2=-28;3-=28. Thinking that qty 1 or 2 would be zero and anything above that would be $28 each. but it does not work that way. anything over 2 changes all quantities to $28. Also, this method does use a coupon code which I need to have.

Scenario 2

I created a price rule - selected bar for product and oil for also purchased. I entered a coupon code of FREE025=-28 however when there is a value in the "also purchased" field, the system will not accept the coupon code. If I delete the "also purchased" value, the coupon code works but I lose the capability of ensuring the oil is added to the cart.

Scenario 2 is also problematic since it still allows me to change the quantities in the cart beyond the coupon amount. ie: FREE025 entitles the customer to 2 free boxes for free. Coupon code FREE050 entitiles the customer to 1 free box. However the customer could change the quantity in the cart to 500 and get 500 at $0. not good!

Optimally this should work for a 1 free box promotion: create a price rule for coupon FREE028=-28 ($28 = price of 1 box of bars) in conjunction with a formula of 2-=28. The effect would be when a customer enters the coupon code for bars and also purchased oil, they would receive 1 box for $0 and anything over 1 box would be at $28

for a 2 box promotion FREE56=-56 (price of 2 boxes) in conjunction with a formula of 3-=28.

_______________________________________________________________

You can not use a coupon code with a formula in the same price rule. A coupon code can not be related to a 'also purchased' product. It is also not possible to apply any formula to the 'Also Purchased Product' of a price rule. Linda's method's can be used only, if you don't require any coupon codes. To restrict the number of free items you could setup the following:
1) Module CAT_Products -> Search for the 'Bar' product -> Full Page Edit -> Enter 1 into field: Selections(orderable quantities). Set Stock = 1.
2) Module CAT_StoreSettings -> Activate the 'Not allow the sale of an item that is no inventory' checkbox
3) Module CAT_StoreSettings -> Select 'Invoice/Credit Note' from the 'Stock Control Type' selector.
-> Now you customer can add only one free 'Bar' item to the cart.

To get a relation between ordered product, coupon and free item, you must setup a configurable product. The base product would be the 'Fish Oil'. Enter 1 into field: Selections(orderable quantities) for this product.
Now you can setup a slot for the free product. Then add restriction for the free products in relation to the base product. This will ensure that only allowed free products can be used with this base product.
After that, you can add a coupon price rules for the free products.

Now you can go to this product -> click on the link: 'select your free product', choose one of the available free items -> enter the coupon code to reduce the price to 0 for the free product -> add to cart. You will not be able to change the quantity of the cart items for this configuration. Optional you can enable this, so that quantity changes of the base product would indicate quantity changes of the free product e.g. 2/2 or 3/3.

You can find a sample scenario in chapter: 'Configurable product example'

_______________________________________________________________

I have 4 promotions (4 unique coupon codes) that we want to do. The premise for all 4 coupons is basically the same - buy product A and get a specific qty (1 or 2) of product C for $0. The difference between the promotions is:

Promotion 1 = 1 free box of bars with the purchase of oil

Promotion 2 = 2 free box of bars with the purchase of oil

Promotion 3 = 2 free boxes of bars for AutoShip customers (role) with the purchase of oil

Promotion 4 = 1 free shaker cup with the purchase of oil

The constant thing here is that the customer must buy product A (oil)

I was successful in setting up a price rule (If customer purchased Product C – Bars AND purchased Product A – Oil) with a formula of -28 the price of the Bars is reduced to Zero. BUT: The coupon code is not used in this scenario and I must limit the qty of the bars based on the coupon code (1 free box). In this scenario, I can go into the cart and change the qty of the Bars to 500 and the customer will get 500 free boxes of bars – not good.

So I thought I could use ranges in the formula field. I set 1-2=-28;3-=28. It recognizes range 1-2 but if I go into the cart and change the qty to 3 it changes the price to $28 for all bars not just those qtys over 2.

QUESTION

Is this a bug or is it not intended to interrogate each range?

Given that I must use a coupon code to deliver the discount. I tried to set a price rule (If customer purchased Product C – Bars AND purchased Product A – Oil) using a coupon code of FREE028=-28 but the system will not accept the coupon code on the bars – it says “an invalid coupon code was entered” - If I delete the “and purchased” product in the price rule it will accept the coupon code but I lose the ability to force the customer to buy the OIL.

QUESTION

Is this a bug or is it not intended to use a coupon code with the “also purchased” option in the price rules.

I have 4 types of bars that the customer can choose from for their free samples. So I setup an identical price rule (as above) for each of the Bar products assuming that the cart would interrogate and apply each rule by product. Will it?

_______________________________________________________________

The configurable product will work for this.
For Promotion 2 and 3 you can add two slots to the base product for the free items or you can make the quantity selectable of the free items(Select 'View Options' from the module menu of the ItemPane module and activate the 'Allow order quantity selection for components of a configurable product' checkbox) and restrict the allowed quantity by using the inventory as described in my previous email or you can also preselect a free product and quantity for a slot.

Page 1 of 1

DotNetNuke

CATALooK.netStore

Buy product A g...