Guest Posted March 9, 2004 Share Posted March 9, 2004 Here's the scenario... We are interfacing OSCommerce with Platinum accounting software for a customer. The customer has two warehouses to ship from. Each warehouse ships to specific states. Platinum has a field for the shipping warehouse code. We would like for OSC to send the code to Platinum based upon the delivery state on the order. Any ideas??? Thanks, Link to comment Share on other sites More sharing options...
TomThumb Posted March 9, 2004 Share Posted March 9, 2004 Add warehouse_code to zones table. select warehouse_code from zones where orders.delivery_state = zones.zone_name while (!succeed) {try()}; GMT -6:00 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.