<![CDATA[BCS Engineering]]> <![CDATA[After installing the On Sale module I can't add a product to the ...]]>
If you skipped some optional steps to the product.tpl you may also need to skip the installation changes made to the func.js file.]]> <![CDATA[I would like a different sale than is available in the On Sale mo...]]> http://www.alteredcart.com/demo/onsale.php
http://www.alteredcart.com/demo/admin/home.php]]> <![CDATA[I have a group of products in different categories I would like t...]]>
Here are the steps:


1. Create a category (name it something similar to – 'sale_group_A') and make sure it is disabled.

2. For each product you would like to have in this sale go to the product modify page and add 'sale_group_A' as an additional category.

3. You can then use the new category 'sale_group_A' in any category based sale, and since the category is disabled it will not display on the customer storefront. ]]> <![CDATA[What do each of the On Sale sales do?]]>
# Buy Product X Get Z Items Free/Discounted (3) - Select an exact product or products that a customer must purchase, and then a number of products (from optional categories) that a customer will receive free or discounted.

# Buy X Items Get Product Y Free/Discounted (8) - Select the number of items a customer must buy (from optional categories), and select an exact product or products that a custom will receive free or discounted.

# Buy X Items Get Z Items Free/Discounted (4)- Select the number of items a customer must buy (from optional categories), and then a number of products (from optional categories) that a customer will receive free or discounted.

# Buy X Items Get Z Discount On Your Order (12)- Select the number of items a customer must buy (from optional categories), and the discount they will receive on their order for buying this amount.

# Spend X Get Product Y Free/Discounted (2) - Select the amount a customer must buy spend (from optional categories), and select an exact product or products that a custom will receive free or discounted for spending this amount.

# Spend X Get Z Items Free/Discounted (9) - Select the amount a customer must buy spend (from optional categories), and then a number of products (from optional categories) that a customer will receive free or discounted for spending this amount.

# Spend X Get Z Discount on Your Order (5) - Select the amount a customer must buy spend (from optional categories), and the discount they will receive on their order for spending this amount.

# Spend X Get Free/Discounted Shipping (6) - Select the amount a customer must buy spend (from optional categories), and then the zones, and shipping methods that will be free/discounted for spending this amount.

# Auto Generate Coupon for the Next Purchase (Sent After Checkout is Completed) (7) -
This sale will automatically send a coupon to the customer when they meet the criteria. This sale must be used with another sale with a coupon assigned.

# Individual Product(s) Discount (10) - Select an exact product or products to discount.

# Quantity Based Product Discount (Wholesale) (11) - Select an exact product or products, the quantity required to purchased, and the discount received when the customer purchases the required amount.]]> <![CDATA[I have an AJAX add to cart customization, or I don't redirect to ...]]> Settings -> Calculate Sales on both the Cart and Checkout pages This will simply calculate the sales once the customer reaches the...]]>
On Sale -> Settings -> Calculate Sales on both the Cart and Checkout pages

This will simply calculate the sales once the customer reaches the checkout.


---

Or you can add the sale calculation to your custom mod, or the cart.php page if you don't redirect to the cart after adding a product. To do this add the following code to your script somewhere after the product has been added to the cart:

// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale'])
require $xcart_dir."/modules/On_Sale/onsale_add_to_cart.php";
// End On Sale //


If this is the cart.php file you can add it after:

# Recalculate cart totals after new item added
$products = func_products_in_cart($cart, (!empty($user_account["membershipid"]) ? $user_account["membershipid"] : ""));
$cart = func_array_merge($cart, func_calculate($cart, $products, $login, $current_area, 0));]]> <![CDATA[How do I display the On Sale coupon data or sale information on t...]]>


Make the following changes:

1. Open skin1/mail/html/order_data.tpl

Find this code near line 122:

{if $order.coupon and $order.coupon_type eq "free_ship"}
<tr>
<td align="right" height="20"><b>{$lng.lbl_coupon_saving} ({$order.coupon}):</b> </td>
<td align="right">{include file="currency.tpl" value=$order.coupon_discount} </td>
</tr>
{/if}


Immediately after insert:

{*** On Sale :: alteredcart.com ***}
{if $order.onsale_data && $active_modules.On_Sale}
{include file="modules/On_Sale/onsale_order_data.tpl" onsale_data=$order.onsale_data}
{/if}
{*** On Sale :: alteredcart.com ***}


2. Open include/func/func.order.php

