Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bloodshoteyes

Archived
  • Posts

    327
  • Joined

  • Last visited

About bloodshoteyes

  • Birthday 06/11/1949

Profile Information

  • Real Name
    Mike
  • Location
    Texas
  • Website

bloodshoteyes's Achievements

  1. You had an extra line at the bottom of index.php. go to ?> place cursor outside, just like in front of the p in place here, and hit delete.
  2. are you sure that coupons reduce your sales tax liability for the full purchase price amount. Most taxing authorities consider coupons as a promotional items which is in most cases a business income reducing expense and a business tax deductable like most cost of sales costs. Most authorites require the purchase be completely totalled and then the coupon deducted from the grand total. But allow it to be shown before the grand total on the invoice. Which on the invoice would fall Sub-total, Taxes, Shipping, Coupon then Grand total. The coupon amount having a minus sign in front of it. You might want to check with your taxing authority before committing
  3. Matt, Thanks for the changes, works very nice.. I did however take it one step further since everything shows up regardless of when it was added.. I took your code: if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_master_status = '0' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_master_status = '0' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } and added: if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_master_status = '0' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_master_status = '0' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } That limits the displayed products to those added in the current month.. Thanks again
  4. Can anyone help???? What would it take to add a check box to master products so you could turn on or off displaying in catalog/includes/modules/new_products.php. I suppose this is unclear. This is what I am trying to accomplish.. New Products for (month) box: No Catagories, No Master Products, just products and slave products... And Master products listed in Catagories Box...
  5. I am not clear on this 'HIDDEN' thing. Will they or will they not show up when you choose the product_master???
  6. Matti, I need to make a Master_Product Like a catagorie with dozens of individual products under it. And I need it to show in the catagorie box in a tree. Is this possible????? Is it possible to only show master_products and not slaves in the New Products for February Box??? Thanks
  7. I think I know what I did. When I uploaded Master_Products I also uploaded two files named .htaccess. One into catalog and the other in admin. I'm running PHP 4.1.0. Can anyone tell me how to get rid of these two files??? Throught admin, no good, permissions need to be reset. Can't see the files from FTP Voyager, so I can't change permissions there. I need some help bad......
  8. Is there any way to get the Master Products to show up under catagories????? It seems if you put them under a catagory item the count shows up in the catagory box but not the Master Products or the slave products. And everything shows up in the Whats New for box.
  9. Christine, Everything in the box OSC runs off of the calender day of your system when you input the product master. Go into your db and change this date to one which goes back 90 days. it will not appear under new items but the slaves will. So if the slaves are the new designs, then everytime you enter one it will appear under new items. One thing to consider is the mod for Featured items, it might work better for you. You can turn them on and off. :D
  10. Recently installed Master Products which runs fine as does the other mods on my test site.. Except now I get these errors... Warning: SAFE MODE Restriction in effect. The script whose uid is 10098 is not allowed to access /tmp/sess_7eee5c2d4c75076dbd0877e03352e93e owned by uid 48 in /usr/local/psa/home/vhosts/XXXXXXXXXXXXXX.com/httpdocs/ecom/catalog/admin/whos_online.php on line 109 Warning: file("/tmp/sess_7eee5c2d4c75076dbd0877e03352e93e") - Success in /usr/local/psa/home/vhosts/XXXXXXXXXXXXXX.com/httpdocs/ecom/catalog/admin/whos_online.php on line 109 Warning: Bad arguments to implode() in /usr/local/psa/home/vhosts/XXXXXXXXXXXXXX.com/httpdocs/ecom/catalog/admin/whos_online.php on line 110 Can anyone help???????
  11. Help people... I don't know why thhe errors previously described are happening. I could really use some help. And maybe Matti could explain what numbers are supposed to be used in admin/configuration/slave products. It seems the questions are yes and no but we use numbers to answer?????????? :(
  12. Help, Help I can't find why this error keeps coming up now that I finsihed loading Master_Products. Can someone please help... Warning: SAFE MODE Restriction in effect. The script whose uid is 10098 is not allowed to access /tmp/sess_9a89054f68596d67b74347f73c87634c owned by uid 48 in XXXX/XXXXXXXXX/XXXX/XXXX/catalog/admin/whos_online.php on line 109 Warning: file("/tmp/sess_9a89054f68596d67b74347f73c87634c") - Success in /admin/whos_online.php on line 109 Warning: Bad arguments to implode() in /ecom/catalog/admin/whos_online.php on line 110 Please...
×
×
  • Create New...