Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

UncleSteve

Pioneers
  • Posts

    529
  • Joined

  • Last visited

Everything posted by UncleSteve

  1. Hi, I've taken a look at your site and a few others, but I notice no one seems to have an email option, is there a reason for this? Thanks
  2. When testing, I see information is sent to the book marking site, these being page title and url, then your left to make your own comments and tags. Is it possible to auto load the tags field from the page metatags perhaps? Thanks
  3. Is there two versions of this contrib, as there's two threads, so though two versions?
  4. Hi, Could someone give me a link to their site with this contrib running please as I'd like to see what its like before changing from what I already have. Thanks guy's Steve
  5. Hi, Could someone give me a link to their site with this contrib running please as I'd like to see what its like before changing from what I already have. Thanks guy's Steve
  6. Hi Jan, Thanks for your prompt reply. Unfortunately my coding ability is not up to the way you have presented your answer, sorry (I'm a copy and paste coder), plus my site is heavily modified, so line numbers are way out. Would you have time to modify the code below (subject to me pasting the correct bit) to show the retail price please? Thanks in advance for your time and efforts Steve $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.minorder, p.vendors_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //<!-- sam - code here for extra field to display phone number 2 --> $product_info = tep_db_fetch_array($product_info_query); $alt_tag = TEXT_ML; //added by sam $vendor_query = tep_db_query(" select vendors_phone2 from " . TABLE_VENDORS . " where vendors_id = '" . (int)$product_info['vendors_id'] . "'"); $vendor = tep_db_fetch_array($vendor_query); $free_shipping = $vendor['vendors_phone2']; //<!-- sam - end of code here for extra field to display phone number 2 --> tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Pricing per Customer if ($customer_group_id > 0) { // only need to check products_groups if customer is not retail $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } } // end if ($customer_group_id > 0) // EOF Separate Pricing per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { // BOF Separate Pricing per Customer if ($customer_group_id > 0) { // only need to check products_groups if customer is not retail $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } } // end if ($customer_group_id > 0) // EOF Separate Pricing per Customer $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText"><font color="#000000">[Order Code:' . $product_info['products_model'] . ']</font></span>'; } else { $products_name = $product_info['products_name']; } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading" valign="top"><?php echo $products_name; ?><BR> </td> <td class="pageHeading" align="center" valign="top"><?php echo $products_price; ?> <br>
  7. Is there a way to display the default price and the SPPC price in the product description, or perhaps to have an icon displayed when a special price is displayed! Or is there any other feature available like my idea? Thanks in advance :)
  8. In an effort to verify my files I uploaded a set of checkout_*.php from a virgin osc install. Only to find I still don't get any vendor emails :blink: I tried an order with the admin MVS set to true and false. So perhaps the error is not with these files. Any idea where else I should look please? Thinking aloud... seems strange that with the MVS modified files I should get vendor emails with MVS set to true. Is there a file outside the checkout_*.php files that I should look at? Thanks Steve If anyone can give me any pointers on this please, as I'm still struggling to get this sorted.
  9. I don't know the exact answer, but may be able to give a little help. See my pm.
  10. Depending how you set the system up, depends how the shipping is charged. You can have various suppliers whom you set up their various shipping charges, so for one, you can set it up as $10 per delivery, and the other $2 per item. then when the customer buys one item from each of your suppliers, they will have the products listed by supplier and what is being charged for shipping so your customer would be charged $12. However you can also set it up so goods are sent from various suppliers, but (as far as I know so far..) you need a common shipping cost across your product range, so you could set up the shipping so the customer is charged $1 per $10 spent, then have it capped at a max cost of $10. Basically there is all sorts of ways it can be set up. Payment methods is a different issue to MVS. Hope the above helps :)
  11. In an effort to verify my files I uploaded a set of checkout_*.php from a virgin osc install. Only to find I still don't get any vendor emails :blink: I tried an order with the admin MVS set to true and false. So perhaps the error is not with these files. Any idea where else I should look please? Thinking aloud... seems strange that with the MVS modified files I should get vendor emails with MVS set to true. Is there a file outside the checkout_*.php files that I should look at? Thanks Steve
  12. Sorted this, I can now see in the header is MVS is on or off :) I pasted in your code above, and I no longer have any error pages :) However...... with MVS switched off, I don't get any vendor emails :( Any idea where I should be looking to make good please? Thanks once again for your help :)
  13. I need the luck :) Thanks for your reply. I've looked for the bit of code you said to look for, and this is the nearest I can find //MVS - added insert for new orders_shipping table $shipping_array = $shipping['vendor']; foreach ($shipping_array as $vendors_id => $shipping_data) { $vendors_query = tep_db_query("select vendors_name from " . TABLE_VENDORS . " where vendors_id = '" . (int)$vendors_id . "'" ); $vendors_name = 'Unknown'; if ($vendors = tep_db_fetch_array($vendors_query)) { $vendors_name = $vendors['vendors_name']; } $shipping_method_array = explode ('_', $shipping_data['id']); if ($shipping_method_array[0] == 'fedex1') { $shipping_method = 'Federal Express'; } elseif ($shipping_method_array[0] == 'upsxml') { $shipping_method = 'UPS'; } elseif ($shipping_method_array[0] == 'usps') { $shipping_method = 'USPS'; } else { $shipping_method = $shipping_method_array[0]; } $sql_data_array = array('orders_id' => $insert_id, 'vendors_id' => $vendors_id, 'shipping_module' => $shipping_method, 'shipping_method' => $shipping_data['title'], 'shipping_cost' => $shipping_data['cost'], 'shipping_tax' => $shipping_data['ship_tax'], 'vendors_name' => $vendors_name, 'vendor_order_sent' => 'no' ); tep_db_perform(TABLE_ORDERS_SHIPPING, $sql_data_array); } //MVS End Which appears the same as from the original contrib. but without your second line of code shown in your suggestion if (SELECT_VENDOR_SHIPPING == 'true') { So I'm wondering if I've missed an up-date somewhere? With regards to your follow up I can only find one occurance of SELECT_VENDOR_SHIPPING in my database. Sorry, this bit has gone over my head. Can you advise further please? Thanks Steve
  14. I've been running MVS for over a year or so without problems. Please bare with me on this... I've now discovered you can 'switch' MVS off which the treats all the products as though they were being supplied by the one supplier, so the customer only gets charged one shipping charge. Right, I've switched off MVS and the check out process works fine up to the order conformation page, then I get an error message Warning: Invalid argument supplied for foreach() in /home/mydomain/public_html/store2/checkout_process.php on line 168 Warning: Cannot modify header information - headers already sent by (output started at /home/mydomain/public_html/store2/checkout_process.php:168) in /home/mydomain/public_html/store2/includes/functions/general.php on line 33 If I do a couple of page refreshes, I then get presented with the cart page (product have gone). From this process, the customer receives their email, but there are no products listed, though the total price and shipping charges are there. Nor do I get the admin email detailing the customer and what they ordered. I've replaced the two files which were listed in the error message (which are about a year or so old when I first set up MVS) but the errors are the same. Can anyone give me any indication of where the problem/s may lie please? Thanks for baring with me, and thank you in advance for any help and guidance you can give :)
  15. Now sorted :) I've never really studied some parts of the admin and the effects of 'switching' things on and off. For anyone who comes along with the same question as mine. In admin I found you can 'turn off' MVS (I thought it was a permanent fixture), but then you need to set up a shipping method to suit your overall requirements. I've been using a tired system, such as; 250:2.50,500:3.00,750:3.50,1000:4.00,1500:4.70,2000:5.88,3000:..... But if you have products with combined shipping costs, you need to add in front of the above line 0:0, so that the system doesn't add the minimum 2.50 charge.
  16. Hi Guy's I have a store with MVS which has been running for a couple of years. However I need to change the way the shipping charges are worked out and charged. I need to retain the way the back end purchase orders (the emails to the supplier) are raised for the individual suppliers, however for the front end I want the shipping calculated as if the supplies are from one vendor. Please bare with me for a moment while I explain. The reason for this is that a customer can buy two products from two of my suppliers, and based on product weight the customer can be charged £5 shipping on both products to give a total shipping charge of £10, but I'd like the system to look at the product weights as being from one supplier, and only charge the customer say £6. Which is what would happen in a standard OSC store. How can I achieve the above changes please? Thanks in advance for reading this and hopefully offering a positive reply :)
  17. Hi, Thanks for your post. Yes the shipping has been set up. but with several thousand products and a large amount of suppliers, I do occasionally miss one. The store has been running for several years. I just wanted to improve the basic message, so if it happens again, the customer is immediately presented with contact details, rather than having to faff around looking for them.
  18. Hi, I'm trying to modify part of my checking out process on my store which uses the MVS contrib. When the customer goes through the checkout and does not select a shipping method, an error message appears at the top of the page, such as "ERROR_NO_SHIPPING_SELECTED_SELECTED". This message is actioned from "mystore.com/checkout_payment.php" and seems to be actioned from the code below (I may be wrong though); // MVS start if a shipping method has not been selected for all vendors, redirect the customer to the shipping method selection page if (SELECT_VENDOR_SHIPPING == 'true') { // This test only works under MVS if (!is_array ($shipping['vendor']) || count ($shipping['vendor']) != count ($cart->vendor_shipping)) { // No shipping selected or not all selected tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, 'error_message=' . ERROR_NO_SHIPPING_SELECTED_SELECTED, 'SSL')); } } // MVS end In the language folder is "mystore.com/includes/languages/english/checkout_payment.php" but there was no 'define' for "ERROR_NO_SHIPPING_SELECTED_SELECTED" so I've added define('ERROR_NO_SHIPPING_SELECTED_SELECTED', 'new text message'); When testing, I still get "ERROR_NO_SHIPPING_SELECTED_SELECTED", rather than my new text. Should I include some sort of 'include' line at the top of the page? Can anyone guide me further on the above please? Thanks in advance for any help and guidance.
  19. Hi Guys. My install is working fine, so no problems there :) However.... My host is complaining my site is using too much processing power on the server :( :(. So I'm wondering if there are any known issues along this line with this contrib. ? Any help comments etc. will be welcomed please. Thanks Steve
  20. Thanks for your reply. I'm experimenting with Google Analytics at present, but I like the 'instant' report of Who's Online', which enables me to visit the source pages, especially search engines to see what search terms were used. Google Analytics is rather delayed.... Steve
  21. Hi, Thanks for your reply. I do advertise with Google, and I did try the analytics thing a couple of years or so back without much luck. I've taken another look after your suggestion and see their code has changed, so I'm trying it again. Thanks Steve
  22. Basically I'd like to track my visitors more effectively. I'm running the enhanced 'whose on line' (WOL) contribution which gives a rolling snapshot of visitors. I feel this contribution has a failing for me at least, where it tracks visitors to the OSC site/folder/catalog, however it doesn't track visitors that hit pages on my domain before they get transferred to the OSC pages. I don't wish to pull my non OSC pages (remnants of my old html store) as they have good presence in the search engines, thus attracting visitors/customers. As mentioned earlier, the WOL reports many visitors as arriving from my own pages, it would be nice to track where the visitor to any page on the site, rather than just to the OSC folder. Does anyone know if this is possible? Is it possible to create a log file from the information created by the rolling information in WOL? I've looked at my AWstats, but these don't give information like the search words used in search engines or what pages the visitors first hit. Thanks in advance for any help and comments :)
  23. Can anyone shed any light on my enquiry please?
  24. Hi Guy's, I have found that at the top of the customer store pages, I have this displayed which comes from the bottom of catalog/includes/includes/functions/whos_online.php as shown here tep_db_query("insert into " . TABLE_WHOS_ONLINE . " (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('" . (int)$wo_customer_id . "', '" . tep_db_input($wo_full_name) . "', '" . tep_db_input($wo_session_id) . "', '" . tep_db_input($wo_ip_address) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($wo_last_page_url) . "', '" . tep_db_input($_SERVER['HTTP_REFERER']) . "', '" . tep_db_input($user_agent) . "')"); } } ?> Can anyone help with its removal/making good please? Thanks in advance :)
  25. Hi Guy's, I've probably missed it (I have searched), but is there a way to include the non-osc pages on the same domain, though many are in different folders to my osc folder (commonly known as 'catalog'). My reason for this, is because many of my 'other' pages lead to the osc site. So rather that list the external page visitors have come from, many are listed as coming from my own site. Perhaps I haven't described myself very well, but hopefully you know where I'm coming from. Thanks in advance :)
×
×
  • Create New...