Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Scotty

Archived
  • Posts

    39
  • Joined

  • Last visited

Everything posted by Scotty

  1. I am getting the following error message when I try to edit a product from the admin section. I have carefully uploaded all the files, updated the db and double checked my installation to match the installation instructions: 1146 - Table 'abcmed_osc1.TABLE_PRODUCTS_AVAILABILITY' doesn't exist select products_availability_id, products_availability_name from TABLE_PRODUCTS_AVAILABILITY order by products_availability_name [TEP STOP] I have checked my database and the table products_availability does exist. I appreciate any help. Scotty
  2. Very useful contribution. However, in order to install version 3, you have to have version 2.1 installed and to upgrade to latest update, you have to install all the other versions first!! My bro, the life is already too complicated, why try to make it even worse? Can you release a version upgrade which doesn't require all these pre-installations? Think of version 4 which will need version 2 and 3 to be installed first. I don't want to sound disgraceful, but I guess it will be much easier if you put one full contribution together for each version rather than leaving it to hundreds of OSC users who like your contribution to take a chance and try to figure out the things themselves. It is especially makes it too hard for those of us who want to install the contribution on a live and busy site and have to go through all these installation steps. Keep up the good work.
  3. A great Contribution. Works like a charm and is as easy to install as you expect a good contribution to be. I installed it both on a standard and a loaded6 installation and it works flawlessly. Thanks very much as I was waiting for something like this for a long long time. :D
  4. Thanks Pal. You were a big help. I found it at the contribution section and just in case anybody else may be looking for it, here is the link: http://www.oscommerce.com/community/contri...ual+order+entry
  5. Hi All, I am looking for a contribution to allow adding new customers and new orders by Administrator from the Admin Section. I know it exists, but I searched and serached for these keywords both at the forum and the contributions section with no luck. Can someone help me to locate the contrbution please? Scotty.
  6. Thank you much for the reply. But I think I figured this thing out: Some. OSC contributions including the Shop by Price do not function when the "Search Engine Compatibility" option in admin section is turned on. This also applies to "All Products" contribution. Once I switched off the "Search Engine Compatibility" option, SBP started to work. However, the SBP does not show the "Special" prices in the lower price range. That means if a $100 product is sold as a special item at $50, the SBP contribution does not bring it up when searching the products at $50 range. So, that may cause some customers to miss out on goodies that they can buy at a lower price. Does anyone have a solution for this? Scotty
  7. I like this contribution a lot and I think it has to be added to OSC's upcoming release as a standard feature. However, I am having this problem which should not be hard to fix, but I don't know how? Here it is: When doing a search using shop by price, the query displays as below in the address bar: shop_by_price.php/range/3 instead of the: shop_by_price.php?range=3 Therefore, I don't get an accurate return of the products in that price range. Is there any way I can fix the query to execute correctly? I appreciate any help you can give me. Regards, Scotty Beam me up!
  8. I have the exact same problem. But it only happens when I try to delete a product from the wishlist. Any ideas on how to solve this problem? Otherwise a great and useful contrib. TIA, Scotty
  9. Hey Jeremy, Thanks for the detailed reply. However, I could not clearly understand a portion of your posting which says: "Enter the following hack in general.php" I have 2 general.php files located at the following locations: /catalog/admin/includes/functions/ /catalog/includes/functions/ Since my site is live and has high traffic, I can not afford to have a downtime for long. Would you mind letting me know if I should insert the code in both general.php files or only in one (which one?). Also, does it matter where in the file body the code is inserted? Thanks pal for both the e-mail and the posting. Keep up the good work. Scotty
  10. Check stock level - true Subtract stock - true Allow Checkout - false I have the exact same information and setup as you've mentioned here. But as freezehell points out, I think there are some bugs associated with this attribute. Thank you and I'll be watching this thread for update info. Meanwhile, if anyone else suffers from the same situation or has a solution for this problem, it will be great to share them with us. Cheers, Scotty
  11. Hi Guys, The problem here is that since after you enter the available stock qty using the QTPro, the quantity on the product information page sets to the total stock for all the available options (total=10), the buyer can order up to 10 for any of the available sizes. Here is how it works: I set the stock quantities for a particular product as you mentioned in your example: Size 1 Qty 3 Size 2 Qty 2 Size 3 Qty 4 Size 4 Qty 1 ===== Total Qty 10 (NOTE: I do not add any qty using the product page) However, my clients can order quantity 10 of any of these sizes. That means they can put Qty 10 for Size 1 or Qty 6 for size 4 and qty 4 for size 2 (total 10) in their shopping basket and successfuly checkout, which defeats the whole purpose of the contribution. You may want to give it a try and see if that is not going to happen in your case, but my QTPro behaves just like that. Scotty
  12. Hi Everyone, A question: After the QTPro Installation, I still have to declare a quantity for the product when I am adding a new product. Here is the problem: Here is what I have: Product (A) Total Qty: 10 Size 1 Qty 3 Size 2 Qty 2 Size 3 Qty 4 Size 4 Qty 1 1. If I enter the quantity 0 in the product information page: The product can not be purchased by shoppers, and the out of stock message is displayed at the shopping cart. 2. If I enter any qty less than 10 in the product information page: Once that qty is reached the product is marked as out of stock, even if I still have a few left based on my stock information. 3. If I enter qty 10 in the product information page: All the sizes can be purchased at any quantity up to 10, despite the fact that I may only have 1 for the size 4! That mean that buyer can order qty 10 for the size 4 (availability=1). This is pretty weird and defies the whole idea of the usefulness for this contribution. Any suggestion on how I can take care of this problem?
  13. I guess I fixed the problem. This is what I did: Change the: function newsletter($title, $content) in newsletters/newsletter.php to: function newsletter_subscribers($header, $title, $content, $unsubscribea, $unsubscribeb, $footer) In admin/newsletters.php changed the: } elseif ($action == 'send') to: elseif ($HTTP_GET_VARS['action'] == 'send') and } elseif ($HTTP_GET_VARS['action'] == 'send') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); $newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; $module = new $module_name($nInfo->title, $nInfo->content); to: } elseif ($HTTP_GET_VARS['action'] == 'send') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); $newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; $module = new $module_name($nInfo->header, $nInfo->title, $nInfo->content, $nInfo->unsubscribea, $nInfo->unsubscribeb, $nInfo->footer); and: } elseif ($action == 'confirm') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); $newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; to: } elseif ($action == 'confirm') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); $newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; $module = new $module_name($nInfo->header, $nInfo->title, $nInfo->content, $nInfo->unsubscribea, $nInfo->unsubscribeb, $nInfo->footer); and in admin/newsletters_subscribers.php I changed all the instances of the following code (I think there are 3 of them): $newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . tep_db_input($nID) . "'"); $newsletter = tep_db_fetch_array($newsletter_query); to: $newsletter_query = tep_db_query("select p.title, p.content, p.module, q.header, q.footer, q.unsubscribea, q.unsubscribeb from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . tep_db_input($nID) . "' "); $newsletter = tep_db_fetch_array($newsletter_query); and voila!!! it worked. Shish!! Not to be ungrateful, but couldn't that be done by the contribution developer rather than poor user :unsure: !! But, anyways thanks for an otherwise fine and useful contribution. :D
  14. Thanks for the superfast reply: I guess you meant the "newsletter_subscribers.php" and not the "product_notifications.php" but I include both: In product_notifications.php (Line number in red): 16 <tr> That is all. In newsletter_subscribers.php ( I include some of the rest of the code as well): class newsletter_subscribers { var $show_choose_audience, $header, $title, $contenta, $unsubscribea, $unsubscribeb, $footer; 16 function newsletter_subscribers($header, $title, $contenta, $unsubscribea, $unsubscribeb, $footer) { $this->show_choose_audience = false; $this->header = $header; $this->title = $title; $this->contenta = $contenta; $this->unsubscribea = $unsubscribea; $this->unsubscribeb = $unsubscribeb; $this->footer = $footer; }
  15. Hi, When trying to send a newsletter, I get the following error messages: Warning: Missing argument 3 for newsletter_subscribers() in /usr/home/chickids/public_html/shopping/admin/includes/ modules/newsletters/newsletter_subscribers.php on line 16 Warning: Missing argument 4 for newsletter_subscribers() in /usr/home/chickids/public_html/shopping/admin/includes/ modules/newsletters/newsletter_subscribers.php on line 16 Warning: Missing argument 5 for newsletter_subscribers() in /usr/home/chickids/public_html/shopping/admin/includes/ modules/newsletters/newsletter_subscribers.php on line 16 Warning: Missing argument 6 for newsletter_subscribers() in /usr/home/chickids/public_html/shopping/admin/includes/ modules/newsletters/newsletter_subscribers.php on line 16 Would someone please help me out with fixing this problem. Scotty
  16. Thanks for the help. It is the Admin section and I see it as soon as I click to use the X-Sell.
  17. I installed the Module and it worked fine, however, after I deleted a product from my shop which wasn't even linked to X-Sell, I started getting this error: 1146 - Table 'xxxxxx_osc1.TABLE_PRODUCTS_XSELL' doesn't exist select b.products_name, a.xsell_id, c.products_model from TABLE_PRODUCTS_XSELL a, products_description b, products c WHERE b.products_id = a.xsell_id and a.products_id ='48' and b.products_id = c.products_id ORDER BY sort_order [TEP STOP] The XSell teble is in the database and everything seem to be as it was when the module was behaving well. Any ideas. TIA, Scotty
  18. Hi, I have 2 Questions: 1- What is the best "Membership" contribution (I Sell to members only)? 2- Is there a method or contribution which can hide the prices (not the products) from the public and reveal them to members, only after they login? I searched the contributions and support forum but could not find a definite answer to these questions. TIA, Scotty. By Mistake I've posted this in the Contribution Announcements but could not delete it afterwards, I appologize in advance. :(
  19. Sorry to repeat my question again, but it seems that important inquiries (at least to me) get buried quickly under the tons of other topics before someone really gets to take a look at them seriously and I am still suffering from the same situation and don't see a light at the end of the tunnel. :blink: So, is there anybody out there who can help me out with this? :huh: TIA, Scotty
  20. Hey Sharad. Is it tomorrow yet, as I have the same problem as James does ;)
  21. Thanks Jason for the hint, but once you copy the code and paste it, do you also have to make changes to the pasted code? If yes, what are those changes? BTW, the author does not include any contact information in the docs. Is there any way else I can get hold of him/her? TIA
  22. I was wondering if anyone knows how to modify the contribution 1446 http://www.oscommerce.com/community/contributions,1446 to include additional table rates. The included text says it is very simple, but I can not figure it out how to do the modification :( I appreciate if anyone can shed some light on this, as this is one of the most helpful shipping related contributes.
×
×
  • Create New...