Jump to content

cigarsforless

♥Ambassador
  • Content count

    240
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by cigarsforless

  1. cigarsforless

    Multi_Vendor_Shipping new thread

    One Page Checkout and MVS? http://addons.oscommerce.com/info/6646 anyone had any luck getting the One Page Checkout contrib to work with MVS? have been using MVS for several years and would LOVE to get it to work with the new One Page Checkout contrib. anyone?
  2. cigarsforless

    Multi_Vendor_Shipping new thread

    Craig, I could kiss you! Thanks to your suggestions I have FINALLY got it working the way I want!!! Don't know what I would have done without you bud! If anyone is interested, I can post the code for my heavily modified vendor email (must say it looks darn good if I do say so myself) Thanks go out to you to Jim, the two of you have helped immensely and I can now stop banging my head against the wall :-)
  3. cigarsforless

    Multi_Vendor_Shipping new thread

    I feel just like the icon for Craig's user info. I'm banging my head and getting more frustrated by the minute. I have tried all 3 suggestions, in various forms and positions in the code and I'm always getting the same suffix added to each vendor email. When looking for code ideas from other pages, i think I have found the solution, but noooooo. even this bit of code returns the same value in each vendor email, yet it works perfectly in other pages. <snip> $package_num = sizeof($vendor_products); $box_num = $l + 1; for ($l=0, $m=sizeof($vendor_products); $l<$m; $l++) { $packageno = $box_num[$l] .' of ' . $vendors_count; </snip> what the above returns for ALL vendor emails (when I test with 3 vendors) is 1 of 3 The same code (or very similar) works perfectly in includes/vendor_order_data.php, includes/vendor_order_info.php, admin/orders.php, order_history.php etc but I can't get it to work in checkout_process.php for the life of me. think I'm gonna lose my mind over this stupid little issue of appending an a, b, c etc to the vendor email order numbers sigh....
  4. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim, I've managed to get it to work somewhat. I can append the Vendor ID to the order ID, but that does not match my existing order number format for multiple vendors. I'm having trouble figuring out how to have the "a" appended to the 1st vendor order and "b" appended to the 2nd vendor order etc. anything I have tried just appends the same value for all vendor emails ie: 1st vendor order 1234a, 2nd vendor 1234a etc when what I want is 1st vendor order 1234a, 2nd vendor 1234b etc thinking this must be set up near this part while ($vendor_order = tep_db_fetch_array($vendor_data_query)) { $vendor_products[$index2] = array('Vid' => $vendor_order['vendors_id'], 'Vname' => $vendor_order['vendors_name'], 'Vemail' => $vendor_order['vendors_email'], 'Vcontact' => $vendor_order['vendors_contact'], 'Vaccount' => $vendor_order['account_number'], 'Vstreet' => $vendor_order['vendor_street'], 'Vcity' => $vendor_order['vendor_city'], 'Vstate' => $vendor_order['vendor_state'], 'Vzipcode' => $vendor_order['vendors_zipcode'], 'Vcountry' => $vendor_order['vendor_country'], 'Vaccount' => $vendor_order['account_number'], 'Vtelephone' => $vendor_order['vendors_phone1'], 'Vinstructions' => $vendor_order['vendor_add_info'], 'Vcost' => $vendor_order['shipping_cost'], 'Vmodule' => $vendor_order['shipping_module'], 'Vmethod' => $vendor_order['shipping_method']); but I can't seem to get it right. any suggestions? Thanks Jim
  5. cigarsforless

    Multi_Vendor_Shipping new thread

    Thanks for the quick response Jim, but... correct me if I'm wrong, but as the order has been processed and added to the database by the time the vendor email gets sent, the cart would now be empty. I'm thinking something here: for ($l=0, $m=sizeof($vendor_products); $l<$m; $l++) { $vendor_country = tep_get_country_name($vendor_products[$l]['Vcountry']); $order_number= $oID; and adding a statement that if there are more than one vendor, then for the 1st product vendor $order_number= $oID . 'a'; for the 2nd product vendor $order_number= $oID . 'b'; for the 3rd product vendor $order_number= $oID . 'c'; etc and if only 1 vendor $order_number= $oID;
  6. cigarsforless

    Multi_Vendor_Shipping new thread

    Ok, have made great headway with my customized vendor email!!! This builds a very nice html email with all kinds of extra tables and info in it like: vendor price subtotals shipping fee vendor order total for those who may want to do the same, here is the code in checkout_process.php (note that I use some extra fields in my database that are included in the form) if (($total_weight > 0 ) && (SELECT_VENDOR_EMAIL_OPTION == 'true')){ $order_id = $insert_id; require(DIR_WS_INCLUDES . 'vendor_order_data.php'); } function vendors_email($vendors_id, $oID, $status, $vendor_order_sent) { $vendor_order_sent = false; $debug='no'; $vendor_order_sent = 'no'; $index2 = 0; //let's get the Vendors $vendor_data_query = tep_db_query("select v.vendors_id, v.vendors_name, v.vendors_email, v.vendors_contact, v.vendor_add_info, v.vendor_street, v.vendor_city, v.vendor_state, v.vendors_zipcode, v.vendor_country, v.vendors_phone1, v.account_number, v.vendors_status_send, os.shipping_module, os.shipping_method, os.shipping_cost, os.shipping_tax, os.vendor_order_sent from " . TABLE_VENDORS . " v, " . TABLE_ORDERS_SHIPPING . " os where v.vendors_id=os.vendors_id and v.vendors_id='" . $vendors_id . "' and os.orders_id='" . (int)$oID . "' and v.vendors_status_send='" . $status . "'"); while ($vendor_order = tep_db_fetch_array($vendor_data_query)) { $vendor_products[$index2] = array('Vid' => $vendor_order['vendors_id'], 'Vname' => $vendor_order['vendors_name'], 'Vemail' => $vendor_order['vendors_email'], 'Vcontact' => $vendor_order['vendors_contact'], 'Vaccount' => $vendor_order['account_number'], 'Vstreet' => $vendor_order['vendor_street'], 'Vcity' => $vendor_order['vendor_city'], 'Vstate' => $vendor_order['vendor_state'], 'Vzipcode' => $vendor_order['vendors_zipcode'], 'Vcountry' => $vendor_order['vendor_country'], 'Vaccount' => $vendor_order['account_number'], 'Vtelephone' => $vendor_order['vendors_phone1'], 'Vinstructions' => $vendor_order['vendor_add_info'], 'Vcost' => $vendor_order['shipping_cost'], 'Vmodule' => $vendor_order['shipping_module'], 'Vmethod' => $vendor_order['shipping_method']); if ($debug == 'yes') { echo 'The vendor query: ' . $vendor_order['vendors_id'] . '<br>'; } $index = 0; $vendor_orders_products_query = tep_db_query("select o.orders_id, o.orders_products_id, o.products_model, o.products_id, o.products_quantity, o.products_name, p.vendors_id, p.vendors_prod_comments, p.vendors_prod_id, p.vendors_product_price, p.products_qty from " . TABLE_ORDERS_PRODUCTS . " o, " . TABLE_PRODUCTS . " p where p.vendors_id='" . (int)$vendor_order['vendors_id'] . "' and o.products_id=p.products_id and o.orders_id='" . $oID . "' order by o.products_name"); while ($vendor_orders_products = tep_db_fetch_array($vendor_orders_products_query)) { $vendor_products[$index2]['vendor_orders_products'][$index] = array( 'Pqty' => $vendor_orders_products['products_quantity'], 'Pname' => $vendor_orders_products['products_name'], 'Pmodel' => $vendor_orders_products['products_model'], 'Pprice' => $vendor_orders_products['products_price'], 'Ppqty' => $vendor_orders_products['products_qty'], 'Pvendor_name' => $vendor_orders_products['vendors_name'], 'Pcomments' => $vendor_orders_products['vendors_prod_comments'], 'PVprod_id' => $vendor_orders_products['vendors_prod_id'], 'PVprod_price' => $vendor_orders_products['vendors_product_price'], 'spacer' => '-'); //MVS end if ($debug == 'yes') { echo 'The products query: ' . $vendor_orders_products['products_name'] . '<br>'; } $subindex = 0; $vendor_attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$oID . "' and orders_products_id = '" . (int)$vendor_orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($vendor_attributes_query)) { while ($vendor_attributes = tep_db_fetch_array($vendor_attributes_query)) { $vendor_products[$index2]['vendor_orders_products'][$index]['vendor_attributes'][$subindex] = array('option' => $vendor_attributes['products_options'], 'value' => $vendor_attributes['products_options_values'], 'prefix' => $vendor_attributes['price_prefix'], 'price' => $vendor_attributes['options_values_price']); $subindex++; } } $index++; } $index2++; // let's build the email // Get the delivery address $delivery_address_query = tep_db_query("select distinct delivery_company, delivery_name, delivery_street_address, delivery_street_address2, delivery_suburb, delivery_city, delivery_state, delivery_postcode, delivery_telephone, delivery_country from " . TABLE_ORDERS . " where orders_id='" . $oID ."'"); $vendor_delivery_address_list = tep_db_fetch_array($delivery_address_query); if ($debug == 'yes') { echo 'The number of vendors: ' . sizeof($vendor_products) . '<br>'; } $email=''; for ($l=0, $m=sizeof($vendor_products); $l<$m; $l++) { $vendor_country = tep_get_country_name($vendor_products[$l]['Vcountry']); $order_number= $oID; $vendors_id=$vendor_products[$l]['Vid']; $the_email=$vendor_products[$l]['Vemail']; $the_name=$vendor_products[$l]['Vname']; $the_contact=$vendor_products[$l]['Vcontact']; $email= '<table border="1" cellspacing="0" cellpadding="10"><tr><td><table border="0" width="100%"><tr><td width="50%" valign="top"><b>' . STORE_OWNER . '</b><br>' . STORE_NAME_ADDRESS . '<br>www.thecigarhut.com</td><td width="50%" valign="top" rowspan="2"><b>Dropship Order #</b>' . $oID . '<br><br><br><br><b>Ship To:</b><br>'; if (tep_not_null(($vendor_delivery_address_list['delivery_company'])) { $email = $email . $vendor_delivery_address_list['delivery_company'] .'<br>'; } $vendor_delivery_address_list['delivery_name'] .'<br>' . $vendor_delivery_address_list['delivery_street_address'] .'<br>'; if (tep_not_null(($vendor_delivery_address_list['delivery_street_address_2'])) { $email = $email . $vendor_delivery_address_list['delivery_street_address_2'] .'<br>'; } if (tep_not_null(($vendor_delivery_address_list['delivery_suburb'])) { $email = $email . $vendor_delivery_address_list['delivery_suburb'] .'<br>'; } $vendor_delivery_address_list['delivery_city'] .', ' . $vendor_delivery_address_list['delivery_state'] . ' ' . $vendor_delivery_address_list['delivery_postcode'] . '<br>' . $vendor_delivery_address_list['delivery_country'] .'<br>' . $vendor_delivery_address_list['delivery_telephone'] . '<br><br></td></tr>'; $email = $email . '<tr><td width="50%" valign="bottom"><b>Attn: ' . $the_contact . '</b><br>' . $the_name . '<br>' . $vendor_products[$l]['Vstreet'] . '<br>' . $vendor_products[$l]['Vcity'] .', ' . $vendor_products[$l]['Vstate'] .' ' . $vendor_products[$l]['Vzipcode'] .'<br>' . $vendor_country . '<br>' . $vendor_products[$l]['Vtelephone'] .'<br><br></td></tr></table>'; $email = $email . '<table border="1" cellspacing="0" cellpadding="3" bordercolor="#808080"><tr><td align="center" colspan="2">YOUR NO.</td><td align="center" colspan="2">SHIP VIA</td><td align="center" colspan="2">PROMISED DATE</td><td align="center">TERMS</td><td align="center" colspan="2">DATE</td><td align="center">PG.</td></tr><tr><td align="center" colspan="2"> </td><td align="center" colspan="2"><b>' . $vendor_products[$l]['Vmethod'] . '</b></td><td align="center" colspan="2"> </td><td align="center">' . $vendor_products[$l]['Vinstructions'] .' </td><td align="center" colspan="2">' . strftime("%m/%d/%y") . '</td><td align="center">1</td></tr><tr><td align="center">QTY.</td><td align="center" colspan="2">ITEM NO.</td><td align="center" colspan="2">DESCRIPTION</td><td align="center">PRICE</td><td align="center">UNIT</td><td align="center">EXTENDED<br>PRICE</td><td align="center" colspan="2">TAX</td></tr>'; for ($i=0, $n=sizeof($vendor_products[$l]['vendor_orders_products']); $i<$n; $i++) { $product_attribs =''; if (isset($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) && (sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) > 0)) { for ($j = 0, $k = sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']); $j < $k; $j++) { $product_attribs .= ' ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['option'] . ': ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['value'] . '<br>'; } } $email = $email . '<tr><td align="center">' . $vendor_products[$l]['vendor_orders_products'][$i]['Pqty'] . '</td><td align="left" colspan="2" nowrap>' . $vendor_products[$l]['vendor_orders_products'][$i]['Pmodel'] . '</td><td align="left" colspan="2">' . $vendor_products[$l]['vendor_orders_products'][$i]['Pname'] . '</td><td align="right">$' . $vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] . '</td><td align="center">' . $vendor_products[$l]['vendor_orders_products'][$i]['Ppqty'] . '</td><td align="right">$' . ($vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] * $vendor_products[$l]['vendor_orders_products'][$i]['Pqty']) . // '</td><td align="right">' . $currencies->format(($vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] * $vendor_products[$l]['vendor_orders_products'][$i]['Pqty']), true, $order->info['currency'], $order->info['currency_value']) . // '</td><td align="right">' . $currencies->format($these_products[$l]['orders_products'][$i]['final_price'] * $these_products[$l]['orders_products'][$i]['qty'], true, $these_info['currency'], $these_info['currency_value']) . "\n\t" . '</td><td align="center" colspan="2"> ' . '</td></tr>'; $VendorSubTotal += ($vendor_products[$l]['vendor_orders_products'][$i]['Pqty'] * $vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price']); } if (tep_session_is_registered('backorders')) { $backorderinfo = $GLOBALS['backorders']; } if (tep_session_is_registered('comments')) { $custcomments = '<b>Customer Comments / Special Instructions</b><br>' . $GLOBALS['comments']; } $VendorTotal = ($VendorSubTotal + $vendor_products[$l]['Vcost']); $email = $email . '<tr><td align="left" colspan="6" valign="top">' . $custcomments . ' </td><td align="left" nowrap>SALE AMOUNT<br>FREIGHT<br>TOTAL AMOUNT<br>PAID TODAY</td><td align="left" colspan="3">$' . $VendorSubTotal . '<br>$' . $vendor_products[$l]['Vcost'] . '<br>$' . $VendorTotal . '<br>$0.00</td></tr><tr><td align="left" colspan="6"><b>Backorder Instructions:</b> ' . $backorderinfo . '</td><td align="center" colspan="4">BALANCE DUE: $' . $VendorTotal . '</td></tr></table></td></tr></table>'; } if (tep_mail($the_name, $the_email, EMAIL_VENDOR_ORDER_NUMBER . '' . $oID . ' for ' . $vendor_delivery_address_list['delivery_name'] . ' from ' . STORE_OWNER, $email . '<br>', STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS) ) $vendor_order_sent = 'yes'; if ( $vendor_order_sent == 'yes') { tep_db_query("update " . TABLE_ORDERS_SHIPPING . " set vendor_order_sent = '" . tep_db_input($vendor_order_sent) . "' where orders_id = '" . (int)$oID . "' and vendors_id = '" . (int)$vendors_id . "'"); } else { tep_db_query("update " . TABLE_ORDERS_SHIPPING . " set vendor_order_sent = 'no' where orders_id = '" . (int)$oID . "' and vendors_id = '" . (int)$vendors_id . "'"); } if ($debug == 'yes') { echo 'The $email(including headers:<br>Vendor Email Addy' . $the_email . '<br>Vendor Name' . $the_name . '<br>Vendor Contact' . $the_contact . '<br>Body--<br>' . $email . '<br>'; } } return true; } //MVS end All that I need to figure out now is how to add a suffix to the order number if more than one vendor is used. (This would be only in the emails sent and not in the database.) ie: customer orders items from 2 vendors, 1st vendor gets an email for Order #12345a 2nd vendor gets an email for Order #12345b but if customer orders from just 1 vendor no suffix is added any ideas?
  7. cigarsforless

    Multi_Vendor_Shipping new thread

    I'm having trouble trying to modify my vendors email (sent in checkout_process.php) to include the following info: vendor item price(s) item subtotal shipping charge Total I can get it to show the vendor price and calculate the prices if 2 or more of an item is ordered. But can't seem to get it to show the shipping fee and calculate the subtotals and totals properly. Below is the code for a heavily modified vendor email (lots of tables and some extra custom fields I use) $email= '<table border="1" cellspacing="0" cellpadding="10"><tr><td><table border="0" width="100%"><tr><td width="50%" valign="top"><b>' . STORE_OWNER . '</b><br>' . STORE_NAME_ADDRESS . '<br>www.thecigarhut.com</td><td width="50%" valign="top" rowspan="2"><b>Dropship Order #:</b>' . $oID . '<br><br><br><br><b>Ship To:</b><br>' . $vendor_delivery_address_list['delivery_company'] .'<br>' . $vendor_delivery_address_list['delivery_name'] .'<br>' . $vendor_delivery_address_list['delivery_street_address'] .'<br>' . $vendor_delivery_address_list['delivery_street_address_2'] .'<br>' . $vendor_delivery_address_list['delivery_suburb'] .'<br>' . $vendor_delivery_address_list['delivery_city'] .', ' . $vendor_delivery_address_list['delivery_state'] . ' ' . $vendor_delivery_address_list['delivery_postcode'] . '<br>'; $vendor_delivery_address_list['delivery_country'] .'<br>' . $vendor_delivery_address_list['delivery_telephone'] . '<br><br></td></tr>'; $email = $email . '<tr><td width="50%" valign="bottom"><b>Attn: ' . $the_contact . '</b><br>' . $the_name . '<br>' . $vendor_products[$l]['Vstreet'] . '<br>' . $vendor_products[$l]['Vcity'] .', ' . $vendor_products[$l]['Vstate'] .' ' . $vendor_products[$l]['Vzipcode'] .'<br>' . $vendor_country . '<br>' . $vendor_products[$l]['Vtelephone'] .'<br><br></td></tr></table>'; $email = $email . '<table border="1" cellspacing="0" cellpadding="3" bordercolor="#808080"><tr><td align="center" colspan="2">YOUR NO.</td><td align="center" colspan="2">SHIP VIA</td><td align="center" colspan="2">PROMISED DATE</td><td align="center">TERMS</td><td align="center" colspan="2">DATE</td><td align="center">PG.</td></tr><tr><td align="center" colspan="2"> </td><td align="center" colspan="2">' . $vendor_products[$l]['Vmethod'] . ' </td><td align="center" colspan="2"> </td><td align="center">' . $vendor_products[$l]['Vinstructions'] .' </td><td align="center" colspan="2">' . strftime("%m/%d/%y") . '</td><td align="center">1</td></tr><tr><td align="center">QTY.</td><td align="center" colspan="2">ITEM NO.</td><td align="center" colspan="2">DESCRIPTION</td><td align="center">PRICE</td><td align="center">UNIT</td><td align="center">EXTENDED<br>PRICE</td><td align="center" colspan="2">TAX</td></tr>'; for ($i=0, $n=sizeof($vendor_products[$l]['vendor_orders_products']); $i<$n; $i++) { $product_attribs =''; if (isset($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) && (sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) > 0)) { for ($j = 0, $k = sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']); $j < $k; $j++) { $product_attribs .= ' ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['option'] . ': ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['value'] . '<br>'; } } $email = $email . '<tr><td align="center">' . $vendor_products[$l]['vendor_orders_products'][$i]['Pqty'] . '</td><td align="left" colspan="2" nowrap>' . $vendor_products[$l]['vendor_orders_products'][$i]['Pmodel'] . '</td><td align="left" colspan="2">' . $vendor_products[$l]['vendor_orders_products'][$i]['Pname'] . '</td><td align="right">$' . $vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] . '</td><td align="center">' . $vendor_products[$l]['vendor_orders_products'][$i]['Ppqty'] . '</td><td align="right">$' . ($vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] * $vendor_products[$l]['vendor_orders_products'][$i]['Pqty']) . '</td><td align="center" colspan="2"> ' . '</td></tr>'; } } $email = $email . '<tr><td align="center" colspan="6"> </td><td align="left" nowrap>SALE AMOUNT<br>FREIGHT<br>TOTAL AMOUNT<br>PAID TODAY</td><td align="left" colspan="3">$SUB_TOTAL<br>$' . $vendor_order['shipping_cost'] . '<br>$TOTAL<br>$0.00</td></tr><tr><td align="center" colspan="6">Memo: Please Reply with USPS Tracking Number</td><td align="center" colspan="4">BALANCE DUE: $TOTAL</td></tr></table></td></tr></table>'; The things I need the right code for are in the last line and I currently have just the following placeholders for them $SUB_TOTAL (to add up the vendor prices for all items ordered) $TOTAL (add together the SUB TOTAL and the SHIPPING COST) and for some reason, the following bit ' . $vendor_order['shipping_cost'] . ' just returns a blank entry even though I have it in the query further up the page. Anyone with any bright ideas to help would be be greatly admired and appreciated!
  8. cigarsforless

    Multi_Vendor_Shipping new thread

    easy fix, you just need to unregister the shipzone (you got it in the ship_estimator.php, but missed it in the products_ship_estimator.php In products_ship_estimator.php find tep_session_unregister ('shipcountry'); change to tep_session_unregister ('shipcountry'); tep_session_unregister ('shipzone');
  9. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim, Hate to tell you this, but... I found a bug in the ship estimator. If you are not logged in, when you go to change address for quote, the estimator does not reset the state. IE: I tested it first with 90210 CA US - worked like a charm went to change address to 33186 FL US and see that the new zip is listed correctly in the ship to address, but the state stays as CA and is not changed to FL this results in no UPS quotes returned. looking into it and will let you know what I find
  10. cigarsforless

    Multi_Vendor_Shipping new thread

    Jim, you are my hero! You have no idea how badly I have been wanting a working shipping estimator for MVS! Thanks for busting your brains and getting this contrib to work with MVS I had tried and tried to get it to work myself, but gave up after realizing it was beyond my abilities. You really saved the day, thanks again!
  11. cigarsforless

    Multi_Vendor_Shipping new thread

    Tare weight gets added on my site for USPS.php but zones don't work This is not an issue for me though as I do not use any zone restrictions for USPS Below is a copy of my USPS.php for MVS that works for me
  12. cigarsforless

    Multi_Vendor_Shipping new thread

    From what I can tell, we need to collect the State info to set the Zone id If a shipping zone is selected in the shipping module, it looks to see if the delivery address zone id is within the selected shipping zone restrictions no zone id, no quote will play with the code to see if I can patch something together
  13. cigarsforless

    Multi_Vendor_Shipping new thread

    I have figured out that the Address Book Enhancer contribution does not in fact affect the Shipping Estimator at all. (If I disable shipping zones, the estimator returns proper quotes and addresses when the shipping address book entry is changed) This can be considered closed as it is not an issue
  14. cigarsforless

    Multi_Vendor_Shipping new thread

    it seems that this zones issue affects all shipping modules. As soon as I set a MVS shipping module Shipping Zone for a vendor the shipping estimator returns no quotes regardless of the shipping module used if no shipping zone is set, then the shipping estimator works like a charm! on a side note, it would be real nice if we could get the shipping estimator to display an error message if no quote was returned. Something like: "Sorry, we are unable to obtain an estimate at this time. Please proceed to checkout to see your shipping options and rates"
  15. cigarsforless

    Multi_Vendor_Shipping new thread

    OK, making some progress here... If I do NOT select a shipping zone in the UPS modules I get quotes This works for both ups.php and upsxml.php BUT, I have a shipping zone set up for UPS that only includes the 51 states APO PR etc are removed from the US state selection if I select any of the shipping zones I have set up, I get no UPS quotes from the shipping estimator. as soon as I set a module to use only a selected shipping zone, no ups quotes are returned so.. now we know exactly what is causing the problem how do I fix it?
  16. cigarsforless

    Multi_Vendor_Shipping new thread

    Tried it and had no difference. Still no UPS quotes. Am working on figuring out the issues as posted above. Will let you know if I get it to work...
  17. cigarsforless

    Multi_Vendor_Shipping new thread

    It is looking like the address enhancer v1.1 (http://addons.oscommerce.com/info/1868) contrib is the culprit I have modified the ship estimator a bit to get it to work with ups.php when logged in but it still does not work when not logged in. (still does not work at all with upsxml.php)
  18. cigarsforless

    Multi_Vendor_Shipping new thread

    Well, now I'm really baffled. I figured I'd disable UPSXML and just use the ups.php module instead as I really do need to use the ship estimator. I don't get quotes with ups.php either! the estimator will only return quotes for usps.php and freeamount.php (I use that one for gift certificates) For the life of me I can't figure out why it is not getting any type of UPS quote regardless of which module I use. any ideas at all where I should look? aside from MVS, I have the following contribs on my site at www.cigarsforless.com that "might" affect this in some way but I can not see how. Country State Selector address enhancer v1.1 CCGV trad
  19. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim, After comparing the 2 files, I find that I have this block of code in there to calculate the handling from both the vendor info and the module itself. // START doing things differently if (isset($this->servicesTimeintransit[$type])) { $eta_array = explode("-", $this->servicesTimeintransit[$type]["date"]); $months = array (" ", "Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sept", "Oct", "Nov", "Dec"); $eta_arrival_date = $months[(int)$eta_array[1]]." ".$eta_array[2].", ".$eta_array[0]; $_type .= ", Estimated Delivery Date: ".$eta_arrival_date; } //END of doing things differently: //MVS Start $vendors_data_query = tep_db_query("select handling_charge, handling_per_box, vendor_country, vendors_zipcode from " . TABLE_VENDORS . " where vendors_id = '" . (int)$vendors_id . "'" ); $vendors_data = tep_db_fetch_array($vendors_data_query); $country_name = tep_get_countries($vendors_data['vendor_country'], true); //MVS Start $handling_charge = $vendors_data['handling_charge']; $handling_per_box = $vendors_data['handling_per_box']; if ($handling_charge > $handling_per_box*$shipping_num_boxes) { $handling = $handling_charge; } else { $handling = $handling_per_box*$shipping_num_boxes; } //MVS End $handling_fee = constant('MODULE_SHIPPING_UPSXML_RATES_HANDLING_' . $vendors_id); $methods[] = array('id' => $type, 'title' => $_type, 'cost' => ($handling_fee + $cost + $handling)); and in the file you sent me is // START doing things differently /* if (isset($this->servicesTimeintransit[$type])) { $eta_array = explode("-", $this->servicesTimeintransit[$type]["date"]); $months = array (" ", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); $eta_arrival_date = $months[(int)$eta_array[1]]." ".$eta_array[2].", ".$eta_array[0]; $_type .= ", <acronym title='Estimated Delivery Date'>EDD</acronym>: ".$eta_arrival_date; } END of doing things differently: */ $methods[] = array('id' => $type, 'title' => $_type, 'cost' => ($this->handling_fee + $cost)); I tried just using the UPSXML module you sent me (I uninstalled the old one and reinstalled the new one) and I am still not getting USPSXML quotes Drat it all to heck!
  20. cigarsforless

    Multi_Vendor_Shipping new thread

    now we are getting somewhere.. With logging turned on for the upsxml module, when I try the ship estimator, no log is written when I got to checkout_shipping.php, the ups log is written and everything looks ok. SO.. it appears that the ship estimator is not even connecting in any way to upsxml.php on my system now, if we could only figure out why not! can you send me a copy of the upsxml module that you have the ship estimator working with? maybe then I can see what is differnet with my version and figure this thing out. Thanks
  21. cigarsforless

    Multi_Vendor_Shipping new thread

    hmmmm still no quotes from UPS XML and since I have some products that only ship by UPS, the estimator will return a box with the product in it, but without a quote. Perhaps a message saying "no quote is available at this time" if the estimator does not get a valid quote?
  22. cigarsforless

    Multi_Vendor_Shipping new thread

    2 more little glitches.. in the files catalog/products_ship_estimator.php and catalog/ship_estimator.php, " IMAGE_BUTTON_CLOSE " needs to be changed to " TEXT_CLOSE_WINDOW " to match the language file definitions
  23. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim I found 2 minor errors in the install in includes/filenames.php you forgot to include: define('FILENAME_PRODUCTS_SHIP_ESTIMATOR', 'products_ship_estimator.php'); in the files products_ship_estimator.php and ship_estimator.php, the close window image is coded as button_close_window.jpg when the included button is button_close_window.gif seems to work well but... I'm still not getting quotes from UPSXML. (at least it does not show an error, it just does not include the UPS quote) will see if I can figure out the xml issue but I think it is a bit beyond me
  24. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim, Did you manage to get this new version to work with the UPSXML module? (Just thought I'd ask before installing it to find out if it suits my needs yet)
  25. cigarsforless

    Multi_Vendor_Shipping new thread

    Hi Jim, Are you saying that an older version of the UPSXML module works with the ship estimator for MVS? As all I need the UPSXML module for, is the ability to add shipping delays per vendor and to have the rates display an Estimated Delivery Date, if the version on your client's site can do that and will work with the ship estimator, you would REALLY make my day if you could email me a copy of the 2 files you have working so I can get this implemented on my site at cigarsforless.com (email addy is in my profile) Thanks much!
×