Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

About eTiMaGo

  • Birthday 10/10/1981

Profile Information

  • Real Name
    Thomas Gires
  • Location
  • Website
  1. eTiMaGo

    [contribution] Update-o-matic

    Strange, I just installed it on a new site I made, and it worked like a charm
  2. Hello everyone, I've been trying to replicate the functionality of the stock USPS module which offers several shipping methods (express, priority, etc) under its module. I need to have the same kind of choices, but in the "item" shipping module, so I can offer different packaging choices to the customer, as well as shipping methods, without having a big jumble of shipping modules! So, I found that in the USPS shipping module, this loop is what sets up the different methods: for ($i=0; $i<$size; $i++) { list($type, $cost) = each($uspsQuote[$i]); $methods[] = array('id' => $type, 'title' => ((isset($this->types[$type])) ? $this->types[$type] : $type), 'cost' => ($cost + MODULE_SHIPPING_USPS_HANDLING) * $shipping_num_boxes); } $this->quotes['methods'] = $methods; So I replicated this manually in my item2 shipping module file (a copy of the original item file, just for testing, excuse the mess): function quote($method = '') { global $order, $total_count; $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_ITEM2_TEXT_TITLE); $methods[] = array('id' => $this->code, 'title' => MODULE_SHIPPING_ITEM_TEXT_WAY, 'cost' => (MODULE_SHIPPING_ITEM2_COST * $total_count) + MODULE_SHIPPING_ITEM2_HANDLING); $methods[] = array('id' => ems, 'title' => 'Express Mail Service', 'cost' => (MODULE_SHIPPING_ITEM2_COST * $total_count*2) + MODULE_SHIPPING_ITEM2_HANDLING); $this->quotes['methods'] = $methods; if ($this->tax_class > 0) { $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title); return $this->quotes; } So this displays the choice just fine in the catalog shipping checkout page, but when I continue, the checkout confirmation page only shows the original method and cost. Thus it seems to me the problem comes in the way that the checkout_shipping.php page passes on the selected shipping module choice to the checkout_confirmation, and it's really stumped me! Any help would be appreciated!
  3. eTiMaGo

    SQL Debugging help!

    couldn't figure it out so I did a very ugly ugly hackjob: load up the customer ids in one query, then loop through it and run each sub query one at a time... yeay...
  4. eTiMaGo

    SQL Debugging help!

    Hi folks, I'm trying to put together some code which hope to make a contribution, a kind of sales analysis tool, where you select one product and it shows you which customers bought it, but also some stats about the customer like how many order they have in total, what is the latest date of the order they placed, etc. But to do that I need to use a nested SQL query, and I am stumped. Every time I run it, it just locks up MySQL, gotta restart the service... anyway here's my code so far, maybe someone can point out the glaringly obvious mistake I am making? :angry: select c.customers_firstname, c.customers_lastname, c.customers_email_address, count(o.orders_id) as num_orders, max(date_purchased) as last_order, c.customers_newsletter from customers c, orders o where c.customers_id = o.customers_id AND c.customers_id in ( select o.customers_id from orders o, orders_products op where o.orders_id = op.orders_id and op.products_id =1234 ) group by o.customers_id order by last_order desc BTW the sub-query on its own works just fine, as does the outer query if I just skip the whole subquery (and that's a useful query too, shows you juicy info about your active customers!)
  5. eTiMaGo

    [contribution] Update-o-matic

    I've been using the Waza04 barcode contribution quite successfully :) http://addons.oscommerce.com/info/1218
  6. eTiMaGo

    [contribution] Update-o-matic

    wow!!! Thanks for the quick updates fabrizio, it's looking good! I've been trying to get something to work, for a mass update without using the order numbers. Have a dropdown box of status FROM, and another box of status TO. So for example if you use this, it will change ALL "Processing" orders to "Packing"
  7. I'm sure everyone who runs a store has had customers placing orders with messed up shipping addresses (usually choosing Uruguay instead of United Kingdom, for example, or less noticeable mistakes like a wrong postcode, etc). Sometimes the customer lets us know too late and the order is already shipped, wasting everyone's time and money. So, what would be wonderful is a system to let customers modify their shipping address AFTER placing the order, as long as it's not reached a certain order status. Has anyone done this, or would be able to?
  8. it's possible also that your stylesheet file is cached by your browser, happened a couple of time... use your browser to open the stylesheet file, refresh it, then go back to your actual site and refresh.. or, simpler, but not sure if it'll work, in IE, press Ctrl and F5 to force refresh all elements of the page. Hope that helps!
  9. eTiMaGo


    Hi Kai, Sure, I know what you mean, but this would be a modification based on a core osCommerce function, so would not be of use only to me, but anyone using osCommerce to track stock. But please do PM me with some information about your current solution to this.
  10. eTiMaGo


    Hi, Excellent contrib, I see a lot of possibilities with it, but one small improvement I'd like to see: 1) My site uses osCommerce's stock tracking, and from playing around with this module, I see that when a customer adds a bundle to their basket, and checkos out, the stock level of the original two items is not deducted, while they would need to be to keep an accurate count. The stock levels of the original items should also be restored if the order is deleted with the "restock product quantity" option is checked. I tried to dig through your code and see if I can add these functionalities myself, but no luck, Im just not good enough yet :D
  11. eTiMaGo

    Show grand total in USD?

    Actually, it just pulls the raw order total, in the default currency of your store, so there's no number or currency formatting. I've learnt a lot more of PHP since then (oscommerce = great teacher), so I think you could put round($total,2) so round it to 2 decimals. Then again I could be wrong :P
  12. eTiMaGo

    Multiple order update

    Actually I would... but the most interesting aspect of it for me is the label printing... and both in its original standalone form and as part of the batch print center, it just does not work... Misses half the orders, does not change their status at all... still stuck doing it by hand!
  13. eTiMaGo

    Multiple order update

    From what I see, the orders' status are actually kept in two places, orders_status in the orders table holds the current status of the order (the one which is searchable, shows up in the orders listing in the admin, etc), and also in the orders_history table, where the latest entry for an individual order is synchronised to the orders_status described earlier, when you use the standard OSC way of updating an order's status. This is done by using the function update_order, which also takes care of adding comments and emailing the customer. Now, this contribution only updates the orders_status, by doing a straight SQL UPDATE command, it does not update the orders_history, or use the update_order function to take care of comments and emailing. Hence, if somebody with slightly better skills than my humble self can update this contribution to use the update_orders function, and optionally add comments to the order, it would be a big improvement. (I've been struggling with this for quite a while, it would require some rewriting of the update_order function which seems to be designed for one-by-one operation only). Also, I'm not sure if it's possible, but if one were to put in a text box, where order numbers can be input line by line (either by hand or through a barcode scanner, for those who use a barcode contribution on their invoice/packing slips), we could have a very very good high-speed automated way of tracking and updating orders efficiently for relatively high-order-volume sites. Just scan,scan,scan,scan all packing slips for shipped orders, choose to change the status to shipped, put in a comment like "order shipped 01/01/1979", press update, and bam, all taken care of, instead of going order by order and updating them.
  14. eTiMaGo

    PayPal orders logging without confirmation

    Hi All, Having the same problem here, what I did was to add a nice little warning in the checkout_payment page, which says: Please select the preferred payment method to use on this order. When paying with Paypal, please be sure to completely finish the process on the Paypal site until you are brought back to this site!!! It's not perfect, but it gets the job done, more or less... Just need to add a little text in the catalog/includes/languages/english/checkout_payment.php file. To be exact, you'd need to add <br><font color="red">When paying with Paypal, please be sure to completely finish the process on the Paypal site until you are brought back to this site!!!</font> or something along those lines.