Jump to content


  • Content count

  • Joined

  • Last visited


Profile Information

  • Real Name
  1. woodpress

    Quantity Price Breaks

    Hi, I've just spent the past 2 1/2 hours reading the forum posts for this module and haven't found an actual solution for the issue that I am having. I have installed the module and run the sql script that came with it, but now on my product_info.php?products_id=28 page I get this error message: 1146 - Table 'db3435795133.products_to_discount_categories' doesn't exist select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, ptdc.discount_categories_id from products p left join specials s on p.products_id = s.products_id left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id, products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id = '28' and pd.language_id = '1' [TEP STOP] on my admin/categories.php page I get: 1146 - Table 'db3435795133.products_to_discount_categories' doesn't exist select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, ptdc.discount_categories_id, dc.discount_categories_name from products p left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id left join discount_categories dc using(discount_categories_id), products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name [TEP STOP] on my admin/discount_categories.php page I get: 1146 - Table 'db3435795133.discount_categories' doesn't exist select count(*) as total from discount_categories dc [TEP STOP] The only thing that I can figure is that the SQL script has gone wrong somehow. But maybe I am overlooking a php error. help? Suggestions? Thank you.
  2. It seems that a lot of our customers are a bit dense and blow by the download link at the end of the checkout process. Is there a way to include links to the downloadable product in the customer receipt email? Please note that some of my products are are physical and some are virtual so it is not uncommon that I would have a split order ie: hard copy book and a digital copy going to the same customer. Thx!
  3. woodpress

    All Customers Report

    EDIT: I think I figured out what is wrong with the state not appearing. The STATE field is being populated by the ADDRESS 2 Field. How is that fixed?
  4. woodpress

    All Customers Report

    Hi. I have downloaded and installed Customer Export Full package v. 1.5. It appears that the STATE list still doesn't populate. In this forum I haven't been able to pin down the fix to get it to display the states. The column is there, but it is unpopulated. Also it appears that all countries are either US or Canada. Any other country defaults to US. Also it doesn't export in IE7 or IE8. I had to do it via FireFox. But I can live with that. Just need the states. Can anyone help??? Thx
  5. woodpress

    UPS ADDS 3 POUNDS Automatically in checkout

    As Ed McMahon used to say to Johnny Carson; "You are correct, sir!" Thank you! You solved a problem that I have been looking to fix for sometime.
  6. Authorize.net sent notice today that come October 2008 they going to start issuing transaction IDs that are greater than 10 digits. Do the Authorize.net module of osCommerce already accomodate IDs greater than 10 or is there an urgent update needed? Thanks. (A copy of Auth.net's letter follows)
  7. I haven't seen this listed anywhere and maybe one of youfine people can tell me if and how this can be done. I need to be able to look at the days orders and see what shipping option customer has chosen. We use USPS flat rate, priority mail and FedEx Ground, Next day and 2-day service. At present we have to open every individual order and look for the shipping option. Wouldn't it be nice to see and act on the Priority orders first without having to dig for them? Thank you in advance for your tips.
  8. woodpress

    Sales Report 2

    My Sales Report 2 Stopped working for some odd reason. It only will show the first 5 days of the current month with no details. The options tabs can be selected but it still only will show the first 5 days of the current month. I have reinstalled the files but no changes. I am running osCommerce 2.2-MS2 and PHP Version 5.1.6 Any suggestions?
  9. woodpress

    Product Sales and Stats v2.0 Contribution

    Diddo issue as to Nicholes. This boxes/reports.php files blows up my admin panel when I add '<a href="' . tep_href_link(FILENAME_STATS_LOW_STOCK, '', 'NONSSL') . '" class="menuBoxContentLink">'Product Sales v2.0'</a>' . So what's the solution?
  10. woodpress

    Unsold Carts Report

    Hi ya, I've got 2 issues with the unsold cart. 1) the thumbnails are displaying 1 pixel wide by 40 pixel high. The parameters specifically are displaying // PARAMETERS define(UNSOLD_IMAGE_HEIGHT, 40); define(UNSOLD_IMAGE_WIDTH, 40); define(UNSOLD_DAYS, 10); 2) my dates are way off. My server does have the proper date set--just checked--but the report is displaying the year 2012. Suggestions or solutions anyone? Thanks!
  11. woodpress

    AIM Module in OSC Merchant v2.2 RC2.

    This really isn't that difficult of a question is it?
  12. woodpress

    AIM Module in OSC Merchant v2.2 RC2.

    ** bump ** anyone care to answer this?
  13. woodpress

    Template Monster 18856

    Hi Nice Theme. Look in includes > boxes > information.php Around line 23 is where you see the module links listed. It looks like <a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' . Add the other links to the modules in the same fashion. Hollar if you have another question about it.
  14. Hello, Is the AIM Module that is posted online (http://addons.oscommerce.com/info/4091) any different than the AIM module that is being embedded with the osCommerce Online Merchant v2.2 RC2. Are they the same? Vger had mentioned that one of the embedded Auth.net modules in osc was crackable. Which version has issues? Can I use the embedded one without problems? Thanks
  15. woodpress

    Sales Report 2

    Is there a way to get this report to be excel ready on download? I can save it as a .txt from the export CSV option. But all of the data is separated by "\n\r" which totally messes up excel.