Need help with shipping

[mikeel100]

This is the only "Need Help With Shipping" thread that is not closed.

Sorry if this is off the topic of the original post...but as usual, I can't find the place to start a new thread.

I've searched and read several threads related to "multiple ship origin zip codes", "shipping help", "dropship shipping", etc. None of the threads I've ran across in the last couple of days have a usable answer.

I have multiple ship origin zip codes for my products (114,000) but Zencart only has one location for shipping ORIGIN zip code...which is set in admin/configuration/shipping/packing/postal code.

I need to replace the admin ship origin zip code with each products unique ship origin zip code just before it is evaluated for UPS shipping cost. I believe(hope) that is the only change I need to make in order to get accurate shipping cost for each product.

I've added a column to my products table, "ship_zip" for each product but I need a way to plug that zip code into shipping cost evaluation process.

I have studied the ups.php module in depth and I know (think) I need to change the configuration table just before line 148:

$this->_upsOrigin(SHIPPING_ORIGIN_ZIP, $country_name['countries_iso_code_2']); 

with a simple query like:

[B]$products_ship_zip[/B] = $db->query("SELECT ship_zip FROM products WHERE products_id = PRODUCT BEING EVALUATED FOR SHIPPING");

$query = ("UPDATE $configuration
SET $configuration.`configuration_value` = [B]'$products_ship_zip'[/B]
WHERE $configuration.`configuration_key` = 'SHIPPING_ORIGIN_ZIP' ");
$stmt = $db->prepare($query);
$stmt->execute(); 

What variable is represents the products_id during the shipping cost evaluation process?

I've tried echo testing the ups.php module but can not put my finger on the products_id variable.

Does the ups.php module evaluate shipping cost a product at a time or in bulk? I'm assuming one at at time.

Should I be setting the $products_ship_zip and changing the configuration in a different file?

Thanks in advance for any help anyone can provide.