Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

satinwoods

Pioneers
  • Posts

    51
  • Joined

  • Last visited

Everything posted by satinwoods

  1. Hello, I'm looking for a popup to request people add themselves to our mailing list. I want it popping up once for them and I want to be able to customize it. I haven't found one that works with oscommerce. I use mail chimp for my newsletter though its pop up does not allow me to customize what I want and it also does not work. Can anyone recommend an addon that will do this for me? Thank you!
  2. I'm using QTPro and I've got a strange problem wtih PayPal I've gone through and updated with all the fixes her http://addons.oscommerce.com/info/7786/v,23 including paypal_standard.php FIX to decrement stock levels The stock is not going down randomly. Some time it drops down and some times it doesn't. Any suggestions?
  3. I fixed it. For anyone else who wants to have they're attributes organized open up; includes/classes/pad_base.php Find: } if (isset($cart->contents[$this->products_id]['attributes'][$products_options_name['products_options_id']])) Add Above: asort($products_options_array); That will fix it. Anyone else have a problem with pay pal? Its really inconsistent.
  4. I've tracked down the sort to this line $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); I just need to get this to sort properly.
  5. Hi there. I just updated to the latest file and the stock.php was suppose to sort the attributes alphabetically, but it hasn't worked. //$q=tep_db_query("select * from " . TABLE_PRODUCTS_STOCK . " where products_id=" . $VARS['product_id'] . " order by products_stock_attributes"); //sorting below goes by name rather than products_stock_attributes. Much easier to have it all sorted alphabetically $q=tep_db_query("select ps. products_stock_id, ps.products_id, ps.products_stock_attributes, ps.products_stock_quantity, pov.products_options_values_id, pov.language_id, pov.products_options_values_name from " . TABLE_PRODUCTS_STOCK . " ps, products_options_values pov where ps.products_id=" . $VARS['product_id'] . " and pov.products_options_values_id = substring_index(ps.products_stock_attributes, '-', -1) order by pov.products_options_values_name asc"); It's not working and I'm lost as to what to do. Suggestions? The other problem I'm having is when people buy something from PayPal, sometimes the stock is taken out and sometimes it doesn't. I haven't been able to find anything connecting the problem. Anyone have a similar problem?
  6. @@Jack_mcs Tried it and I got this mess; [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]143[/b] [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]148[/b] [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]167[/b] For about 100 lines of just errors after errors And yes I did go in and do this like it said to "Yo use QTpro with this contrib, you must edit attributeManager - attributeManager - classes attributeManagerConfig.class.php and edit line 65 "AM_USE_QT_PRO" to "true"" Did I miss something else? I read through the instructions again and I think I got everything. I used v2.8.10. Was I suppose to use v2.8.7?
  7. Can anyone confirm that this works with QTPro?
  8. @@toyicebear Nice, that fixed it! Thanks! Now it won't load all the areas, here's what the sql looks like Full texts geo_zone_id geo_zone_name geo_zone_description last_modified date_added Edit Edit Copy Copy Delete Delete 3 15% Rate NULL 2013-08-21 13:09:15 Edit Edit Copy Copy Delete Delete 4 14% Rate NULL 2013-08-21 13:09:24 Edit Edit Copy Copy Delete Delete 5 13% Rate NULL 2013-08-21 13:09:33 Edit Edit Copy Copy Delete Delete 6 5% Rate NULL 2013-08-21 13:09:43 Edit Edit Copy Copy Delete Delete 7 No Tax Out Side Canada 2013-10-07 08:37:21 2013-10-07 08:32:20 Edit Edit Copy Copy Delete Delete 8 Shp: United States: 48 United States: Continental 48 states NULL 2013-11-20 13:11:01 Edit Edit Copy Copy Delete Delete 9 Shp: United States: 48 United States: Continental 48 states NULL 2013-11-21 14:00:17 It shows the double States in the drop down and the "rest of the world". No idea why the rest isn't working.
  9. @@toyicebear I am using that file. Still doesn't work. I re-installed it to make sure and nothing changed. :(
  10. I just installed multigeozone and I'm getting this error when I try to edit it in the admin section Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 line 196 is while ($zone_class = mysqli_fetch_assoc($zone_class_query)) { Thoughts?
  11. In qtpro_stock_table.php Here is the original $products_attributes_query = tep_db_query("SELECT pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa WHERE pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); What I would like it to do is $products_attributes_query = tep_db_query("SELECT pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix, pa.products_options_values_name FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa WHERE pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'. ORDER BY pa.products_options_values_name"); I'm not getting any errors, but its also not doing anything. Help?
  12. My attributes in the drop down are not sorting. http://strutfashion.ca/product_info.php?cPath=26&products_id=193 As you can see they're not in any order. Just in what order I added them. I can't seem to figure it out!
  13. I'm trying to get this mod working http://addons.oscommerce.com/info/6414 But when I go to confirm my order I get this message. I spoke with my host and they narrowed the problem down to this. I just spoke with Internet Secure and they say that that mod should be working fine. Any thoughts on how to fix this?
  14. Never mind, I figured it out. I was using an item on special to test it when I had exempt specials turned on. I'm going to go facepalm myself for a while.
  15. Hi there, I think I'm missing something with this mod. I've tripled checked my installation and everything seems to be fine. I can add the module, add a discount code, it knows when I've entered a wrong code, but when it gets to checkout_confirmation.php it doesn't show at all. I echoed array_sum($order->coupon->applied_discount) and its 0. I've been going through all the forums I can find to see if anyone else has had this problem. The only thing that I can find is that in include/calsses/order.php I found this code $shown_price = $currencies->calculate_price($this->products[$index]['final_price'], $this->products[$index]['tax'], $this->products[$index]['qty']); $this->info['subtotal'] += $shown_price; Instead of this code in the instructions $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty']; $this->info['subtotal'] += $shown_price; I also didn't run any SQL because it said And since I can go into the admin and see my coupon code I assume everything is working well. Please help, I'm really lost with this.
  16. @@jeni.kiliikuli @@jaggster @@GadgetSmith I'm having the same problem. It can see correct and incorrect codes in payment but it won't show up in the confirmation page. Have any of you solve that issue? Have you tried another coupon module?
  17. This is a great mod and works great for me. I would like one option though. When I add a new attribute, I would like to have it default the quantity to 1. Is there anyway for me to do this?
  18. I'm having the same problem. Anyone know the solution to this problem?
  19. Hello everyone, Just installed OScommerce fresh and added on how did you hear about us addon. I then added on qtpro and it all works and I get no errors however when the order is processed the order itself is blank although the product attribute has been decremented and the price is still there properly. I have no errors to report so I'm kinda lost at this point. Help? :(
×
×
  • Create New...