Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

RicherDesigns

Archived
  • Posts

    7
  • Joined

  • Last visited

Everything posted by RicherDesigns

  1. Try adding: /// fix for yasu define('SEO_URLS', 'true'); define('SEO_ENABLED', 'true'); To the top of a googlesitemap/index.php (default installation) Will enable the tep_href_link function - works fine for me with YASU :) Very impressive contrib BTW - thanks Chemo!
  2. Just a quick add-on to this great mod: my client wanted the vendor emails to be sent at *checkout* time, not when they were processed in admin... I've hacked together this code which seems to do the trick, after installing via the instructions add the code below to checkout_process.php after the "send emails to other people" block. This also fixes the attributes query as they were not coming through correctly in on my system. Remember to backup, etc ;) //vendors email begin // Get the delivery address $delivery_address_query = tep_db_query("select distinct delivery_company, delivery_name, delivery_street_address, delivery_city, delivery_state, delivery_postcode from " . TABLE_ORDERS . " where orders_id='" . $insert_id ."'"); $delivery_address_list = tep_db_fetch_array($delivery_address_query); //find out what shipping methods the customer chose $shipping_method_query = tep_db_query("select title from " . TABLE_ORDERS_TOTAL . " where orders_id='" . $insert_id . "' and class = 'ot_shipping'"); $shipping_method = tep_db_fetch_array($shipping_method_query); $vendors_email_query = tep_db_query("select distinct o.orders_id, v.vendors_id, v.vendors_name, v.vendors_email, v.vendors_contact, v.vendor_add_info, v.vendor_street, v.vendor_city, v.vendor_state, v.vendors_zipcode, v.vendor_country, v.account_number, o.products_id, o.orders_products_id FROM " . TABLE_VENDORS . " v, " . TABLE_ORDERS_PRODUCTS . " o, " . TABLE_PRODUCTS . " p where p.vendors_id=v.vendors_id and o.products_id=p.products_id and o.orders_id='" . $insert_id . "' and v.vendors_send_email=1 GROUP BY vendors_id"); while ($vendors_email_list= tep_db_fetch_array($vendors_email_query)) { $order_number='" . $insert_id . "'; $the_email=$vendors_email_list['vendors_email']; $the_name=$vendors_email_list['vendors_name']; $the_contact=$vendors_email_list['vendors_contact']; $email= $the_contact . ' <br>' . $the_name . '<br>' . $the_email . '<br>' . $vendors_email_list['vendor_street'] .'<br>' . $vendors_email_list['vendor_city'] .', ' . $vendors_email_list['vendor_state'] .' ' . $vendors_email_list['vendors_zipcode'] . ' ' . $vendors_email_list['vendor_country'] . '<br>' . "\n" . EMAIL_SEPARATOR . "\n" . 'Special Comments or Instructions: ' . $vendors_email_list['vendor_add_info'] .'' . "\n" . EMAIL_SEPARATOR . "\n" . 'From: ' . STORE_OWNER . "\n" . STORE_NAME_ADDRESS . "\n" . 'Accnt #: ' . $vendors_email_list['account_number'] . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_SEPARATOR . "\n" . '<br>'; // Get all the products to be included in the email $vendors_email_products_query = tep_db_query("select distinct o.orders_id, o.orders_products_id, v.vendors_id, p.vendors_prod_comments, o.products_name, p.vendors_prod_id, o.products_model, o.products_id, o.products_quantity, p.vendors_product_price, o.orders_products_id FROM " . TABLE_VENDORS . " v, " . TABLE_ORDERS_PRODUCTS . " o, " . TABLE_PRODUCTS . " p where p.vendors_id=v.vendors_id and v.vendors_id='" . $vendors_email_list['vendors_id'] . "' and o.products_id=p.products_id and o.orders_id='" . $insert_id . "' order by o.products_name"); $email = $email . '<table width="75%" border=1 cellspacing="0" cellpadding="3"> <tr><td>Qty:</td><td>Product Name:</td><td>Item Code/Number:</td><td>Product Model:</td><td>Per Unit Price:</td><td>Item Comments: </td></tr>'; while ($vendors_email_products= tep_db_fetch_array($vendors_email_products_query)) { $product_attribs =''; $vendors_email_products_attrib_query = tep_db_query("SELECT products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE 1 AND orders_products_id = '" . $vendors_email_products['orders_products_id'] . "'"); while ($vendors_email_products_attribs = tep_db_fetch_array($vendors_email_products_attrib_query)) { $product_attribs .= $vendors_email_products_attribs['products_options'] . ': ' . $vendors_email_products_attribs['products_options_values'] . '<br>'; } $email = $email . '<tr><td> ' . $vendors_email_products['products_quantity'] . '</td><td> ' . $vendors_email_products['products_name'] . '<br>' . $product_attribs . '</td><td> ' . $vendors_email_products['vendors_prod_id'] . '</td><td> ' . $vendors_email_products['products_model'] . '</td><td> ' . $vendors_email_products['vendors_product_price'] . '</td><td>' . $vendors_email_products['vendors_prod_comments'] . '</td></tr>'; } $email = $email . '</table><br>'; //send the email tep_mail($the_name, $the_email, EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id , $email . '<br>', STORE_NAME, STORE_OWNER_EMAIL_ADDRESS) ; } //vendors_email end You also need to add define('TABLE_VENDORS', 'vendors'); to catalog/includes/database_tables.php Many thanks to blucollarguy for this great mod :D
  3. Hi hobbyhen, I had the same thing on a clients server, it would re-direct when trying to access /admin/ - strangely the code worked perfectly on my server! Anyway - we got around it by adding the rule below into the htaccess file, it stops the rewrite rule when the site is accessed via SSL - so https://www.theserver.com/admin/ would still enter the admin. Doesn't solve the issue itself but it a workaround if you have SSL. RewriteCond %{SERVER_PORT} !^443$
  4. Have you tried the fix presented in this post? Appears to work for me - haven't fully tested it (too busy reading 88 pages of this thread) :)
  5. Thanks Ralph, I'd agree with your points re: usability, but I think it's a step in the right direction. I think the combined drop down with a list of all available (in stock) combinations would be a good solution - I'd guess it would need to combine the various option values into a single value - then extract it during the add to cart function. Certainly should be more compatible than my script (which is pretty much a store dependant hack). Am in two minds currently whether displaying an "out of stock" message or simply hiding the option is the best approach... think I'll leave mine as is currently as it may prevent confusion. Look forward to seeing your developments! :)
  6. Hi all - I've just installed the latest version of QTpro and it's working like a charm! It really has come on along nicely since I last used it (thanks Ralph!). :D I've made a few mods to my install to make the drop-down system more intuitive - it uses JavaScript to display the stock levels for each colour / size, updating the stock info as you change between colours, etc... eliminating the problem where customers can add products to the basket when the specific colour / size is not available (if you should wish). It also forces selection of each specific option, meaning people can't checkout without specifically selecting colours, sizes, etc. It's probably not suited to all stores, only those with size and colour options for the majority of their products... also is *completely* dependant on JavaScript, which may be a worry to some people (I usually force it in admin). If anyone wants to be a guinea pig and try it out, drop me a message and I'll post the code! Example link below - http://store-02.richerdesigns.co.uk/produc...?products_id=51 Cheers :)
×
×
  • Create New...