Find this code near line 384:

if (!empty($active_modules['Google_Checkout']))
include $xcart_dir."/modules/Google_Checkout/get_order_data.php";


Immediately after insert:

// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale']){
require $xcart_dir."/modules/On_Sale/onsale_orders.php";
$order['onsale_data'] = $onsale_data;
}
// End On Sale //



3. Upload the attached file to the skin1/modules/On_Sale directory (if this file already exists you can skip this step):

skin1/modules/On_Sale/onsale_order_data.tpl

onsale_order_data.tpl]]> <![CDATA[The On Sale module discounts aren't applied when using Google Che...]]>
payment/auth.php

Find this code near line 43:

include_once $xcart_dir."/init.php";


Immediately after insert this code:

// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale'])
require $xcart_dir."/modules/On_Sale/onsale_payment_auth.php";
// End On Sale //


Additionally, please make sure the modules/On_Sale/onsale_payment_auth.php file is on your server. If it is not you will need to download the most recent version of the On Sale module and upload this file from the distribution to your server.

-------

For Google Checkout only make these additional modifications:

Please be sure the /modules/On_Sale/onsale_google_shipping.php file is on your server. If it is not please download the lastest version of the On Sale module and update your software before making these changes.

modules/Google_Checkout/gcheckout_callback.php

Find this code near line 355:

$config['Shipping']['enable_all_shippings'] = 'N';


Immediately after insert:

// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale'])
x_session_register('onsale_cart_subtotal_discount');
// End On Sale //


Find this code near line 379:

$_tmp['shipping_methods'] = $_result_shipping_methods;


BEFORE Insert:

// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale'])
require $xcart_dir."/modules/On_Sale/onsale_google_shipping.php";
// End On Sale //


modules/Google_Checkout/gcheckout_callback.php

Find this code near line 524:

x_load('cart','crypt','user','order');


After insert:

// On Sale :: www.alteredcart.com //
global $active_modules, $xcart_dir;
if ($active_modules['On_Sale'])
require $xcart_dir."/modules/On_Sale/onsale_payment_auth.php";
// End On Sale //]]> <![CDATA[Google Webmaster Tools gave me a "duplicate meta" message on the ...]]>
After:

{assign var="_meta_descr" value="$_meta_descr`$config.SEO.meta_descr`"}
{assign var="_meta_keywords" value="$_meta_keywords`$config.SEO.meta_keywords`"}


Add:

{if $main == 'onsale_display'}
{assign var="_meta_descr" value="Your custom meta descr"}
{assign var="_meta_keywords" value="Your custom meta keywords"}
{/if}


Changing the value="" as needed.]]> <![CDATA[How do I discount an entire category of products.]]> 2. Set the Spend to $0.
3. Select the categories you want to discount.
4. Set the amount you want to discount each item in this category.

Since every customer at your store has spent at least $0, they will all be eligible for this sale.]]> <![CDATA[How can I limit a customer to one coupon with the On Sale module?]]> Immediately BEFORE enter: {if !$cart.onsale_coupons} OR {if !$cart.onsale_coupons && $cart.coupon_discount == 0} The 1st option will allow one X-Cart coupon, and one On Sale coupon. The 2nd option will allow only one coupon per order regardless if it is an X-Cart coupon or On Sale coupon Then find this code near line 30: Immediately after add: {else}

Limit one coupon per order.

{/if} The text can be changed as needed.]]> <![CDATA[[Tutorial] How to setup sale exclusions.]]>
For example. Lets say you have two sales:


* Buy 2 get a 20% discount

* Buy 3 get a 33% discount.

You don't want the customer to be eligible for both sales. If they buy 2 you would like them to have a 20% discount, but if they buy 3 or more you would like them to have a 33% discount.

For this you will want the Buy 2 get a 20% discount sale to first check and make sure the customer isn't eligible for the Buy 3 get a 33% discount sale. You can use an exclusion for this.

First make sure the order to apply is setup so the Buy 3 get a 33% discount sale is applied first. This is a very important. Using the example above the order of these sales would be:

1 [order to apply] - Buy 3 get 33% discount

2 [order to apply] - Buy 2 get 20% discount

The order to apply is set on the main sales Overview page. To get to this page go to admin/onsale.php and click the Overview tab.

Any sale selected as exclusion must have a higher lower to apply than the sale you are currently creating/editing.

