Easy Populate 1.2.5.4 support

Read my WIKI TUTORIAL on Easy Populate.

Thanks for all your replies:clap:

ill take a look schoolboy:D

I've got Easy Populate module configured with correct files uploaded. I've also configured upload tab delimited text file. 5 Test products upload correctly. Only is issue is Catgories. Items are to be added to subcategory under Retail and Commercial but categories are added at primary category level.

Example of store output is:
http://www.teamnhl.us/store

Upload file can be viewed at:
http://www.teamnhl.us/store/temp/nhlfurnitureproducts-editedeasypopulatesampleupload4.txt

or

http://www.teamnhl.us/store/temp/nhlfurnitureproducts-editedeasypopulatesampleupload4.xls

I've checked for characters in spreadsheet and that cateogories and subcategories match up. There are no backslashes or forward slashes or any other characters except in product description field. I've also checked to make sure there are no missing headers in spreadsheet.

Any ideas?

Cheers,

Gene Fourney
The Highlands Group

thehighlandsgroup:

I've got Easy Populate module configured with correct files uploaded. I've also configured upload tab delimited text file. 5 Test products upload correctly. Only is issue is Catgories. Items are to be added to subcategory under Retail and Commercial but categories are added at primary category level.

Example of store output is:
http://www.teamnhl.us/store

Upload file can be viewed at:
http://www.teamnhl.us/store/temp/nhlfurnitureproducts-editedeasypopulatesampleupload4.txt

or

http://www.teamnhl.us/store/temp/nhlfurnitureproducts-editedeasypopulatesampleupload4.xls

I've checked for characters in spreadsheet and that cateogories and subcategories match up. There are no backslashes or forward slashes or any other characters except in product description field. I've also checked to make sure there are no missing headers in spreadsheet.

Any ideas?

Cheers,

Gene Fourney
The Highlands Group

Not sure why you are getting that. I uploaded your file to my test site and it came out as expected, 2 top level with the correct sub-cats. My test site is 1.3.7 but I don't see why that would make a difference. I have another live site that I use EP on (it's 1.3.8a) without any problems.

I would suggest a manual addition of the cats/sub-cats and then upload it again (or just move the ones already there).

If that doesn't work, then I am just as puzzled as you!
Good luck!

I've got a problem with a site. I was working with instructions from a friend of mine who set the site up and is currently out of town. I really need to try to get the site back up.

I used Easy Populate to download the database (PriceQty-EP2008Dec02-2210.txt). I made the price changes, and then I saved the file as PriceQty.txt and I uploaded. It looked like everything went alright, one or two bad lines, but everything else was accepted. I checked a couple products under admin and the pricing had updated.

This was the middle of the day yesterday (Sunday). THis morning (monday) I came in, and tried to bring up the home page and got this message:

Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

I tried to login to the admin and got this message:

0 DB_ERROR_NOT_CONNECTED
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]

Any help is appreciated.
THanks,
chris

Your problem is unlikely to be EP.

Your site cannot connect to the database. (All files, not just product.)

Assuming nothing else was changed, you need to contact your hosting company or the person that maintains the server. Either your sql server is down (most likely)or your database is corrupted.

On the FTP site, I can see the file I uploaded via Easy Populate and it's 46457k. When I download the file, it's a zero k file. Might that mean the file is corrupted. Is it possible I named it incorrectly? Can I repost my backup via the ftp site or is this a lengthier process than just putting the file on the ftp site?

My backup is just PriceQty-EP2008Dec02-2210.txt. Is that all I need or is there a larger backup I should have pulled down before starting this?

Thanks,
Chris

Nothing to do with EasyPopulate or your file or FTP. The file you are refering to is only a temp work file and has nothing to do with the operation of your site.

All site data is stored in a SQL database. The error is a problem connecting to that.

Do you know where your site is hosted? Tell their tech support about the problem. They should be able to check the sql server.

There are a few different ways you can connect to sql, so there is not one simple answer.

If you look at includes/configure.php you will see the sql server name. That may help you to get to the right support people.

Hi , all my products and categories upload with the quantities 3 of category x , 34 of category y but when I click the category it says there are no products to display .I rechecked my data file and everything looks ok that products , image , url , categories are in the right place with the appropiate data. any ideas?

awhfy99:

Not sure why you are getting that. I uploaded your file to my test site and it came out as expected, 2 top level with the correct sub-cats. My test site is 1.3.7 but I don't see why that would make a difference. I have another live site that I use EP on (it's 1.3.8a) without any problems.

I would suggest a manual addition of the cats/sub-cats and then upload it again (or just move the ones already there).

If that doesn't work, then I am just as puzzled as you!
Good luck!

Thanks for the reply. I did manual addition of cats/sub-cats and then uploaded already. It looks as if I'll build out spreadsheet and then manually move categories after upload.

Cheers,

Gene Fourney
The Highlands Group

I just read through the wiki and I trying to come up with the best concept for uploading attributes. The wiki touches on using a sku for a product number such as
20105444
20 being shirt
10 long sleeve
5 being small
444 being product ID

