Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mghay

Pioneers
  • Posts

    34
  • Joined

  • Last visited

Everything posted by mghay

  1. Using V2.2 I have discovered a glitch with the calculation of tax for orders of multiple products. This is best seen on the Order Confirmation page. The cost of multiple products is listed correctly (e.g. 19 x Widgets 119,70 EUR) but the subsequent sub-total is incorrect (e.g. Sub-Total: 119,76 EUR) I can see in checkout_confirmation.php that in the first case the tax is applied to the products_price first, then the order quantity to produce the correct result. However, the Sub-Total is derived from order_total_modules->output which must use the products_price x qty x tax formula which, thanks to multiple decimal points and subsequent rounding, produces the incorrect result (customers buy a tax-inclusive priced product rather than have tax added separately at the till!). This incorrect result is then used throughout the subsequent billing, invoicing, etc. It's only a matter of a few cents but it stands out on the invoice. I would like to alter this incorrect order of calculation but I am unable to locate just where it is buried. I have searched through the various directories but although order_total.php looks to be the most obvious, I can't see that function anywhere. If anyone can point me in the right direction or offer any other help, I would be most grateful.
  2. Hi, I've been using this contrib for a while but can anyone help with a couple of snags I have come across? First, when selecting the DELETE IMAGE button in Categories / Products listing I don't want the image file deleted from the server, only the entry from the database. I've tried changing or deleting code in admin/categories.php to no avail. Any pointer to what I should try would be much appreciated. Second, after selecting EDIT to amend an existing product, the image upload directory path seems to be added to the existing one thus corrupting it even if the dir path is entered manually (this happens with both TRUE and FALSE selected in configuation 'pre-fill upload dir..') and so the image is not found. On the second time around with a manual entry of the dir path, it all works OK but it does mean that I have to go through the edit procedure twice. For minor corrections of product info it's easier to change the raw db entry! Thanks for any ideas, Mike
  3. Thanks Spooks and Ken44. What I really want to display is not a misleading 'New Products' price list but a selected listing of products - not purely random - both new and existing with some of the latter being on Special. I came upon this problem by re-vamping the shop display with this contribution and re-jigging the category lists. The items on Special had been on sale for a long time but had a revised write-up and were then re-entered so, effectively, became a New Product as far as the programming was concerned. Then they were displayed under New Products, sans discounted price for the reasons you have explained. At last now I can stop puzzling over that particular problem and concentrate on the display issue. Thanks also for your 'read the file' dig :-" - yep, did read the file - initially for the install!! - but didn't twig that line when I came across the (non-existant) problem, and that WOULD have saved me a bit of hassle. Fair cop. :blush:
  4. Before I burn any more braincells, can you please confirm the way things SHOULD work! I have some products listed in Specials and the prices display correctly on the 'Product List', 'Product Info' , 'New Products' pages and 'Specials' box, i.e. with both the normal price with strikethrough, plus the new special price. However, on the 'New Products for (month)' list, only the normal price is displayed (I think the vanilla version does this as well). Since this could be confusing, I need to be able to display the Specials price on this first page to be displayed. I've had no success with my efforts to tweak new_products.php - any suggestions or pointers to what I should look at would be appreciated. Thanks Mike
  5. Great, thanks a lot; that bit is now fixed. Now becoming a nuisance is the image locations set in the admin/new products edit page. With the 'Generate 3 image set now.' box unticked, I want to select my own images for the three image selections using the 'Browse..' box. Each time I exit that page via 'preview' then 'update' as usual, the 'Upload location' path is added to whatever is set in the images path. The first time around, the Thumb and other images may be loaded OK, but if I return to add or amend anything on that page, as soon as I update the entry, the image path is corrupted by the addition of a repeated upload location path. In Config/AI I have togglled the Prefill Upload dir to false then true but none of the config settings seem to help. I can see from phpMyAdmin that the images entry in products/products_image table contains the double path, so it appears that I have a code error somewhere - any idea where this might be?
  6. Hi, Installed V.2.2.0 OK and now getting to grips with image control in the Categories/Products and New Products - finding the later a bit unstable: all images seem to need to be specified together; if I enter one, then come back to edit another, the first one tends to disappear or is ignored. Strange. Main point of this request-for-help post: With image pop-up after 'Click to Enlarge' is selected, the window initially opens towards the top left - as specified in the javascript coding about line 88 of Products_Info - before jumping to near the centre of the screen. Question 1: Where can I specify the final position of the pop-up window (I can't see anywhere in the new javascript code in the Non Lightbox lines). I assume that disabling the position specification in the first bit of java code will stop the initial pop-up. Question 2: Is it possible to specify the opening size of the pop-up window (presumably at the same place as Q1!). Thanks, Mike
  7. V2.0 failed to work. Perhaps it's because I did not amend a file: Instructions say: "5. Now you need to edit some existing files: A. /catalog/product_info.php. B. /admin/includes/languages/english.php C. /admin/includes/boxes/catalog.php D. /admin/includes/filenames.php E. /catalog/includes/filenames.php F. /catalog/includes/languages/product_info.php G. catalog/stylesheet.css" but there is no update data for item F. /catalog/includes/languages/product_info.php I get the message: Warning: require(includes/languages/english/options_images.php) [function.require]: failed to open stream: No such file or directory in C:\xampp\htdocs\laine\options_images.php on line 13 Fatal error: require() [function.require]: Failed opening required 'includes/languages/english/options_images.php' (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\laine\options_images.php on line 13 Now, Line 13 is: require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_OPTIONS_IMAGES); so I think this indicates there is an options_images file missing - files with that name in catalog/ and admin/.../languages/ but not catalog/.../languages/ (?) Can't see any sign of one from earlier versions, either, so is this why so many other people had trouble? I really would like this to work since it is just what I need but it's getting too time consuming and irritating. Any pointers in the right direction much appreciated. Mike
  8. Thanks Sam, Yep, read the doc but this is a different header, an addin for Category Description which is displayed above Product Listing. Got there eventually by inserting code above script for 'function changeValue..'. Did a 'clean' install of V2.6 so discovered that I had to add manufacturers_description field manually; previous version had it in product_listing_setup.php but not included in 'Install SQL V2.6.txt' listing. Minor problem. Bit more confusing is the SQL error I get when selecting either Price sort order (both Name options are OK): "1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 20' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '76' order by final_price , pd. limit 0, 20" You have provided the option to remove this option display so no great problem, but I cannot find where these lines are to try to change the syntax. This forum must keep you as busy as coding your next contrib!! Cheers & Happy New Year, Mike
  9. Hi Sam, A question on tweaking your great contrib: With V2.5, when a customer selects List or Thumbnail View, I want the displays to be List Block or Thumb Grid. I've been messing about for several hours now so can you put me out of my misery?? Presumably an inputted param somewhere in Modules/Product_listing.php? Also I managed to 'lose' the optional display sort box, but no great prob there because it displayed an SQL fault which I couldn't resolve. Finally, I notice that a previous contrib, Category Header, no longer displays - no great prob there either, I'll just have to work around it. After all the above, does V2.6 provide better controls and will it upgrade or is it a complete new install? Thanks a bunch and Happy New Year Mike
  10. Thanks Jack, Works fine now. At the risk of being a pain...a quick query about the Silo infobox. I have it all selected with a title entered for all cats and for a number of links. The infox box displayes OK - but only for products, not cats - and with the product name as box header and only the one link. It's no big deal and I am happy to leave it like that but is that the way it is supposed to be? I gathered from your notes that the header should be that entered in the Silo Control and that the number of links selected, presumably the last few viewed, should be displayed. The info is there in the db files and the 'is_disabled' = 0 but the silo setting seems to get stuck in the 'Get Settings' routine. However, that is all too difficult just now one to puzzle about another day! Thanks again for a great contrib, Mike
  11. Hi Jack, Please ignore the post above - I tried to edit it but got locked out. 2 mins after the post, I spotted my error. All now resolved - I think! Schoolboy error (of course) - I hadn't checked all the right boxes in Admin/Page Control. Still, I had a few hours of searching thru' the codes and actually thought I had found a bug for you, but not so. All the best, Mike
  12. Hi Jack, Found one bug in the code from the Install_Catalog.txt file: In the products_info section, FIND around line 240, there is a line: <?php echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title']; ?></a></td> If I move the <a to before <?php as <a> the pages display OK in both languages. BUT... the categories path is still missing from the French version, just the url is shown; english version OK, so still to find that prob. Let you know if I find it. Mike
  13. After install of Header Tags SEO V 3.1.8 (correct version files this time!) everything now works OK - except... in french language products page, after 'currently viewing:' the breadcrumb trail appears to be lost: the right column is displayed in the centre of the page immediately under 'currently viewing:'. Subcategories displays seem Ok and everything works fine in English version. Files uploaded to both English and French dirs. I trailed thru' all the updated files and checked for instances of language id, etc., but all seems to be there. Any idea of what or where I should check for before I go for another install attempt? Thanks Mike
  14. Thanks for your fast reply Jack. Too fast! Yep, I just discovered I have 2 downloads of Header Tags - different version - and I was 'mix-and-matching' inadvertantly!! Copied the correct files across and problems resolved. Sorry about that. Last prob to sort out in Admin menu: between Page Control and Fill Tags I now have BOX_HEADER-TAGS_SILO - haven't gone thru' files yet but more human error I suspect. Thanks for your time & effort, Mike
  15. Hi, Just installed HeaderTags SEO 3.1.8 into 2.2rc2a and I think I have ironed out most of the errors during code insertion, but a couple must still remain. Any idea where to look for them? Errors: 1. At the top of every Category (and sub-cat) page, 'path Standard' text is displayed above shop logo in top left. Home and info pages are OK. Assume it must be towards the top of index.php but can't see anything obvious. 2. Top of admin page has warning: Found Missing Tags: Categories table has 2 items with missing meta tag information. I've gone thru' all the cat pages and all seem to be filled; used 'Fill all' and 'Fill empty tags' options, no better. Can't see anything in raw database tables to help. 3. After update of Fill Tags, a blank page is displayed. I have to back page on the browser to clear it. The last two are not serious but I don't want the spurious text displayed to shop visitors. Thanks for any ideas. Mike
  16. Hi, I'm using the contribution 'Box categories pro V2.2' by Gideon Romm and it works fine. It defaults to 2 levels of category listing with the option of displaying all levels. It all works fine, just as advertised but I would like to change it (of course!) to display 3 levels only (not all levels) or to expand levels on mouse-click or -over on sub-category. I've played around with the code and looked at other contributions (such as 'categories-tree') for clues but with no progress. Has anyone else looked at this contribution with a view to modification? If anyone thinks they can help, I'll post the relevant categories.php code but I haven't done so now to avoid annoyance. Thanks. Mike
  17. I think there is a problem for returning customers on the Billing and Shipping Information page. PWA autoinstaller 2.14 seems to have worked OK, but for a returning customer, the email address box produces an error report (as for a new account) when an existing email address is entered. OK for new account situation but a pwa returning customer still has his previous email address and this should be acceptable on this page. Any ideas on how to solve this? Thks Mike
  18. Hi Paul, I have just used PWA autoinstaller 2.14 (30 June version) and the code in account_history.php does not appear to be amended. Have you used this version or an older one and should I now add this code (testing does not seem to reveal the problems you have)? Mike
  19. Hi Christian, Yes, just disable or delete the php code inserted into header.php about line 68 or so (see the double slashes // below): <table border="0" width="100%" cellspacing="0" cellpadding="1"> <tr class="headerNavigation"> <td class="headerNavigation"> <?php echo $breadcrumb->trail(' |'); ?></td> <td align="right" class="headerNavigation"><?php if (tep_session_is_registered('customer_id')) { ?><a href="<?php echo tep_href_link(FILENAME_LOGOFF, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_LOGOFF; ?></a> | <?php } ?> <?php //if (tep_session_is_registered('customer_id') && (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])) && !$order->customer['is_dummy_account']) { ?> <a href="<?php echo tep_href_link(FILENAME_ACCOUNT, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_MY_ACCOUNT; ?></a> | <?php // } ?> <a href="<?php echo tep_href_link(FILENAME_SHOPPING_CART); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CART_CONTENTS; ?></a> | <a href="<?php echo tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CHECKOUT; ?></a> </td> </tr> </table> Mike
  20. Thanks for your contrib, Ken. It all works well after a bit of tweaking and customization for multi-language site and the printed pdf file certainly looks a lot better than the page dump I was using as an invoice! Mike
  21. In 2.2rc2a - Categories image problem resolved by using fix as above - Products image problem resolved by using "$sql_data-array['products_image']....... . " patch in original READ_ME file marked as only for earlier versions than 2.2rc2a. All now works as advertised. Thanks to all for original and fixes. :lol: Mike
×
×
  • Create New...