Jump to content

Kayti

Members
  • Content count

    58
  • Joined

  • Last visited

About Kayti

  • Birthday 09/10/1972

Profile Information

  • Real Name
    Katie
  • Gender
    Female
  • Website
  1. Hi I'd be grateful if anyone could help please. I receive the following error when trying to duplicate a product (there is no problem using Link To). 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 '0')' at line 1 insert into products_description (products_id, language_id, products_name, products_description, products_spec, products_musthave, products_extraimage, products_manual, products_extra1, products_moreinfo, products_url, products_viewed) values ('535', '1', '………………', ' I use MySQL version 4.1.22-standard. I have Product Tabs [http://www.oscommerce.com/community/contributions,2610] installed. Many thanks in advance for any help. Katie
  2. Hi I'd be really grateful for some feedback I've just installed this contribution and got the following error: Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/***/public_html/admin/categories.php on line 83 I've used this contribution before in the past with no problems, however this is the first time I've used it with Header Tags 2.6.3. Any assistance of either a fix or if anyone knows a header tags contribution that does work with Ultimate SEO URLS I've no problem uninstalling the other one to install an alternative. Again thank you in advance for help. Many thanks Katie
  3. Kayti

    Abstract Zones

    Hi Mark, No I'm afraid those changes make no difference it still treats each zone the same and doesn't show both shipping options for products in the Collect?Individual Prices zone. Many thanks Kate
  4. Kayti

    Abstract Zones

    Hi Mark, Thanks for getting back to me so quickly, here goes the code: Shipping Module: pickup <?php /* $Id: pickup.php,v 1.40 2003/02/05 22:41:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class pickup { var $code, $title, $description, $icon, $enabled; // class constructor function pickup() { global $order; $this->code = 'pickup'; $this->title = MODULE_SHIPPING_PICKUP_TEXT_TITLE; $this->description = MODULE_SHIPPING_PICKUP_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_PICKUP_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_PICKUP_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_PICKUP_STATUS == 'True') ? true : false); if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_PICKUP_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_PICKUP_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } //-MS- Active Shipping Added if( $this->enabled == true && function_exists('tep_check_active_zone') ) { $this->enabled = tep_check_active_zone(MODULE_SHIPPING_PICKUP_ACTIVE_ZONE, MODULE_SHIPPING_PICKUP_ACTIVE_MODE); } //-MS- Active Shipping Added EOM } // class methods function quote($method = '') { global $order; $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_PICKUP_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_PICKUP_TEXT_WAY, 'cost' => MODULE_SHIPPING_PICKUP_COST))); if ($this->tax_class > 0) { $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title); return $this->quotes; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_PICKUP_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Customer Pickup', 'MODULE_SHIPPING_PICKUP_STATUS', 'True', 'Do you want to offer customer pickup?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Pickup Fee', 'MODULE_SHIPPING_PICKUP_COST', '0.00', 'The fee for all orders being picked up by the customer. Most likely will be 0.00 but can be changed if needed.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_PICKUP_TAX_CLASS', '0', 'Use the following tax class on the fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_PICKUP_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); //-MS- Active Shipping Added tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Active Shipping', 'MODULE_SHIPPING_PICKUP_ACTIVE_ZONE', '0', 'Use the following active zone to activate the module based on categories-products.', '6', '0', 'tep_get_active_zone_title', 'tep_cfg_pull_down_active_zones(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Mode of Operation', 'MODULE_SHIPPING_PICKUP_ACTIVE_MODE', 'Inclusive', 'Inclusive: Enables the module if one product is found to be covered by the active zone.<br>Exclusive: Enables the module if all products in the cart are covered by the active zone', '6', '0', 'tep_cfg_select_option(array(\'Inclusive\', \'Exclusive\'), ', now())"); //-MS- Active Shipping Added EOM tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_PICKUP_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { //-MS- Active Shipping Added return array('MODULE_SHIPPING_PICKUP_STATUS', 'MODULE_SHIPPING_PICKUP_COST', 'MODULE_SHIPPING_PICKUP_TAX_CLASS', 'MODULE_SHIPPING_PICKUP_ZONE', 'MODULE_SHIPPING_PICKUP_ACTIVE_ZONE', 'MODULE_SHIPPING_PICKUP_ACTIVE_MODE', 'MODULE_SHIPPING_PICKUP_SORT_ORDER'); //-MS- Active Shipping Added EOM } } ?> and Shipping Module: pickupi <?php /* $Id: pickupis.php,v 1.40 2003/02/05 22:41:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class pickupis { var $code, $title, $description, $icon, $enabled; // class constructor function pickupis() { global $order; $this->code = 'pickupis'; $this->title = MODULE_SHIPPING_PICKUPIS_TEXT_TITLE; $this->description = MODULE_SHIPPING_PICKUPIS_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_PICKUPIS_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_PICKUPIS_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_PICKUPIS_STATUS == 'True') ? true : false); if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_PICKUPIS_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_PICKUPIS_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } //-MS- Active Shipping Added if( $this->enabled == true && function_exists('tep_check_active_zone') ) { $this->enabled = tep_check_active_zone(MODULE_SHIPPING_PICKUPIS_ACTIVE_ZONE, MODULE_SHIPPING_PICKUPIS_ACTIVE_MODE); } //-MS- Active Shipping Added EOM } // class methods function quote($method = '') { global $order; $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_PICKUPIS_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_PICKUPIS_TEXT_WAY, 'cost' => MODULE_SHIPPING_PICKUPIS_COST))); if ($this->tax_class > 0) { $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title); return $this->quotes; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_PICKUPIS_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Customer Pickup', 'MODULE_SHIPPING_PICKUPIS_STATUS', 'True', 'Do you want to offer customer pickupis?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Pickup Fee', 'MODULE_SHIPPING_PICKUPIS_COST', '0.00', 'The fee for all orders being picked up by the customer. Most likely will be 0.00 but can be changed if needed.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_PICKUPIS_TAX_CLASS', '0', 'Use the following tax class on the fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_PICKUPIS_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); //-MS- Active Shipping Added tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Active Shipping', 'MODULE_SHIPPING_PICKUPIS_ACTIVE_ZONE', '0', 'Use the following active zone to activate the module based on categories-products.', '6', '0', 'tep_get_active_zone_title', 'tep_cfg_pull_down_active_zones(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Mode of Operation', 'MODULE_SHIPPING_PICKUPIS_ACTIVE_MODE', 'Inclusive', 'Inclusive: Enables the module if one product is found to be covered by the active zone.<br>Exclusive: Enables the module if all products in the cart are covered by the active zone', '6', '0', 'tep_cfg_select_option(array(\'Inclusive\', \'Exclusive\'), ', now())"); //-MS- Active Shipping Added EOM tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_PICKUPIS_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { //-MS- Active Shipping Added return array('MODULE_SHIPPING_PICKUPIS_STATUS', 'MODULE_SHIPPING_PICKUPIS_COST', 'MODULE_SHIPPING_PICKUPIS_TAX_CLASS', 'MODULE_SHIPPING_PICKUPIS_ZONE', 'MODULE_SHIPPING_PICKUPIS_ACTIVE_ZONE', 'MODULE_SHIPPING_PICKUPIS_ACTIVE_MODE', 'MODULE_SHIPPING_PICKUPIS_SORT_ORDER'); //-MS- Active Shipping Added EOM } } ?> I thought pickup and pickupi were correct because in some instances they are handled correctly. As a test I changed Collect handled by pickup exclusive to inclusive and with a product from Collect and a product from Collect/Individual Prices in the cart individual prices, pickup and pickupi are shown. Then if I change Collect handled by pickup back to exclusive with the same two products in the cart I have individual prices and pickupi available suggesting that the three shipping modules are correct (I hoped). It's only when I take the Collect handled by pickup exclusive product out of the cart the problem occurs, with only an Individual Prices/Collect product handled by individual prices inclusive and pickupi inclusive in the cart, only individual prices is available when it should be individual prices and pickupi. Sorry this is a bit complicated, if it's easier if you have a look let me know and I'll PM you shop details (it's not live yet). Many thanks for your help. Katie
  5. Kayti

    Abstract Zones

    Hi Mark Thanks for the link to this contribution, it's great. I'm a bit stuck on getting it working fully and wondered if you could point me in the right direction please. Products are either 1. Buyer to Pickup or 2. Individual Shipping Prices or Buyer to Pickup as selected by the buyer. I've created two shipping zones: 1. Collect - contains only products that are Buyer to Pickup 2. Collect/Individual Prices - contains products buyer to choose shipping option Shipping modules installed: 1. individual prices 2. pickup 3. pickupi (a duplicate of pickup to use) I've then set up: - pickup - Collect - exclusive - pickupi - Collect/Individual Prices - inclusive - individual prices - Collect/Individual Prices - inclusive Two of three buyer cart options work perfectly, but the last one doesn't and I really don't understand why: - Product(s) in cart from Collect zone gives buyer pickup option only - perfect - Products in cart from Collect and Collect/Individual Prices zones gives buyer individual prices and pickupi - perfect (the exclusive setting on pickup ensures this option is not included to give the buyer two pickup options) - Product(s) in cart from Collect/Individual Prices zone gives the buyer individual prices option only but it should give individual prices and pickupi I've been looking at this for some time now and can't see where I've gone wrong. I'd be very grateful for help. Many thanks Katie
  6. Kayti

    Secpay Help!

    Hi It may also be worth adding to this thread that you must not have any gaps in your shop name when using SecPay (it took me sometime to work this out >_< ). Cheers Katie
  7. Kayti

    Seperate Pricing Per Customer v3.5

    Hi JanZ The store is up and running now, however there are 50,000 products to go in! I've installed Easy Populate, which is working fine on Group 0 (retail group) but not Group 1 (trade/wholesale group). I have SPPC and SPPC Attributes installed, I'll worry about the attributes bit later (maybe), but it would be really great if I could get the separate prices working. Have you looked at this contribution before? When I download the csv file it doesn't include the Table Products Groups fields customers_group_price or customers_group_id and if I add them manually to the csv file and upload it just ignores them. There isn't much code in EP that relates to SPPC and I've done the obvious (I hope) and check the correct table name and field names have been used. I'd really value any comments you can offer on this. Thank you Katie // this is for the separate price per customer module (lines 563 - 584) if (isset($filelayout['v_customer_price_1'])){ $sql2 = "SELECT customers_group_price, customers_group_id FROM ".TABLE_PRODUCTS_GROUPS." WHERE products_id = " . $row['v_products_id'] . " ORDER BY customers_group_id" ; $result2 = tep_db_query($sql2); $ll = 1; $row2 = tep_db_fetch_array($result2); while( $row2 ){ $row['v_customer_group_id_' . $ll] = $row2['customers_group_id']; $row['v_customer_price_' . $ll] = $row2['customers_group_price']; $row2 = tep_db_fetch_array($result2); $ll++; } } //lines 1311-1336 case 'priceqty': $iii = 0; // uncomment the customer_price and customer_group to support multi-price per product contrib $filelayout = array( 'v_products_model' => $iii++, 'v_products_price' => $iii++, 'v_products_quantity' => $iii++, 'v_customer_price_1' => $iii++, 'v_customer_group_id_1' => $iii++, 'v_customer_price_2' => $iii++, 'v_customer_group_id_2' => $iii++, #'v_customer_price_3' => $iii++, #'v_customer_group_id_3' => $iii++, #'v_customer_price_4' => $iii++, #'v_customer_group_id_4' => $iii++, ); $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_price as v_products_price, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity FROM ".TABLE_PRODUCTS." as p "; break; // for the separate prices per customer (SPPC) module (lines 2286-2357) $ll=1; if (isset($v_customer_price_1)){ if (($v_customer_group_id_1 == '') AND ($v_customer_price_1 != '')) { echo "<font color=red>ERROR - v_customer_group_id and v_customer_price must occur in pairs</font>"; die(); } // they spec'd some prices, so clear all existing entries $result = tep_db_query(' DELETE FROM '.TABLE_PRODUCTS_GROUPS.' WHERE products_id = ' . $v_products_id ); // and insert the new record if ($v_customer_prices_1 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_1 . ', ' . $v_customer_price_1 . ', ' . $v_products_id . ', ' . $v_products_price .' )' ); } if ($v_customer_price_2 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_2 . ', ' . $v_customer_price_2 . ', ' . $v_products_id . ', ' . $v_products_price . ' )' ); } if ($v_customer_price_3 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_3 . ', ' . $v_customer_price_3 . ', ' . $v_products_id . ', ' . $v_products_price . ' )' ); } if ($v_customer_price_4 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_4 . ', ' . $v_customer_price_4 . ', ' . $v_products_id . ', ' . $v_products_price . ' )' ); } } // end: separate prices per customer (SPPC) module
  8. Thanks for getting back to me Todd. I'll keep an eye on this thread to hear about updates and compatibility with SPPC; it would be very much appreciated if you get it working. If I do manage to get anywhere myself I'll post it up here for your feedback. Cheers Kayti
  9. Hi Todd, Have uncommented as per below: $filelayout = array( 'v_products_model' => $iii++, 'v_products_price' => $iii++, 'v_products_quantity' => $iii++, 'v_customer_price_1' => $iii++, 'v_customer_group_id_1' => $iii++, 'v_customer_price_2' => $iii++, 'v_customer_group_id_2' => $iii++, #'v_customer_price_3' => $iii++, #'v_customer_group_id_3' => $iii++, #'v_customer_price_4' => $iii++, #'v_customer_group_id_4' => $iii++, ); and uncommented all the SPPC code starting: // this is for the separate price per customer module if (isset($filelayout['v_customer_price_1'])){ $sql2 = "SELECT customers_group_price, customers_group_id FROM ".TABLE_PRODUCTS_GROUPS." WHERE products_id = " . $row['v_products_id'] . " ORDER BY customers_group_id" ; I can't find anything else that references SPPC. Downloaded the prices/quantity file but there are no SPPC columns included. Added name/description columns plus v_customer_price_N and v_customer_price_group_N manually and did the upload and the details insert OK into the retail group (0) but not into the trade (Group 1). Queried the product_groups table and the entries have not inserted into the table. Also tried using a Complete file and inserted v_customer_price_N and v_customer_price_group_N manually before v_manufacturers_name, same results as above, group 0 is fine but no entry into group 1. Have I missed some code to uncomment somewhere? Also, instruction states: Open your /catalog/admin/includes/configure.php file and set DOCUMENT_ROOT TO $DOCUMENT_ROOT DO THIS!! I now have the following error on admin/file_manager.php (not that I use this but I don't like errors just in case they are duplicated elsewhere I haven't found yet): Warning: dir(DIR_FS_DOCUMENT_ROOT) [function.dir]: failed to open dir: No such file or directory in /home/**/public_html/admin/file_manager.php on line 178 Fatal error: Call to a member function on a non-object in /home/**/public_html/admin/file_manager.php on line 179 Presumably I need to change something in admin/file_manager.php so it is happy with $DOCUMENT_ROOT instead of DOCUMENT_ROOT do I? Many thanks for your help. Katie.
  10. Hi I need some instruction on how to integrate this with SPPC too. I have SPPC v415 and SPPC Attributes Module installed. EP installed, the csv file will update the the first pricing category (retail) but not the second (trade). I've uncommented the two groups in the filelayout_array as per the manual instructions: $filelayout = array( 'v_products_model' => $iii++, 'v_products_price' => $iii++, 'v_products_quantity' => $iii++, 'v_customer_price_1' => $iii++, 'v_customer_group_id_1' => $iii++, 'v_customer_price_2' => $iii++, 'v_customer_group_id_2' => $iii++, #'v_customer_price_3' => $iii++, #'v_customer_group_id_3' => $iii++, #'v_customer_price_4' => $iii++, #'v_customer_group_id_4' => $iii++, ); However there in just no column for the trade category in the csv file. I get nothing for product attributes either, no columns in the csv file. Any help would be gratefully appreciated. Many thanks Katie
  11. Kayti

    Seperate Pricing Per Customer v3.5

    Hi JanZ, Exactly that problem, I had left the "@" for hide_from_groups last in the order on the insert query. :blush: Thank you again. Katie :thumbsup:
  12. Kayti

    Seperate Pricing Per Customer v3.5

    Hi JanZ I have needed to add attrib sort v1.2 so we can specify the attribute sort order (they were getting in an awful mess without this added). On the first insert it defaults to 0 and won't input a value until we go back and use the edit option, then the correct order is added. With SPPC and SPPC Attributes installed is there some sort of conflict to resolve on the insert button? Many thanks Katie
  13. Hi Can anyone help please. I have Attribute Sort Order installed, when I enter the sort order number it defaults to 0 when I click Insert. If I then update the input using Edit the sort order field updates fine. [Have also got SPPC and the attributes module installed]. Many thanks in advance. Katie
  14. This is an opening thread for a new contribution Lead Time Varying Information. I created this contribution because I couldn't find anything similar. I needed to provide a simple information sentence in the checkout_shipping.php page that notified the customer of the lead time. This was to be updated when necessary by the store owner who did not want to run a SQL query or change code on the php files, even the languages files. The contribution creates a new page in the Configuration menu called LEAD TIME (see screenshot). The value can be editted in a textarea the same as the stores address details. You can write letters or numbers in here. This creates a CONSTANT called LEAD_TIME which can be called in a languages file anywhere you need. I've added this in a new infoBox at the top of the shipping page. Since the store owner would be updating this himself occasionally I have changed the admin\index.php so that it is a link from there. Under the Configuration menu I have replaced Cache with Lead Time. Simply change the text you use and this contribution can be used to provide any information you like. This is running fine with Separate Pricing per Customers, Shipdate and Ultimate SEO URL plus a whole pile of smaller modifications installed.
  15. Kayti

    Batch Update Status Support

    Hi (again) I've just found your posts of 7th Dec and sorted the above perfectly (apologies for not seeing it before)! Many thanks for a great contribution. Katie
×