What I am having a hard time with is the best way to populate my attributes. This sku theory leads me to believe I would have the same product added 4 times once per size as a new product. Currently I have a spreadsheet that has my colors and sizing but it isn't formated anywhere close to the by attribute that easypopulate accepts. Do anyhow have any advice here? Anything really? The only thing I can think of is figuring my own direct import into the db through php admin.. which wouldn't be easy for me but would be manually adding all of the products size and color variants.

ahall13:

.... Do anyhow have any advice here? Anything really? The only thing I can think of is figuring my own direct import into the db through php admin.. which wouldn't be easy for me but would be manually adding all of the products size and color variants.

The only advice I can offer is in the way of common sense; The easier it is for you to distinguish products by their SKU at a glance the better off you'll be.

If you do not rely on a distributor that uses standardized SKUs, you're free to make up your own, and you can use letters as well, so that Red doesn't have to be 444, it can be RD or whatever.

I also tried to make some kind of standardized system for myself across the field, but the model numbers don't have to be sequential (or make any kind of sense) and the biggest hurdle is being able to use them after not looking at them / thinking about them for a few weeks, after they'd cleared out of your short-term.

-Tim

For a quick tutorial on how to add fields to easy populate go to http://www.zen-cart.com/forum/showthread.php?t=116061

ahall13:

I just read through the wiki and I trying to come up with the best concept for uploading attributes. The wiki touches on using a sku for a product number such as
20105444
20 being shirt
10 long sleeve
5 being small
444 being product ID

What I am having a hard time with is the best way to populate my attributes. This sku theory leads me to believe I would have the same product added 4 times once per size as a new product. Currently I have a spreadsheet that has my colors and sizing but it isn't formated anywhere close to the by attribute that easypopulate accepts. Do anyhow have any advice here? Anything really? The only thing I can think of is figuring my own direct import into the db through php admin.. which wouldn't be easy for me but would be manually adding all of the products size and color variants.

Have you downloaded a complete model/attributes(after manually adding a product or three with attributes in the admin panel)? You should be able to copy and paste from your spreadsheet into that file. I know it's awkward to use at first but once you are familiar with the fields it's easy. All of the spreadsheets from our vendors have to get copied and pasted, but it's not too hard once you've done it once or twice.

If you want to post a snippet of your spreadsheet we can see if we can offer any solutions.

Hello everyone, I'm not sure this is the right place to post this, but I downloaded the new Langer's EP [ Easy Populate Advance2.75a-Zen-Cart 1.2 - Default Language English(1) ] but the functions will not work. I've double then triple checked that I put the files into the right places, but I cannot either Download the tab-delim file nor is one created in the /temp folder. I've checked that temp is 0777.

Am I missing something?

I am running 1.2.5.4 on another Zen Cart install, and it works fine, but it is the older version.

-Tim

Nevermind, the only thing I was missing was some rather basic competence. :(

Works great now!

-Tim

I have to say Zen Cart is one of the best I have seen in testing EVERY cart I can get my hands on. The only issue I have is the LACK of a working easy populate. I have been messing with this thing on two different servers and urls and databases with no luck. I can get everything but a price???? I have changed files, saved with different formats, done everything i can think to do with NO LUCK. Has anyone got this thing to work. I have also used both ver of easy populate with the same results, no price. I am using the newest ZC,

Server Host: ( Database Host: mysq05..com (98..0.89)
Server OS: Linux 2.6.26.5-SMP2 Database: MySQL 5.0.41-community-log
Server Date: 01/03/2009 11:38:55 Database Date: 01/03/2009 11:38:55
Server Up Time: 11:38:55 up 44 days, 4:00, 1 user, load average: 7.80, 6.80, 6.43 HTTP Server: Apache/1.3.37 (Unix) mod_throttle/3.1.2 FrontPage/5.0.2.2635 mod_psoft_traffic/0.2 mod_ssl/2.8.28 OpenSSL/0.9.8b
PHP Version: 5.2.3 (Zend: 2.2.0) PHP Memory Limit: 24M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 189 kB Database Index Size: 322 kB

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2009-01-03 11:15:28] (Fresh Installation)
v1.3.8 [2009-01-03 11:15:28] (Fresh Installation)
PHP Version 5.2.3

Any help would be appreciated...Thank you and be safe

1.2.5.5 is the latest version right? Just asking cuz it says last updated Dec 01 2006.

Also, are questions/concerns regarding modhole's easy populate advanced handled here? Or are most people using 1.2.5.5 here?

Thanks!

Resolved - thanks

Ive been having an encoding file problem when i upload my file to easy populate...half of my characters show up as ?????? in my product descriptions on my website or just some random character...im using microsoft table wizard to combine tables as well and i save as a tab delimited text...i have my easy populate sheet and then i have a sheet with the quantities from my distributors and i just update the quantities in my easy populate sheet with microsoft table wizard and save it as a tab delimited text file.......well ever since i switched computers it has been doing this......

Please someone help me fix this...ive tried saving as UTF format, ASCII format, ISO...etc and all of them do it...

Im using microsoft excel 2007 and i tried open office as well and it still did it...never had this happen till recently when i got a new computer and i cannot figure out what is going on

Its not showing up on the website now like this because i used my old computer, but the old computer is about to die out so i need to figure this out soon...thanks in advance