Store credit and reward point module

[greenhat]

This is a great plugin, but there was a one small issue for me - it would give reward points to all orders with status id >= than the one specified. Unfortunately, this is not practical in my shopping cart as I have scattered statuses for which I need to give reward points. I believe this is the case for most carts with default setup (Cancel status = 5 , which is less than Shipped status = 3 , etc. )
I figured out a fix, so if anyone else is interested, you can do the same:

1. Replace function "_check_order_status" in store_credit.php file with:

    function _check_order_status($orders_id) {
        global $db;
        $order_query = "SELECT orders_status FROM " . TABLE_ORDERS . "
                                        WHERE orders_id = " . $orders_id . "
                                        LIMIT 1";
        $order_status = $db->Execute($order_query);

        $order_status_rewarded = explode(",", MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS);

        if (in_array($order_status->fields['orders_status'], $order_status_rewarded)) {
            return true;
        } else {
            return false;
        } 
        
    }

2. Run this SQL on your DB:

UPDATE zen_configuration
SET use_function=NULL, set_function=NULL
WHERE configuration_title = "Required Order Status"

3. Go to Admin -> Modules -> Order Total -> Store Credit -> Edit -> in Required Order Status field, write the order ids delimited by comas for which you'd like to give rewards (for example: "3,102")


good luck

[greenhat]

Quick correction for the above. This is a more proper way to do it.

Instead of 2nd step, do the following:


- in /includes/modules/order_total/ot_sc.php file, replace

//$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Required Order Status', 'MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS', '2', 'What order status is required to receive reward points?', '6', '4', 'zen_cfg_pull_down_order_statuses(', 'zen_get_order_status_name', now())");

by

        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Required Order Status', 'MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS', '2', 'What order status is required to receive reward points?', '6', '4', now())");

- under Admin -> Modules -> Order Total -> Store Credit -> click "Remove" followed by "Install"

[notageek]

First, I apologize that I am really out of my depth with this module. I believe I installed it per the instructions.

In Admin->Order Total, I had a conflict between my gift voucher GV sort order of 840 which was also the default sort order for the store credit module, so I put the store credit sort order at 850, thinking if the gift voucher is used the store credit would not be used--a wild guess. I selected the default where I could, and true to show the store credit box.

I installed the .sql patch by cut and paste, as per instructions, instead of uploading; and when I installed the 3.x .sql patch, per the instructions, the program feedback said it was already installed.

I went to my store to see the changes, and now the print is large in my store and the following message appears on top of my "Authorize Net is in test mode" message:

'); define('TEXT_SC_CRON_ORDERS_UPDATED', '%s order(s) updated.'); define('TEXT_SC_CRON_PRODUCTS_UPDATED', '%s product(s) updated.'); define('TEXT_SC_PRODUCTS_INFO', 'Earn up to %s in rewards points when you purchase this product!'); /* End Store Credit Order Total Module */ ?>

Also, I placed the chron file in my www directory where the next step up are the Admin and Includes directories, but didn't actually understand where it was supposed to go, so that was a guess. Then I read online about cron jobs and it refers to Unix and Linux which I do not have; I am working on a test WAMP server in a Windows environment. It may be that my online web host uses Unix or Linux, though. So I really do not know where to start in using cron, or if it will work on my WAMP server. Cron is totally new to me, and I do not know what it means to "run" it.

I really do not know whether I should be asking for instructions here as maybe I am too ill-prepared to really figure out a mod with instructions that seem to be directed to more knowledgeable persons. Shall I uninstall or is there hope for me getting this running? I am seeing in the instructions and the forum that people are figuring things out but not stating what they figured out, and sometimes only responding to parts of questions.

Is there anything basic to read on how to proceed and how to really work with this module? Does anyone know what I might have done to alter my site as stated above? (I do have a backup.)

Thanks.

[notageek]

Still working on getting rid of the stray messages that came up when I installed this module:

'); define('TEXT_SC_CRON_ORDERS_UPDATED', '%s order(s) updated.'); define('TEXT_SC_CRON_PRODUCTS_UPDATED', '%s product(s) updated.'); define('TEXT_SC_PRODUCTS_INFO', 'Earn up to %s in rewards points when you purchase this product!'); /* End Store Credit Order Total Module */ ?>

