Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Profile Information

  1. naiadomare

    Official PayPal IPN Support Thread

    Hi all, I'm afraid that I may well be asking an answered question but I'm in a bit of a panic! Sorry if that is the case. In fact, I think it could be solved by the last update on the contributions page (about the php.ini file) I just received an order from my shop and didn't receive the confirmation email and the order doesn't show up in admin. I assume that the customer didn't receive the email confirmation either. The order is saved in the database though. I believe that I read somewhere that the email wouldn't get sent if the customer didn't get redirected back to the site and that, in this case, the order wouldn't be saved in the database. It's weird that the order would be in the database but not show up in admin. I tested using the sandbox server during development but I have made quite a lot of changes since and, obviously, the site is now live! Any help would be greatly appreciated. Luckily I can get to all the information through the database but my other half, who runs the shop, doesn't know how to do that! Cheers, Joseph PS. If I never said thank you for the contribution ---> THANK YOU!!!!
  2. naiadomare

    Product Description 1.3

    Hi, just passing by to say a HUUUUGEEEE THANK YOU for this contrib. I've used it on my newly opened site (feedback thread: http://forums.oscommerce.com/index.php?showtopic=302114 ) and it's been really, really useful. Thanks again and regards from Madrid!
  3. naiadomare

    Wishlist 3.0 Support Thread

    Hi, just passing by to say a HUUUUGEEEE THANK YOU for this contrib. I've used it on my newly opened site (feedback thread: http://forums.oscommerce.com/index.php?showtopic=302114 ) and it's a really major feature that we think is amazing. It's been tweaked a bit to fit in with the site but there's no way in a million years I could have done something like this from scratch! Thanks again and regards from Madrid!
  4. naiadomare

    "Dynamenu" for osCommerce

    Hi, just passing by to say a HUUUUGEEEE THANK YOU for this contrib. I've given it a slightly unusual use on my newly opened site (feedback thread: http://forums.oscommerce.com/index.php?showtopic=302114 ) and it would have been impossible without this contrib. The site's pretty much based on it! Thanks again and regards from Madrid!
  5. naiadomare

    Images for Next/Previous Page Links

    Hi, didn't have email notifications set as on. I decided not to use images for the arrows in the end and just tweaked the style sheet to make it prettier. I basically changed the text inside the "define" in the language files to the html for an image. I decided I didn't like it pretty quickly but I would have added<div class/id="whatever"></div> tags in there too in order to do fine tuning from the stylesheet. I know it's very "hacky" but this technique of sticking html where text would normally go has helped me do loads of things now that I think about it. For example, the code to output the flash header on my site in the correct language just uses this technique to add in the correct file path depending on the chosen language. It's really handy when you need to stick html in somewhere and you're not sure how. When I've needed to put tables, text, images, etc... all mixed up and in two languages or something in a page, I just write the page as if it were normal html and then copy and paste that into a "define" in the appropriate language file and output it in the body of the appropriate main php file. (my site's a bit weird but I hope you know what I mean) An example of outputting an image instead of text: First you put whatever you want to go instead of text in the includes/languages/yourlanguage.php (or /yourlanguage/yourfile.php): define('IMAGE_HERE', '<img src="/yourstore/images/yourimage.png" width="whatever" height="whatever" />'); Then you output it wherever you want in the main file like this: <?php echo IMAGE_HERE; ?> I've just opened the shop yesterday and have put a feedback thread here: http://forums.oscommerce.com/index.php?showtopic=302114 All criticism welcome. Regards from Madrid!
  6. naiadomare

    Its there a DHL API for europe

    Hello from Spain! I was just leaving a message regarding this and another issue: http://forums.oscommerce.com/index.php?showtopic=301813 We have negotiated rates with DHL and, desperately hoping that I'm not going to have to set up table rates for the whole world, I have spoken to the Spanish technical department who have assured me that I will receive API keys on Monday. That said, I'm not 100% sure if they really understood what I was asking for or if they were simply playing along to get me to sign the contract. The guy I spoke to said that he knew of the OsCommerce module and said that it should work. I recommend that you speak to them there too. If you are interested in using DHL too, we should keep in touch to see how we're both doing. Us Europeans have to stick together!!! PM if you like and I'll give you my email address and/or phone number. Oh, and if you want to have a look at my post, maybe you could help me out!!!!! The idea of table rates is terrifying me as it seems as though it would be a horribly long, hard job to set things up for the whole world! Regards, Joseph
  7. Hi all. I'm in real need of assistance. I have the following issues: 1. I am working for my other half and she's the worst boss in the world and has no idea about anything computer related. 2. The shop is going live on Monday (in two days) and the idea is to ship just about anywhere. 3. We have haggled rates with DHL for shipping and I should supposedly be able to integrate their system through the API (I think it's ready to go and just awaiting some codes). The issue is that the codes should arrive on Monday morning at the same time as the shop should open. Any problems shall, of course, be my fault! 4. The following: Suddenly I have been presented with something that I really don't know how to do. The DHL system should calculate the rates for each order for me and that should be great (if I haven't missed something and it's not going to work). BUT... my "better half" has suddenly decided that it is of the utmost importance that each country should have a certain order total at which the shipping is free. So, I really need to be using the DHL system with the module I have installed but I have no idea how to simply not apply any shipping fees if a certain amount is reached for a particular zone. It would be one hell of a job to do this all as table rates (at least I think it would!) and, anyway, it would have to be based on zone and weight up until a certain price and that doesn0t seem to be configurable with, for example, Zone Rates. I've been looking around and I've only found this as part of other shipping modules. For example, the Zone Rate module allows you to do it but I don't know what would happen if I just included the minimum order for free shipping in each zone in that module as well as having the DHL module active. Would the Zone Rates module only show up if the zone and minimum order are appropriate? and, if that is the case, Will the DHL module still show up but the Zone Rates would be selected as "best option" by default??? Thank you, thank you, thank you for any guidance you could give me! (and sorry if I'm sounding too much like a "noob"! I've been doing codey, programming stuff until now and the configuration options have got me beat!) Of course, I'm also open to any other suggestions for shipping options that would meet our requirements. I saw something called e-Shipper that looks interesting but I don't know if it would work for us as we are based in Madrid, Spain. Joseph - http://www.naiadomare.com
  8. naiadomare

    Images for Next/Previous Page Links

    OK, so I was being daft. I've done what I said before i.e. I just added an image reference in the includes/languages/mylanguage.php files instead of "<< Previous" and "Next >>" and Robert is your Father's Brother! Thanks all the same!
  9. naiadomare

    Images for Next/Previous Page Links

    Hi Simon, Thanks, I'm basically looking for info, clues, hints, etc... and I think it might be useful for others too. I prefer to do things myself so that I know what's going on. I'm not exactly a "newbie" with programming stuff so it shouldn't be a problem. I'd probably be able to figure it out but I'm in a hurry so if you (or anyone) could point me in the right direction I'd really appreciate it. Cheers. PS. Is it possible to simply add an html image reference instead of text in the appropriate language files? I tried it and it hasn't worked so far but I don't know if I may have done something wrong.
  10. Hi all, I'm trying to figure out how to use images (left and right arrows) instead of the "Previous" and "Next" buttons in the product listing. Any ideas? Thanks in advance and regards from Madrid.
  11. Update: Changed sort order to "false" and all is well. If anyone figures out what the issue is with this function, It'd be handy but otherwise... Excellent work to all involved. Joseph
  12. FORGET WHAT I JUST WROTE!!!!!!!1 I was being stupid. It was a mod I'd made that was actually sending me to a new product page instead of the edit product page. Now I've fixed that. BUUUUTTT..... 1052 - Column 'products_options_sort_order' in order clause is ambiguous select * from products_attributes as pa INNER JOIN products_options po ON pa.options_id=po.products_options_id where products_id = '1065' AND language_id=1 order by products_options_sort_order ... now appears on the edit page. Fun. I saw that someone had a similar problem but I couldn't see any solution that works for me (I did try). Seems to be an issue with 2.8.2 Cheers
  13. Hi Chaps and Chapesses, (I've been looking for a similar issue all over and haven't found it). In short, I had version 2.7.1 working fine on my site (apart from having to add attributes in "edit mode" instead of directly when adding new products) until yesterday morning when it suddenly went sightly haywire and then disappeared. Now I have version 2.8.2 installed and it shows up again (after deleting the .htacess file from this contrib's directory - maybe that would have fixed it from the start!). So far so good. BUT.... Now when I try to edit a product, none of the information that I have already added to the product shows up in the edit page; all of the input fields are blank, empty and devoid of all alphanumeric symbols. I know the information is still there (i.e. it's not a database problem) as all the info and attributes still show up in the shop. Therefore, apart from not wanting to write it all in again, It seems to me that this could cause database issues or something else bad. I don't want to just make the edits I want and save in case it deletes all of the other info. A dilemma. So, any idea why folks? I'm pretty sure that it has to do with a conflict with the "Category Description" contrib as I just installed it yesterday. Can't figure out what they might to to one another to produce this problem though. http://www.oscommerce.com/community/contributions,2343 If it's not that then it could be with my modified version of "Optional Related Products" as that''s the only other contrib that also affects the admin/categories.php file. My site's pretty heavily modded in general. Thanks for any clues and regards from Madrid, Joseph http://www.naiadomare.com http://www.madrididiomas.es
  14. naiadomare

    Related Products by Categories - I need help!

    Here's a link to the ORP contrib page: http://www.oscommerce.com/community/contributions,2293/ And its support forum (where I already left a message about this): http://forums.oscommerce.com/index.php?showtopic=251243 Cheers.
  15. naiadomare

    Related Products by Categories - I need help!

    Hello again, Sorry. I should have given a decent example before. I think the short answer is "Yes, I think we're on the same page" but I'll put an example in my own words too to make sure... Let's say that this is one product displayed in the listing for the category "Ibiza Collection(1)": Clothes>Trousers>Ibiza Collection(1)>Product X I have a database table in which "Ibiza Collection(1)" is the Master and the following categories are Slave (each Master>Slave relationship is a separate database entry): Accessories>Belts>Ibiza Collection(2) Foootwear>Boots>Ibiza Collection(3) In the listing item for Product X I would like to have a button to associated products. This link could either send its parent category ID or its own ID to the new code. This code should then somehow get all of the products from the slave categories and display them. I've got the idea of displaying them in random order because that's one of the options of the ORP contrib. The Optional Related Products contribution displays related products in the product_info page below the product information by calling a list from optional_related_products.php. This doesn't work for me even if I could adapt it to show the contents of various categories as I've done away with the product_info page . I've got everything in the product listing (attributes, product description, tell a friend, enlarge image, etc...). However, I don't know if the code it uses to display the related products might be a good starting point if it then gets put into into a new .php file to display a list there instead of in the index. Here it is: <?php /* $Id: optional_related_products.php, ver 1.0 02/05/2007 Exp $ variation to support contribution: Graphical Borders 2.1 Copyright © 2007 Anita Cross (http://www.callofthewildphoto.com/) Part of Contribution: Optional Related Products Ver 4.0 Based on code from Optional Relate Products, ver 2.0 05/01/2005 Copyright © 2004-2005 Daniel Bahna (daniel.bahna@gmail.com) osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Released under the GNU General Public License */ $orderBy = 'ORDER BY '; $orderBy .= (RELATED_PRODUCTS_RANDOMIZE)?'rand()':'pop_order_id, pop_id'; $orderBy .= (RELATED_PRODUCTS_MAX_DISP)?' limit ' . RELATED_PRODUCTS_MAX_DISP:''; $attributes = " SELECT pop_products_id_slave, products_name, products_model, products_price, products_quantity, products_tax_class_id, products_image FROM " . TABLE_PRODUCTS_RELATED_PRODUCTS . ", " . TABLE_PRODUCTS_DESCRIPTION . " pa, ". TABLE_PRODUCTS . " pb WHERE pop_products_id_slave = pa.products_id AND pa.products_id = pb.products_id AND language_id = '" . (int)$languages_id . "' AND pop_products_id_master = '".$HTTP_GET_VARS['products_id']."' AND products_status='1' " . $orderBy; $attribute_query = tep_db_query($attributes); if (mysql_num_rows($attribute_query)>0) { $count = 0; ?> <tr> <?php echo mws_header(TEXT_RELATED_PRODUCTS); ?> <td align="center" class="productListing-data"> <table border="0" cellspacing="0" cellpadding="2" width="100%" align="center"> <tr> <?php while ($attributes_values = tep_db_fetch_array($attribute_query)) { $products_name_slave = ($attributes_values['products_name']); $products_model_slave = ($attributes_values['products_model']); $products_qty_slave = ($attributes_values['products_quantity']); $products_id_slave = ($attributes_values['pop_products_id_slave']); if ($new_price = tep_get_products_special_price($products_id_slave)) { $products_price_slave = $currencies->display_price($new_price, tep_get_tax_rate($attributes_values['products_tax_class_id'])); } else { $products_price_slave = $currencies->display_price($attributes_values['products_price'], tep_get_tax_rate($attributes_values['products_tax_class_id'])); } echo '<td class="productListing-data" align="center">' . "\n"; // show thumb image if Enabled if (RELATED_PRODUCTS_SHOW_THUMBS == 'True') { echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . "\n" . tep_image(DIR_WS_IMAGES . $attributes_values['products_image'], $attributes_values['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"').'</a><br>' . "\n"; } $caption = ''; if (RELATED_PRODUCTS_SHOW_NAME == 'True') { $caption .= '<p>' . $products_name_slave . '</p>' . "\n"; if (RELATED_PRODUCTS_SHOW_MODEL == 'True') { $caption .= '<p>' . $products_model_slave . '</p>' . "\n"; } } elseif (RELATED_PRODUCTS_SHOW_MODEL == 'True') { $caption .= '<p>' . $products_model_slave . '</p>' . "\n"; } if (RELATED_PRODUCTS_SHOW_PRICE == 'True') { $caption .= '<p>' . sprintf(RELATED_PRODUCTS_PRICE_TEXT, $products_price_slave) . '</p>' . "\n"; } if (RELATED_PRODUCTS_SHOW_QUANTITY == 'True') { $caption .= '<p>' . sprintf(RELATED_PRODUCTS_QUANTITY_TEXT, $products_qty_slave) . '</p>' . "\n"; } echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . $caption . '</a>' . "\n"; if (RELATED_PRODUCTS_SHOW_BUY_NOW== 'True') { echo '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=rp_buy_now&rp_products_id=' . $products_id_slave) . '">' . tep_image_button('button_rp_buy_now.gif', IMAGE_BUTTON_RP_BUY_NOW) . '</a>'; } echo '</td>' . "\n"; $count++; if ((RELATED_PRODUCTS_USE_ROWS == 'True') && ($count%RELATED_PRODUCTS_PER_ROW == 0)) { echo '</tr><tr>' . "\n"; } } ?> </tr></table> </td> <?php echo mws_footer(''); ?> </tr> <?php } ?> Regards from Madrid, Joseph