Jump to content

allaboutwicker

Members
  • Content count

    455
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by allaboutwicker

  1. allaboutwicker

    [Contribution] Discount Coupon Codes

    I see from your contribution list that you use the STS template contrib. I have not tried that one yet and for the main reason that it seems to cause a lot of hard times getting other contribs to work from what I have read. I may be wrong, but that is my hunch as to what is giving you grief. Have you checked that thread for answers to some of your problems?
  2. allaboutwicker

    PayPal IPN v2.3.3 error!

    Hi, I am not 100% sure on this, but I plugged your error message in google search and found this: http://discussionboard.prostores.com/showp...amp;postcount=6 Worth taking a look.
  3. allaboutwicker

    Trying to find a module. I saw in the past....

    Hi, I just wanted to let you know that I went to your site to take a peek and noticed that when you click on the Specials link at the top you get the following error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9, 9' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 I am not sure how to fix it, but did find this thread with not exact, but similar error thru a google search: http://forums.oscommerce.com/index.php?sho...144095&st=0 Also, I noticed that you have not changed your title of your site from showing osCommerce.
  4. allaboutwicker

    Trying to find a module. I saw in the past....

    Hi, I found this one: http://addons.oscommerce.com/info/367 You might also check this one as it looks quite interesting and more recent: http://addons.oscommerce.com/info/1333 How I found them was I went to the Community --> Contributions and searched "weight shipping" to see what came up. I looked thru and picked out these, but there may be more there you may want to use instead. I have not used any myself to give an opinion as to how well they work. Hope this helps!
  5. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi TracyS, I don't know if this will help as it appears we have some different fixes or contribs installed, but I will post my code of the same area in that file here and you can compare to see if you think something might help: function is_recalc_shipping() { global $order, $language; //calculate the order total: // agrafuese - subtotal/shipping fix $order_total = $this->cart_info['total_products']['total']; /********** $order_total = $order->info['total'] - $order->info['shipping_cost']; **********/ // END agrafuese - subtotal/shipping fix if( DISPLAY_PRICE_WITH_TAX != 'true' ) $order_total -= $order->info['tax']; //check if there is free shipping if( strtolower(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING) == 'true' ) { include( DIR_WS_LANGUAGES.$language.'/modules/order_total/ot_shipping.php' ); //if free shipping is enabled, make sure the discount does not bring the order total below free shipping limit if( $order->info['shipping_method'] == FREE_SHIPPING_TITLE ) { //if free shipping is the selected shipping method if( $order_total < MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER ) { //if the discount lowers the total below the free shipping limit return true; } } } //check if table rate shipping has changed if( strtolower(MODULE_SHIPPING_TABLE_STATUS) == 'true' ) { include( DIR_WS_LANGUAGES.$language.'/modules/shipping/table.php' ); if( substr($order->info['shipping_method'], 0, strlen(MODULE_SHIPPING_TABLE_TEXT_TITLE)) == MODULE_SHIPPING_TABLE_TEXT_TITLE && MODULE_SHIPPING_TABLE_MODE == 'price' ) { $table_cost = split( "[:,]", MODULE_SHIPPING_TABLE_COST ); for( $i = 0; $i < count( $table_cost ); $i += 2 ) { if( $order_total <= $table_cost[$i] ) { $shipping = $table_cost[$i+1]; break; } } // agrafuese - subtotal/shipping fix /********** if( $order->info['shipping_cost'] != $shipping ) { //if the discount lowers the total below the table rate return true; } **********/ // END agrafuese - subtotal/shipping fix } } return false; }
  6. allaboutwicker

    [Contribution] Discount Coupon Codes

    I believe the 3.31 version by dimi on 27 Sep 2007 is the latest full package to download first, then do any upgrades after that if needed.
  7. allaboutwicker

    editing attributes under product add/edit page

    Hi, I would highly recommend the following contrib for attributes: http://addons.oscommerce.com/info/4063 It is awesome!!!
  8. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I am not sure if you have been to the contrib page for discount codes, but there was an update on 1/7/08 that might be what you are needing: http://addons.oscommerce.com/info/4269
  9. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, did you see the post back on 1/15/08 where they had the same error then found the fix as stated here: Fixed ! I found that when creating the tables in the database, the prefix "coupons_" was left off of a few columns Don't know if yours is the same issue, but does sound like a database problem to me.
  10. allaboutwicker

    [Contribution] Discount Coupon Codes

    It appears you may be using the STS contrib. I haven't installed that one. From what I have seen this could be why it doesn't just work right out. If you are using the STS contrib, maybe there is something under that forum discussion that will help you.
  11. Hi, Did you figure this out yet? I installed google checkout, but it has been a while and I am not sure if it is the same exact one, but I will try to help. If you have not made any other file changes before this contribution, then you can just overwrite the original oscommerce files with the files in the contrib. As far as the googlecheckout files, I believe you should just copy that whole folder to your catalog and it will install all the files under it. There may be a few google files outside of this folder which need to be uploaded as well into their proper places. Have you opened the installation file? It should give specific instructions as to what to do, especially needed if you have changed any files involved before. The following are not necessary to upload as they are for installation references only: OSC_DIR: CHANGELOG INSTALLATION.txt README.txt states.jpg UPGRADE Don't forget to make back up copies of any files you modify if don't have them already!!! Hope this helps. post back if you need more help.
  12. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I believe you should be able to allow this if you change the setting in your admin panel under Modules, then Order Total, then Discount Coupons. You should have the option that asks: Exclude product specials? to which you pick either true or false, in your case you want it to be false. Try that and if you need more help post back.
  13. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, I did a file compare of your code listed and mine and they are very close. However, I just went to your site and logged in as a customer to check it out from there and when I check the code on that page, the discount coding isn't there. I think you need to make sure that you upload the modified checkout_payment.php file that has the coding in it. Maybe you uploaded it under the wrong folder. I have done that before. It is still pulling from the old file without the discount coding. Check that out and let me know what happens.
  14. allaboutwicker

    [Contribution] Discount Coupon Codes

    I wasn't exactly sure what you need here, but if you mean during checkout on the store side, did you do the contrib coding in the files checkout_payment.php, checkout_process.php and checkout_confirmation.php?
  15. allaboutwicker

    [Contribution] Discount Coupon Codes

    Also, have you made sure all the proper changes have been made in your checkout_confirmation.php file?
  16. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, my "screen shot 2" in the post right before yours shows how it looks for me on the store side after a coupon code was used. Check in your admin under modules, then order total to make sure you don't have any duplicate sort order numbers as I think they all need to be unique, not necessarily in the exact order as mine. Here is a screen pic of how mine looks in admin: screen shot 5
  17. allaboutwicker

    [Contribution] Discount Coupon Codes

    OK, sure. Here are a few links to my site so you can see this contrib. I did not know if you wanted store side or admin side so I am adding both: screen shot 1 screen shot 2 screen shot 3 screen shot 4 Hope this helps!
  18. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hey Kevin, Your welcome. Not really much of en eye as I think I had been told this a while back when I was trying to install it or it is in the updates somewhere. Anyway, glad to give back some help when it is something not too complicated for my little brain, as I have received help from others. Post back if there is anything else you need help on and I will help if I can.
  19. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi Kevin, I checked my catalog.php file and I have different discount coding in then what you have as follows: //kgt - discount coupons '<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a><br>'. '<a href="' . tep_href_link(FILENAME_DISCOUNT_COUPONS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_DISCOUNT_COUPONS . '</a>' ); //end kgt - discount coupons I may be wrong, but I believe you put the coding in catalog.php which is supposed to go in reports.php Also, even so, I think you need another dot ( . ) after your '</a><br>' like this: '</a><br>'.
  20. allaboutwicker

    [Contribution] Discount Coupon Codes

    I checked my paypal_ipn.php and my discount coding is much further down then where you show yours. Mine looks like this around it: $sql_data_array = array('orders_id' => $order_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => (SEND_EMAILS == 'true') ? '1' : '0', 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && $order->info['coupon'] != '' ) { $sql_data_array = array( 'coupons_id' => $order->info['coupon'], 'orders_id' => $order_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons // initialized for the email confirmation $products_ordered = ''; $subtotal = 0; $total_tax = 0; I haven't had an order with a discount coupon go thru paypal for a while, I now also have Google checkout and credit cards, but I am sure I did a little while back and it worked.
  21. allaboutwicker

    [Contribution] Discount Coupon Codes

    Hi, Did you add this coding to your includes/modules/paypal_ipn.php file? //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && $order->info['coupon'] != '' ) { $sql_data_array = array( 'coupons_id' => $order->info['coupon'], 'orders_id' => $order_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons
  22. allaboutwicker

    Paypal website payment standard module... any contributions?

    Hi, Did you check out the previous post regarding a contribution to help with this: http://www.oscommerce.com/community/contri...1/search,paypal In there it states: How to solve comeback to shop problems with Paypal Payments It's a simple manipulation to do and it will take about 5 minutes. First of all, take time to read entirely this message to understand what you have to do. It seems to be long but it's very sample. Working on OS Commerce imposes a comeback to shop on "catalog/process.php" in order to send mail so as to add in database the order. And it's here that the problem appears: This comeback is not automatic and even if it will be modified at the Paypal account level (preferences/reception payments preferences on website: automatic returns on), the feedback doesn't work if your client do not use a Paypal account to pay. If he wants to pay with a credit card, Paypal show a link to comeback and he ha to do this step himself.Unfortunately, many people shutdown after there payments without doing this. As a result, you have neither mail nor order in the administration part. You just have a mail from Paypal to inform you about the payment of the order. But you haven't got the details of the order. So what the client wants? What have you sold? How to manage this in your administration part? Many solutions still exist but they add charts in the base and so on... At the end, we have orders that can not be managed through the classical administration. I would check that out and see if it helps you!
  23. allaboutwicker

    Shipping modules?

    Hi again, I sent you a PM earlier stating I wasn't sure what you meant. I think I understand now. I use the browser called Firefox so I think where you see an internet explorer symbol I am seeing a firefox file. It is labeled install and is 492 bytes. All you do with this one is double click it and it will open in your browser to explain what to do with all the other files. You will need an ftp program on your computer to properly upload files when you do these modifications and if you want to change anything in a file that you already have. I have read that you should not be doing it through your regular oscommerce admin screen. I downloaded the free ftp program smart ftp and it works well for me, but there are many out there if you don't have one already. ***Before you do any changes to your site I highly recommend using the ftp program to make a backup of all your oscommerce files somewhere special on your computer*** Carefully read the install instructions. I have not personally done this contrib as I am in the US, but I did download it onto my computer to take a peek at it to try to help you. If you have not done any other changes to your files, you can just upload the files they have in the contribution and overwrite the old ones. Any future contributions you will need to be very careful to modify specific files and then upload them. You will also need to run the SQL file called "auspost" in this contribution. What you do is look for a program called phpMyAdmin in your cpanel (control panel) for your website, not the oscommerce admin, but your webhosts cpanel. On one of mine I have to first go into MySQLAdministration then the phpMyAdmin is in there. Search in your cpanel and you might find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it. ***Make sure you have made a backup of your database! Just in case. Then what you do is go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file into the box, but I would prefer to browse for it. Hope this helps! Let me know if you need more. Leslie
  24. allaboutwicker

    Shipping modules?

    Hello, I went to the tool bar on this site and then contributions. I typed in Australia post and searched. It gave me several responses. Here is one of them which is probably what you want, I believe it calculates the shipping based on the items weight and shipping address: http://addons.oscommerce.com/info/648 You will need to use the second one down, Australia Post 3.01, as that is the latest complete package. The very first is only an upgrade to it if you need or want it. You would have to download and unzip the file, find the install log and see if you understand how to install the contribution. If you need more help on how to do this in detail you can post back and I will try to explain it to you.
  25. allaboutwicker

    Product Attributes - Option Type Feature

    Hi, The only way I know of is to use a program one of which is called phpMyAdmin. You probably have this somewhere in your cpanel (control panel) for your website. On one of mine I have to first go into MySQL Administration then the phpMyAdmin is in there. Search in your cpanel and you should find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it. Assuming its there, what you do is make sure you have made a backup of your database! Just in case. Then go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file contents into the box, but I would prefer to browse for it. Hope this helps! Post back with any further questions. Leslie
×