Easy Populate 1.2.5.4 support

[gecko77799]

Use version 1.2.5.4 which has is supported in this thread together with WIKI at
http://www.zen-cart.com/wiki/index.php/Easy_Populate

Version 1.2.5.4 shows compatibility with ZC 1.36 Tearing down my whole store with mods and all isn't much of an option. I don't want to take the chance of messing other mods or store functionality up by such a downgrade. Since there is no official 1.2.5.6 thread I assumed this is the best place to come since all the EZ Pop wizards are here.

So does anyone mind taking a crack at my Duplicated Manufacturer issue?

[misty]

Version 1.2.5.4 shows compatibility with ZC 1.36

Yes, and also works with ZenCart 1.3.8.a, which is why
suggested it, because version you have installed is not
as stable.

[chadderuski]

I'm getting some of the Manufacturers duplicated but not all. It's very weird. I'm using ZC 1.38a and EZ Pop 1.2.5.6 I verified that all variations of the Manafacturer's names were eliminated so there was only one for each. Nothing else has been duplicated. Help please.


I've looked up and down this support thread. If the answer to this already exists I apologize but my eyes are starting to bleed now.

You most certainly have something different in the manufacture's name ... even an added space at the end will cause a duplicate, ie:

"Libbey" vs "Libbey "

Manufacturer's are also case sensitive:

"Libbey" vs "libbey"

This issues is also evident in Category names.

[schoolboy]

I just installed EasyPopulate on my new zencart and I am trying to upload a datafile to it. I get the following errors when I try to upload "An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer" I dont have an easypopulate errorlog in my Temp folder and I dont really know what to do, it said that the file itself may be causing the issue so I will post that as well. Any info would be a great help, thank you!

What EP version are you using? The 1.2.5.6 CSV version?

(I personally don't use these newer "csv" versions as they appear to be a bit buggy).

Your v_products_price...

$35.61
$341.76
$341.80
$335.07
$341.80
$341.80
$30.65
$169.33
$299.06
$347.04


You are including a $ symbol before the price. This column should just be the numeric value - NO currency symbol.

[llynix]

Here is an open question to EP users: Does the froggle code really need to be in this? It seems there are several google feeders that perform this function just fine.

Well to me I thought the froogle code would be a happy bonus, as I don't have anything like it in my cart yet. But it appears to be severely outdated as froogle is now the Google merchant center or something like that. Looking through the docs there it would appear that the feed this produces isn't exactly compatible.

So as it stands now it seems broken. If it were to be fixed to work with what Google now offers I would definitely use it.

Anthony Taylor
Webmaster
http://buydentalequipment.com

[llynix]

So as it stands now it seems broken. If it were to be fixed to work with what Google now offers I would definitely use it.

Alright.. I had a peek inside and did what I can to bring EP into shape with regards to Google.

This is untested and may contain bugs!! However the old version was broken so maybe this is better.

Here is the diff:

557c557
< 			'v_froogle_ shipping'   => $iii++,
---
> //			'v_froogle_ shipping'   => $iii++,
559c559
< 			'v_froogle_ upc'    => $iii++,
---
> //			'v_froogle_ upc'    => $iii++,
564c564
< 			'v_froogle_manufacturer_id' => $iii++,
---
> //			'v_froogle_manufacturer_id' => $iii++,
566c566
< 			'v_froogle_product_type'  => $iii++,
---
> //			'v_froogle_product_type'  => $iii++,
568c568
< 			'v_froogle_currency'    => $iii++,
---
> //			'v_froogle_currency'    => $iii++,
572,573c572,573
< 			'product_url'   => $iii++,
< 			'name'      => $iii++,
---
> 			'link'   => $iii++,
> 			'title'      => $iii++,
576,580c576,580
< 			'image_url'   => $iii++,
< 			'category'    => $iii++,
< 			'offer_id'    => $iii++,
< 			'instock'   => $iii++,
< 			'shipping'    => $iii++,
---
> 			'image_link'   => $iii++,
> 			'product_type'    => $iii++,
> 			'id'    => $iii++,
> 			'condition'   => $iii++,
> //			'shipping'    => $iii++,
582c582
< 			'upc'     => $iii++,
---
> //			'upc'     => $iii++,
587c587
< 			'manufacturer_id' => $iii++,
---
> //			'manufacturer_id' => $iii++,
589c589
< 			'product_type'    => $iii++,
---
> //			'product_old'    => $iii++,
591c591
< 			'currency'    => $iii++,
---
> //			'currency'    => $iii++,
754,756c754,756
< 		$row['v_froogle_instock']     = 'Y';
< 		$row['v_froogle_shipping']    = '';
< 		$row['v_froogle_upc']       = '';
---
> 		$row['v_froogle_instock']     = 'new';
> //		$row['v_froogle_shipping']    = '';
> //		$row['v_froogle_upc']       = '';
760c760
< 		$row['v_froogle_manufacturer_id'] = '';
---
> //		$row['v_froogle_manufacturer_id'] = '';
762c762
< 		$row['v_froogle_product_type']    = 'OTHER';
---
> //		$row['v_froogle_product_type']    = 'OTHER';
764c764
< 		$row['v_froogle_currency']    = 'usd';
---
> //		$row['v_froogle_currency']    = 'usd';
798a799
> 			// Google merchants doesn't seem to require the quotes anymore A.T.
800,801c801,802
< 			$row['v_froogle_products_name_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name']))) . '"';
< 			$row['v_froogle_products_description_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description']))) . '"';
---
> 			$row['v_froogle_products_name_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name'])));
> 			$row['v_froogle_products_description_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description'])));

There are a few spots where it could be cleaner. And right now it just defaults to 'new' for the condition which seems to be required.

I went off the directions located here: http://www.google.com/support/mercha...&answer=160083

I've yet to test this, because I'm running it on a beta site which has a few mangled product prices that I don't want released in the wild. I'll get back with you guys when I've tested.

Anthony Taylor
Webmaster
http://buydentalequipment.com

[Scrat]

llynix My advice would just use 'Google Base Feeder' as in the add-ons. This is a much better mod now than EP for google feeds as you can automate via con jobs. As everthing in software, this mod has not been develop lately and things have moved on...

[llynix]

llynix My advice would just use 'Google Base Feeder' as in the add-ons. This is a much better mod now than EP for google feeds as you can automate via con jobs. As everthing in software, this mod has not been develop lately and things have moved on...

Except the Google base feeder hardcodes the condition field. My Zen Cart installation has been hacked to add an additional condition field. So no matter what I would have to hack something. Since we'll be using Easy Populate in other projects it seemed the lesser of two evils. It wasn't too hard to hack into shape. Things haven't changed that much.

Anthony Taylor
Webmaster
http://buydentalequipment.com

[schoolboy]

Well - this week I took delivery of my shiny new HP Pavillion, loaded up with all the latest MS horror stories (vista64, MS Office 2007...)

... and I set about working with some clients' sites using EasyPop to manage some price changes.

Export TXT file to Temp Folder (All OK)
Open MS Excel 2007 (All OK)
Import TXT file into Excel (sort of OK, but apply all the format stripping procedures and it should be fine)
Do edits to data. (OK)
SAVE AS tab-delimited file (OK)
Open file in notepad++ to see if I can spot obvious MS junk (OK)
FTP to temp folder (OK)
Use EP to import into database...

... BANG! CRASH! SPLINTER...

All product data disappears!

Major panic. Swallow heart pills. Take 2 cups of espresso.

-------------------------------------------

Go onto old computer.
Use similar process as above... THIS TIME use OPEN-OFFICE CALC instead of MS...

Runs as smooth as a Cheetah...

Data back in dbase - all is OK

What's the moral of the story? (You tell me...)

[chadderuski]

Hiya Schoolboy!

So... You DID make a backup before using EP??? LOL!

What you describe sure sounds like some funky end-of-line issues. Did they change something in excell 2007?

If you track it down, please post your discovery. I have had similar problems via excell on the MAC that necessitated using OO to export my tab or CSV files.

-cj