CatDadRick

February 26, 2008

Jim,

Thanks for the excellent job on re-working the MVS Shipping Estimator. The new buttons are a much better match to OSC's standard buttons and integration on the Product Info page is great.

Thanks,

Rick

February 13, 2008

Surfalot,

I've installed EP 2.76f as you suggested and I've added my 12 fields. So far, everything seems to work fine except that the new fields I've added don't show up in the box for the custom download. It's not a big deal as they do work if I use the quick links below the box, but is it possible for me to get check boxes for all of my additional fields?

Thanks,

Rick

Surfalot,

I found what I was looking for. Now I have functional check boxes for all of my additional fields.

Thanks Surfalot for an excellent contribution and good advice.

BTW Do you surfalot? My brother owns a surf shop in Huntington Beach, CA.

February 13, 2008

Hi Rick,

Good idea. I've thought for a long time that the osC packing list is spartan.

What features do you think should be on the list (and what shouldn't be)?

My thoughts:

1. No logo

2. Large font for quantity, product & code to help with picking

3. "Picked By" and "Checked By" areas

4. Total order weight in Kg (?)

5. No prices

Cheers

Chris

Chris,

Any more thought on this?

Thanks,

Rick

February 13, 2008

Surfalot,

I've installed EP 2.76f as you suggested and I've added my 12 fields. So far, everything seems to work fine except that the new fields I've added don't show up in the box for the custom download. It's not a big deal as they do work if I use the quick links below the box, but is it possible for me to get check boxes for all of my additional fields?

Thanks,

Rick

February 12, 2008

v2.76f R1 is the most fixed. what tables have you added fields from ?

Thank, Surfalot, I'll download that version and add my fields. I have 4 fields from Multi Vendor Shipping 1.1 and 7 fields from a products discount contrib. All of these fields are in the products table.

Thanks,

Rick

February 11, 2008

that makes sense to me. that is two of the reasons I decided an admin is not the way to go. There isn't enough room in the admin to provide all the proper explanation needed for each option and that tab issue. And of course, with a nice simple admin, nobody reads the docs like the readme begs you to do. You would be better off using one of my versions. This contribution is quite complex and shouldn't, if not can't, be reduced to an "admin version". There are quite a few bug fixes since 2.76d. Have fun :)

Surfalot,

Thanks for your reply. I've been using v 2.61 I think. I've wanted to upgrade but I've added several fields to it and didn't want to fix something that wasn't broken. The admin version sounded like a good idea, but if the tab issue can't be easily fixed then the admin panel doesn't mak a lot of sense. There several EPs to download, which one do you recommend?

Thanks,

Rick

February 11, 2008

Easy Populate 2.76d-MS2 (with attributes) is FANTASTIC.
I was limping along with an older version that was FUBAR.

Surfalot is the Man!

Special thanks to:

Mossey Jude for the Admin adaptation...the perfect touch.

UGLi's May 6, 2006 recommendation to index the products_model field has really supercharged my 20,000 product catalog.

Netstep,

Do you have EP 2.76d with Attributes and Admin working? I installed it last night and everything seems to work except that I can't use the "tab" delimiter. Unless I hard code it into easypopulate.php tab is seen as "\t", not as a true tab character. When I look at the output my fields are delimited by \t, not by tabs.

Thanks,

Rick

February 11, 2008

Hi all,

I've just upgraded from a very early version of EP to version 2.76d with admin. Everything seems to work well except for Field Separator. No matter what I put in the field, it stays at comma. I use phpMyAdmin to manage my DB and I can see that the configuration value is being changes as I update the settings in admin and the admin panel shows the changes correctly, but when I open Easypopulate the separator is set to comma. Any idea how I can fix this?

Thanks,

Rick

OK, I found part of the problem. This version has a setting for Excel friendly output that, if set to true will force the separator to comma. I've set this to false and now I can get any of the separators to work except tab, the default. I think it's due to the use of "\t" in the $separator array in easypopulate.php. If I select Tab in the admin panel, I get output that has \t between each field, not an actual tab. If I hard code the Tab separator in easypopulate.php , like other versions of Easy Populate, it works fine. Does anyone know how this might be fixed? is anyone else using this version of Easy Populate with admin?

Thanks,

Rick

February 11, 2008

Hi all,

I've just upgraded from a very early version of EP to version 2.76d with admin. Everything seems to work well except for Field Separator. No matter what I put in the field, it stays at comma. I use phpMyAdmin to manage my DB and I can see that the configuration value is being changes as I update the settings in admin and the admin panel shows the changes correctly, but when I open Easypopulate the separator is set to comma. Any idea how I can fix this?

Thanks,

Rick

February 10, 2008

Is the constant set in your database? Try uninstalling and reinstalling the module for that vendor.

Regards

Jim

Thanks Jim,

Removing and re-installing worked. Strange thing is, I've had it working in the past, why would it need re-installing.

Thanks,

Rick

February 9, 2008

Repost

Jim,

I just added new product that uses FedEx shipping, so since I haven't used FedEx for some time I thought i should test the module. The module works and I do get shipping rates, but I also get this error in the Ship Estimator window...

Warning: constant() [function.constant]: Couldn't find constant MODULE_SHIPPING_FEDEX1_ZONE_8 in /var/www/catalog_live/includes/modules/vendors_shipping/fedex1.php on line 75

Here's the code from around line 75...

	function zone($vendors_id='1') {
  $this->zone = @constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id);
  return $this->zone;
}

function enabled($vendors_id='1') {
  $this->enabled = false;
  $status = @constant('MODULE_SHIPPING_FEDEX1_STATUS_' . $vendors_id);
					if (isset ($status) && $status != '') {
	$this->enabled = (($status == 'True') ? true : false);
  }
  if ( ($this->enabled == true) && ((int)constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id) > 0) ) {
	$check_flag = false;
	$check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . (int)constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id) . "' and zone_country_id = '" . $this->delivery_country_id . "' order by zone_id");
	while ($check = tep_db_fetch_array($check_query)) {
	  if ($check['zone_id'] < 1) {
		$check_flag = true;
		break;
	  } elseif ($check['zone_id'] == $this->delivery_zone_id) {
		$check_flag = true;
		break;
}

As you can see, I do have the constant defined. Can you give me any suggestions for fixing this? I've used this FedEx in the past and don't recall getting this error. It wouldn't have anything to do with PHP5/MySQL5 would it?

Thanks,

Rick

February 8, 2008

I'd sure appreciate some help here. I'm honesty stuck. Can't find any help --not on forum or knowledge area. PLEASE SOMEONE HELP!

I'm also getting this message in my error log. Related?

PHP Warning: reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object in /...oscommerce/includes/classes/vendor_shipping.php on line 48

When I go there I find this code:

reset($modules_array);

Larry

Larry, I'm no expert but I think you have a PHP5 error. PHP5 handles arrays differently than previous PHPx. You might want to post here "http://www.oscommerce.com/forums/index.php?showtopic=101973". It's the support thread for MVS-1.x.

Rick

February 8, 2008

Jim,

I just added new product that uses FedEx shipping, so since I haven't used FedEx for some time I thought i should test the module. The module works and I do get shipping rates, but I also get this error in the Ship Estimator window...

Warning: constant() [function.constant]: Couldn't find constant MODULE_SHIPPING_FEDEX1_ZONE_8 in /var/www/catalog_live/includes/modules/vendors_shipping/fedex1.php on line 75

Here's the code from around line 75...

	function zone($vendors_id='1') {
  $this->zone = @constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id);
  return $this->zone;
}

function enabled($vendors_id='1') {
  $this->enabled = false;
  $status = @constant('MODULE_SHIPPING_FEDEX1_STATUS_' . $vendors_id);
					if (isset ($status) && $status != '') {
	$this->enabled = (($status == 'True') ? true : false);
  }
  if ( ($this->enabled == true) && ((int)constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id) > 0) ) {
	$check_flag = false;
	$check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . (int)constant('MODULE_SHIPPING_FEDEX1_ZONE_' . $vendors_id) . "' and zone_country_id = '" . $this->delivery_country_id . "' order by zone_id");
	while ($check = tep_db_fetch_array($check_query)) {
	  if ($check['zone_id'] < 1) {
		$check_flag = true;
		break;
	  } elseif ($check['zone_id'] == $this->delivery_zone_id) {
		$check_flag = true;
		break;
}

As you can see, I do have the constant defined. Can you give me any suggestions for fixing this? I've used this FedEx in the past and don't recall getting this error. It wouldn't have anything to do with PHP5/MySQL5 would it?

Thanks,

Rick

February 7, 2008

Hi Jim,

Are you saying that an older version of the UPSXML module works with the ship estimator for MVS?

As all I need the UPSXML module for, is the ability to add shipping delays per vendor and to have the rates display an Estimated Delivery Date, if the version on your client's site can do that and will work with the ship estimator, you would REALLY make my day if you could email me a copy of the 2 files you have working so I can get this implemented on my site at cigarsforless.com

(email addy is in my profile)

Thanks much!

Me too Jim,

One of my vendors now includes shipping dimensions in inventory feeds. I think the UPSXML module can give dimensional rates, so it might be handy for me also.

Thanks,

Rick

February 6, 2008

Rick: Now that I have an editor again, I remembered that I had to change the code for the close window button as well. The original has this in locations that don't always get called, so you don't always have a close button. Find this text near the end:
</table>

<?php

if ($debug == 'yes') {
and add just before that
  <tr>
<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '10'); ?></td>
 </tr>
 <tr>
<td>
  <p align="center">
  <?php echo '<a href="java script:window.close()">' . tep_image_button('button_close_window.jpg', IMAGE_BUTTON_CLOSE) . '</a>'; ?>
  </p>
</td>
 </tr>
You should also remove the close window code from elsewhere on this page so it doesn't show up twice.

Regards

Jim

Thanks Jim, that worked. In testing this I noticed that if I clicked on Ship Estimator after my login expired I would get an empty window with a close button just about dead center, right where the shipping info should be. I was looking at moving the close function, but wasn't sure how far down to go.

Also, you're trying to get this to work with the UPSXML module? I'm still using the UPS (non XML) module. Is there a reason to go to the UPSXML module?

Thanks,

Rick

P.S. (If anyone else is following this and trying to get it to work, there is no space between java and script in "java script:window.close()" in the above code snippet. This editor dosesn't seem to like javascript as one word).

February 5, 2008

I had the same problerm. If I remember correctly it has nothing to do with ship_estimate.php. You need to add code from the readme in either the box or the shopping_cart.php (I call the estimator from a box only). Did you add the javascrript? You must access the page from the buuton on the shopping_cart.php or your box to have the close button function. Just navigating to the ship_estimate.php page won't allow you to use the close button as you never poped up to get the window.

-Kendall

Kendall,

I am accessing the Ship Estimator from my cart, not by calling the page directly. The pop-up is working. Shipping estimates are good, just no close button.

Jim,

When you get Eclipsed fixed maybe you can send me the line number and stuff. The code you posted didn't work. I found 2 close() statement and tried it on both, but no go.

Thanks,

Rick

February 5, 2008

Rick: The close button is there, it's just in the wrong location -- look in the images folder. You need to move it to catalog/includes/languages/english/images/buttons.

Regards

Jim

Jim,

I have the button graphic and it's in the right place, now, but I don't have the button in the Ship Estimate window. I've looked at ship_estimate.php

Thanks,

Rick

February 5, 2008

That's the version I'm working on. I'm currently having problems with getting UPSXML to work at all, under any circumstances. It's giving me an Invalid Document error. Bleah. I gave up on it for a bit to try to get some other things working.

Jim,

I have this installed now and everything seems to work well except for the [CLOSE WINDOW] button. There is no close windows button in my Ship Estimator window. Do you have the button?

Thanks,

Rick

February 5, 2008

That's the version I'm working on. I'm currently having problems with getting UPSXML to work at all, under any circumstances. It's giving me an Invalid Document error. Bleah. I gave up on it for a bit to try to get some other things working.

There is a security/global variable issue in ship_estimator.php. If you are running this on a live site, I would recommend adding this code to the top:
  switch (true) {
case isset($_GET['action']):
  $action = $_GET['action'];
break;
case isset($_POST['action']):
  $action = $_POST['action'];
break;
default:
  $action = '';
 }
 $action = preg_replace("(\r\n|\n|\r)", "", $action);  // Remove CR &/ LF
 $action = preg_replace("/[^a-z_]/i",'', $action); // Strip anything we don't want
Why the code uses both POST and GET to pass the action is beyond me. Oh well, it works.

Actually, the thing that really surprises me is my initials on v1.0. I don't remember doing this. At all. Ever. Either my memory is worse than I thought, or ... I can't think of any other reasonable explanation. Drat.

Regards

Jim

Jim, Cigarsforless,

I just installed this on my test store yesterday, late afternoon and so far it seems to work OK. I use the standard UPS module, not the UPSXML module, tho I'm not sure why. What advantage does the UPSXML module have over the standard/non-XML module?

Jim,

Thanks for the code, I'll add it to my site today.

Thanks,

Rick

February 5, 2008

Rick

I'm supposed to be working on the shipping estimator. I've got it doing what I want for the contents of the shopping cart, and am working on getting it to work for individual products from the product_info page. Well, I should be doing all of that, but mostly I'm getting interrupted to fix things my clients have broken, and to booby-trap part of the admin to catch them when they break it again. Grrr.

I've also half-started another shipping module (R&L Freight.) That's a low priority, so don't expect it anytime soon. Unless someone waves large amounts of money in my face.

The shipping checkout will always highlight the cheapest shipping method, no matter where it is on the list. You can put UPS at the top of the list and FedEx at the bottom, but if FedEx is cheapest, that's what will be selected by default. The customer will then do whatever they want, anyway. So it goes.

Regards

Jim

Jim,

I downloaded MVS Shipestimator v1.1b a week or so ago, it's my next project. Is that the one you're working on?

Rick

February 4, 2008

what does admin sort order do?

Drillsar,

What Sort Order is supposed to do is give you control over the priority of the module at checkout. In other words, if you have 3 shipping modules installed, USPS, UPS & FedEX. You allow all 3 methods but you prefer USPS. Set the Sort Order for USPS to a lower number than UPS or FedEX and USPS will be selected as the default shipping method. That's how it's supposed to work. However, in several places this doesn't work, but I think in the Vendor Shipping modules it does.

Rick

February 4, 2008

Rick,

Can you possibly send me your usps.php file? Thanks

Drillsar,

Don't know if you're following this thread this morning, but I've got it working now.

With my usps.php, goto line 177 and fix the typo

if (($maxins == 0) || (constant('MODULE_SHIPPING_USPS_INSURE_' . $vendors_is) == 'False')) {

Should be

if (($maxins == 0) || (constant('MODULE_SHIPPING_USPS_INSURE_' . $vendors_id) == 'False')) {

Then look at line 227. You'll see this

$uspsQuote = $this->_getQuote();

Change it to

$uspsQuote = $this->_getQuote($vendors_id);

Jim spotted that last change and I think that's what made it work for me.

Also, if you want the admin sort order to work, apply the fix I posted earlier in this thread. Like Jim says, it shouldn't work, but it does. Go figure.

Hope this helps,

Rick

February 4, 2008

I put in these print statements -- Line 175:
print 'Cost per package: ' . $costperpkg . "<br>\n";
and Line 207
print 'Insurance: ' . $insurance . "<br>\n";
Those values were being set properly, so the output should have been correct. Which it was. You might need to add in some more checkpoints depending on what you see from those two. This is my normal debugging mode (once I get all of the typos that the validator finds.) There's nothing like knowing what all of those constants and variables are really set to.

Regards

Jim

Edit: Too slow again. Oh well, glad to hear that you got it working.

Jim,

Thanks for the trouble shooting tips, I'm never sure where to put things like print statements. Maybe this will help me learn to better find my errors.

It seems the real problem was, insurance was always on/true, not off/false as I thought. I think adding the $vendors_id to line 227 solved the problem and I just didn't see it because I was looking for insurance to come on, not go off. Anyway, thanks again for your help.

P.S. Are you working on any new modules at this time?

Thanks again,

Rick

February 4, 2008

I put some test numbers into this, and I'm seeing the Insurance being added to the shipping cost. I have no idea why yours isn't. I can only suggest you put some Print statements in (or file logging or mail if you are on a live site) and try to find the values that are not properly set.

Regards

Jim

Jim,

It's working now. After my last reply, I went back to admin, set insurance to false, updated and then set insurance to true and updated again, now it's working. I'm going to do a bit more testing, but Ithink it's ready for my live store.

Thanks for your help,

Rick

February 4, 2008

I put some test numbers into this, and I'm seeing the Insurance being added to the shipping cost. I have no idea why yours isn't. I can only suggest you put some Print statements in (or file logging or mail if you are on a live site) and try to find the values that are not properly set.

Regards

Jim

Jim,

How did you put test numbers into it? I'm working on a "sandbox" site until I have everything working. Any suggestions where to put print statements? I have PHP error logging turned on so I can see errors on my sandbox, but I'm not getting any.

Thanks,

Rick

CatDadRick

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by CatDadRick

Multi_Vendor_Shipping new thread

Easy Populate & Products Attributes

[CONTRIBUTION] PDF Customer Invoice

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Fedex1 in MVS

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Multi_Vendor_Shipping new thread

Browse

Activity