1
Posted 07 April 2007 - 03:05 PM
Posted 07 April 2007 - 03:18 PM
bongo, on Apr 7 2007, 04:05 PM, said:
Believers
Posted 07 April 2007 - 05:25 PM
bongo, on Apr 7 2007, 08:18 AM, said:
if (is_array ($free_product = $cart->get1free ($products_id))) {
I'm afraid there is no easy way to set all of your products for Get 1 Free. This contribution uses a separate database table to hold the promotions, so you can't do a simple SQL to add them all. I'm afraid you'll have to do it the hard way.Posted 08 April 2007 - 12:53 PM
kymation, on Apr 7 2007, 06:25 PM, said:
if (is_array ($free_product = $cart->get1free ($products_id))) {
I'm afraid there is no easy way to set all of your products for Get 1 Free. This contribution uses a separate database table to hold the promotions, so you can't do a simple SQL to add them all. I'm afraid you'll have to do it the hard way.Posted 13 April 2007 - 03:30 PM
define('TEXT_GET_1_FREE_PROMOTION', '<b><i><font color = ffffff>Special Offer:</b> Buy %u Get %u Free!</i></font>');
if (tep_db_num_rows($get_1_free_query) > 0) {
$free_product = tep_db_fetch_array($get_1_free_query);
echo '<p>' . sprintf (TEXT_GET_1_FREE_PROMOTION, $free_product['products_qualify_quantity'], $product_info['products_name'],
$free_product['products_free_quantity']) . '</p>';
Believers
Posted 15 April 2007 - 01:53 AM
lishen, on Apr 13 2007, 08:30 AM, said:
echo '<p>' . sprintf (TEXT_GET_1_FREE_PROMOTION, $free_product['products_qualify_quantity'], $free_product['products_free_quantity']) . '</p>';
Posted 18 April 2007 - 03:37 PM
bongo, on Apr 8 2007, 07:53 AM, said:
Posted 24 April 2007 - 08:29 AM
$products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n";
// start Get 1 free
// If this product qualifies for free product(s) add the free products
// if (is_array ($free_product = $this->get1free ($products_id))) {
if (is_array ($free_product = $cart->get1free ($products_id))) {
// Update products_ordered (for bestsellers list)
// Comment out the next line if you don't want free products in the bestseller list
tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $free_product['quantity']) . " where products_id = '" . tep_get_prid($free_product['id']) . "'");
$sql_data_array = array('orders_id' => $insert_id,
'products_id' => $free_product['id'],
'products_model' => $free_product['model'],
[b]'products_name' => free_product['name'],[/b]
'products_price' => 0,
'final_price' => 0,
'products_tax' => '',
'products_quantity' => $free_product['quantity']
);
tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
$total_weight += ($free_product['quantity'] * $free_product['weight']);
}
// end Get 1 free
}
Posted 24 April 2007 - 08:42 AM
'products_name' => free_product['name'],to this
'products_name' => $free_product['name'],
Posted 24 April 2007 - 09:42 AM
(bangin head to the wall)Edited by djbastard, 24 April 2007 - 09:45 AM.
Posted 25 April 2007 - 04:19 PM
djbastard, on Apr 24 2007, 05:42 AM, said:
(bangin head to the wall)
Posted 25 April 2007 - 04:21 PM
djbastard, on Apr 24 2007, 05:42 AM, said:
(bangin head to the wall)
Posted 27 April 2007 - 12:22 PM
Posted 27 April 2007 - 12:25 PM
Posted 01 May 2007 - 12:15 AM
Edited by fonkjam, 01 May 2007 - 12:16 AM.
Posted 24 May 2007 - 06:15 PM
I really needed to put an expiration date in that field. It won't link to cart if left blank.
Still don't know why emails not working. going to revert back to previous Saved Backup & move from there.
