Jump to content

desmoworks

Members
  • Content count

    48
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by desmoworks

  1. desmoworks

    ### POINTS AND REWARDS MODULE V1.00 ###

    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 ";
  2. desmoworks

    ### POINTS AND REWARDS MODULE V1.00 ###

    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); ?>
  3. desmoworks

    ### POINTS AND REWARDS MODULE V1.00 ###

    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); ?>
  4. desmoworks

    ### POINTS AND REWARDS MODULE V1.00 ###

    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.
  5. desmoworks

    [Contribution] - USPS Methods

    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?
  6. desmoworks

    Install Add Many Quickies 1.00

    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.
  7. desmoworks

    [CONTRIBUTION] Subcategory textboxes

    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.
  8. desmoworks

    Master Products - MS2

    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.
  9. desmoworks

    Sitemap SEO

    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?
  10. desmoworks

    Automatically send data feed to Froogle

    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
  11. desmoworks

    Sitemap SEO

    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!
  12. desmoworks

    Master Products - MS2

    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?
  13. desmoworks

    Master Products - MS2

    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!
  14. desmoworks

    Master Products - MS2

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

    Master Products - MS2

    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!
  16. desmoworks

    Master Products - MS2

    Not yet - I put another 4 hours into it the other day, but haven't made it through your whole list of suggestions... I'm totally at a loss! I hope to work on it tomorrow or Monday again.
  17. desmoworks

    Master Products - MS2

    Search through the thread - it is mentioned several times.
  18. desmoworks

    Master Products - MS2

    I'm sad to say I haven't figured this out yet! I have SPPC installed and working correctly. I have this exact same setup on another site and all is fine... I can't figure it out! I've gone over product_info a couple of times and couldn't find any issues. I will say this site is built off of a template (what a mistake! this was my first oscommerce site - won't do a template again as they are butcher jobs... at least this one is!).
  19. desmoworks

    Master Products - MS2

    Still haven't got this figured out. It is an issue with the application_top.php - but nothing seems to fix it. I can either get the selected slave and master to add or the master only - but I can't get just the selected slave to go. I've tried a ton of configurations posted in this thread + a couple more, but nothing seems to work! Any help would be appreciated!
  20. desmoworks

    Master Products - MS2

    Maybe I'm missing it, but when I hit add to cart with the quantity of each slave it correctly adds the slave but also adds the master! I don't want it to add the master!!!
  21. Did anyone ever figure this out? I'm trying to do this, but I haven't made it happen yet. I just want the subcategories to show as I have only 2 top level categories that aren't selected off of the standard menu.
  22. desmoworks

    Master Products - MS2

    I searched, but couldn't find this. On regular products (no slave products) I want customers (wholesalers) to be able to have the option to order more than what is in stock and have a message appear in the cart saying some of the quantity selected will be back ordered. As it is right now if there is 2 products in stock the drop down box will only show choices 0, 1, 2. I'd like it to show 0,1,2,3,4,5,6... or better yet be a text box where they can enter the desired number. I've been messing around with this for a few hours and haven't been able to get it to work. Thanks,
  23. desmoworks

    Seperate Pricing Per Customer v3.5

    I'd like to be able to show the discounted amount in the shopping cart down by the subtotal so the user knows how much they have saved. I tried to search this thread, but didn't find any info on it - the thread is rather extensive so it is possible I missed it. Has anyone done this?
  24. desmoworks

    NEW! Complete Order Editing Tool!

    Thank you for this! I'm glad I searched the forums before trying to figure it out myself!!!
  25. desmoworks

    Master Products - MS2

    Thanks George, I'll give this a try when I get home tonight!
×