Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

nerd3d

Archived
  • Posts

    24
  • Joined

  • Last visited

Profile Information

  • Real Name
    Charles Taylor

nerd3d's Achievements

  1. Using 1.6a1 of the Order Editor almost all my products are ESD. It doesn't seem this contribution does any thing with the orders_products_downloads table when an item is added (or zeroed out) Has anybody looked at this or perhaps there is already a contribution that does this. OsC 2.2 MS2 integrated in NukeShop 0.7 WebMakers' Download Controller 5.3 and Free Ship - Pay and Free Download. Coupons and Gift Vouchers 5.11
  2. @ Irin: This is probably a sort order problem. If you look back a few pages in this thread I posted the sort order that worked for me. The examples in the documentation appear to be wrong. @ alex wong: Check the variables in admin/includes/configure.php Pay close attention the the http_catalog and dir_ws_catalog variables. There is probably an extra slash somewhere.
  3. @ TCwho Well for me it's not a matter of it being a great contribution. It is a necessary confrib. There are some bugs. First the instructions for setting up the sort order are wrong (Atleast on my server they were) look back a couple of pages for the right sort orders. I had a problem with it working with percent off coupons. They would show on the cart, but never deduct. Somewhere someone changed a couple of lines to fix one bug and made another. If percent off gives you trouble post back here I'll dig out that fix for you. The installation documantation is very good if you follow it to the letter you will get the contrib installed and working, there WILL be bugs to swat. Don't even think of installing this in a live shop. The configuration documentation could probably use another look. This thing is a bear to get dialed in.
  4. A bug and the fix. How's that for a change? 6 files included in the GVCC 5.11 contain references to tables names that are hard coded. For the majority of users this will be OK, but it broke the coupon functionality for me. My tables all have a prefix to allow multiple shops in one database. Anyone else with changed table names may run into the same problem. There are 6 files that have these hard coded SQL table references. If you have changed (prefixed) table names you'll need to edit the files to fix the queries. I could only find 6 files with hard coded tables, there may be more! Backup your files first Backup your files first Backup your files first You will edit 6 files, back them up. popup_coupon_help.php modules/includes/order_total/ot_coupon.php admin/listproducts.php admin/listcatagories.php admin/validcatagories.php admin/validproducts.php Did I say, "Backup your files first"? I didn't before I started fiddling with these queries. I said bad things for about an hour over a mis-placed space. In popup_coupon_help.php find $result = tep_db_query("SELECT * FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id and categories_description.language_id = '" . $languages_id . "' and categories.categories_id='" . $cat_ids[$i] . "'"); replace it with $result = tep_db_query("SELECT * FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' and c.categories_id='" . $cat_ids[$i] . "'"); //N3D Fixed this query to use soft coded table names Then find $result = tep_db_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "'and products.products_id = '" . $pr_ids[$i] . "'"); And replace it with $result = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS . " p , " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'and p.products_id = '" . $pr_ids[$i] . "'");//N3D Fixed this query to use soft coded table names OK now open modules/includes/order_total/ot_coupon.php find $cat_query = tep_db_query("select products_id from products_to_categories where products_id = '" . $products_id . "' and categories_id = '" . $cat_ids[$i] . "'"); and replace it with $cat_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "' and categories_id = '" . $cat_ids[$i] . "'"); //N3D Fixed this query to use table names from database_tables.php Then find $cat_query = tep_db_query("select products_id from products_to_categories where products_id = '" . $products_id . "' and categories_id = '" . $cat_ids[$i] . "'"); and replace it with $cat_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "' and categories_id = '" . $cat_ids[$i] . "'"); //N3D Fixed this query to use tables named in database_tables.php Now open admin/listproducts.php and find $result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "'and products.products_id = '" . $pr_ids[$i] . "'"); replace it with $result = mysql_query("SELECT * FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'and p.products_id = '" . $pr_ids[$i] . "'"); // N3D fixed query to use soft coded table names Open admin/listcatagories.php and find $result = mysql_query("SELECT * FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id and categories_description.language_id = '" . $languages_id . "' and categories.categories_id='" . $cat_ids[$i] . "'"); Replace it with $result = mysql_query("SELECT * FROM " . TABLE_CATAGORIES . " c, " . TABLE_CATAGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' and c.categories_id='" . $cat_ids[$i] . "'"); //N3D fixed query to use soft coded table names Open admin/validcatagories.php and find $result = mysql_query("SELECT * FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id and categories_description.language_id = '" . $languages_id . "' ORDER BY categories.categories_id"); Replace it with $result = mysql_query("SELECT * FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' ORDER BY c.categories_id"); //N3D fixed query to use soft coded table names OK, last one open admin/validproducts.php and find $result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "' ORDER BY products_description.products_name"); Replace it with $result = mysql_query("SELECT * FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' ORDER BY pd.products_name"); //N3D Fixed query to use soft coded table names. I hope this helps somebody.
  5. I'm using Linda McGrath's Free shipping and Payment contribution. That may have something to do with mine not having troubles in the with the negative balance in the check out. I also have all the shipping calculations set to false on Coupons and GV. All my products are downloads, so I don't have any shipping charges. Wish I could help more. P.S. If you use this get the newest one from her website.
  6. Quin, check the sort order on your payment modules. It sounds like the GV is not being applied. IF you can't see the check box by the redeem button the sort order is messed up. If this is even a tiny bit off the whole thing freaks out. Note: The GV number must be higher than the coupon number, at least that's the way it works on my server.
  7. I saw someplace in this thread that there was a glitch in the javascript that tests if the credits cover the order. That may be what is messing you up. I don't charge shipping so I can't test it. But if the credit covers paypal it skips right to the "thanks" screen, as it should.
  8. Thank you Kagg! It seems following the directions is not the way to get this thing working. I believe Strider is the one who took the time to create the (quite comprehensive instructions) and I thank him but perhaps there should be a stick on the front of this sopic that the contribution won't work unless you use a very specific sort order. The sort order examples provided do not work. Here's what worked for me... Discount Coupons 740 Gift Vouchers 760 Low Order Fee (not used) Shipping 2 Sub-Total 1 Tax (not used) Total 900
  9. In your payment page do you get the check box to redeem the gift vouchers. I believe it should be right above the "Redeem" button. That little goodie will not show up on my site. I've spent hours trying to unwind the 1000 mile of spagetti that the credit_selection function is made out of. The thing calls it's self and I can't figure out why. When it does it blows out it's own variables. I wish I knew what author was trying to do.
  10. I should add that, and since I can't edit my post for some mysterious reason, I'll respond to my self. Coupons work fine. It's only the gift vouchers that don't work. I think there's supposed to be a check box on the payment page that is not displayed. I can't figure out where it's called from and why it does not show.
  11. I'm able to redeem Gift Vouchers and even send them to somebody else. But I can't get them to actually come off the order. The amount available shows in the cart, but it never gets applied to the order. If the order is for $5.00 and I have $10 worth of discount I don't think payment options should be showing... They do. The credit amount is not taken off the payment (It gets sent to the gateway at the full amount) The voucher balance is not reduced after checkout. My Order Total settings... Discount Coupons 740 Gift Vouchers 9 Low Order Fee Shipping 2 Sub-Total 1 Tax (No tax settings) Total 900 Installed MODs... Download Controller w/ free charger and free shipper. I tried simply the "easy" install, replacing all the changed files. Didn't work that way either. It must be a setting I over looked. Any help would be greatly appreciated!
  12. Looks like some files were not uploaded, or uploaded to the wrong folder. When I installed this I mixed up some of the files for the Admin section and put them in catalog. Watch the folde paths carefully!
  13. When I export a Froogle feed I'm getting duplicates when products are in multiple catagories. Has anybody coded a fix for this?
  14. Deleting a coupon makes it "inactive" how do I really delete it.. Deleting it from inactive does not work. I created several test coupons to figure out how every thing would work. I would really like to get rid of them.
×
×
  • Create New...