The best way to imagine this is the On Sale module will go through all sales setup on your store one by one applying discounts, adding free products, etc. Using our example the On Sale module will first check if the customer has 3 qualifying products in their cart. If they do the sale will be applied.

On Sale will then move to the next sale, using the value set in order to apply. On Sale will check if the customer will receive the Buy 2 get 20% discount sale. However, if Buy 3 get 33% discount is set as an exclusion, and the customer is receiving the discount from this sale the On Sale module will skip (or exclude) the Buy 2 get 20% discount.

If the customer isn't receiving the Buy 3 get 33% discount the Buy 2 get 20% discount sale will be applied as normal.]]> <![CDATA[How do I add the On Sale discounts to the Related or Upselling pr...]]> assign("product_links",$product_links); Immediately BEFORE insert this code: // On Sale :: www.alteredcart.com // if...]]>

Find this code near line 49:


if (!empty($product_links))
$smarty->assign("product_links",$product_links);


Immediately BEFORE insert this code:


// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale']){
$products = $product_links;
require $xcart_dir."/modules/On_Sale/onsale_products.php";
$product_links = $products;
}
// End On Sale //




/recommends.php

Find this code near line 76:


if (!empty($recommends))
$smarty->assign("recommends", $recommends);


Immediately BEFORE insert this code:


// On Sale :: www.alteredcart.com //
if ($active_modules['On_Sale']){
$products = $recommends;
require $xcart_dir."/modules/On_Sale/onsale_products.php";
$recommends = $products;
}
// End On Sale //




skin1/modules/Upselling_Products/related_products.tpl

Find this code near line 21:


{$lng.lbl_our_price}: {include file="currency.tpl" value=$product_links[cat_num].price}


CHANGE it to:


{$lng.lbl_our_price}: {* On Sale :: alteredcart.com *}{if $active_modules.On_Sale}{include file="modules/On_Sale/onsale_currency.tpl" price=$product_links[cat_num].original_price}{/if}{* END On Sale :: alteredcart.com *} {include file="currency.tpl" value=$product_links[cat_num].taxed_price}
{* On Sale :: alteredcart.com *}{if $active_modules.On_Sale}
{include file="modules/On_Sale/onsale_img_display.tpl" onsale=$product_links[cat_num].onsale}{/if}{* END On Sale :: alteredcart.com *}




skin1/modules/Recommended_Products/recommends.tpl

Find this code near line 21:


{$lng.lbl_our_price}: {include file="currency.tpl" value=$recommends[num].taxed_price}


CHANGE it to:


{$lng.lbl_our_price}: {* On Sale :: alteredcart.com *}{if $active_modules.On_Sale}{include file="modules/On_Sale/onsale_currency.tpl" price=$recommends[num].original_price}{/if}{* END On Sale :: alteredcart.com *} {include file="currency.tpl" value=$recommends[num].taxed_price}
{* On Sale :: alteredcart.com *}{if $active_modules.On_Sale}
{include file="modules/On_Sale/onsale_img_display.tpl" onsale=$recommends[num].onsale}{/if}{* END On Sale :: alteredcart.com *}


]]> <![CDATA[How do I create a sale that auto-generates a coupon?]]>


2. You must then create a sale that will control the distribution of the coupons (saletype 7). There are 4 different criteria that can send a coupon to the customer after a sale.

• If a customer buy certain products
• Buys a certain amount of products
• Spends a certain amount
• The coupon is sent for every order

You will also need to select a master coupon to use. If you selected the example coupon sale for $10 off your order the customer would receive this coupon when their order was processed.

In the example below, if the customer spends $100 they will receive a coupon for $10 off (the previously created sale).



Notes:

• The coupon sale must be active and valid (not expired), if not the coupon sending sale will be marked invalid, and you will need to delete it and create a new sale with a valid coupon.

• The customer will not be sent the actual coupon name, but an alias using their last name and 4 digits, example: SMITH1345, DOE8219

• The order must first be processed for the coupon to send. The order cannot go from Queued to Completed, it must first be processed.

]]> <![CDATA[On Sale is calculating sales using the price before discount. I n...]]>
For sales based on subtotals such as a free shipping sale you will want to set the Order to apply to a number higher than any sales that are discounting products in the cart. This will then calculate the subtotal based sales on the discounted price.



]]> <![CDATA[ How do I discount an entire category of products.]]> 2. Set the Spend to $0.
3. Select the categories you want to discount.
4. Set the amount you want to discount each item in this category.

