Store Credit Module

[yellow1912]

Further questions regarding module manager should be posted at:
http://www.zen-cart.com/forum/showth...module+manager

Questions regarding the Store credit and reward point module should be posted at:
http://www.zen-cart.com/forum/showth...t=reward+point

This thread is for the original Store Credit module only. I dont want to go off topic here, so I wont answer any future question regarding the 2 modules above in this thread.

[stampsville]

Weird, it seems like the first patch was not run correctly.

Try to run this from tools->sql patch first:

CREATE TABLE IF NOT EXISTS sc_customer (
  `customer_id` bigint(20) NOT NULL default '0',
  `amount` float NOT NULL default '0'
);

Yea, I caught that and adjtusted my table alraedy, but I belive your code would have fixed it. I got a error saying it already exists...so can't say for sure.

I'm trying to create a test order but haven't gotten anything. Do I need to run CRON for this, even if time is set at 0?

Thanks
GJW

[yellow1912]

Is it a test site? I want to check the admin side if possible. Please do not post further question in this thread though. See my post above.

[ravenbird]

Hi everyone,

I've also installed the module manager and all of it's classes. My question, since there aren't any directions anywhere that I could find, is: How to use the module manager???

Do I just drop files that haven't been merged or copied into the catalog folder and let the manager find them? Do I put them into a special folder? What? How?

New to ZenCart. All help is appreciated.

Raven

[numinix]

just upload using the same structure then in ADMIN->TOOLS->MODULE MANAGER you can install the sql patches.

[walkerhxg]

I still get the error with store_credit3.01b +module_manager_alpha4 .

I clicked update and got this: 1146 Table 'ec968_comsql3.sc_customers' doesn't exist
in:
[show fields from sc_customers]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
How to uninstall store_credit3.01b +module_manager_alpha4 ?

[medgeley]

Hi

The store credit module seems to work OK, and I can get it to display the potential reqard points that can be earnt. The problem is it won't display the potential reqard points on items which have free shipping. Can anyone help?

[numinix]

Hi

The store credit module seems to work OK, and I can get it to display the potential reqard points that can be earnt. The problem is it won't display the potential reqard points on items which have free shipping. Can anyone help?

You will need to add the optional code to each of your product type templates that you use.

[data_digger]

If there are many customers (>10k) admin/store_credit.php starts to run sloooowly and it eats up a lot of resources. To address that, change admin/store_credit.php:

function store_pending_rewards() {
    global $db;
    
    $customers = $db->Execute("SELECT customers_id FROM " . TABLE_CUSTOMERS . " ORDER BY customers_id ASC");
    while (!$customers->EOF) {
      $customers_id = $customers->fields['customers_id'];
      $pending_rewards = $this->get_pending_rewards($customers_id);
      if($pending_rewards == 0.0) { $customers->MoveNext(); continue; }
      $db->Execute("UPDATE " . TABLE_STORE_CREDIT . "
                    SET pending = " . $pending_rewards . "
                    WHERE customers_id = " . $customers_id . "
                    LIMIT 1");
      $customers->MoveNext();
    }
  } 

to

function store_pending_rewards() {
    global $db;
    
    $customers = $db->Execute("SELECT DISTINCT customers_id FROM " . TABLE_SC_REWARD_POINT_LOGS . " ORDER BY customers_id ASC");
    while (!$customers->EOF) {
      $customers_id = $customers->fields['customers_id'];
      $pending_rewards = $this->get_pending_rewards($customers_id);
      if($pending_rewards == 0.0) { $customers->MoveNext(); continue; }
      $db->Execute("UPDATE " . TABLE_STORE_CREDIT . "
                    SET pending = " . $pending_rewards . "
                    WHERE customers_id = " . $customers_id . "
                    LIMIT 1");
      $customers->MoveNext();
    }
  } 

[carsal]

Hi

I have been using this module for a while now and it works perfectly. I am however wondering if anyone has ever thought to create a report that can be run to check variances on the admin side.

Basically what I would liek to be able to do is check which accounts have had movement on their store credits and by how much each month? I have various staff that work on the admin side and they need to add on store credits for certain customers once a month. As there is no way for me to specify how many credits to add on I need a double check to make sure that the correct credits have been added for the month.

Is there anyone that can assist me with this?

KR