Guest Posted March 23, 2003 Share Posted March 23, 2003 This module works like the pickup shipping method + you can have multiple stores (pickup addresses) + still works for 1 store + adjusts the delivery address to the address of the selected shop + stores can be added in the admin Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2003 Share Posted March 23, 2003 http://www.oscommerce.com/community/contributions,1097 Quote Link to comment Share on other sites More sharing options...
edwardkirwin Posted April 15, 2003 Share Posted April 15, 2003 HELP!!  I have installed your package but get the following error when in the admin/catalog/stores option  1146 - Table 'test.stores' doesn't exist  select count(*) as total FROM stores  [TEP STOP]  This is from the stores.php page  Can you assist please?  Cheers  Edward :roll: Quote Link to comment Share on other sites More sharing options...
Guest Posted April 15, 2003 Share Posted April 15, 2003 Warning: Cannot modify header information - headers already sent by (output started at /home/customers/i/n/t/intekcommunications.net/shopadmin/includes/application_top.php:587) in /home/customers/i/n/t/intekcommunications.net/shopadmin/includes/functions/general.php on line 18 Â Â Any ideas? Â is this the suspect bit of code off line 18 in general.php? Â header('Location: ' . $url); Â Â Blinding mod if i can get him working! Quote Link to comment Share on other sites More sharing options...
Guest Posted April 16, 2003 Share Posted April 16, 2003 Sorry guys, I am skiing in the alps right now.... So I will get back to you when i am back home (tuesday next week)... Â Edward, you should run the sql statement included in the download that creates the table Quote Link to comment Share on other sites More sharing options...
Emmtee Posted May 7, 2003 Share Posted May 7, 2003 Very nice module, anyway i'd really like the shipping adress set to the selected store adress so it shows up on the invoice etc... Quote http://www.oscommerce.com/community/contributions,1762 Link to comment Share on other sites More sharing options...
ikama Posted June 18, 2003 Share Posted June 18, 2003 Really a nice contri. However customers shiping-adress is still shown in Confirmation-Mail. Instead of, should be the right pickup-address! Quote Link to comment Share on other sites More sharing options...
jobjonah Posted December 2, 2003 Share Posted December 2, 2003 Thanks for the nice contribution. I have it in MS2 and the address is somehow giving my tax computation a problem. If I ship UPS to myself I get charged 7.75% sales tax but if Store Pickup is indicated no tax is added. Â Thanks for the careful documentation. It is my 10th contribution install and the best documentation of the 10. Quote Link to comment Share on other sites More sharing options...
ShinXP Posted January 30, 2004 Share Posted January 30, 2004 (edited) Hi, Thank for this module, but i have an error >_< Â 1062 - Duplicate entry '2' for key 1Â insert into address_book (entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_company, entry_suburb, entry_state, entry_zone_id, customers_id, address_book_id) values ('A Definir', 'A Definir', '8 Rue Barbaroux', '83170', 'Brignoles', '73', 'CyberEspace Ourson Surfeur', '', '', '85', '0', '2') Â [TEP STOP] Â I'm on MS2 ... Â Anyone could help me ?? Â Thank Edited January 30, 2004 by ShinXP Quote Link to comment Share on other sites More sharing options...
jobjonah Posted January 30, 2004 Share Posted January 30, 2004 Try taking out one of those 'A Definir', and see if that get's rid of the error. Quote Link to comment Share on other sites More sharing options...
jernst Posted March 3, 2004 Share Posted March 3, 2004 I have a problem using this excellent contribution with taxe/zones: the taxes are not applied because the address is emptied out at some point when it is replaced by the shop's address (I think). Â Can you help ? Â thanks, Quote Link to comment Share on other sites More sharing options...
jobjonah Posted March 3, 2004 Share Posted March 3, 2004 I had to give up on this one and used http://www.oscommerce.com/community/contributions,598/page,4 back on 12/24/03. It's in German, but real easy to figure out and it worked. Quote Link to comment Share on other sites More sharing options...
adegio Posted March 4, 2004 Share Posted March 4, 2004 Try this: Â 1. Open file admin/stores.php 2. Find the line that starts with $max=tep_db_fetch_array(tep_db_query(" Â 3. Replace the entire line with this line: $max=tep_db_fetch_array(tep_db_query("select max(s.stores_id)+1 as max_stores_id, max(a.address_book_id)+1 as max_address_id FROM " . TABLE_ADDRESS_BOOK . " a, " . TABLE_STORES . " s")); Â Good luck! :D Quote Link to comment Share on other sites More sharing options...
Guest Posted May 9, 2004 Share Posted May 9, 2004 This mod actually works great for my needs. I created a page to display the different pickup locations dynamically and link to a yahoo map for the location.  At this time it is a crude looking hack for a cart I'm working on. Its MS2 with BTS and some other mods, so you may need to modify it to fit for you. The map feature works for US only. To change for your location visit yahoomaps.  <table> <?php    $sql = "select s.*, a.*, z.* from stores s, address_book a, zones z where s.address_book_id = a.address_book_id and a.customers_id = 0 and z.zone_id = a.entry_zone_id";  $qstores = tep_db_query($sql);   while ($store = tep_db_fetch_array($qstores)) {  $company = $store['entry_company'];  $street = $store['entry_street_address'];  $city = $store['entry_city'];  $state = $store['zone_name'];  $zip = $store['entry_postcode'];     $map = "http://us.rd.yahoo.com/maps/us/insert/Tmap/extmap/*-http://maps.yahoo.com/maps_result?addr=" . urlencode($street) . "&csz=" . urlencode($city) . "," . urlencode($state) . "%20" . urlencode($zip);    echo "<tr>";  echo "<td class=\"boldmain\">" . $company . "</td>";  echo "</tr><tr>";  echo "<td class=\"main\">" . $street . "</td>";  echo "<td class=\"main\">" . $city . "</td>";  echo "<td class=\"main\">" . $state . "</td>";  echo "<td class=\"main\">" . $zip . "</td>";  echo "<td class=\"main\"><a href=". $map . " target=\"_blank\">Map it</a></td>";  echo "</tr>";  }   ?>  </table> Quote Link to comment Share on other sites More sharing options...
THX Posted May 30, 2004 Share Posted May 30, 2004 Anyone been able to work out the tax issue with this contrib? or the fact the address does not display inside the order confirmed email that is sent to the customer? Quote Link to comment Share on other sites More sharing options...
THX Posted May 31, 2004 Share Posted May 31, 2004 anyone?? Quote Link to comment Share on other sites More sharing options...
THX Posted June 5, 2004 Share Posted June 5, 2004 *bump* again Quote Link to comment Share on other sites More sharing options...
mentalskylight Posted March 19, 2005 Share Posted March 19, 2005 I am using the Multi Pickup (MS1) on my (somewhat modified) installation of MS2. After some pain and suffering, I have managed to get the contribution to deal with the tax elements properly (at least on my installation :-))  In the hope that I can help someone avoid the same pain, here are the changes I made. Use them entirely at your own risk!  I have assumed that you have installed the Multi Pickup (MS1) 1.0 contribution exactly as per install instructions. Now....  1. In /catalog/includes/classes/order.php locate the following section:    // for multiple pickup... delivery is one of the company addresses   $arrship=explode('_',$shipping['id']);   if($arrship[0]=='multipickup'){    $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '0' and ab.address_book_id = '" . $sendto . "'");   }else{    $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '" . $customer_id . "' and ab.address_book_id = '" . $sendto . "'");   }   // eo for multiple pickup... delivery is one of the company addresses  2. Replace it with the following:    // for multiple pickup... delivery is one of the company addresses   $arrship=explode('_',$shipping['id']);   if($arrship[0]=='multipickup'){    $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '0' and ab.address_book_id = '" . (int)$sendto . "'");   }else{    $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '" . (int)$customer_id . "' and ab.address_book_id = '" . (int)$sendto . "'");   }   // eo for multiple pickup... delivery is one of the company addresses  3. In the same file, just a bit further on, locate the following:     $tax_address_query = tep_db_query("select ab.entry_country_id, ab.entry_zone_id from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) where ab.customers_id = '" . (int)$customer_id . "' and ab.address_book_id = '" . (int)($this->content_type == 'virtual' ? $billto : $sendto) . "'");  4. Replace it with the following (be very careful - only replace the section identified above!):    // for multiple pickup... delivery is one of the company addresses   $arrship=explode('_',$shipping['id']);   if($arrship[0]=='multipickup'){    $tax_address_query = tep_db_query("select ab.entry_country_id, ab.entry_zone_id from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) where ab.customers_id = '0' and ab.address_book_id = '" . (int)($this->content_type == 'virtual' ? $billto : $sendto) . "'");   }else{    $tax_address_query = tep_db_query("select ab.entry_country_id, ab.entry_zone_id from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) where ab.customers_id = '" . (int)$customer_id . "' and ab.address_book_id = '" . (int)($this->content_type == 'virtual' ? $billto : $sendto) . "'");   }   // eo for multiple pickup... delivery is one of the company addresses  If you look carefully, you will see that the only changes I have made are to change the $customer_id to (int)$customer_id and $sendto to (int)$send_to in the shipping_address_query and then to apply the same logic to the tax_address_query. It worked for me, hopefully it will work for you. Good Luck!!  PS Nothing to do with the tax elements, but make sure you have followed the changes recommended by this post  http://www.oscommerce.com/forums/index.php?sho...ndpost&p=321224  and you will have a great contribution working on your site! Quote Link to comment Share on other sites More sharing options...
Geordiedan Posted August 1, 2005 Share Posted August 1, 2005 Hi all, Â I've set this up and it's allowing me to add stores etc.. Â Only thing is I can't see where you select the pickup as a shipping method when checking out?? Â Do I need to have several shipping modules installed, or just one particular one? Â I'm probably just being stupid again ;) Â Cheers, Â Dan Quote Link to comment Share on other sites More sharing options...
Geordiedan Posted August 1, 2005 Share Posted August 1, 2005 I'm probably just being stupid again ;) <{POST_SNAPBACK}> Â Yup - guess who didn't see "pick up" in the shipping screen :'( :blush: :P Â Anyone else using this mod? Â Dan Quote Link to comment Share on other sites More sharing options...
Geordiedan Posted August 9, 2005 Share Posted August 9, 2005 Has anyone found a fix for Delivery Address not showing up in the confirmation emails yet? Â Thx, Â Dan :) Quote Link to comment Share on other sites More sharing options...
Geordiedan Posted October 11, 2005 Share Posted October 11, 2005 Right - I've got this working great for one store, but I want to set up more stores, and limit which are visible to the customer depending on which 'zone' they select when they register. Â The Admin tool lets me assign each store a zone, but they're all shown to the customer at checkout. Â Is there a way to limit the stores shown to the customer, based on this Zone setting? Â This would make my day ;) Â Thanks, Â Dan :) Quote Link to comment Share on other sites More sharing options...
azer Posted October 31, 2005 Share Posted October 31, 2005 it seems that ther is not so much people using this contrib while it s very interresting .. what about the contributor ? Quote MS2 Link to comment Share on other sites More sharing options...
paccoral Posted November 18, 2005 Share Posted November 18, 2005 Looking into this as we have several locations that we would like customers to pick up product. will run this on a demo site first my first experience was not good. reinstalled original site and will test again Quote Link to comment Share on other sites More sharing options...
ozEworks Posted January 6, 2006 Share Posted January 6, 2006 Does this cater for stock control at each store? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.