Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cbcnz

Archived
  • Posts

    59
  • Joined

  • Last visited

Profile Information

  • Real Name
    Nicholas Wood

cbcnz's Achievements

  1. Hi, Just a quick check to see if anyone has achieved this yet, I'm looking for a feature where by once a customer has placed an order for X number or products that order can be split in two this would enable two orders, two packing slips, two separate order statuses. Applications would include: Ship in stock items and back ordered items Separate products from different drop shippers Thanks Nic
  2. Hi All, I am looking for a way to place orders with our suppliers directly from admin. The main features I think would work well would be "admin shipping basket" "stock update" "either email directly to supplier or output data that can be entered into a supppliers ecommerce site or telephone order", "drop ship (if supplier supported)" and "inward order tracking" Has anyone done something like it as I would be keen to discuss
  3. Fantastic! found the fix on page 47 :D
  4. Hi Again, Another little niggle I have is all the spiders get called "Mozilla" in the Name field. The full names show up as: Name: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/b Name: Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/hel It would be great if there was an easy way to show the spider name in the name field!! :D
  5. Hi, When I updated my spiders.txt with the latest from the contributions page and they now register as spiders with there correct ip address
  6. Great Contribution! One minor problem, I have a whole heap of connections from 127.0.0.1 , These connections look to me very much like bots and I think it may be caused by one of the bot session killers we have installed. Anyone else experenced? Oh and who's online tags them as customers.
  7. yea would be good to have an option in admin where reg only can be switched on and off
  8. Whole thing works great for me !! I added another bit of code to highlight orders that have been status "on its way" for more than four days (easy to identify which orders can be updated to delivered and/or tracked down if the customer has not recieved it // begin reverse-sort Pending orders if ($status == 1) { $orders_query_raw = "select o.orders_status, 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 = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id ASC"; } else if ($status == 5) { $orders_query_raw = "select o.orders_status, 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 = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id ASC"; } // end reverse-sort Pending orders <?php // highlight if orders are Pending status and over 2 days old --> if ($orders['orders_status'] == '1') { // convert times to unix timestamp for comparison $time_since_order_placed = ($today_time - strtotime($orders['date_purchased']) ); // 172800 = 2 days in the unix timestamp format if ($time_since_order_placed > 172800) { echo '<font color=red>'; } } // highlight if orders are On its way status and over 4 days old --> if ($orders['orders_status'] == '5'){ // convert times to unix timestamp for comparison $time_since_order_updated = ($today_time - strtotime($orders['last_modified']) ); // 345600= 4 days in the unix timestamp format if ($time_since_order_updated > 345600) { echo '<font color=green>'; } } echo $orders['orders_id']; ?>
  9. Great Contrib!! some very minor tweaks and it works great with MYOB V12 (NZ Edition) Changed the GST code from 'GST' to 'S' Removed 'products.products_SupModel AS SupModel' from the SQL Query Removed the 'Sales Tax Calc. Method' Row from the export After doing that, changing the account codes to match our accounts and changing the output folder it is working just fine. Now all I have to do is have this + MYOB Export module + CSV Bank Statments working togeather and it makes quite an efficent Accounting/OSC intergration, especaly when there are upwards of 20 transactions per day. Thanks for this contrib!
  10. Thanks heaps for the help I'll put those things into place now
  11. I have recently started accepting paypal on my wedsite, I did this by simply enabling the included paypal payment method, It seems to work ok with payments comming through with the right amount charged. but after charging my customers paypal account and giving me the money, The paypal account crashes and the order is not placed into my OsC DB, as a result I see a payment in my paypal account but have no idea what it is for, its not the end of the world as I just email the customer asking what they ordered . I dont have a 2nd paypal account to use to test the system so I can only rely on what customers have told me has happened. Any help would be great.
×
×
  • Create New...