Zen Cart Logo
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Views: 1,301,217

Results 2,601 to 2,620 of 3,834
1 Nov 2009, 4:56 AM
#2601
gecko77799 avatar

gecko77799

New Zenner

Join Date:
Nov 2008
Posts:
8
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

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. :frusty:

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. :wacko:

1 Nov 2009, 5:53 AM
#2602
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

I'm using ZC 1.38a and EZ Pop 1.2.5.6 I
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

1 Nov 2009, 3:10 PM
#2603
gecko77799 avatar

gecko77799

New Zenner

Join Date:
Nov 2008
Posts:
8
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

misty:

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?

1 Nov 2009, 3:58 PM
#2604
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

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.

2 Nov 2009, 5:24 PM
#2605
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

gecko77799:

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. :frusty:

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. :wacko:

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.

2 Nov 2009, 6:21 PM
#2606
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

NickPCs:

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.

4 Nov 2009, 10:02 PM
#2607
llynix avatar

llynix

Zen Follower

Join Date:
Jul 2009
Location:
Texas
Posts:
210
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

chadderuski:

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

5 Nov 2009, 9:21 PM
#2608
llynix avatar

llynix

Zen Follower

Join Date:
Jul 2009
Location:
Texas
Posts:
210
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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/merchants/bin/answer.py?hl=en&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

6 Nov 2009, 9:14 PM
#2609
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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...

6 Nov 2009, 9:33 PM
#2610
llynix avatar

llynix

Zen Follower

Join Date:
Jul 2009
Location:
Texas
Posts:
210
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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...

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

9 Nov 2009, 6:18 PM
#2611
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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... :shocking::shocking::shocking:

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... :smile:

Data back in dbase - all is OK

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

9 Nov 2009, 8:09 PM
#2612
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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

9 Nov 2009, 9:12 PM
#2613
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

chadderuski:

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

Oh yes... ALL my hosting accounts (for clients) INCLUDE DAILY BACKUP service with the hosting co, and I ALSO employ a fantastic chap in Mumbai (India) who does manual backups a little later than the host's backup system. In that way, I have backups happening every 12 hours... Been doing it this way for years and years... (Only ever had to restore a full backup once though... Host is great!)

9 Nov 2009, 9:18 PM
#2614
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

chadderuski:

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

I tried a few things on a test install of ZC - using the EP file that seemed to be causing problems.

After running EP on one attempt, it seemed to go just fine. EP reported UPDATED PRODUCTS, but they did not appear in the store.

Looking at the DB in phpMyAdmin showed that the PRODUCTS table got populated OK, but the PRODUCTS_DESCRIPTION table was empty...

I figured that something (like line breaks) may be the culprit at v_products_description... but couldn't find anything. Also, looked for " " marks ... nothing.

I'll abandon MS now... Do everything in OpenOffice....

12 Nov 2009, 8:30 PM
#2615
crafterscafe avatar

crafterscafe

New Zenner

Join Date:
May 2009
Posts:
38
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

background:

was using php v4, installed ep v 1.2.5.6 and had probs. so I upgraded to php v5.

I used a freshly downloaded sample file but whoops all the catagorie columns are missing. however, I didn't notice this until I uploaded. It did something but didn't add product.

now I have something really weird - this is the only one I have found like this but I have a product number #310 that is showing two times on the screen, but only one time in the admin section.

I have seen the opposite prob talked about here but not this.

here is the link to the product, if you click it then use the next prev buttons you will see it is only displayed one time. ???

I have looked in DB and see nothing odd. Please help as it also does not update quantities in cart correctly either.

http://crafterscafe.com/index.php?main_page=index&cPath=53_54

it is the polished chrome product 1 x 1"

12 Nov 2009, 8:57 PM
#2616
crafterscafe avatar

crafterscafe

New Zenner

Join Date:
May 2009
Posts:
38
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Is anyone able to use EP to populate new products and QBI for getting info to quickbooks?? are there conflicts with these two programs that I can not find in documention???
I am thinking my problems have something to do with this.

12 Nov 2009, 9:08 PM
#2617
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

crafterscafe Use version 1.2.5.4 from Modhole and you want have any major issues as it just works(One or two bugs) but it will not make your head hurt :no:

Also check your product number for any extra characters, also check in your database to see if you have two records the same.
As for QBI I don't use it so I would need to know the format of the import required, if is a case of re-arranging the format that should be pretty straight forward in OO/excel

15 Nov 2009, 5:40 PM
#2618
jmebright avatar

jmebright

New Zenner

Join Date:
Aug 2009
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have EP working great on Zen 1.3.8a. I have my complete .csv file with all my products, and I need to compare it to a different excel file that has just model #'s and qty.'s. Is there a way to do this automatically or with a macro?

File 1 is a complete .csv file exported from EP.

File 2 is an excel file from my supplier that has roughly 3000 rows and 3 columns. Column A is model #, B is Qty., C is price.

I have excel and open office and I want the Qty. of each model from File 2 to be inserted in the correct Qty. cell for that model in File 1. I want the same thing to happen with the price. Then any model #'s that are in File 2 but not in File 1 should be added to file one.:huh:

Can somebody help with this or is there another site that my be able to help?

15 Nov 2009, 9:28 PM
#2619
kristina avatar

kristina

New Zenner

Join Date:
Aug 2009
Posts:
6
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm running zen-cart 1.3.8a.
I've installed easy populate 1.2.5.7
I'm using a downloaded file as a template but cannot get the file uploaded again.
The error message I'm getting is: "No model field in record. This line was not imported" and no lines are getting imported.
What am I doing wrong???
I'm so :frusty:

15 Nov 2009, 10:32 PM
#2620
jmebright avatar

jmebright

New Zenner

Join Date:
Aug 2009
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Are you using MS or Openoffice?