Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

lokust

Members
  • Content count

    14
  • Joined

  • Last visited

Everything posted by lokust

  1. lokust

    Free shipping for certain products only

    This is great. One update to this. My scenario: I'm using table rates based on price and want certain products to ship free. When only a free shipping product is in cart, the cost posted here is fine: if ($total_weight == 0) { $free_shipping = true; include(DIR_WS_LANGUAGES . $language . '/modules/order_total/ot_shipping.php'); } However if I have a mix of free shipping and non-free shipping products then this code will do the necessary checks: if (round($total_weight / 777) == $total_count) { $free_shipping = true; include(DIR_WS_LANGUAGES . $language . '/modules/order_total/ot_shipping.php'); } Note that I use the value "777" in product weight field to denote a free shipping product. You can use any numerical value you like.
  2. lokust

    OSC-Affiliate

    Hiya, I wonder if some kind soul could help me answer the following questions about this plugin: - When visitors click through and purchase goods how robust is OSC at tracking and reporting the sales? - Can we exclude certain products? - Can we exclude VAT and carriage?
  3. I have the Separate Pricing per Customer contribution installed. I have a question regarding how to display a message depending on customer group. So basically, if someone is not logged in or logged in as Retail customer group display text in template "All Prices include VAT" and if user is logged in as a Trade customer display "All Prices exclude VAT". To clarify - the text currently exists in the foot section of my templates. I'm using STS templates. Is there any was to detect the customer session and then display the correct message? Cheers.
  4. lokust

    [Contribution] Extra Fields

    Hi, I'm trying to replace the Price column in modules/product_listing.php with an extra field. (short story: customer would prefer to display unit price rather than the actual bulk price so I have created an extra field for Unit Price) So I have (with limited php knowledge) edited product_listing.php around line 112: $lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' '; and changed it to: (I am using STS and have applied the STS code for Product Extra Fields $lc_text = ' ' . $product_extra_fields_box . ' '; I get a blank column. I guess I'm also assuming that the variable $product_extra_fields_box is available to product_listing.php Could someone point me in the right direction for changing normal price display to an extra field? Cheers, Al
  5. Hi, I've followed the manual to install Easypopulate 2.90 on Milestone 2.2. Have updated my sql with the update file and when I goto catalog > easy populate and Click on any of the links in: Export and download catalog's and Froogle's file or Creation catalog's and Froogle's file in the directory temp - I get this error: 1054 - Unknown column 'p.products_price1_qty' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id :blink: Whatever is happening?
×