Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

visionspin

Archived
  • Posts

    6
  • Joined

  • Last visited

Profile Information

  • Real Name
    Louis Hutmire

visionspin's Achievements

  1. Ok, guys. I could really use some help with this. I have been struggling with this for 5 months, which puts me 4 months overdue on creating this shopping cart for my client...and he is not happy about that. :'( Here is what I need help with: My client uses dry ice to ship, which effects both the weight and the space left in the box. The ice amount varies based on the number of days it takes to ship it. I have finally come to the conclusion that the best way to take care of this is to have the dimensions and the weight of the ice already taken into account in the dimensions and weight of the boxes. So, if my client has 3 box sizes and chooses UPS Next Day, then the box sizes and weights would be one amount, if he chooses 2 Day, there would be a different set of boxes (even though the actual boxes are the same, the ice amount varies), etc. For ground though, it gets more complicated and would need to take the zone into account to determine how many days the shipping would be. So here is my question--How do I get it to choose the boxes based on type of shipping and zone shipping to, as well as ordering the packaging of them by the cost of the boxes? Where in the code does this go? I really need your help and would truly appreciate it. The shopping cart has been completely designed and ready to go for 3 months and this is all that is holding it up. Thanks in advance for your help!
  2. I am using the UPX XML module with dimensional support and time in transit. I know that it determines the box size by choosing the least expensive one that will fit the items first. Is it possible to have several different box types that are determined by the type of shipping the customer has chosen and the zone that it will be shipped to? For example, the customer selects UPS Next Day and the packing algorithm selects only from boxes #1-3 in the chart below or if the customer lives in Zone 2 and chooses Ground, only boxes #13-15 would be used to determine # of boxes, weight, etc. Box Type #1--Small Box Type #2-Medium Box Type #3-Large Box Type #4--Small--Next Day Box Type #5-Medium--Next Day Box Type #6-Large--Next Day Box Type #7--Small--2 day Box Type #8-Medium--2 Day Box Type #9-Large--2 Day Box Type #10--Small--Ground--Zone 1 Box Type #11-Medium--Ground--Zone 1 Box Type #12-Large--Ground--Zone 1 Box Type #13--Small--Ground--Zone 2 Box Type #14-Medium--Ground--Zone 2 Box Type #15-Large--Ground--Zone 2 Box Type #16--Small--Ground--Zone 3 Box Type #17-Medium--Ground--Zone 3 Box Type #18-Large--Ground--Zone 3 Each of these box types would have its own dimensions and weight. If this can be done, would someone be willing to help me figure out how to configure the module to do this, including where to put the code? Thanks in advance.
  3. Woohoo, thank you JanZ! You've made my day a happy one. I don't suppose you know off the top of your head what the time in transit query result looks like? Is it just a number representing the number of days?
  4. Looking at /catalog/includes/modules/shipping/upsxml.php I need to make a Time in Transit query to UPS prior to the dimensional calculations, so I can figure how much ice I'll need. Does the Time in Transit query submit to UPS simultaneously with the other stuff? Or does it submit separately, so I can use the result of the Time in Transit to calculate how much ice I'll need? Any help appreciated... here's a snipet of the code in question: if (DIMENSIONS_SUPPORTED) { // sort $productsArray according to ready-to-ship (first) and not-ready-to-ship (last) usort($productsArray, ready_to_shipCmp); // Use packing algoritm to return the number of boxes we'll ship $boxesToShip = $this->packProducts($productsArray); // Quote for the number of boxes for ($i = 0; $i < count($boxesToShip); $i++) { $this->_addItem($boxesToShip[$i]['length'], $boxesToShip[$i]['width'], $boxesToShip[$i]['height'], $boxesToShip[$i]['current_weight']); $totalWeight += $boxesToShip[$i]['current_weight']; } } else { // The old method. Let osCommerce tell us how many boxes, plus the weight of each (or total? - might be sw/num boxes) $this->items_qty = 0; //reset quantities for ($i = 0; $i < $shipping_num_boxes; $i++) { $this->_addItem (0, 0, 0, $shipping_weight); } } // BOF Time In Transit: comment out this section if you don't want/need to have // expected delivery dates $this->servicesTimeintransit = $this->_upsGetTimeServices(); if ($this->logfile) { error_log("------------------------------------------\n", 3, $this->logfile); error_log("Time in Transit: " . $this->timeintransit . "\n", 3, $this->logfile); } // EOF Time In Transit
  5. Torin, thank you ever so much for your UPS XML module. It's an absolute necessity for me. I'd been searching for dimensional support and multiple box sizes, too. Bless your dear heart. I'd like to propose that your UPS XML module support frozen shipping. There are a number of places using oscommerce that ship frozen products. The general method for this is dry ice (which UPS allows). The price of the styrofoam containers and the dry ice itself require that the tare price be calculated more exactly. This could not be a separate module from the UPS XML module because: The displacement of the ice effects the number of boxes shipped The amount of ice is dependent on the number of days (a direct result of the shipping method choice). I'd guess this is the stuff that would need added: 1. Field to products table - Dry ice shipping (Y/N) ALTER TABLE products ADD products_length DECIMAL(6,2) DEFAULT '12' NOT NULL, ADD products_width DECIMAL(6,2) DEFAULT '12' NOT NULL, ADD products_height DECIMAL(6,2) DEFAULT '12' NOT NULL, ADD products_ready_to_ship INT(1) DEFAULT '0' NOT NULL, ADD products_ice INT(1) DEFAULT '0' NOT NULL; 2. Dry ice information table. DROP TABLE IF EXISTS ice; CREATE TABLE ice ( ? ice_id int NOT NULL auto_increment, ? ice_name varchar(64) NOT NULL, ? ice_description varchar(255) NOT NULL, ? ice_units_base DECIMAL(6,2) default '5' NOT NULL, ? ice_daily_add DECIMAL(6,2) default '5' NOT NULL, ? ice_cost DECIMAL(6,2) DEFAULT '0' NOT NULL, ? ice_unit_volume DECIMAL(6,2) DEFAULT '50' NOT NULL, ? PRIMARY KEY (tare_id) ); 3. Calculation for amount of ice. (must be made before number of boxes are determined) if (frozen_shipping == "yes") { $ice_amount = (($numdays - 1) * $ice_daily_add) + $ice_units_base; } 4. Calculation for amount of boxes. (accounts for volume lost to ice. ice shipped products and non-ice shipped products shipped separately) I'm still thinking about this one and I'm looking into your code to see how the number of boxes are determined. Any help you would be willing to give me to figure this out quickly would be great. 5. Calculation for ice price. (must be made after number of boxes are determined) if (frozen_shipping == "yes") { $ice_price = $ice_amount * $ice_cost * boxes; }
  6. Though new to osCommerce, I face the daunting task of creating a shipping module to deal with the complexities of a particular clients needs including: - calculating the tare price based on multiple box sizes - amount of ice needed to ship frozen merch determined by zone and shipping method - and more Whew! Can anyone give any advice to me regarding building a basic shipping module to get me started? Anything to defray the learning curve. The equation will be hard enough, pulling on 8 different tables of data in addition to a UPS query.
×
×
  • Create New...