Jump to content

randyroy

Members
  • Content count

    23
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Randy

Recent Profile Visitors

1,751 profile views
  1. randyroy

    Multi_Vendor_Shipping new thread

    Ok. I think I see the problem. I looked at the orders_products table and all of the products in all of the orders have a vendors_id of 1. So whenever an order is placed in the store, the vendors_id is set to 1. Can you please tell me which file is responsible for setting the vendors_id in the orders_products table when the order is entered? I would bet there is a static entry in that file that was changed at some point for testing. Thanks, Randy
  2. randyroy

    Multi_Vendor_Shipping new thread

    Correction. I don't have a vendors_id field in the orders table. But looking back through the code, I don't see where it pulls that value directly from the orders table. I do have an orders_status field and there is data for each order in this field. The same is true for the orders_id fields.
  3. randyroy

    Multi_Vendor_Shipping new thread

    I have data in all fields in the orders table except the 4 cc credit card fields, and the suburb fields. (I would guess this is correct since those aren't used in this store.) The only other field in question is the orders_date_finished field which has NULL for all 6 orders in the store currently. Also, the queries use variables for languages_id and vendor_orders_data['orders_id']. I am not sure how to rewrite the query for running it directly in phpMyAdmin. Thanks, Randy
  4. randyroy

    Multi_Vendor_Shipping new thread

    Hey Jim, It looks like I am getting somewhere here. I uncommented the 2 print orders query statements in the file that you sent me and one of them displayed the queries and listed 4 id's. That worked. The problem now is that the part where it's supposed to list the results and turn them into hyperlinks is still not working. I believe that is this section of code in the orders_by_vendor.php file: while ($vendors_orders = tep_db_fetch_array ($orders_query) ) { $date_purchased = $vendors_orders['date_purchased']; ?> <tr class="dataTableRow"> <td class="dataTableContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $vendors_orders_data['orders_id'] . '&action=edit') . '" TARGET="_blank"><b>View this order</b></a>'; ?></td> <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_id']; ?></td> <!-- <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' . $vendors_orders_data['v_products_id']) . '" TARGET="_blank"><b>' . $vendors_products_data['products_name'] . '</a>'; ?></td> --> <td class="dataTableContent"><?php echo ' from <a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $vendors_orders['customers_id'] . '&action=edit') . '" TARGET="_blank"><b>' . $vendors_orders['customers_name'] . '</b></a>'; ?></td> <td class="dataTableContent" align="left"><?php echo strip_tags($vendors_orders['order_total']); ?></td> <td class="dataTableContent" align="left"><?php echo tep_date_short ($date_purchased); ?></td> <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_status_name']; ?></td> <td class="dataTableContent" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS_EMAIL_SEND, '&vID=' . $vendors_id . '&oID=' . $vendors_orders_data['orders_id'] . '&vOS=' . $vendors_orders_data['vendor_order_sent']) . '"><b>' . $vendors_orders_data['vendor_order_sent'] . '</a></b>'; ?></td> </tr> <?php ​Does any of that look incorrect? I am not sure how to print out individual results from each line to see where the problem is. Thanks, Randy
  5. randyroy

    Multi_Vendor_Shipping new thread

    Thanks for the file. That gives me the exact same results. So at this point, my best guess is that there is some order id or vendor id that is being left out of the order table at the point of order creation. Can you please tell me which file controls the order being added to the database table? Is it checkout_process.php?
  6. randyroy

    Multi_Vendor_Shipping new thread

    Thanks, Jim. I have gone back and tried all of the orders_by_vendors.php files from every revision of MVS that I could find. (V1, V1.1, V1.2, V1.2.1, V1.2.2, V1.2.3, and V1.3). I can't find any that work and actually display the list of orders for the selected vendor. I have sent a PM to another user who claimed in an older post to have gotten it working and hope they can point me in the right direction. I appreciate your help and will continue to work on this. Thanks again. :) Randy
  7. randyroy

    Multi_Vendor_Shipping new thread

    Sorry about the <> code block button. I didn't know I needed to use that to post code. Also uncommenting the last two yielded no change. Is there a working version of MVS that I can download where the orders_by_vendor page works? I have MVS 1.3 installed but am not sure if that is the most recent, or if it works in that version. It is the most recent that I could find. Does your MVS orders by vendor work? Thanks, Randy
  8. randyroy

    Multi_Vendor_Shipping new thread

    Thanks. Here is the section that I think is causing the trouble. There are commented statements that provide direction, but the lines that it says to modify either don't exist or cannot be found For example: // comes here but status is blank echo 'in admin/orders by vendor php line 219 vendors id = ' . $vendors_id . ' and orders id = ' . $vendors_orders_data['orders_id']. ' and status = ' . $status; But there is nothing in line 219 that matches that. Here is line 219: <td class="dataTableContent" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS_EMAIL_SEND, '&vID=' . $vendors_id . '&oID=' . $vendors_orders_data['orders_id'] . '&vOS=' . $vendors_orders_data['vendor_order_sent']) . '"><b>' . $vendors_orders_data['vendor_order_sent'] . '</a></b>'; ?></td> And here are the sections that I am questioning. Can you please confirm that these look correct? <?php if ($line_filter == 'asc') { if ($status > 0) { ?> <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link (FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent . '&status=' . $status) . '"><b>DESCENDING</a></b> order'; ?></td> <?php } else { ?> <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link (FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent) . '"><b>DESCENDING</a></b> order'; ?></td> <?php } } else { if (isset ($status) ) { ?> <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line_filter=asc' . '&sent=' . $sent . '&status=' . $status) . '"><b>ASCENDING</a></b> order'; ?></td> <?php } else { ?> <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line_filter=asc' . '&sent=' . $sent) . '"><b>ASCENDING</a></b> order'; ?></td> <?php } } $orders_statuses = array (); $orders_status_array = array (); $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int) $languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_statuses[] = array ('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name'] ); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } ?> <td class="main" align="right"><?php echo tep_draw_form('status_report', FILENAME_ORDERS_VENDORS . '?&vendors_id=' . $vendors_id . '?&sent=' . $sent) . HEADING_TITLE_STATUS . ' '; ?><?php echo tep_draw_pull_down_menu('status', $orders_statuses, '','onChange="this.form.submit()";');?></form></td> </tr> </table> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_VENDOR; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_ID; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_STATUS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_SENT; ?> </td> </tr> <?php $vend_query_raw = "select vendors_name as name from " . TABLE_VENDORS . " where vendors_id = '" . $vendors_id . "'"; $vend_query = tep_db_query($vend_query_raw); $vendors = tep_db_fetch_array($vend_query); ?> <tr class="dataTableRow"> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS, '&vendors_id=' . $vendors_id . '&action=edit') . '" TARGET="_blank"><b>' . $vendors['name'] . '</a></b>'; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent" align="right">Click To<br>Send Email</td> </tr> <?php if ($sent == 'yes') { $vendors_orders_data_query = tep_db_query ("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='yes' group by orders_id " . $line_filter . ""); } elseif ($sent == 'no') { $vendors_orders_data_query = tep_db_query ("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='no' group by orders_id " . $line_filter . ""); } else { $vendors_orders_data_query = tep_db_query ("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' group by orders_id " . $line_filter . ""); // echo 'in admin/orders by vendor php line 224 line filter = ' . $line_filter . ' and orders id = ' . $vendors_orders_data['orders_id']; } while ($vendors_orders_data = tep_db_fetch_array ($vendors_orders_data_query)) { if ($status > 0) { // $status = '1'; $orders_query = tep_db_query ("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from (" . TABLE_ORDERS . " o) left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = '" . $status . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id = '" . $vendors_orders_data['orders_id'] . "' order by o." . $sort_by_filter . " ASC"); // comes here but status is blank echo 'in admin/orders by vendor php line 219 vendors id = ' . $vendors_id . ' and orders id = ' . $vendors_orders_data['orders_id']. ' and status = ' . $status; } else { $orders_query = tep_db_query ("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from (" . TABLE_ORDERS . " o) left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id = '" . $vendors_orders_data['orders_id'] . "' order by o." . $sort_by_filter . " ASC"); // echo 'in admin/orders by vendor php line 223 vendors id = ' . $vendors_id . ' and orders id = ' . $vendors_orders_data['orders_id']; } while ($vendors_orders = tep_db_fetch_array ($orders_query) ) { // echo 'in admin/orders by vendor php line 227 vendors id = ' . $vendors_id . ' and orders id = ' . $vendors_orders_data['orders_id']; $date_purchased = $vendors_orders['date_purchased']; ?> Any assistance that you can provide is greatly appreciated. Thanks, Randy
  9. randyroy

    Multi_Vendor_Shipping new thread

    My apologies. I meant that the list where the orders should be is blank. I have the headings and drop down menus. And the page loads without any issue. I can click on the vendor drop down and select different vendors. I can also change the sort by status selection. But no orders ever populate below that no matter what I select.
  10. randyroy

    Multi_Vendor_Shipping new thread

    Hi all, I would like to inquire about the orders_by_vendor page please. Mine is blank even after replacing the original files with the ones from drillsar on posts #4864 and #4865. Can you please advise as to what the solution is for this? I am using OSCommerce 2.3.4 Responsive, with MVS 1.3. Thanks much, Randy
  11. randyroy

    Multi_Vendor_Shipping new thread

    Nevermind. Funny how I can never find the answer until I post the question on the board. Thanks to drillsar for posting the bug fixes. The files from post #4864 and #4865 fixed it right up. Shipping methods are working and displaying correctly in the admin order page. Thanks much, Randy
  12. randyroy

    Multi_Vendor_Shipping new thread

    For example, I have an order with 3 items from 2 different vendors. Each item was ordered with a different UPS shipping method. But in the attached screenshot of the order, they all show as combined shipping. But the dollar amount for the total combined shipping options is accurate. I don't know how to get them to show the UPS shipping method that they were ordered with instead of the combined shipping.
  13. randyroy

    Multi_Vendor_Shipping new thread

    I have MVS setup and it calculates everything correctly from a money standpoint. But when I go into Admin-> Orders, it shows Combined Shipping as the shipping method for all products in a single order. If I only have one product in the order, it will display the UPS shipping type correctly. But for a multi-item order where product is coming from multiple vendors, it shows combined shipping as the method for all items. So, as an admin, I have no way of knowing how to ship each piece. I have searched for the past few days and haven't found a way to remedy this. Any assistance that you can provide is greatly appreciated. Thanks, Randy
  14. Disregard. I figured it out.
  15. Hi. I am also trying to add the weight attribute to Easy Populate, based on the size option. I realize this post is quite old but did you ever find a solution to this? Thanks, Randy
×