Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NigelW

Pioneers
  • Posts

    17
  • Joined

  • Last visited

Profile Information

  • Real Name
    Nigel
  • Gender
    Male

Recent Profile Visitors

6,742 profile views

NigelW's Achievements

  1. Hi just seen this thread whilst browsing through things, it's probaly not much help to @@chipshi11 now but hopefully this may help anyone else with this issuse who reads this. There is an addon for UK postcode shipping, it's made for v2.2 - UK Postcode based carrier shipping Hopefully this can be modified to 2.3.4 as I hope to use it, I have it installed on a 2.2 site and with a bit of tweaking can support different carriers (by modifying the name of the module etc.) The hardest part is getting a current list of the outbound postcodes as it's a heavily guarded Royal Mail asset - paid for by the general public ! A fairly up-to-date copy of the postcode list can be found at the Office for National Statistics - click here - and search for 'postcode' The problem with this link is that it contains every postcode along with the location data (great if your writing a navigation app B) ), so it needs a bit of parsing as it's only 1.21Gb small (uncompressed) Alternatively ask your carrier if the have a postcode to charge zone list that you can import. If anyone wants anymore info please feel free to pm me.
  2. @@KeesB I know it's a while since your post, but it occurs to me that your problem may be the width of your info box, or the length of your category, causeing the sub-categorey icon to wrap. Just a thought :)
  3. Just a quick update to anyone following this thread, wdepot has updated this add-on, and it now works as it should., so if you have had issues with it try out again download from http://addons.oscommerce.com/info/8561
  4. Been struggling with this all day (with the osc 2.3 version on the addon), I have also had the 'upate' error warning about the date values not being seperated by a "-". As g2777 pointed out the db is not being updated, and there is no field to enter the date in the admin page. On closer inspection of the admin page there seems to be a bit of code missing around line 317. from the addon it reads: <tr class="dataTableRow"> <td class="dataTableContent"> Account verification start date (yyyy-MM-dd)</td> <td class="dataTableContent"> <script language="javascript"> bgnVerify.writeControl(); bgnVerify.dateFormat="yyyy-MM-dd";</script></td> </tr> I added an input box to it (after the </script> tag) and all seems to be working, at least no more errors and the db is updating the lines now read: <tr class="dataTableRow"> <td class="dataTableContent"> Account verification start date (yyyy-MM-dd)</td> <td class="dataTableContent"> <script language="javascript"> bgnVerify.writeControl(); bgnVerify.dateFormat="yyyy-MM-dd";</script> <?php echo tep_draw_input_field('bgn_verify_date', ACCOUNT_VERIFY_DATE, 'size="10"'); ?></td> </tr> I remember having this problem when I tried to add this to my 2.2 store, so I guess the same solution may work for 2.2 as well B)
  5. I have made a lot of changes to my store, so the code my not be exactly the same. Off the top of my head, the mods that might affect the code are QPBPP, Product Quick Edit, Ultra Pics, Bundled Products, No Default Shipping Method & UK Postcode based carrier shipping, these have all been tweaked to make the site work the way we wanted, so again the code may not be exactly as released. My thanks to all those that developed the above mods First, BACKUP BACKUP BACKUP ! Follow the install instructions but do not update the database just yet (see further down), in the mod I made the following changes: \catalog\checkout_shipping.php on/about line 400 change to: <tr valign="middle"><td align="center" class="productInfo">If no shipping rates are available please check your postcode or contact us</td></tr> on line 336 change: if ($order->restrict_delivery == false || in_array($quotes[$i]['methods'][$j]['title'], $restrict_delivery_allowed) ) { to: if ($order->restrict_delivery == false || [color=#ff0000]![/color]in_array($quotes[$i]['module'], $restrict_delivery_allowed) ) { on line 341 change: $checked = (($quotes[$i]['id'] . '_' . $quotes[$i]['methods'][$j]['id'] == $shipping['id'] || ($order->restrict_delivery == true && $quotes[$i]['methods'][$j]['title'] == $restrict_delivery_allowed[0])) ? true : false); to: $checked = (($quotes[$i]['id'] . '_' . $quotes[$i]['methods'][$j]['id'] == $shipping['id'] || ($order->restrict_delivery == true && !$quotes[$i]['module'] == $restrict_delivery_allowed[0])) ? true : false); What does this do ? Basically the mod looks for the 'title' however this is wrong for my shipping modules, as this line is dynamic showing the shipping weight, so I want it to change it to look for the module name instead. I also want also the to make the mod check for files NOT in the list, this made it easier to eliminate the forms of shipping rather than allowing them (to leave this in it's original form leave out the ! in the line 336) The sql also needs to be changed: # Insert configuration key for Restrict Delivery shipping method INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Restrict Delivery shipping method', 'RESTRICT_DELIVERY_SHIPPING_METHOD', 'Interlink', 'Enter the module name(s) for shipping methods not allowed for restricted poducts seperated by ";". The module name is the bold title that appears in the shipping list', 7, 1, now(), NULL, NULL); #Add boolean field to Products table. Default value is 0, or "not restricted". alter table products add column products_restrict_delivery tinyint(4) not null default 0; The following section adds a 'Restrict Shipping' field to the Edit Product page in admin to allow easy assignment to a product \catalog\admin\categories.php line 326 insert: 'products_restrict_delivery' => tep_db_prepare_input($HTTP_POST_VARS['products_restrict_delivery']), lines 529, 539, 855, 1037 insert: products_restrict_delivery, after products_unit, line 539 insert: , '" . $product['products_restrict_delivery'] . "' after , '" . $product['products_unit'] . "' line 842 insert: 'products_restrict_delivery' => '', line 1337 after: <!-- EOF QPBPP --> <td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td> </tr> add: <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Resticted Shipping (1 for YES 0 for NO)</td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_restrict_delivery', $pInfo->products_restrict_delivery); ?></td> </tr> If Product Quick Edit mod is installed \catalog\admin\product_quickedit_info.php line 50 insert: p.products_restrict_delivery, before p.products_unit, line 61 insert (between the weight & unit lines: 'products_restrict_delivery' => tep_db_prepare_input($HTTP_POST_VARS['products_restrict_delivery']), Line 359 after: <tr> <td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td> <td class="main" colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td> </tr> insert: <tr> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Restrict Delivery<br>(1 = YES, 0 = No):</td> <td class="main" colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_restrict_delivery', $pInfo->products_restrict_delivery); ?></td> </tr> \catalog\admin\product_quickedit.php line 23 after the weight entry add: p.products_restrict_delivery, change code at lines 70-82 to read: <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="8%">Model</td> <td class="dataTableHeadingContent" width="8%">ID</td> <td class="dataTableHeadingContent" width="40%">Name</td> <td class="dataTableHeadingContent" width="2%"> </td> <td class="dataTableHeadingContent" align="right"width="8%">Price</td> <td class="dataTableHeadingContent" align="right"width="8%">Stock</td> <td class="dataTableHeadingContent" align="right"width="8%">Weight</td> <td class="dataTableHeadingContent" align="right"width="8%">limited</td> <td class="dataTableHeadingContent" align="right"width="8%">Edit</td> <td class="dataTableHeadingContent" align="right"width="2%"> </td> </tr> around lines 99-121 change the code to look like this: echo '<tr valign="middle"' . ($pID == $product['products_id'] ? 'bgcolor="#9999ff"' : (((int)($i/2)*2) == $i ? 'bgcolor="#DFE4F4"' : '')) . '>'; ?> <td width="8%" class="dataTableContent"><?php echo $product['products_model'];?></td> <td width="8%" class="dataTableContent"><?php echo $product['products_id'];?></td> <?php echo '<td width="40%" class="dataTableContent">' . '<b><a href="' . tep_href_link('product_quickedit_info.php', 'action=preview&read=only&pID=' . $product['products_id'] . '&prod_search=' . $prod_search) . '">' . $product['products_name'] . '</b>' . ($short ? '<br>' . $product['short_desc'] : '') . '</a>'; ?></td> <td width="2%"> </td> <td width="8%" class="dataTableContent" align="right"><?phpecho $currencies->display_price($product['products_price'], tep_get_tax_rate($product['products_tax_class_id'])) ; ?></td> <td width="8%" class="dataTableContent" align="right"><?phpecho $product['products_quantity']; ?></td> <td width="8%" class="dataTableContent" align="right"><?phpecho $product['products_weight']; ?></td> <td width="8%" class="dataTableContent" align="right"><?php if ($product['products_restrict_delivery']) echo 'YES'; ?></td> <td width="8%" class="dataTableContent" align="right"><?php // BOF Quick Attributes echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES_QUICK, 'pID=' . $product['products_id'].'&cPath='.$cPath, 'NONSSL') . '" target="_blank">' . tep_image(DIR_WS_IMAGES . 'icon_quick_attribute.png', IMAGE_ICON_QUICK_ATTRIBUTE) . '</a>'; // EOF Quick Attributes ?> <a href="<?php echo tep_href_link('product_quickedit_info.php', 'action=edit&pID='. $product['products_id'] .'&prod_search=' . $prod_search) ?>">Edit</a></td> <td width="2%" class="dataTableContent" align="right"> </td> </tr> <?php } } ?> The above is taken from the notes of changes I make to our site, I hope they are accurate enough to help you, but I cannot guarantee they are 100% as they were made a few years ago
  6. If I understand you correctly you trying to restrict the delivery options for bulky items, for example you send items by post and by carrier, and the bulky items will only go by carrier, so when someone chooses a bulky item they are not given the option for delivery by post. If that's the case you could use Restrict Delivery - despite what fat_dog says this module does work, though he is right about the documentation. I had to play around with a couple of things to make it work, I will dig out what I changed and post it up here for you
  7. Have had the same problem today, After a bit of searching I found a solution, basically the fix is to add (double) just after number_format( <td align="right" class="dataTableContent"> <input name="update_totals['.$i.'][value]" id="'.$id.'[value]" value="' . number_format((double)$order->totals[$i]['value'], 2, '.', '') . '" size="6"> Being reasonably new to php & mysql I really don't understand why this works - maybe someone can explain :unsure:
×
×
  • Create New...