John Wisdom

Hi Andy, My live site is a modded osc site but I have a regular osc site that I test things with too. Slimbox works great with less code. Here's how I have slimbox2 set up on my osc test site and it works with all browsers I've tested. Before the </head> tag I have this on product_info.php, but I have it before my cssmenu.js code. Now, I defined in my configuration.php DIR_WS_BIG_IMAGES but I think you can just make it work using the code below like the regular lightbox but the other lightbox code may cause issues so you need to pull it out. It caused other issues for me with some other jQuery code which got me on slimbox2 in the firs place, but I'm glad that happened. Note: I have the particular version listed to keep myself straight. <link rel="stylesheet" href="css/slimbox2.css" type="text/css" media="screen" /> <script type="text/javascript" src="includes/js/jquery-1.3.1.min.js"></script> <script type="text/javascript" src="includes/js/slimbox2.js"></script> <script type="text/JavaScript"> <!-- jQuery(function($) { $("a[rel^='lightbox']").slimbox({/* Put custom options here */}, null, function(el) { return (this == el) || ((this.rel.length > 8) && (this.rel == el.rel)); }); }); //--> </script> My image related line around line 151 is very simple now like this. <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(DIR_WS_BIG_IMAGES . $product_info['products_image']) . '" target="_blank" rel="lightbox" title="'.$product_info['products_name'].'" >' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </td> This works with javascript disabled also by going to a new window. Hope this helps.

Hi Cat, I found Slimbox2 while I was reading on the jQuery site yesterday and got it running on my test site pretty easily although I had problems with Thickbox and gave up on it. I haven't done a lot of testing with it but it seems to have more/better information/instructions and I think it can do more. It easily replaces Lightbox which I had running and Slimbox2 is simpler. I have this right before my closing head tag <script type="text/javascript" src="includes/js/jquery-1.3.1.min.js"></script> <script type="text/javascript" src="includes/js/slimbox2.js"></script> <script type="text/JavaScript"> <!-- jQuery(function($) { $("a[rel^='lightbox']").slimbox({/* Put custom options here */}, null, function(el) { return (this == el) || ((this.rel.length > 8) && (this.rel == el.rel)); }); }); //--> </script> I simplified the image line and it works with just the php code with rel="lightbox" in the statement after target="_blank". Anyway, you might install this faster and easier than fixing Thickbox.

Here's some food for thought quoted form Google on robots.txt "To block access to all URLs that include a question mark (?), you could use the following entry:" User-agent: * Disallow: /*? Unfortunately, I only recently found this as I had a lot of duplicates too but since I've added that in they are dropping daily. I hope I don't offend anyone by posting this here but it might be an easy answer for some.

Hi Erick, It looks like there error is telling you it's missing from your database so it can't find the value. I think you missed a step on your database installation because you should have an entry in your configuration table with this configuration_key "MODULE_SHIPPING_UPSXML_INSURE". It's a pretty easy install as I remeber from the Admin panel but it's possible to have problems with the install. It might be a problem you can see in Admin/modules/shipping/UPSxml as that is a setting for it.

Actually, I was thinking of Individual shipping price, but this isn't going to work because if they have another item in the cart it doesn't charge correct shipping. Sorry about that. You might want to consider this as an add on item when someone is buying multiple items.

I meant you should check the UPS website and see what it shows for a cost there and then it gives you an idea of how far off you are. UPS charges get down to about $6 for a box. You can also activate the log in this module and you can see what you are sending UPS. I don't think UPS is a good option for this though. Just use the individual shipping price for the cards and it will defer to UPS XML for everything else. So, the only time this will show is when someone is buying cards. I'm not sure what it will do if there have multiple items though. I'm assuming you have looked through all the contribution available for shipping. Do you think you'll sell a lot of greeting cards on your site?

Bill, How much is the real UPS charge for shipping that envelope? Check your tare weight under Admin/configuration/shipping and that might be your problem. Dimensional support is well worth the time to set it up and makes this module perfect for UPS shipping. You can also look for a contribution called "Shipping Per Product", which simply lets you set a flat price per item on the items you choose.