in the admin screen:
BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>

I have tried to wipe the above error messages out by performing a backup of the root database and the store, and then 2 entire WAMP backup restorals from different backup dates, and although my other changes disappeared with the restoral of earlier versions of my website and local test WAMP server, the above two error messages have persisted, and the Store Credit Module also persisted.

I have cleared my browser's cache and the Zen Cart cache, and have used the developer's tool to compare my files with the original download files with Winmerge, and the compared files are identical.

Where would I look for the Admin headers to remove the BOX_CUSTOMERS_CREDIT....that appears there?

Where would I look for text appearing on my home page above the Authorize Net is in testing mode message?

Are these messages more likely to be in php files or in the MySQL database?

Thanks.

[greenhat]

This probably has nothing to do with installing this module, but to get authorize.net out of Test mode:
ADMIN -> Modules -> Payment -> Authorize.net -> Edit -> Transaction Mode -> Production.

Your other errors seem very odd.. i suggest to completely uninstall the module and reinstall it ..

you can also check this file:
/store/includes/languages/english/extra_definitions/store_credit_definitions.php to make sure everything looks right there. it looks as if you went to modify it and accidentally pressed enter before " '); " on this line:
define('TEXT_SC_CRON_COMPLETED', 'Completed in %s seconds.<br>');

good luck

Still working on getting rid of the stray messages that came up when I installed this module:

'); define('TEXT_SC_CRON_ORDERS_UPDATED', '%s order(s) updated.'); define('TEXT_SC_CRON_PRODUCTS_UPDATED', '%s product(s) updated.'); define('TEXT_SC_PRODUCTS_INFO', 'Earn up to %s in rewards points when you purchase this product!'); /* End Store Credit Order Total Module */ ?>

in the admin screen:
BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>

I have tried to wipe the above error messages out by performing a backup of the root database and the store, and then 2 entire WAMP backup restorals from different backup dates, and although my other changes disappeared with the restoral of earlier versions of my website and local test WAMP server, the above two error messages have persisted, and the Store Credit Module also persisted.

I have cleared my browser's cache and the Zen Cart cache, and have used the developer's tool to compare my files with the original download files with Winmerge, and the compared files are identical.

Where would I look for the Admin headers to remove the BOX_CUSTOMERS_CREDIT....that appears there?

Where would I look for text appearing on my home page above the Authorize Net is in testing mode message?

Are these messages more likely to be in php files or in the MySQL database?

Thanks.

[greenhat]

posted in a wrong thread

[notageek]

Greenhat,

I really appreciate your comments. It was getting very lonely talking to myself.

You will be glad to hear that I just resolved the stray message problem.

On Numinix's site on page 7 relating to the Store Credit Module, spikescot2005 had posted the problem and I had felt slomojojo's response was a sort of "jerryrig" solution, and completely missed his clarification #107.

Slomojojo's solution reveals that there is more than one type of tag in PHP: apparently Store Credit Module uses a short opening php tag: <?.

Slomojojo stated he went into each of the files (there are many) and searched for <? and replaced it with <?php.

When I read his clarification today that (thank you so much, slomojojo), the same thing is accomplished on a test WAMP server by simply opening PHP settings and enabling "short open tag" if it's off, it finally made sense to me as being a PHP tag problem.

That did indeed fix the error everywhere AT ONCE.

I am so worn out from spinning my wheels for days (despite all the extraneous learning I accomplished) the fix seems anticlimatic, but I am so greatly encouraged by your having taken the time to try to shed some light on my problem.

[greenhat]

no problem.. i can see that it wasnt really helpful..
great that you figured it out and posted the solution here.. i think i ran into this problem a long time ago also . a lot of people probably do .

[pokerdis]

Hello,

I installed without issues, activated sidebox. Issued my test account a credit, credit showed fine in sidebox. My issue is that when trying to use the credit and the total in the cart (with shipping and tax) is a lower dollar amount it still asks and requires that I choose a a payment method even though the store credit is greater than the total purchase.

I do have the box checked that says "do you want to apply your store credit"

Any ideas?

Thanks,
Tom

[2004g35]

is 3.05 the latest version? I saw reference somewhere to a 3.1 version. Thanks