Jump to content

deep-silver

Members
  • Content count

    352
  • Joined

  • Last visited

Everything posted by deep-silver

  1. The idea comes from contributions... http://www.oscommerce.com/community/contributions,2082 http://www.oscommerce.com/community/contributions,2221 but they are not required and its NOT an update to them . Please note that even if this contribution carry the same title as contributions 2221, they are NOT the same and you WON'T be able to merged this module with contributions 2221. that's the reason i did not uploaded there, if you already installed contributions 2221 or cosidering it, you will have to make your choice amoung the two. (NOT like contributions 2221, this module does NOT require any of the functions required by Credit Class & Gift Voucher so you can use it with or without Gift Voucher contribution(tested) What does this module do ? ------------------------------------ I think that the title say it all. This is a Points and Reawrds system,(more or like a cash back or discount system) aimed to popup sales and get new usrs to signup. The system awards shopping points to customers for the amount they spend. Points consider as cash when redeemed, so points are in pending status untill approved by admin.(manually) Once approved, customers can then use those points to pay for order druing checkout. Admin features. ------------------------------------ 1.Enable/Disable the Points System. 2.Enable/Disable the Redemptions System.(maybe you would like to offer a gift and not money back). 3.Set the number of points awarded for evry $1.00 spent(or whatever based on your currency system). 4.Set the value of each point(based on your currency system). 5.Enable/Disable points awarded for shipping fees. 6.Enable/Disable Products Restriction. 7.Set the model name allowed When Products Restriction enabled.(only one group) 8.Enable/Disable Points Limitation. and set the number. of points needed before they can be redeemed. 9.Enable/Disable Welcome Points. and set the Points amount to be auto-credited for New signup customers. 10.Admin can view/add/delete customers points with/without queuing customers points table(optimised the database). Customes features. ------------------------------------ * New signup customers can be awarded with welcome points. * Customers can earn points(cash back) for an item purchased at the store. * Customers can choose the amount of points they would like to spend. * Customers can view their shoping points account status. The system designed to use minimum database space, customers points hold in customers table while all other points hold in customers_points_pending table. Once pending points approved by admin, pending points move to customers account so table used stay optimised. Redeemed points recorded in customers order history only. What this module does not do ? ------------------------------------ 1.The system designed for a small to medium shops. Since shopping points cosider as money when redeemed. awarded points default status is pending. Customers shopping points account will never be auto-credited(except points for new signup if enabled). if you own a large shop with lots of orders daily, it could be hard to keep track of points then this system is NOT for you. 2.When admin delete order while points status for that order is still pending. those points will also be deleted, however if admin already approved those points, admin must delete them manually(via admin panel). This module as been tested on a fresh install of osCommerce Version 2.2MS2 as well as on a fully modified versions (includes Credit Class & Gift Voucher contribution). Please use it at your own risk. This zip package includes... * A folder contain all files and images required by this module .(sorry,only english language files provided). * A folder contain all images, new and modified files required by this module (for a fresh install). * A folder contain screenshots admin and catalog(I think that all contributions uploaded here should have). * Step by step installation instrctions(corrently only in english). All support handled through the osCommerce forums. Please do not email directly. As a respect to the contributors and as part of GNU General Public License You are not allowed to remove any of the comments/links to oscommerce web site.
  2. deep-silver

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

    Could you please explain your issue again, I'm having problem understanding it :blush: http://www.trend-silver.com/925silver.php your site English version is missing and errors show up Warning: require(includes/languages/english/925silver.php) [function.require]: failed to open stream: No such file or directory in /XXX/XXX/public_html/XXX/925silver.php on line 20 シルバーアクセサリー専門店 ですか ;) ;) ;) ?????
  3. deep-silver

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

    Thank you! Really??? well check again! If its not working for you without register globals off, then your store is not the latest osCommerce2.2rca! checkout the demo site http://www.deepsilver.co.cc/catalog/ work fine with register globals off/on.
  4. deep-silver

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

    Your problem has got noting to do with this module. You are using other "Ultimate HTML Emails" mod, you will have to merge it with this module if you like to email the points out.
  5. deep-silver

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

    the link you refer to is way too old. and belong to an older version. try the demo site, if its not happening there, your coding is wrong! http://www.deepsilver.co.cc/catalog/
  6. deep-silver

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

    Please finish the install process, before posting. you are seeing this error because you are missing parts of the install!
  7. deep-silver

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

    use ssl on your domain, and try Credit Card Number Encryption mod. http://addons.oscommerce.com/info/4359 can't really tell but, there are lots of websites that rip there customers like selling 10 times more. no the only differnt is that paypal send you an email with the result therefore you have to process each order manually. Its a COD, they must pay the delivery guy first! :lol: and the funny thing is that they paid for it so the chance that you have to deal with refund is low compare with Credit Cards. if you like you could add a statement against any payment method you don't want to use point with. like if ((USE_POINTS_SYSTEM == 'true') && (USE_REDEEM_SYSTEM == 'true') && ($payment->code != 'paypal')) {
  8. deep-silver

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

    use the installer and run the uninstall, then run the install again.
  9. deep-silver

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

    I own a store in Japan, for us paypal is nothing but a third party that want to have a bit out of my cake! I process my credit card order offline via my store POS register. once I'm done i delete the card record. You really want to pay a third party,(i guess you making enough profit and able to share it :rolleyes: .) You don't have to use paypal IPN why don't you use paypal standard???. I can't really suggest because as wrote above, here in Japan things are different, 95% of my customers choose COD, the fees are low there is no risk of not getting what they buy, and for me i get the money to my bank account from the shipping company, BOOM done! income tax, insurance, shipping, refund, all covered. Just don't forget that you are a store owner and do your best to work for yourself not for others. all am saying is that if you really need paypal(sure they need you :lol: ) try to find a way that work out fine for you and your customers. not processing points for order paid by a third party is not a bad marketing. you could give them a paypal choice but without points.
  10. deep-silver

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

    If they hit the back button, or change their mind somehow. or don't even order, the order is still there. why? Paypal (IPN) build in a way that it record the order before sending the customers to paypal, else when the customer mess up with paypal, you got nothing. anyway in case of Paypal (IPN) once you choose paypal for your order there is no going back or changing your mind. is it a customer friendly idea??? is it worth paying paypal 4.3% out of your order and still give customers points discount???. if you a store owner you can process your customers card order without directing them to a third party site, and paying much less then 4.3%. You should reconsider the whole idea. We give points in order to push and keep our customers with us.
  11. deep-silver

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

    magento?????? osCommerce has been on the market since early 2000, that's 8 years ago. still used by lots of people world wide. if magento(or any other un solid) will be around at 2016, then we'll talk!
  12. deep-silver

    mysqli concern Bug.

    When using mysqli at admin/server_info page. it will trough up en error. The script try to get mysql server info using PHP mysql command insted of PHP mysqli command. at admin/includes/functions/general.php under function osc_get_system_information() line no.80 'db_version' => 'MySQL ' . (function_exists('mysql_get_server_info') ? mysql_get_server_info() : ''), should have an option for mysqli as it should say 'db_version' => 'MySQL ' . (function_exists('mysqli_get_server_info') ? mysqli_get_server_info() : ''), but even then with will return an error because the database connection is missing from the function. to test it try this at admin/includes/functions/general.php under function osc_get_system_information() add after global $osC_Database; $mysqli = @mysqli_connect("localhost","username","pass"); then replace line 80 with this 'db_version' => 'MySQL ' . (function_exists('mysqli_get_server_info') ? mysqli_get_server_info($mysqli) : ''), this return the correct mysql server info.
  13. deep-silver

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

    It look like Reward point system will be implemented into the osCommerce MS3. found it on osCommerce roadmap list http://www.oscommerce.com/community/roadmap,10
  14. deep-silver

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

    Have you fixed the problem? BTW i think you missed CATALOG STEP = 14.
  15. deep-silver

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

    it can be done but, its mean that they will have to select a payment method to cover the rest.
  16. deep-silver

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

    i need to download and install this module to learn it. therefore i need some some can you wait?(faster would be to give me access to your server, PM don't post)
  17. deep-silver

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

    Bug found. In a very rare case where full amount is covered by point and shipping tax and regular items tax are separated the order total is not rounded correctly and you will be returned to payment page asking you to choose payment method. to fix it open catalog/includes/languages/english/modules/order_total/ot_redemptions.php find this at line no.37 $order->info['total'] = $order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending); and replace with this. $order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4); in a normal cases you won't see any different.
  18. deep-silver

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

    i never used this payment, are you asking me to install it and get myself a sendbox test account so i can solf your problem?. the points information needs to pass to that or any third party payment. i don't know how that payment look like.
  19. deep-silver

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

    Please Note. in a rare case where you have enough points to cover your order and your store has only one payment option. you stuck. why? osCommerce choose that option as the default payment option. the only why around is. 1. the safe way is to enable any other option. 2. you could add an extra code to go around it. i will not post it now unless someone is really in need of it. ----------------------------------------------------------------------------------------------------------------------------- When using points to pay for your the whole order. you will notice that the payment method is empty. this add on will show points as payment method or other payment + points. in catalog/includes/languages/english/modules/order_total/ot_redemptions.php find line no.37 $order->info['total'] = $order->info['total'] - (tep_calc_shopping_pvalue($customer_shopping_points_spending)); and add after. $order->info['payment_method'] = ( $order->info['total'] > 0) ? $order->info['payment_method'] . '+' . str_replace(':', '', TEXT_POINTS) : str_replace(':', '', TEXT_POINTS); ----------------------------------------------------------------------------------------------------------------------------- Any none standard payment (third party that use api) like PayPal IPN. will need to be merge in order to use it with this module. I am looking into paypal IPN and will post soon.
  20. deep-silver

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

    please read the release note in refer to upgrade. there is a minor change to points decimal place, customers_shopping_points changed from (15,2) to (15.,4). points_pending changed from (15,2) to (15.,4). 99% useless unless you are using 4 decimal places ie= your points look like this "128.0321". made this chance in case osCommerce team will modified currencies class again, or in a very rare tax calculations(it will support a better rounded result). As far as i know your store use $ like this $128.33, so you don't need to worry about it.
  21. deep-silver

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

    Guys you are probably having this problem while testing this module, Lets say that while testing your site you go trough the checkout, your total is $95 your, points value 55$ you then must choose payment method, so you do. On the next screen it show you the confirmation and all work fine. now without making that order. you went to your admin an added enough points to cover your order, then continue testing, that's for sure give you an error, your chosen payment method is still registered, else why the hack you will want to choose payment to start with??. Anyway in the real world there are no testing, so this should not happen. ------------------------------------------------------------------------------------------------------------------------------------------ Let me clear up a few things before we continue. POINTS AND REWARDS MODULE is like the name says a points module sort of discount, not a replacement to a payment module. I don't want to find myself getting paid by points!. So why did i build this module? With the growing no. of online commerce site, unless you are selling something unique that is no where to be found or your prices are the lowest, you will find it hard to keep your online customers at your store. Now here is where points are the issue. while shopping at your store, your customers earn point with the ability to redeem them on their NEXT order.(so if they would like to use their points they have to come back and buy more). They do have to choice of surfing the net looking for a better price, but even if they do find (and they will!) they will only be able to use their points at your store. In a real life because points value are usually less then 10% of the product price and unless you allow your customers to earn points for order paid with points, the chance that they will earn enough points to cover their full order (includes shipping and tax) is very rare. if and by any chance they do, "Men you got your self an Hell of a customer". In my case if there was a big chance that my customers will have enough points to cover their order, i wouldn't be using this module or at least set the points value lower. I've been using this module since osCommerce early time and till today i never had such a case, so go figure it up.
  22. deep-silver

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

    Work fine at the demo site. If you have enough points to cover the order, you don't need to choose a payment method, just check the box to use the points and continue. if you check the radio button for any payment, that payment is on. there is a way around by adding if statement before the payment checker, like the way CV where the add if ($cover) $payment =""; but this is a big security hole. so if the module show you that you got enough points to cover your order, there is no need to check the radio button. You probably already notice that on core osCommerce site, once you check the radio button you can't get rid of it, even if you log of and log in again. its happen because its a radio button, i prefer check box that give you the ability to check it on/off. anyway i will look into it tomorrow .
  23. deep-silver

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

    Try the same thing at the demo site, if its not happen then your setup is wrong. check your coding in refer to catalog/checkout_process.php and catalog/checkout_confirmation.php
  24. deep-silver

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

    Dated: OCT.04.2008 V2.1rc2a -------------------------- 1.Overall reffresh of the code. *compatibility with the latest osCommerce-2.2rc2a. *compatibility with MySql V5.xx . *compatibility with PHP V5.xx and V6.00 . - Register_global off - Register_long_array off 2.Bug fixed at admin section. when sorting points on a page other then the first page, the script took you back to the first page. 3.Bug fixed at admin section. when adjusting points to a customer without points and auto expire is on, the date left empty. 4.Created a new installer. The old installer did not work on heavily secured servers. 5.Updated the code to reflect the tax issue. osCommerce-2.2rc2a team has made changes to the currencies class, read osCommerce-2.2rc2a log file for more details 6.Updated the code in refer to products_info.php . Points information no longer shown on a none qualified Product. 7.Bug fixed at create account page . Email did not sent out at all if the point system is turned off. 8.Fixed a possible security hole . where an hacker could go trough and add mutiple referral points for the same order. 9.Clean up the INSTALL.txt file . Some people had problem understanding it. 9.Added the new FAQ type Provided by Phocea. -Clean up the file and removed none English comments. -Moved the css elements to catalog/stylesheet.css -Fixed a minor bug in Phocea's version where the date not show at FAQ no.14 10.Maybe some more . There is a good chance that i made a few other changes along the way and probably forgot about it. ----------------------------------------------------------------------------------------------------------- The user wanting to upgrade this contribution will need first upgrade to the latest osCommerce-2.2rc2a then replace the module core files as well as go trough the install.txt to confirm that your code is the same. There is a demo site for a limited time. http://www.deepsilver.co.cc/catalog/index.php
  25. deep-silver

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

    How about sharing out the result so other can learn how to. could you please post here how did you fix your problem (even if its just a stupid mistake :lol: )
×