Ummmm, you need to set it for a realistic number and it has to be less than 150lbs or you will keep getting that error. It's the maximum weight of a box that you will ship. If I were you I would use the real weight that your boxes will go up to. You might want to look into the dimensional support part of this module is you product line varies on weight and size.

That is set in the Admin panel in Admin/configuration Enter the Maximum Package Weight you will ship = set to what you want

check and see if you have an extra upsxml.php file in moduules/shipping and that is probably the problem. Did you rename one to upsxml_old.php or something like that? That has caused problems for people before. If you have one renamed remove it and try it again.

Try this If cURL is not compiled into PHP (Windows users (?) and some Linux users) you can change line 74 to : $this->use_exec = '1'; Using exec() cURL from the command line interface (CLI) is then used. See for more information "Changes from 1.1.3 to 1.1.4" in the changes.txt file. If exec() is disabled and logging is enabled, this will be logged also. Here is the section of the changes.txt file it is referring to: Changes from 1.1.3 to 1.1.4 ------------------------------- Modification of catalog/includes/modules/shipping/upsxml.php in function _post to 1. also log cURL errors if they occur 2. add the date and time of the UPS request to the log file. 3. The two lines: curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); are commented out again. These need only be uncommented if you get curl error 60: "error setting certificate verify locations" and likely only the first one. Search the cURL website (http://curl.haxx.se) for more details on this error. For a list of the cURL options and a list of errors, see http://curl.haxx.se/docs/manpage.html. 4. As default, cURL is assumed to be compiled into PHP. If not (some Linux users and apparently Windows users) you can try setting line 74 to: $this->use_exec = '1'; Code for checking if exec() can be called and using it to execute cURL was taken from the file authorizenet_direct.php from the contribution Authorize.Net Consolidated 1.7b with Curl Fix (contribution 2184). Without using addslashes() on the xmlRequest before using it in the exec() statement would give a 100001 error from UPS: The XML document is not well formed.5. Editing of some comments regarding the Time in Transit code

It's working perfectly now and the packaging routine is very fast. I ran a wide variety of items utilizing all the boxes and mixed in several RTS with no problems.

As I obsessed over this last night and I looked at older versions I thought this may have been the problem. I even tried changing it around but I was kind of like Stevie Wonder with a Rubic's cube. I'll run it through an assortment of products and see how it works out.

By Quoted rates I'm assuming you mean "negotiated rates", which I haven't used. Is everything working correctly when "negotiated rates" are not activated? Do the other UPS rates look correct and it's just those two? I don't know the Canadian options but you may be getting unusual quotes because those options are not available for the postal code you are trying. If you have installed and uninstalled this module you might want to take a look at your database configuation table to make sure the present install is clean. I had a problem when I was setting mine up with duplicate entries that caused problems. I did look at the log you posted a few days ago and it does have weight but no dimensions. There are 3 echo statements in version 1.2.5 that you can uncomment out one at a time to help debug.

Actually, I didn't see 1.2.5 until early this morning so it has your correction. I'll continue to work at it to see if I can come up with anything. Once the problem showed up (customer called) it took me a while to figure out that it was this module because it was timing out on 2 items.

Jan, I saw your 1.2.5 update to the file and updated mine, but it still ignores the ready to ship option unless it's too big for a box. I found a way to work around this and it only has this problem with the 48x8x6 box. By making items 48x8x8 it no longer tries to fit them into a box and that solves it. I don't quite get why it doesn't get another 48x8x6 when it needs one but instead hangs, but it will get more 31x15x10 boxes as needed. Here's an output Array( [0] => Array ( [length] => 48.0 [width] => 8.0 [height] => 8.0 [current_weight] => 8.0 [price] => 34.99 ) [1] => Array ( [length] => 47.0 [width] => 8.0 [height] => 8.0 [current_weight] => 14.0 [price] => 15.98 ) [2] => Array ( [length] => 72.0 [width] => 14.0 [height] => 12.0 [current_weight] => 65.0 [price] => 143 ) [3] => Array ( [id] => 31 [name] => Large [description] => 31x15x10 [length] => 31.0 [width] => 15.0 [height] => 10.0 [empty_weight] => 2.0 [max_weight] => 20.00 [volume] => 4650.0 [x] => 10.0 [y] => 15.0 [z] => 31.0 [remaining_volume] => 3750 [current_weight] => 3.4 [products] => Array ( [0] => Array ( [id] => 52 [name] => Larkspur - Natural Light Blue - 4 oz [model] => [image] => larkspur_light_blue.jpg [price] => 5.7500 [quantity] => 1 [weight] => 0.7 [length] => 30.0 [width] => 5.0 [height] => 3.0 [ready_to_ship] => 0 [final_price] => 5.75 [tax_class_id] => 1 [attributes] => [x] => 3.0 [y] => 5.0 [z] => 30.0 [volume] => 450 [largest_box_it_will_fit] => 5 ) [1] => Array ( [id] => 715 [name] => Plumosum Cones - Preserved and Dyed - Burgundy [model] => [image] => Plumosum_Cones_burgundy.jpg [price] => 12.7500 [quantity] => 1 [weight] => 0.7 [length] => 30.0 [width] => 5.0 [height] => 3.0 [ready_to_ship] => 0 [final_price] => 12.75 [tax_class_id] => 1 [attributes] => [x] => 3.0 [y] => 5.0 [z] => 30.0 [volume] => 450 [largest_box_it_will_fit] => 5 ) ) [price] => 18.5 ) [4] => Array ( [id] => 31 [name] => Large [description] => 31x15x10 [length] => 31.0 [width] => 15.0 [height] => 10.0 [empty_weight] => 2.0 [max_weight] => 20.00 [volume] => 4650.0 [x] => 10.0 [y] => 15.0 [z] => 31.0 [remaining_volume] => 0 [current_weight] => 13 [products] => Array ( [0] => Array ( [id] => 524 [name] => Case - Triticum (wheat) - Natural - 20 bunches - 20% off [model] => [image] => Triticum_natural.jpg [price] => 68.6400 [quantity] => 1 [weight] => 11.0 [length] => 31.0 [width] => 15.0 [height] => 10.0 [ready_to_ship] => 0 [final_price] => 68.64 [tax_class_id] => 1 [attributes] => [x] => 10.0 [y] => 15.0 [z] => 31.0 [volume] => 4650 [largest_box_it_will_fit] => 5 ) ) [price] => 68.64 ) [5] => Array ( [id] => 45 [name] => 48x8x6 [description] => 48x8x6 [length] => 48.0 [width] => 8.0 [height] => 6.0 [empty_weight] => 2.0 [max_weight] => 25.00 [volume] => 2304.0 [x] => 6.0 [y] => 8.0 [z] => 48.0 [remaining_volume] => 1257.75 [current_weight] => 11.2 [products] => Array ( [0] => Array ( [id] => 324 [name] => Bamboo - Pencil - Red - 10 pieces [model] => [image] => bamboo_pencil_red.jpg [price] => 5.7500 [quantity] => 1 [weight] => 1.0 [length] => 31.0 [width] => 1.5 [height] => 1.5 [ready_to_ship] => 0 [final_price] => 5.75 [tax_class_id] => 1 [attributes] => [x] => 1.5 [y] => 1.5 [z] => 31.0 [volume] => 69.75 [largest_box_it_will_fit] => 5 ) [1] => Array ( [id] => 364{4}21 [name] => Eucalyptus - Preserved - Washed - Jade Green [model] => [image] => euc_jade_green_washed.jpg [price] => 4.6500 [quantity] => 1 [weight] => 1.2 [length] => 30.0 [width] => 5.0 [height] => 3.0 [ready_to_ship] => 0 [final_price] => 8.35 [tax_class_id] => 1 [attributes] => Array ( [4] => 21 ) [x] => 3.0 [y] => 5.0 [z] => 30.0 [volume] => 450 [largest_box_it_will_fit] => 5 ) [2] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 ) [3] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 ) [4] => Array ( [id] => 647 [name] => Magdelena Ting Ting - Natural [model] => [image] => magdelena_ting_ting.jpg [price] => 3.8900 [quantity] => 1 [weight] => 1.0 [length] => 42.0 [width] => 1.5 [height] => 1.5 [ready_to_ship] => 0 [final_price] => 3.89 [tax_class_id] => 1 [attributes] => [x] => 1.5 [y] => 1.5 [z] => 42.0 [volume] => 94.5 [largest_box_it_will_fit] => 3 ) [5] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 ) [6] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 ) [7] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 ) [8] => Array ( [id] => 650{1}41 [name] => Straight Ting Ting - Dyed [model] => [image] => Ting_ting_natural_straight.jpg [price] => 3.3000 [quantity] => 6 [weight] => 1.0 [length] => 36.0 [width] => 2.0 [height] => 1.0 [ready_to_ship] => 0 [final_price] => 3.3 [tax_class_id] => 1 [attributes] => Array ( [1] => 41 ) [x] => 1.0 [y] => 2.0 [z] => 36.0 [volume] => 72 [largest_box_it_will_fit] => 3 &nb

Well, I've found a problem that causes it to time out but I don't know why. It can happen with just 2 or 3 certain products but the products have to be over 31" long and there has to be more than will fit in one 48x8x6 box. The strange thing is if I have an item marked RTS is being placed it in a box when possible. Just one of each of these makes the page timeout. INSERT INTO `products` VALUES (324, 100, '', 'bamboo_pencil_red.jpg', '5.7500', '2003-02-07 12:18:43', '2007-01-31 19:27:52', '0000-00-00 00:00:00', '1.0', 1, 1, 0, 44, '0.0000', '33.0', '1.5', '1.5', 0), (569, 99, '', 'bamboo_special.jpg', '15.9800', '2006-01-04 15:18:41', '2007-01-31 19:27:52', NULL, '14.0', 1, 1, 0, 23, '0.0000', '48.0', '8.0', '6.0', 1), (647, 35, '', 'magdelena_ting_ting.jpg', '3.8900', '2006-05-10 11:49:30', '2007-01-31 20:28:02', NULL, '1.0', 1, 1, 0, 15, '0.0000', '42.0', '1.5', '1.5', 0); Any ideas?

Jan, YOU ARE A GENIUS! Well, maybe. Seriously, I plugged that in on my test site a few hours ago and it worked with some of the same products it was failing with before. But, I keep getting phone calls and emails so I haven't been able to do better testing. I'll give it some harder and more real world product combinations to see how well it will work, but intitially it looks great. Thanks a lot for your help on this because I don't know if I would have been able to make it work correctly. Do you think it will run into problems with time on large orders?

The first 4 of the array are a product that's being packaged on its own. Do you think I have a problem somewhere else?

Well, I'm puzzled now. Here is that output with some various products but it fails with just the bamboo items too. The really strange thing is I could swear it worked correctly when I first changed over from the old version. Unfortunately, I have a mountain paperwork so I have to wait to dig for the problem. Array ( [0] => Array ( [length] => 33.0 [width] => 1.5 [height] => 1.5 [current_weight] => 0.7 [price] => 5.25 ) [1] => Array ( [length] => 33.0 [width] => 1.5 [height] => 1.5 [current_weight] => 0.7 [price] => 5.25 ) [2] => Array ( [length] => 33.0 [width] => 1.5 [height] => 1.5 [current_weight] => 0.7 [price] => 5.25 ) [3] => Array ( [length] => 33.0 [width] => 1.5 [height] => 1.5 [current_weight] => 0.7 [price] => 5.25 ) [4] => Array ( [length] => 33.0 [width] => 1.5 [height] => 1.5 [current_weight] => 0.7 [price] => 5.25 ) [5] => Array ( [id] => 43 [name] => 31x15x7 [description] => 31x15x7 [length] => 31.0 [width] => 15.0 [height] => 7.0 [empty_weight] => 1.5 [max_weight] => 16.00 [volume] => 3255.000 [x] => 7.0 [y] => 15.0 [z] => 31.0 [remaining_volume] => 2550 [current_weight] => 2.7 [products] => Array ( [0] => Array ( [id] => 45 [name] => Avena (oats) - Natural Green - 6 oz [model] => [image] => Avena_natural.jpg [price] => 3.4900 [quantity] => 1 [weight] => 0.4 [length] => 30.0 [width] => 2.0 [height] => 2.0 [ready_to_ship] => 0 [final_price] => 3.49 [tax_class_id] => 1 [attributes] => [x] => 2.0 [y] => 2.0 [z] => 30.0 [volume] => 120 ) [1] => Array ( [id] => 71 [name] => Triticum (wheat) - Natural Green- 26"-29" - 6 oz [model] => [image] => Triticum_natural.jpg [price] => 4.2900 [quantity] => 1 [weight] => 0.5 [length] => 30.0 [width] => 2.0 [height] => 3.0 [ready_to_ship] => 0 [final_price] => 4.29 [tax_class_id] => 1 [attributes] => [x] => 2.0 [y] => 3.0 [z] => 30.0 [volume] => 180 ) [2] => Array ( [id] => 419 [name] => Dried Hydrangeas - Large Hamburgs - 3 stems [model] => [image] => hydrangea_hamburg_large.jpg [price] => 11.9900 [quantity] => 1 [weight] => 0.3 [length] => 5.0 [width] => 9.0 [height] => 9.0 [ready_to_ship] => 0 [final_price] => 11.99 [tax_class_id] => 1 [attributes] => [x] => 5.0 [y] => 9.0 [z] => 9.0 [volume] => 405 ) ) [price] => 19.77 ) ) Here is a PhPmyadmin output of my packaging table. INSERT INTO `packaging` VALUES (31, 'Large', '31x15x10', '31.0', '15.0', '10.0', '2.0', '20.00', 2), (43, '31x15x7', '31x15x7', '31.0', '15.0', '7.0', '1.5', '16.00', 1), (46, '34x5x8', '34x5x8', '34.0', '8.0', '5.0', '1.5', '10.00', 1), (45, '48x8x6', '48x8x6', '48.0', '8.0', '6.0', '2.0', '25.00', 1), (47, '13x13x13', '13x13x13', '13.0', '13.0', '13.0', '1.0', '5.00', 2);

Hi Jan, Unfortunately, commenting out the sanity check does not correct the problem. I studied the packaging routine quite a bit yesterday and I was thinking that I could specify boxes for certain products based on thier length. I'll work on that next week and see how it goes. John

double post

The old saying "having the right tool for the job makes life easier" really applies to working on OSC. I don't know what you're using to work on your site, but I've been where you are and you are in for a challenge. Get Macromedia Dreamweaver and learn how it works and it's capabilities. It's worth it. Go to the PHP website tutorial and that will help a lot and explain how to comment out lines etc. The other thing is read all the OSC documentation so you understand how the file structure works and see examples of "how to". Open catalog/includes/languages/english/modules/shipping/upsxml.php and you will see where that is defined. Look for define('MODULE_SHIPPING_UPSXML_RATES_TEXT_DESCRIPTION', 'United Parcel Service (XML)'); Change it to say what you want.

Yes To remove time in transit from displaying comment out line 304-324 Most text that you need to change in OSC is found in includes/languages/ and for this contrib it's includes/languages/english/modules/shipping/upsxml.php and you can change it to United Parcel Service (UPS)

Well, I just copied a product from one category to another to test it and it works on mine moving all the data. I looks like you don't have all the data on the product you are trying to copy, but I just get by with manipulating code. Here is the query insert from my admin/categories.php. case 'copy_to_confirm': if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) { $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); if ($HTTP_POST_VARS['copy_as'] == 'link') { if ($categories_id != $current_category_id) { $check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['total'] < '1') { tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')"); } } else { $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error'); } } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { // LINE MODED: Added "products_ship_price" $product_query = tep_db_query("select products_ship_price, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); // LINE CHANGED: MS2 update 501112 - Added :(empty($product['products_date_available']) ? "null" : ...{some code}... ") . " // LINE MODED: Added "products_ship_price" tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_ship_price, products_image, products_price, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . $product['products_ship_price'] . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ". '" . tep_db_input($product['products_weight']) . "', '0', '" . $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); Hope this helps