Page 14 of 14 FirstFirst ... 4121314
Results 131 to 140 of 140
  1. #131
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Store Credit Module

    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.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  2. #132
    Join Date
    Jul 2004
    Posts
    142
    Plugin Contributions
    0

    Default Re: Store Credit Module

    Quote Originally Posted by yellow1912 View Post
    Weird, it seems like the first patch was not run correctly.

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

    Code:
    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

  3. #133
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Store Credit Module

    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.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  4. #134
    Join Date
    Mar 2008
    Posts
    3
    Plugin Contributions
    0

    Default Re: Store Credit Module

    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

  5. #135
    Join Date
    Apr 2007
    Location
    Vancouver, Canada
    Posts
    1,530
    Plugin Contributions
    81

    Default Re: Store Credit Module

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

  6. #136
    Join Date
    Mar 2008
    Posts
    9
    Plugin Contributions
    0

    Default Re: Store Credit Module

    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 ?

  7. #137
    Join Date
    Sep 2008
    Posts
    3
    Plugin Contributions
    0

    Default Re: Store Credit Module

    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?

  8. #138
    Join Date
    Apr 2007
    Location
    Vancouver, Canada
    Posts
    1,530
    Plugin Contributions
    81

    Default Re: Store Credit Module

    Quote Originally Posted by medgeley View Post
    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.

  9. #139

    Default Re: Store Credit Module

    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:

    PHP Code:
    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
    PHP Code:
    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();
        }
      } 

  10. #140
    Join Date
    Dec 2009
    Posts
    18
    Plugin Contributions
    0

    help question Re: Store Credit Module

    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
    [FONT="Arial"]Sam[/FONT]

 

 
Page 14 of 14 FirstFirst ... 4121314

Similar Threads

  1. Store credit and reward point module
    By yellow1912 in forum Addon Payment Modules
    Replies: 170
    Last Post: 19 Mar 2021, 03:17 PM
  2. Replies: 0
    Last Post: 11 Mar 2010, 04:39 AM
  3. Replies: 2
    Last Post: 24 Jun 2008, 11:07 PM
  4. Replies: 1
    Last Post: 16 Mar 2008, 12:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR