Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

steepedincode

Pioneers
  • Posts

    36
  • Joined

  • Last visited

About steepedincode

  • Birthday 01/01/1908

Profile Information

steepedincode's Achievements

  1. Also needed here. Thought osCommerce had this as core functionality, but evidently not.
  2. Looking for the same thing. Thought osCommerce could do this out of the box, but apparently cannot. :(
  3. On the subject of enhancements. How can we get the weight of each item purchased added to the export?
  4. Just started using this contribution on a v2.2 RC1 store. Contrib works good. I made a simple sort order change to the drop-down lists and CSV output file to display orders in descending order. To sort order descending in the range lists, on or about line 66 change: $orders_list_query = tep_db_query("SELECT orders_id, date_purchased FROM orders ORDER BY orders_id"); to: $orders_list_query = tep_db_query("SELECT orders_id, date_purchased FROM orders ORDER BY orders_id DESC"); With this change the following change is needed otherwise the CSV file won't display the orders at all. On or about line 118 change: generatecsv($_GET['start'], $_GET['end']); to generatecsv($_GET['end'], $_GET['start']); The orders now output in ascending sort order in CSV. The next change sorts the orders in descending order in the CSV output file. On or about line 140 change: $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start AND orders_id <= $end ORDER BY orders_id"); to: $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start AND orders_id <= $end ORDER BY orders_id DESC"); Appreciate any feedback or insights on potential issues with these changes. QUESTIONS: 1. My client further wants the CSV file to display orders in COLS instead of ROWS. He's manually converting rows to cols in Excel, but is a way to change the CSV export to handle this? 2. Must second the request others here have made to export with field headings. Is this an easy change?
  5. Ok, for anyone who's interested or has something more to offer, these are my findings so far: 1. The WARNING mentioned in my previous post seems to have something to do with the fact that the same code appears in two different files: the changes called for in "checkout_confirmation.php" also appears in /includes/modules/payment/multiple_orders.php. I removed the dup code in the latter file, which got rid of the WARNING and got me moving a little further along. Note that when I removed the dup code, I also had to add a few language definitions to "checkout_confirmation.php" to make instructions to the end user more clear. Also, in /includes/languages/english/modules/payment/multiple_orders.php the attribute 'class="main"' has been left off some <p> tags. This causes text to disappear on dark backgrounds. Change <p> to <p class="main"> and all is good. But these are the issues I'm still trying to work out: 1. It's not the most user-friendly flow I've seen. We'll probably have to institute some help screens to assist customers in the flow. The way it works is that you can add products to the cart, assign a shipping address, choose "Pay With Next Order" then "Confirm Order." At this point, customers are taken to the "Success" screen, so it looks like the order has been processed. But is has not. The order will not be processed until it's paid for! In order to do that, customers must add something else to the cart, then choose an actual payment method (i.e. Credit Card). At this point the current order and the previous one(s) are all processed for payment at the same time. The customer will again see the success screen with the order details. It's cumbersome, but works. 2. Once a customer has assigned several items to various shipping addresses, the interface shows a "delete" button at each order placed. That button does not delete the order. It confirms it. This MUST be fixed. 3. On the Checkout Confirmation screen once you've added more than one item to different shipping addresses, the Confirm Order button at the bottom of the checkout_confirmation.php screen does not work. I found a workaround by placing a button copy ABOVE the "Items Remaining to Pay" section (below the current order). A copy is needed, otherwise the button disappears if only buying one item. So, there are two Confirm buttons once you have multiple ship-to orders, one works, the other does not. Ultimately a conditional must be set up to get rid of the unneeded button. I suspect that there may be other issues. I'll attempt to resolve these and report back any other findings. I welcome insights or experiences anyone else has had with this contribution. The thing is a bear-and-a-half, but unfortunately it's the only one I've found that can manage multiple ship-to addresses. :huh:
  6. In spite of the age and lack of support for this contribution, I've decided to give it a go on a v2.2 RC2 store since I cannot find any other contrib that lets customers ship to multiple addresses. If there is another, please post link to it. This contribution runs ok it seems, but I get a database.php WARNING on checkout_confirmation.php: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /[server-root-path]/includes/functions/database.php on line 103. In database.php from lines 102 - 104 I find this function: function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } Any insights about this warning or function is greatly appreciated.
  7. I must THIRD this request. There exists a contribution called Multiple shipping address V2 developed by Daniel Kerr. However, the latest release appears to be quite some time ago, 1 Dec, 2004 - http://www.oscommerce.com/community/contributions,2623. I found an update to it by Jerome for PHP5 on 18 Oct, 2005 - http://addons.oscommerce.com/info/2548, but it references Daniel Kerr's previous update as 25 Oct, 2004, instead of 1 Dec, 2004. So, I'm still scrutinizing this contribution's status and compatibility with my client's v2.2, RC2 store. Any insights to this contribution or others that can accomplish the task of multiple shipping addresses per order would be greatly appreciated.
  8. Ok, it's fixed. Just for the record and for general interest, the issue seems to have been with $HTTP_POST_VARS vs. $_POST. CONTRIBUTION CODE (caused problem on my configuration of osC): $categories_heading_title_array = $HTTP_POST_VARS['categories_heading_title']; $categories_description_array = $HTTP_POST_VARS['categories_description']; MY FIX: $categories_heading_title_array = $_POST['categories_heading_title']; $categories_description_array = $_POST['categories_description']; Lesson learned!
  9. I recently installed this contribution on a version of osCommerce running as a Joomla component. Everything works great, except I cannot edit or update the categories_heading_title or categories_description from the osCommerce admin tool (Catalog > Categories, categories.php). When I add content to the category heading title and category description fields directly into the database (via MySQL command line), the content displays in my web site, no problem. The content is also available when I edit the category in the osCommerce admin area, categories.php. However, when I save the category, the content in the database fields are deleted. Similarly, if I type in content in the admin tool and save, nothing is saved to the database except an empty string. (???) I've ruled out any database permissions problems and have narrowed the problem down to some incompatibility in the categories.php file. Any suggestion at all would be appreciated. Thanks in advance.
×
×
  • Create New...