Easy Populate 1.2.5.4 support

[welshranger]

Thanks for all your replies

ill take a look schoolboy

[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/nhl...pleupload4.txt

or

http://www.teamnhl.us/store/temp/nhl...pleupload4.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

[awhfy99]

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/nhl...pleupload4.txt

or

http://www.teamnhl.us/store/temp/nhl...pleupload4.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!

[cmezzetta]

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

[Jeff G]

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.

[cmezzetta]

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

[Jeff G]

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.

[goldenhues]

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?

[thehighlandsgroup]

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

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