UPS Worldship XML Export

[cryogenicz]

I installed this wonderful mod, and it all seems to work except it is not adding the proper weight to UPS.

I was thinking, it would be good for this program to either enter the proper weight (it is only adding each Item's weight once, even if there is multiple items)
or a way to make it enter 0 for every weight and all orders go into the pending shipment so I can manually enter all weights, and process the shipment.

Any help would be AMAZING!

[ctopher]

You got no help?

I had the same problem because we use a prefix to our SQL table names. That is, our orders table is actually called pre_orders where pre_ is the table prefix.

To fix this chage from hard coded table names to zen cart variable names in print_ups_xml.php. So change line 44 in print_ups_xml.php from:

  $query = mysql_query("SELECT * FROM `products` wHERE `products_id` = ".$order->products[$i]['id']. " LIMIT 1");

to:

 $query = mysql_query("SELECT * FROM ".TABLE_PRODUCTS." WHERE `products_id` = ".$order->products[$i]['id']. " LIMIT 1");

note that the tabled called products was changed to TABLE_PRODUCTS.

You also need to make a similar change to line 52. From:

    $query = mysql_query("SELECT `shipping_method` FROM `orders` WHERE `orders_id` = ".$oID." LIMIT 1");

To:

    $query = mysql_query("SELECT `shipping_method` FROM ".TABLE_ORDERS." WHERE `orders_id` = ".$oID." LIMIT 1");

I hope that helps anyone else who is stumbling....

Chris

[chuckienorton]

I'm having same probs... I just added this update, ctopher, and it didn't fix it. What is that update supposed to do?

(using version 9 at the moment)
Thanks,
Chuck

[ctopher]

The changes I suggested made the module more friendly to carts that use a prefix in their table names.

When installing Zen Cart, you could, at the Database Setup screen, set a string as the "Store Identifier (Table-Prefix)". If you didn't leave this blank, then the table names in your database would use this string as a prefix.

http://www.installationwiki.org/imag...1175_02_10.png

For example if you put "Zen_" as the Store Identifier, then your "products" table will actually be called "Zen_products". If this is the case there will be no "products" table and the Worldship Export module's query will fail because the table doesn't exist. All I did was replace the hard coded table names with the Zen Cart variable names which will automatically use the Store Identifier.

What problems are you having?

[sweettraders]

My prefix is zen. Change line 42 to 50 in print_ups_xml.php to the code below which will multiply weight with quantity per product ordered.

while (!empty($order->products[$i])) {

  $query = mysql_query("SELECT * FROM `zen_products` wHERE `products_id` = ".$order->products[$i]['id']. " LIMIT 1");
  $result = mysql_fetch_array($query);
  $query2 = mysql_query("SELECT * FROM `zen_orders_products`  WHERE `orders_id` = ".$oID." AND `products_id` = ".$order->products[$i]['id']. " LIMIT 1");
  $result2 = mysql_fetch_array($query2);
  $weight = $weight + $result2['products_quantity'] * $result['products_weight'];
  $i++;
  }