Since every customer at your store has spent at least $0, they will all be eligible for this sale.


--------------------------------------------------------------------------------

Related Articles

•What do each of the On Sale sales do?
•[Tutorial] How to setup sale exclusions.
•[Tutorial] How do I create a sale that auto-generates a coupon?
•What is IP restricted mode? How do I set this up with the One Page Checkout?

--------------------------------------------------------------------------------

Still Have Questions? If you are unable to find a solution in the knowledgebase please open a support ticket for a personal response from alteredCart support.

]]> <![CDATA[ The On Sale discounts do not work when I apply the discount to t...]]> Display Cart Discounts: On individual Products In the Order Subtotals Section When using the Order Subtotals Section di...]]> Display Cart Discounts:

On individual Products
In the Order Subtotals Section

When using the Order Subtotals Section
discount the products that are receiving the discount must have the option checked on the product modify pages to 'Apply global discounts'.



Without this option X-Cart will not allow the products to be discounted in the subtotals section. If you use the On individual Products discount option this setting can be ignored based on your settings on the On Sale -> Settings page.

]]> <![CDATA[How can I display the On Sale discounts with the Firetank Feature...]]>
include/func/func.product.php

Find this code near line 870:


return $product;
}


Before this add:


// On Sale :: www.alteredcart.com //
global $xcart_dir;
if ($active_modules['On_Sale']){
require $xcart_dir."/modules/On_Sale/onsale_func_select_product.php";
}
// End On Sale //



/product.php

Change this:


$product_info = func_select_product($productid, @$user_account['membershipid']);


to this:


$GLOBALS['loading_product_page_info'] = true;
$product_info = func_select_product($productid, @$user_account['membershipid']);
$GLOBALS['loading_product_page_info'] = false;



And add this to the featured products manager style template (this varies depending on the template chosen when installing the featured products module:


{* On Sale :: alteredcart.com *}{if $active_modules.On_Sale}{include file="modules/On_Sale/onsale_img_display.tpl" onsale=$products[product].onsale}{/if}{* END On Sale :: alteredcart.com *}



--------------------------------------------------------------------------------

Related Articles

•How do I add the On Sale discounts to the Related or Upselling products on my main product display page?
•The On Sale module discounts aren't applied when using Google Checkout or Gift certificates.
•How do I display the On Sale coupon data or sale information on the customers invoice?
•I'm receiving this error on the checkout page: "There was an error loading the shipping options, please try again. (You may need to refresh your browser.)"

--------------------------------------------------------------------------------

Still Have Questions? If you are unable to find a solution in the knowledgebase please open a support ticket for a personal response from alteredCart support.

]]> <![CDATA[ I'm receiving the following error: INVALID SQL: 1054 : Unknown c...]]>
Open the file INSTRUCTIONS if upgrading from version 1.17 or earlier.txt. in the On Sale zip distribution. At the bottom there are a number of SQL patches. Insert these one at a time into your patch/upgrade -> SQL Queries section in the X-Cart admin.

Some SQL queries may fail. This is normal.

Bill


--------------------------------------------------------------------------------

Related Articles

•I'm receiving this error on the checkout page: "There was an error loading the shipping options, please try again. (You may need to refresh your browser.)"
•I'm receiving a file is corrupt error when download a file using the Download Expander link.
•How do I find files that may have extra line breaks or whitespace after the ?> in a PHP file?
•When the checkout loads the first state is selected by default. How can I force a customer to select a state.

--------------------------------------------------------------------------------

Still Have Questions? If you are unable to find a solution in the knowledgebase please open a support ticket for a personal response from alteredCart support.

]]> <![CDATA[How can I display the On Sale category link only when there are a...]]> settings tab), they you can do the following: Open modules/On_Sale/onsale_home.php Add this code at the very bottom of the file before the ?>: $smarty-...]]> settings tab), they you can do the following:

Open modules/On_Sale/onsale_home.php

Add this code at the very bottom of the file before the ?>:

$smarty->assign('active_sales', is_array($sales) && count($sales) > 0 ? true : false);


You can then add && $active_sales the On Sale code in your skin1/customer/categories.tpl file:

For example:

Change:

{*** On Sale :: alteredcart.com ***}
{if $active_modules.On_Sale}


to:

{*** On Sale :: alteredcart.com ***}
{if $active_modules.On_Sale && $active_sales}]]>