desmoworks

Any ideas how to make a report to show the total new points for the day and for the month? I was trying to use a modified version of this to account for the date, but the problem is the points store in the customers table don't have an "added" date attached to them like the points in the pending table do! $customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_points_expires, c.customers_shopping_points, pp.customer_id, (c.customers_shopping_points - sum(case when pp.points_status = 4 then pp.points_pending else 0 end)) as points_accumulated from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where c.customers_id = pp.customer_id group by c.customers_firstname, c.customers_lastname order by $sort ";

For the report I had to do it a little differently. In order to do a proper sort by accumulated points I had to get the math done in the query instead. Now I can sort by customers name, current points, accumulated points, etc... I also added their emails to the report and next will figure out how to export the report with selected parameters to excel. The query: $customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_points_expires, c.customers_shopping_points, pp.customer_id, (c.customers_shopping_points - sum(case when pp.points_status = 4 then pp.points_pending else 0 end)) as points_accumulated from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where c.customers_id = pp.customer_id group by c.customers_firstname, c.customers_lastname order by $sort "; The output: <?php echo number_format($customers['points_accumulated'],POINTS_DECIMAL_PLACES); ?>

Looks like I've got it. Basically just takes the customers current points and adds (well, subtracts the negative) the redeemed points to get the total accumulated points. Below is for what the customers see in their account. Just finishing up the report in the admin section so we can track these people easily. Next up will be to make loyalty groups at the different point levels and an automated system to alert those who qualify. The query: <?php $accumulated_points_query = tep_db_query("select c.customers_id, c.customers_shopping_points, pp.customer_id, sum(pp.points_pending) as points_redeemed from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where points_status = 4 and c.customers_id = pp.customer_id and customers_id = '" . (int)$customer_id . "'"); $accumulated = tep_db_fetch_array($accumulated_points_query);?> And to display the data: Lifetime Accumulated Loyalty Points: <?php echo number_format($accumulated['customers_shopping_points'] - $accumulated['points_redeemed'],POINTS_DECIMAL_PLACES); ?>

I'd like to have a total accumulated points calculation as we are offering special one time rewards for different levels of achievement. Such as 2000 points, 5000 points, 10000 points, etc... Kind of like an airline where they have various levels of achievement within their rewards systems.

I'd like to change the names a bit of the shipping methods to reflect the max size of a flat rate box. When I change them they disappear from the available methods list from checkout_shipping.php. I'm changing includes/modules/shipping/usps.php 'Priority Mail Int Flat Rate Small Box' => 'Priority Mail regimark International Small Flat Rate Box**', to 'Priority Mail Int Flat Rate Small Box' => 'Priority Mail regimark International Small Flat Rate (max dim. 8-5/8" x 5-3/8" x 1-5/8")', What am I missing here? Where do I need to make this change?

Did anyone get this to work with 2.2? I used it on a previous OSC instillation, but now have 2.2 and haven't been able to get it to work.

I'm trying to add some php code in the subcategory textbox to pull the latest posts off my wordpress blog that deal with that particular category. For some reason I am unable to add php directly to the box - only html. Does anyone have thoughts on this? I can't seem to figure out why, but I'm probably missing something silly.

Did anyone ever figure out how to display "from $X.XX" or "starting at $X.XX" on the master listing based on the lowest priced slave product? I've been playing around with currencies.php, but haven't had any luck yet. I tried to search, but with the new forum layout searching is ridiculously hard.

I've run into a strange problem. The site map works fine and all is good after setting up the configuration options, anchor text, titles, etc... but after some time it seems my configuration is erased from the database. The link in admin/configuration is gone and the settings are no longer being applied to the sitemap. I logged into phpmyadmin and sure enough the tables are not there. I re-inserted and a few days later they are gone again. This is happening on both of my sites. Has anyone ran into this?

I had an older version of this contributions on my sites which was working fine. I just upgraded to 2.2 and one site is fine (109 products) the other has about 35,000 and it keeps having a 500 error. Any thoughts on this? It wasn't an issue before. Thanks

Has anyone changed this to a 3 or 4 column setup? I'd like to have: ==================================================== categories >>>>> manufacturers >>>>> standard pages >>>>> whatever else ==================================================== Rather than just 2 rows next to each other and a lot of white to the right!

Here is where I'm at. In application_top if I run this code: //Master Products // customer adds multiple products from the master_listing page case 'add_slave' : reset($HTTP_POST_VARS); while ( list( $key, $val ) = each( $HTTP_POST_VARS ) ) { if (substr($key,0,11) == "Qty_ProdId_") { $prodId = substr($key,11); $qty = $val; if(isset($HTTP_POST_VARS["id_$prodId"]) && is_array($HTTP_POST_VARS["id_$prodId"])) { // We have attributes $cart->add_cart($prodId, $cart->get_quantity(tep_get_uprid($prodId,$HTTP_POST_VARS["id_$prodId"]))+$qty, $HTTP_POST_VARS["id_$prodId"]); } else { // No attributes $cart->add_cart($prodId, $cart->get_quantity($prodId)+$qty); } } } if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; //Master Products EOF The master is added when the slave is. Adding standard products works correctly. If I take out this portion: if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); } I can add slave products only with no master (so that is correct), but I can no longer add standard products from product_info.php - I can however add products with no attributes from the product listing page and new_products, etc... I don't really understand that bit of code, but the problem definitely seems to be related given the function with and without that bit. Any thoughts on that?

I should back up - the above is on the one that works - the install I'm having trouble with is on a piece of junk purchased template from template monster. I didn't realize how bad it was until I built my own!

It's custom... took a vanilla OSC and modified to remove all tables and get a custom design going.

Pretty much everything is identical... different servers - same host... all mods are the same on both sites. I'm sure it is one tiny thing that I haven't found, but it will be found!