Easy Populate 1.2.5.4 support

Quote:

---

Originally Posted by buyersparadise

Thanks for the advice. Problem is I tried that and it wont work how come? Once it finds the .000 then it ask what i want to replace it with and I type .jpg and it keeps telling me excel cannot find a match. next to the replace it has a preview and format area. DO I change any thing on there? what should the within, search, and look in be on and should the match case and match entire cell content be checked? Thanks.

---

I suspect the problem is you have to format the column as numbers and then you can't put text in there. Once you get the .00 showing you could copy the whole column and paste it into a text editor, then do a global search & replace to change the .00 to .jpg. Then in excel change the column to text & paste in the changes you made in your text editor.

The problem here is this will only work as long as your image names are all numbers, and all in the main image directory. That's why I like to use a free program called NoteTab Light (actually I use Note Tab Pro, but the free light version will do what you need). It has a feature called block-paste, so you can create a column of:
.jpg
.jpg (etc)
Then after you've copied your file names just put the cursor in front of the first .jpg and from NoteTab's menu do Modify->Block->Paste and the column of file names is pasted in front of the column of .jpg's

If you want to put everything in a subdirectory of the main image directory just block paste the subdirectory name in front of the filename column.

Dennis

Just a quick question...how do I change the currency from $ to £, especially for the Google feed file.

Thanks

Sorry, another quick question. If I upload a file with "model, price & qty" what does EP do with the products?

Does it dump them into one category, if so what one?

Will Easy Populate let me upload products with multiple attributes, multiple, differing quantity breaks and prices?

I understand that I should already have the option names and values already set-up, correct?

Is it possible to export tables from an existing store into Easy Populate?

And can someone please tell me what the difference is between standard and advanced? (I'm sorry but the features list at zenbuilder doesn't do this and, I'm hoping, is probably more elaborate than the paragraph shown).

Thank you!

Val

Quote:
Originally Posted by misty
You are using INCORRECT VERSION...download
EP1.2.5.4.from url below
http://www.zen-cart.com/archived_con...s/admin-tools/


Hello,
I too had the incorrect version of EasyPopulate. When I tried to delete the files in /public_html, and then tried to open my Admin, I received this error message:

Fatal error: Class box: Cannot inherit from undefined class tableblock in /home/ssolis/public_html/admin/includes/classes/box.php on line 27

I do not know what I did, or how to fix this. Can anyone help? As of right now, I cannot access my Admin Panel.

Thanks,
Sandy
##############################___
Sandy Solis
SRS Custom Printing
www.srscustomprinting.com

Sandy,

You need to be sure you completely removed all the old version files from your server before uploading the new *correct* version files. A number of these files are loaded automatically, and they can cause problems like you are suffering when using incompatible versions.

You may have to do this manually ... but it shouldn't be too hard to fix.

-chaddro

Quote:

---

Originally Posted by chadderuski

Sandy,

You need to be sure you completely removed all the old version files from your server before uploading the new *correct* version files. A number of these files are loaded automatically, and they can cause problems like you are suffering when using incompatible versions.

You may have to do this manually ... but it shouldn't be too hard to fix.

-chaddro

---

Thanks chaddro. I thought I did delete all the files that I added for the incorrect version though. I went through and deleted each one manually. I've since decided I do not want to load the Easy Populate module at this time, but maybe if I load the correct version, this will fix the Fatal Error???

Also, I've just received an order in my store, but according to the email from the customer, it did not assign an order number, which I assume is why the system did not notify me of an order. I'm very dead in the water here without access to the Admin Panel. :ohmy:

I've gone back and double checked that I removed all the files from the incorrect version and they are gone. Even through I uploaded the files from the correct version, I still cannot access the control panel. I do not know what else to try... Any help is most appreciated!

Hello, all. This is my first experience with Easy Populate and I am having a problem. When I use the Upload option, it only inserts the first product and stops. It doesn't seem to know when to start a new product. What am I doing wrong?

Quote:

---

Originally Posted by ssolis5788

Thanks chaddro. I thought I did delete all the files that I added for the incorrect version though. I went through and deleted each one manually. I've since decided I do not want to load the Easy Populate module at this time, but maybe if I load the correct version, this will fix the Fatal Error???

Also, I've just received an order in my store, but according to the email from the customer, it did not assign an order number, which I assume is why the system did not notify me of an order. I'm very dead in the water here without access to the Admin Panel. :ohmy:

---

Quote:

---

Originally Posted by ssolis5788

I've gone back and double checked that I removed all the files from the incorrect version and they are gone. Even through I uploaded the files from the correct version, I still cannot access the control panel. I do not know what else to try... Any help is most appreciated!

---

Sounds like maybe you've deleted too many things.
Gotta start from the beginning: http://www.zen-cart.com/wiki/index.p...Obscure_Issues

Quote:

---

Originally Posted by DrByte

Sounds like maybe you've deleted too many things.
Gotta start from the beginning: http://www.zen-cart.com/wiki/index.p...Obscure_Issues

---

The Fatal Error is it referring to is this (in the box.php file):

class box extends tableBlock {

function box() {

$this->heading = array();

$this->contents = array();

}


When I use the "Evaluate Line" tool in Crimson Editor, it says "error(3): function not defined". Is this as simple as defining a function?? I will check the link you referred me to, but my shop has been down now for 3 days and I have no clue how to fix this.

Quote:

---

Originally Posted by ssolis5788

I've gone back and double checked that I removed all the files from the incorrect version and they are gone. Even through I uploaded the files from the correct version, I still cannot access the control panel. I do not know what else to try... Any help is most appreciated!

---

What FTP software are you using? What version zencart? It sounds like something got deleted that is part of the core.

Does your FTP software have the ability to "synchronize"?

BACK UP YOUR FILES FIRST.

Then re-extract your zencart version, and try to synchronize the admin folder to the server. It should give you a list of changed files. Note that you don't want to over write your custom define pages.

One lesson to learn here is NEVER (sigh) install a mod to a live site. Always work within a sub-directory that has a working copy to test on first (and with it's own database and copy of data). I actually have multiple backups running in subdirectories. Main Site is in ROOT, then a full working backup in a sub-directory, and usually 1 or more testing directories.

This way I can test a mod and just over-write the directory and restore the database if there are problems.

I am beginning to think that perhaps your issue isn't EP 1.2.5.4 related. Nothing in the mod should affect your ability to login to the admin. But perhaps a file on your server got corrupted.

If your really stuck and at a loss, leave me a pm and I'll see what I can do to help more directly.

-chaddro

I've tried using EP several times now, but everytime I try it, it will only upload the first item and not the rest. Any ideas on how to fix this?

I'm really hoping to get this to work. I need to move about 800 products pretty quickly.

Thanks in advance! :)

Quote:

---

Originally Posted by KittieMD

I've tried using EP several times now, but everytime I try it, it will only upload the first item and not the rest. Any ideas on how to fix this?

I'm really hoping to get this to work. I need to move about 800 products pretty quickly.

Thanks in advance! :)

---

KittieMD,
Look closely at your upload file and make sure the very last column to the right has EOREOR for EVERY product you have listed.

Quote:

---

Originally Posted by digidiva-kathy

Hello, all. This is my first experience with Easy Populate and I am having a problem. When I use the Upload option, it only inserts the first product and stops. It doesn't seem to know when to start a new product. What am I doing wrong?

---

digidiva-kathy
See Note to KittieMD on this page.

Quote:

---

Originally Posted by elkbow

KittieMD,
Look closely at your upload file and make sure the very last column to the right has EOREOR for EVERY product you have listed.

---

Wonderful! I will give that a try. Is there also a way to put in attributes, such as a download file name?

Quote:

---

s there also a way to put in attributes, such as a download file name?

---

KittieMD - No, the only way would be use a SQL script.

Scrat,
In the past I have tried to use the Attributes down load, but it never worked.

So I deleted all products and relisted them without attributes except two items. Not a big store, only around 3200 products, but that Attribute never worked.

John

Quote:

---

Originally Posted by elkbow

Scrat,
In the past I have tried to use the Attributes down load, but it never worked.

So I deleted all products and relisted them without attributes except two items. Not a big store, only around 3200 products, but that Attribute never worked.

John

---

Thanks for the replies. :)

Does the Easy Populate Advanced support setting up Attributes, such as download links?

Ok, I've found several spots that say that "Quantity Discounts" is going to be available in the next release, but that does not help me now. Is there anyway to get it to work now? or a patch for this release?

I can manually add all my quantity discounts in, but it would take forever. I actually started it, uploaded my .txt file with a bunch of changes I made and it actually overwrote my quantity discounts, so that not cool either.

Any ideas?

KittieMD & Margecc:

EPA is supposed to support attributes, although I cannot personally verify this. Check langer's site. Attributes do not work in EP 1.2.5.4.

When Last I spoke with Langer (august 07) he was working on quantity discounts for EPA (not EP), but it seems he never quite got it working since he's never released a new version after 3.03 ???? I also needed quantity discounts, so I was waiting for his update before buying.

When last this came up, no programmer was willing (or had the time) to take up EP 1.2.5.4 for a rewrite or update.

Quote:

---

Originally Posted by margecc

Ok, I've found several spots that say that "Quantity Discounts" is going to be available in the next release, but that does not help me now. Is there anyway to get it to work now? or a patch for this release?

I can manually add all my quantity discounts in, but it would take forever. I actually started it, uploaded my .txt file with a bunch of changes I made and it actually overwrote my quantity discounts, so that not cool either.

Any ideas?

---

I have the ot_quantity_discount module activated and it works fine. I don't see why it can't be installed on your site. I am using v1.3.7.1 but I know it worked on the previous version also.

I have another quick question about EP. I have all of my product quantity boxes turned off and when I add a single item manually, the quantity boxes do not appear. But when I add products with EP it adds the quantity boxes. Is there a way to tell EP to not add the product quantity boxes?

Thanks for all the help! :)

Quote:

---

Originally Posted by KittieMD

I have another quick question about EP. I have all of my product quantity boxes turned off and when I add a single item manually, the quantity boxes do not appear. But when I add products with EP it adds the quantity boxes. Is there a way to tell EP to not add the product quantity boxes?

Thanks for all the help! :)

---

On your EP tab.delimited file under v_products_quanity do you have a quanity listed?

Quote:

---

Originally Posted by elkbow

On your EP tab.delimited file under v_products_quanity do you have a quanity listed?

---

Yes, I have tried it with both a 1 and a 0. I am a graphics site, so I don't have physical inventory.

Hey guys... bit of a newbie here, so maybe this is obvious, but it's got me pretty confused.

Site and admin was working 100% yesterday... fresh install with just a few categories and a couple test products entered in. Nothing crazy done to it. I'm running ZenCart 1.3.8 btw... This morning, I installed EP 1.2.5.4 as far as dragging the folders into my zen cart root. Chose to replace any files, as I haven't done any customization, and from what I can tell, NONE of the files in the EP folders overwrite anything from the regular install anyways.

So I try to go to my admin page, which had been working previously... And it comes up blank. Nothing, nada. No login option. Tried clearing my cache, no help.

Does EP just not get along with 1.3.8? I tried getting some info out of this thread, but jeez, it's 1500 replies long about and it's just too much ground to cover in a reasonable time frame. I also tried a search, but the search function won't even recognize "exact phrases" so that gave me way too much.

So I'm sorry if I'm asking something obvious... but does anyone know of a known issue caused by dropping the EP folders into 1.3.8? Is there anything I can look for? Everything was working before, and I highly doubt a file would corrupt itself out of the blue... and I didn't do any PHP customization, so it shouldn't be that...

Thanks in advance for your time and help. :)

-- ########

Teeb,

Did you download 1.2.5.4 or 1.2.5.5??

There should not be an issue with EP 1.2.5.4 if you uploaded it correctly. Check your remote files though your site's control panel to verify that your files are in fact there, and you didn't REPLACE the admin directory with the one from EP...

If you re-upload your /admin directory from your local copy, you should be okay.

I am using EP 1.2.5.4 on serveral 1.3.8a sites without issue.

1.2.5.4 -- just double checked. And I am on 1.3.8a, not just 1.3.8

And I already tried dumping my backup admin directory back over it to no avail.

If I try going to say, mysite.com/admin/login.php or index.php

It's just blank. If I try going to something that doesn't exist, I get a file not found. If I restrict permissions on those, I get you don't have permission to view this file...

So they're there... and the server sees them. But it won't display them. And I can't get logged in to do anything. :( And my storefront is still up and running. I've tried bouncing Apache, just out of curiosity, but of course that didn't help either.

Really clueless here.

Quote:

---

Originally Posted by Teeb

1.2.5.4 -- just double checked. And I am on 1.3.8a, not just 1.3.8

And I already tried dumping my backup admin directory back over it to no avail.

If I try going to say, mysite.com/admin/login.php or index.php

It's just blank. If I try going to something that doesn't exist, I get a file not found. If I restrict permissions on those, I get you don't have permission to view this file...

So they're there... and the server sees them. But it won't display them. And I can't get logged in to do anything. :( And my storefront is still up and running. I've tried bouncing Apache, just out of curiosity, but of course that didn't help either.

Really clueless here.

---

How very odd. Sandy just had something odd like this happen last week. Okay, do this:

1) pull a copy of your admin/includes/configure.php off to the side
2) re-extract a full 1.3.8a from the download so it's fresh
3) rename admin to admin2
4) open your configure.php and carefully change reference to admin to admin2 being sure that your are adding the "2" to the directory paths.
5) now put this copy of configure.php into admin2/includes/
6) upload admin2 to your store's root

You should now be able to login normally. Note that this does not change any of your data, but if you have custom mods installed (like EP) they will not be active since those files are not in admin2.

If you can now login properly into the admin2 directory, you can rename your local copy back to admin then do a synchronize with the remote site (depending on your FTP software) to see just what has changed. Perhaps a remote file got corrupted??? Look for CORE files that should not have been changed.

To be "safe" you can always use your site's control panel to make an extra copy of your admin.

Hope this helps!

-chaddro

Well, for one, our server is on site, which makes it pretty easy for me to get at it and do things.


Secondly...

I set up an admin/admin2 and checked differences. The only differences were the files added for EP.

So I tried adding the files one at a time to the admin2 directory, refreshing the site every file, waiting to see which one was breaking it. It turned out 3 files cause the admin login to stop coming up.

admin/includes/extra_datafiles/easypopulate_filenames.php
admin/includes/functions/extra_functions/easypopulate_functions.php
admin/includes/languages/english/extra_definitions/easypopulate.php


Any of those three files cause the admin login to stop showing up. The page just goes completely blank. View source comes up completely blank when you check it.

If I log in to the admin without those three files, I get to the admin page, but a slightly broken version of it. The bar is still across the top, but missing certain dropdowns, like tools... and if you click on any items, you don't really go anywhere. If at that point, I add one or all three extra files, I get a completely blank page again.

I really don't know php well at all, and I hate asking other people to do my work for me, but I'm seriously at a loss here. I got one of the other guys in the office who actually knows a decent bit of PHP to take a look at it, and he didn't have a clue either, although he didn't really dig into the code or anything.


I did notice that the temp folder from my zip download of EP has an Attributes, Category, Froogle, Full, and Price/Qty exports in it already... and an index.html... Basically as if the guy just zipped up stuff off his site and threw it out to the community. Is there a chance he has a configuration setting flipped somewhere that needs to be put back to a default? I didn't see anything looking through all the EP files, but again, I'm not familiar with the program or PHP much. Is it also possible that anything in that temp folder (the upload folder) would affect the stuff in the admin file? I wouldn't think so pre-installation... I haven't even run the sql script yet, since I can't actually get the admin panel to open up with the files in place.

I've also tried the URL forced install path mentioned in install.txt with all files in the directories, and that didn't do anything either.

For reference, the exact "install" file I'm using is the one with the most recent date, obtained here (maybe this is what's getting me?):

http://www.modhole.com/modhole/index..._Document_id=2

Is there a very slightly different zip I can get somewhere else on the site?

Thanks again for your effort chadderuski... every idea gets me a little closer to getting this working...

I really don't want to dig through the SQL tables and write a query to do this the long way for a couple thousand items. Not to mention I couldn't hand it off to our sales guys then, cause they'd be clueless as to how to do mass price updates or add 500 new items whenever we get a new vendor if they had to use SQL queries.

Hello All

I have inherited administration of some large (35,000+ products) webstores. A lot of the categories are a mess and others are crammed: 700 items in one cat, or "round" items in the "square" cat. I have been moving prods around and breaking up these huge cats in our zen cart and x-cart shops.

I have noticed that in zen cart when I change the category of a product in my text file and upload using EP, it leaves the prod in the old cat and also copies it to the new cat. I now have hundreds of products all over the place that are linked to their old locations.

It's my fault for not checking earlier: I just assumed that since it showed up in the new cat it was gone from the old.

So 3 questions:

Is there a way to kill these hundreds of linked prods without doing it one at a time? For instance, I know that everything in "square" that's linked has already been moved to "round", so "square shouldn't have any links at all.

Is there a way to swap prods between cats in my EP file, and stop zc from leaving the old one in it's old location?

And if I want to use EP to put the same product in 2 top-level cats, would I make 2 line items for it in the text file, one for each category?

TIA
--Tapper

Quote:

---

Originally Posted by KittieMD

Yes, I have tried it with both a 1 and a 0. I am a graphics site, so I don't have physical inventory.

---

KittieMD
This is what I had to do:

Go to admin/Catalog/Product Types.

Under Product-General on the right select edit layout

Select the Value for the Title you want 1=On, 0=Off.

Your probably looking at "Show Quanity in Stock".

Quote:

---

Originally Posted by elkbow

KittieMD
This is what I had to do:

Go to admin/Catalog/Product Types.

Under Product-General on the right select edit layout

Select the Value for the Title you want 1=On, 0=Off.

Your probably looking at "Show Quanity in Stock".

---

Thanks for replying! :)

I have it set to zero, but it still shows. Any other suggestions?

Quote:

---

Originally Posted by KittieMD

Thanks for replying! :)

I have it set to zero, but it still shows. Any other suggestions?

---

KittieMD
I just looked at my tab.delimited file and had a problem with the date added kept going to 12-31-69.

So I deleted everything in that column and it worked. Try NOT putting anything in that EP Full file under the Quanity column. Neither a 1 or a zero. Nothing, and reload and refresh a product page.

Well don't I feel silly.

Some extreme digging with chmod got it working. Something was messed up in permissions... I'm not even sure what, as I did some wholesale changes and then tweaked things back down for security. But that fixed it.

Quote:

---

Originally Posted by elkbow

KittieMD
I just looked at my tab.delimited file and had a problem with the date added kept going to 12-31-69.

So I deleted everything in that column and it worked. Try NOT putting anything in that EP Full file under the Quanity column. Neither a 1 or a zero. Nothing, and reload and refresh a product page.

---

I just tried it and the quantity boxes still show. :(

Okay, so it's not a one, zero, or blank. Hmmm, the quantity boxes have to be generated from EP because on a manually added item, they don't appear. Does EPA address and fix this issue? If it fixes this problem, I would be willing to purchase it.

Quote:

---

Originally Posted by Teeb

Well don't I feel silly.

Some extreme digging with chmod got it working. Something was messed up in permissions... I'm not even sure what, as I did some wholesale changes and then tweaked things back down for security. But that fixed it.

---

I am having the same problem as Teeb.

I setup ZC version 1.3.8a

then I downloaded ep v. 1.2.5.4 and copied the included files to their respective locations.

Afterwards the admin pages show up as blank.

I tried making sure that the ownership of the new files was consistant with all of the other files but the results were no different (the admin pages are still blank.

Teeb, Karl:

I just did a quick fantastico install of 1.3.8a, then uploaded 1.2.5.4 from modhole and everything tests fine.

This begs the question: what other mods to you have installed?

Fresh 1.3.8a install, or upgraded? Fantastico install?

ARE YOU SURE you uploaded all the files to their correct folders?

What host are you using?

FTP programs aren't perfect. What FTP program are you using?

Did you set the /temp folder permissions to 777?

Did you enable HTTPS?

Check your admin/includes/configure.php file for anything "odd" ...

Oh, and with 1.3.8a I've seen some odd behavior when 'STORE_SESSIONS' and/or 'SQL_CACHE_METHOD' are set to file. Set them to "db" and "database" and see what happens.

Also begs the question: was your /cache folder permissions set to 777?

I have been using EP for a couple years now on multiple hosts/installs and multiple testing installs. I haven't seen this behavior before. At least not related to EP.

You may also want to check that you cleared your browser's cache, and reboot. Also try a different browser. Zencart has had some odd admin login issues.

That about taps me out ideas!

-chaddro

chaddro


Thanks for your message. Since this is a new install I am playing with, I deleted the zen-cart install and database and started from scratch. After installing the zen-cart I noticed that my earlier download of Easy Populate was about 2k smaller in size.

Anyway when I uploaded and unzipped the ep zip file in the stores root directory, I noticed that once again I got a blank page when going to the admin page.

Next I went to my stores root dir and changed ownership so all the new files had the same owner as the other store files.

When I went back to the admin dir in my browser, it worked fine.

Thanks

Hi everyboddy:

The problem I am having is that the data sheet from my distributor has 2 image fields one with the "directory path" and the second one with the "image name". In order to show the image in my site I need to combine the two fields as "directory path/image name". They also supply the image folder that matches the "directory path". The question is how I can combine the two fields to accomplish the results. This an example from the data fields. :blink:

Thank you

PHP Code:

---

v_products_model    v_status    v_products_image    v_products_name_1            this is the directory path
HMV-VS-OD-XXL    ACTIVE    245-443373.jpg    Humvee Safari Vest Olive Drab XXL    apparel/men/jackets_coats/
HMV-VS-OD-3XL    ACTIVE    245-443374.jpg    Humvee Safari Vest Olive Drab 3XL    apparel/backpacks/ 


---

Quote:

---

Originally Posted by Gutable

Hi everyboddy:

The problem I am having is that the data sheet from my distributor has 2 image fields one with the "directory path" and the second one with the "image name". In order to show the image in my site I need to combine the two fields as "directory path/image name". They also supply the image folder that matches the "directory path". The question is how I can combine the two fields to accomplish the results. This an example from the data fields. :blink:

Thank you

PHP Code:

---

v_products_model    v_status    v_products_image    v_products_name_1            this is the directory path
HMV-VS-OD-XXL    ACTIVE    245-443373.jpg    Humvee Safari Vest Olive Drab XXL    apparel/men/jackets_coats/
HMV-VS-OD-3XL    ACTIVE    245-443374.jpg    Humvee Safari Vest Olive Drab 3XL    apparel/backpacks/ 


---

---

If you are "hot linking" to their images, just ask them to provide the complete path. What I am understanding you to say is that they send some folders with the images that you require. If that is the case, then what I would do is to dump all of the images into your /images directory and be done with it. Then you would only have to paste the names into your EP upload. The only possible conflict would be if you had duplicated image names assigned to different images. Looks like the only reason they separate the images is so that different sellers will get just the images they need, and nothing extra. If you insist on keeping the images within the correct sub-folders, then it looks like a lot of typing (or maybe the merge utility if you can get it to work). It was explained a few posts back if you want to try it.

Quote:

---

Originally Posted by KittieMD

I just tried it and the quantity boxes still show. :(

Okay, so it's not a one, zero, or blank. Hmmm, the quantity boxes have to be generated from EP because on a manually added item, they don't appear. Does EPA address and fix this issue? If it fixes this problem, I would be willing to purchase it.

---

It is my understanding that EPA is not supported here and all things considered that is quite reasonable,

So let me tell you what I WISH I had done (and can't believe I did not since it is such a routine) Instead of blindly paypaling off money under the misguided notion I could not live without the perceived advantages.

May I suggest, that you visit the site where EPA is sold and and, in theory, supported.

Then, based on the response from the seller (IF you manage to get one) you can make a decision about whether or not the support will meet your expectations.

After spending most of the last 24 hours reading this thread and experimenting with the FREE version, all things considered. I could have better spent the money used for EPA.

Of course, your experience may vary and you may think you need what it offers, but only you only if you think you will not need support of any type.

As far as I can tell, the seller has not done anything except post excuses for why he has not answered questions for close on a year.

Yes, I am coldly annoyed which my children and grandchildren and especially my ex husband can tell you is not something you want to experience.

Now off to try to understand Easy Pop Free and what I did wrong in setting a special

Wheat
who is about to have to rebuild a site from scratch BECAUSE of a landmine in EPA

Quote:

---

Originally Posted by awhfy99

If you insist on keeping the images within the correct sub-folders, then it looks like a lot of typing (or maybe the merge utility if you can get it to work). It was explained a few posts back if you want to try it.

---

Thank you for the response Dennis:

The images are for download, not hot linking. However I figured out the way to merge the two fields to make one image path. I add a field in my excel data sheet to merge the two columns =CONCATENATE(S2,E2) where "S2" and "E2" are the columns to merge; and it works great. :clap:

Thanks

Hello,
do you have idea what can I upload in my store, with easy populate, different currencies for price??
For example, I want to insert in file.txt v_product_currencies, like in attachment.
Please help me.
Sorry but I don't speak english very well

ADComputers

Quote:

---

Originally Posted by monkeytown

I did a fresh install after a server crash corrupted my cart (it wasn't live yet fortunately) and I noticed this issue start when I had around 22000 items loaded in the cart. Now the results page never shows if I load 5k or 200 items from a .txt file. Any tips or an explaination appreciated.

---

I am also having this problem which i can work around but now is spillin over to my google base feeder, I only have 8000 items and i cant load with EP even 10 items without the blank page coming at me!. I am using vs. 1.2.5.4 , I have modified my php.ini, change my settings in admin all to 300 but if I time it it is still timing out after 60 secs any idea where else i can look to change my time out time?

Open question to EP vets:

Who of you are actually using the Froogle aspect of EP? I ask because this code seems to now be orphaned since "froogle" has been replaced by Google Base, and there is a nice mod "Google Base Feeder" that seems to work quite well.

If EP free is going to ever move forward with an update, it would be best to eliminate what DOESN'T work or is no longer useful ...

Love to hear your opinions!

Easy Populate Advance2.76d-mod3a Zen-Cart 1.3.x - Default Language English(1)

File uploaded.
Temporary filename: D:/usr/local/php/uploadtemp\php9C.tmp
User filename: ytytyt.txt
Size: 1826
| models | 1 | Products N | roducts De | | banner2.jp | 11 | 0 | 11111 | 0 | 1 | 2008-04-02 | | | test two | ategory Na | | | --none-- !Updated!
| modle | 1 | Guild Wars | oduct Qty | | banner2.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-03 | | | test two | ategory Na | | | --none-- !Updated!
| modles | 1 | Guild Wars | | | banner3.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-04 | | | test two | ategory Na | | | --none-- !New Product!

| modlesd | 1 | Guild Wars | | | banner4.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-05 | | | test two | ategory Na | | | --none-- !New Product!

| modledasd | 1 | Guild Wars | | | banner5.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-06 | | | test two | ategory Na | | | --none-- !New Product!

| modledasd | 1 | Guild Wars | | | banner6.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-07 | | | test two | ategory Na | | | --none-- !New Product!

| modleddaa | 1 | Guild Wars | | | banner7.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-08 | | | test two | ategory Na | | | --none-- !New Product!

| modleasdas | 1 | Guild Wars | | | banner8.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-09 | | | test two | ategory Na | | | --none-- !New Product!

| modlefghj | 1 | Guild Wars | | | banner9.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-10 | | | test two | ategory Na | | | --none-- !New Product!

| | | | | | | | | | | | | | | | | | |

No products_id field in record. This line was not imported

Quote:

---

Originally Posted by ebloger

Easy Populate Advance2.76d-mod3a Zen-Cart 1.3.x - Default Language English(1)

File uploaded.
Temporary filename: D:/usr/local/php/uploadtemp\php9C.tmp
User filename: ytytyt.txt
Size: 1826
| models | 1 | Products N | roducts De | | banner2.jp | 11 | 0 | 11111 | 0 | 1 | 2008-04-02 | | | test two | ategory Na | | | --none-- !Updated!
| modle | 1 | Guild Wars | oduct Qty | | banner2.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-03 | | | test two | ategory Na | | | --none-- !Updated!
| modles | 1 | Guild Wars | | | banner3.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-04 | | | test two | ategory Na | | | --none-- !New Product!

| modlesd | 1 | Guild Wars | | | banner4.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-05 | | | test two | ategory Na | | | --none-- !New Product!

| modledasd | 1 | Guild Wars | | | banner5.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-06 | | | test two | ategory Na | | | --none-- !New Product!

| modledasd | 1 | Guild Wars | | | banner6.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-07 | | | test two | ategory Na | | | --none-- !New Product!

| modleddaa | 1 | Guild Wars | | | banner7.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-08 | | | test two | ategory Na | | | --none-- !New Product!

| modleasdas | 1 | Guild Wars | | | banner8.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-09 | | | test two | ategory Na | | | --none-- !New Product!

| modlefghj | 1 | Guild Wars | | | banner9.jp | 1 | 0 | 11111 | 0 | 2 | 2008-04-10 | | | test two | ategory Na | | | --none-- !New Product!

| | | | | | | | | | | | | | | | | | |

No products_id field in record. This line was not imported

---

User filename: ytytyt.txt
Incorrect file extension.. should be i.e.
yourfile.csv
Headers are also incorrect.. should be similar to
i.e.

Code:

---

v_products_model v_products_image v_products_name_1 v_products_description_1

---

I am unable to find the docs on how to use this. I downloaded the 'latest and greatest' and the read me file says.

Quote:

---

DOCUMENTATION
--------------

Detailed manuals can be found here:

1. /docs/1readmeFIRST.txt (includes "quick" installation and configuration notes)
2. /docs/Easypopulate_Manual.* (complete manual in various formats)

Please do read the manuals carefully. Its worth the time!

There is no documentation for the new product attributes feature. You can find some useful information,

---

However, the unzipped file has NO doc folder. Only a catalog folder with a temp and admin/includes folders.

I've no idea what to do, how to do it, where to put it; easy big fella ;-), nor how to make this function for me.

Thanks,
Ted

So. No cares if froogle is chopped out of 1.2.5.4?

chop... chop... chop...

I used Easy Populate to place my products on the site in the primary categories. I am now attempting to place them into secondary categories, however, I get this message:

"no such current category path for this existing product"

I know the category path exists, why won't it work?

I am using the field header: ptc_categories_index_path

Quote:

---

Originally Posted by chadderuski

So. No cares if froogle is chopped out of 1.2.5.4?

chop... chop... chop...

---

Actually I don't mind chopping out froogle, but also attributes too. They never worked for me but everything else works just great.

elkbow

Is this statement correct? "You can only use the file formats below"

I found this statment in message 1379

Quote:

---

Originally Posted by Scrat

HumDaddy - You can only use the file formats below:-

You cannot just pick the headings you would like to import.

hankthtank - Try to download a 'Complete' file then add a product to the last row and import the file in that format and you will see this work.

---

Quote:

---

Quote:
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file

---

Quote:

---

Originally Posted by elkbow

Actually I don't mind chopping out froogle, but also attributes too. They never worked for me but everything else works just great.
elkbow

---

Yep, and we also need to RENAME the module to something a bit more UNIQUE. Mixed free modules vs EPA questions... makes it much more difficult for the casual installer to even know what is going on.

Once cleaned up it'll be a lot easier to add functionality. Would really like to just use the .xls format. THAT might eliminate a whole slew of confusion.

Quote:

---

Originally Posted by chadderuski

Yep, and we also need to RENAME the module to something a bit more UNIQUE. Mixed free modules vs EPA questions... makes it much more difficult for the casual installer to even know what is going on.

Once cleaned up it'll be a lot easier to add functionality. Would really like to just use the .xls format. THAT might eliminate a whole slew of confusion.

---

Got that right. I am still looking for instructions, or manual.

Quote:

---

Originally Posted by TedNigma

Got that right. I am still looking for instructions, or manual.

---

Well, there isn't any. However, if you are patient and willing you can go back and page through this entire thread. The *basics* gets explained over and over again.
Yes, a painful answer, but your best bet.

The basic functionality does work quite well. People have used EP to load 100K of products!

But, complicated store with lots of attributes is where EP stumbles. EP Advance was going to address this, but that seems to have stalled since last August when I last heard from Langer.

Hi there, hoping You can help with an EP problem i'm having...

The product database I received from my supplier is an Excel spreadsheet, but many of the product descriptions seem to have extra spaces, even bullet points in them - so when i compile my list of products as per the FullEP document, get them into the right headers etc... and save as a tab delimited text file, everything gets screwed up, presumably because anything other than a single space is an unknown character for a text file?

I hope that made sense... is there any way to quickly format all these Excel cells, to that they conform when i put them into my delimited text file? I have hundreds of products so going through each one by hand is well... a daunting prospect!

Thank you in advance,

maddy xx :wub:

p.s if anyone wanted to see their Excel file as an example I could provide that if it helps :)

Quote:

---

Originally Posted by madelina

p.s if anyone wanted to see their Excel file as an example I could provide that if it helps :)

---

Madelina:

Did you add a category & product manually first? If you load even 1 manually first, then download the full-export. This will give you your road map.

NOTE: EVERY line needs EOREOR or things go bad!

Also: HTML formating is OKAY in descriptions.

When you name your file, use the same name and just change the last 4 numbers.

I suggest breaking your data into smaller chunks until you get the hand of things. EP doesn't like smart quotes either ... they come out as funny characters.

Also be careful the use consistent category names... Smallwares and SmallWares are TWO DIFFERENT CATEGORIES and you'll get duplicate linked products.

You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.

Ok I could probably find this by looking through the whole thread, but can someone tell me if there is a "paid" version of EZ Populate that works better/more functions than the free version, and if so where to get it?

EDIT: I found the modhole.com website, with EZ Populate Advanced. I'm willing to pay the $65 for it, but does anyone know if it's significantly better than the free version?
Thanks a lot

Quote:

---

Originally Posted by chadderuski

Madelina:

Did you add a category & product manually first? If you load even 1 manually first, then download the full-export. This will give you your road map.

NOTE: EVERY line needs EOREOR or things go bad!

Also: HTML formating is OKAY in descriptions.

When you name your file, use the same name and just change the last 4 numbers.

I suggest breaking your data into smaller chunks until you get the hand of things. EP doesn't like smart quotes either ... they come out as funny characters.

Also be careful the use consistent category names... Smallwares and SmallWares are TWO DIFFERENT CATEGORIES and you'll get duplicate linked products.

You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.

---

useful stuff, thank you :) i'm having a problem with the database my supplier gave me which contains characters that excel struggled with, but i think i may have a solution now. thank you so much for replying and i'll heed your advice! :clap:

Question: I download my products using easy populate however they are not shoewing up in my store. the category has the number behind it as if my products are there but they are not showing up...any suggestions. Do I need to purchsae the newer version....I'm really frustrated...help please!!!!! Thanks

Hey All,

What should the format of the text be in the v_products_description_1 field? Will it accept plain text or does it have to be a specific format?

Ideally i would like to be able to control the format, have separate lines, selected font and size etc etc.

Thanks in advance

Quote:

---

Originally Posted by hduk

Hey All,

What should the format of the text be in the v_products_description_1 field? Will it accept plain text or does it have to be a specific format?

Ideally i would like to be able to control the format, have separate lines, selected font and size etc etc.

Thanks in advance

---

I think you would control this by using HTML, but I have to aks, what is v_products_description_1? I only use v_products_description (no "1").

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

Quote:

---

Originally Posted by cellz4less

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

---

Check this out.
http://www.zen-cart.com/index.php?ma...roducts_id=395

Quote:

---

Originally Posted by cellz4less

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

---

Quote:

---

Originally Posted by elkbow

Check this out.
http://www.zen-cart.com/index.php?ma...roducts_id=395

---

Has anyone used version 1.2.5.5 yet?

Does anyone have a fix for the multi language category?

Yes I know the advanced commercial version have fixed it, but I look how to fix it on the GNU version. Has any code here been released by users?

---------------
Still weard that Advanced version allowed to be commercial as it uses Zen Cart internal functions??


marksu

Quote:

---

Originally Posted by marksu

Does anyone have a fix for the multi language category?

Yes I know the advanced commercial version have fixed it, but I look how to fix it on the GNU version. Has any code here been released by users?

---------------
Still weard that Advanced version allowed to be commercial as it uses Zen Cart internal functions??


marksu

---

marksu,
Did you look here?
http://www.zen-cart.com/forum/showth...guage+category

Quote:

---

Originally Posted by elkbow

marksu,
Did you look here?
http://www.zen-cart.com/forum/showth...guage+category

---

EDIT:
Well I ment multi languge support for the Easy Populate.

That is about some multilanguge for EZ-Pages.
That is totaly different module for different purpose.
But yes I do have that installed as well.

Problem is that Easy Polupate is not compatible with multi languge for category category ... etc.

marksu

Hi, Ive installed easy populate but when uploading the .txt file I got:

No model field in record. This line was not imported

So I created all the categories via zencarts admin for my products which match those in the .csv and the tab text file.
But whenever I upload the .txt file I still get the same problem. Also when I check the actual site it has created lots more categories with no products in them, the categories are all numbers such as:

0.01
0.02
0.03
0.04
0.05

etc. etc.

Can someone tell me where I'm going wrong. As when I upload the dvd example spreadsheet thats in the temp file that works. I have double and triple checked the headings for each column and the model one which is the first one is titled

v_products_model

which seems to be correct as it matches the one in the dvd file that works. I have downscaled my list to 200 products to see if that works, as there are approx 3000 products in total.

The headers Im using are (in actual spreadsheet order):

v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_description_2
v_products_description_3
v_products_description_4
v_products_price
v_products_weight
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
EOREOR (what is this by the way? - Ive kept it in for now - can I delete this column)

Any help would be appreciated as I'm completely stuck and cannot see what I've done wrong!

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

Quote:

---

Originally Posted by kyates

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

---

Do you have this field at the top, and at the end of every row: EOREOR?

it tells the program that it is the end of one product, and another product is on the next line. If you don't it will only read the first product.

Hi,

I'm trying to install Easy Populate 1.2.5.5 for Zen Cart 1.3.8a. My system is running MySQL 5.

I received the following message after clicking on install:
"Easy Populate Configuration Missing. Please install your configuration by clicking here".

So I clicked "here" and received the following.

"Success Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products."

Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

Regards.

Quote:

---

Originally Posted by Scrat

If anyone is needing this the install.sql file for the database for MySql 5

PHP Code:

---

# MySql 5 Config 
# Install Easy Populate Configuration v1.2.5.4
INSERT INTO `configuration_group` VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');

UPDATE `configuration_group` SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

INSERT INTO `configuration` VALUES (NULL, 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL),
(NULL, 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'),
(NULL, 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL),
(NULL, 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL),
(NULL, 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL),
(NULL, 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'); 


---

Enjoy !

---

I bought EP Advanced and just finished uploading over 12,000 products to my store. After a few tests (because I didn't know what I was doing) I uploaded without a hitch and all the products display fine. Well worth the $65.

Anyway, just for the record, I did manage to upload my products (tried 50 items at one go) successfully. Really convenient, saved me quite a bit of time. :smile:

hi,
is there any limit on how many products can be uploaded at one time. my supplier gives me a file with over 37000 products and every time i upload or download to zencart it takes ages.

I downloaded my .txt file through EZ popluate. I then edited my products (I didn't origianlly have a model number with some of them so I added a model number). I uploaded the .txt file through EZ popluate, added it to the database.

It created duplicate products instead of overwriting the original product. :oops: Am I doing something wrong?
Thank you for your time. I love this contribution, I am just confused I think.:lookaroun

Newbird, you wrote>>Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

In the install.txt it said to only run the SQL if the config install fails. It sounds like your config install went fine. And I saw that you had success uploading products, so that's great.

My Issues:

1) Knowing the answer is out there somewhere...Why am I getting
"No model field in record. This line was not imported | | | | | " after I upload?

2) When I attempt to browse to my txt file, the Upload function doesn't execute but if I load my txt file to the temp folder and use that "form" (Import from Temp Dir (temp/), the upload does execute correctly. Has anyone seen this?

I would LOVE to see this thread/forum split up by the moderator!!

Thanks.

Quote:

---

It created duplicate products instead of overwriting the original product. Am I doing something wrong?

---

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

Quote:

---

Originally Posted by misty

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

---

So now that I have the model numbers, it will automatically overwrite if I make any more changes?

Thanks for your help!

Quote:

---

Originally Posted by erika_311

So now that I have the model numbers, it will automatically overwrite if I make any more changes?

---

Every product MUST have UNIQUE model number..if you add further
products, using model number used before, EP will overwrite..
use different/unique model number/s for further products, EP will
enter.

Quote:

---

Originally Posted by misty

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

---

AWESOME! Thank you!

Quote:

---

Originally Posted by erika_311

AWESOME! Thank you!

---

:smile:
Your Welcome..

I was just wondering if we should change the setting in the database table to make the field "product_model" Null=No;

1 - Can this be done without harming other functions?
2 - Would this prevent me (as it should) from adding a product without this important value?
3 - Wouldn't this prevent importing products with a null value - again, as it should?

~Lynne

Ok, I'm sorry if I'm asking really basic stuff here, but this thread is 150 pages long and search isn't paring it down well for me at all.


I'm trying to set up Attributes. Pulling down a model/attributes sheet with Easy Populate is not making any sense to me. I made a couple of attributes and gave them values... and threw them on a category of products, and pulled down the sheet with EP again... and it's still not making a lot of sense to me. It's either really complex, or way simpler than what I thought it'd be and that's why I'm confused.

All it's doing so far is listing EVERY product, EVERY attribute on every row, and putting a 0 in one column of the ones that have it assigned. Is that all it does? And doing that is all it takes?

Does anyone have any SQL scripts they use to assign attributes instead of doing it through EP? Because that doesn't seem to be a very simple way of doing it. You'd have to link that model sheet to some other sheet anyways, and if you're joining tables, might as well just go straight to SQL, right?

The main thing I want to do it outside of the default attribute copy interface for, is I need to assign by category and manufacturer. At the least. Not just category. And even probably a lot of manufacturers will have some colors and options only available to certain product lines, and not all of their items under a certain category.

Any advice or help would be awesome.

Most especially just an explanation of what each column in that models/attributes sheet is. Maybe it's just as simple as I'm thinking and I'm over complicating it on myself.

Thanks in advance.

Can I change the field product_model to "unique" without causing any problems for other functions?

Quote:

---

Originally Posted by lkzone

Can I change the field product_model to "unique" without causing any problems for other functions?

---

EVERY Product entered using Easy Populate, MUST HAVE
UNIQUE MODEL NUMBER, or it wont work.

I have started work on a WIKI entry for Easy Populate that Newbies may find helpful.

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Additionally, there are probably 100,000,000,000 users of Zencart and EP that are more intelligent than me, so I'd appreciate it if EP experts could take a look and alert me to errors, etc. (As it's the WIKI, users can edit at will ! :D )

Misty, thanks. I know the number has to be unique but in my products table the field doesn't have that setting in the table structure. Also, Null isn't set to no. Should I change these in my table/field attributes?

Quote:

---

Originally Posted by lkzone

I was just wondering if we should change the setting in the database table to make the field "product_model" Null=No;

1 - Can this be done without harming other functions?
2 - Would this prevent me (as it should) from adding a product without this important value?
3 - Wouldn't this prevent importing products with a null value - again, as it should?

~Lynne

---

Whatever you do, DON'T try to delete product_model from the database. It is FUNDAMENTAL to the functioning of Easy Populate.

The Model Number (aka Stock Keeping Unit or SKU) is an elementary part of all retail, as it provides the unique identifier for a product. These days, barcodes are used for the same purpose.

If you use Easy Populate, you will need to give each of your products a unique Model Number.

I've just put up the start of a WIKI on Easy Populate. You may find it helpful...:smile:

I am aware that the number has to be unique and cannot be deleted.

In the table structure: should I (we) change the field product_model to be unique?

Secondly, shouldn't the null field be set to no.

I appreciate your responses Misty and love the new Wiki stuff (read it today) but I still haven't gotten an answer as to changing the field attributes in the database.

Regards,
Lynne

Quote:

---

Originally Posted by lkzone

I am aware that the number has to be unique and cannot be deleted.

In the table structure: should I (we) change the field product_model to be unique?

Secondly, shouldn't the null field be set to no.

I appreciate your responses Misty and love the new Wiki stuff (read it today) but I still haven't gotten an answer as to changing the field attributes in the database.

Regards,
Lynne

---

Lynne, Zencart allows DUPLICATE products (either by linking, or by outright duplication). This means de-facto, that DUPLICATE products have the same Model Number.

EP handles this by allowing duplicate model numbers in an EP upload IF the two (duplicate) products are in different categories. (See my WIKI).

So you don't want to force uniqueness in this d-base table.

Additionally, as it is EP that requires a model number (not zencart itself) null should not be set to no.

Okay, I won't change the setting -- thanks for zoning in on my question!

BTW, my experience with relational databases (I'm not a programmer!) shows that primary keys should always be unique. Wouldn't you think that the Products table would have a one-to-many relationship with Product_categories?

This would allow the setting of product_model to be unique. Hmmmmm

Anyway, that's not how it's setup at this point so I guess I'll have to trust my data entry clerk not to double-enter -- hmmm...what if my vendor's inventory update has a duplicate product_model # ... I wonder what will happen...

ya see, I'm only uploading the quantity/pricing for my products so category is never a field being compared. Hmmmm

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu

I tried to do the seach but did not find solution.

I have need to display a image for view only for products.

I did following

1. Added Option name: Price list
2. Added a empty option value
- some reason Attribute controll reuires that
3. Added "Price list" with image defined to a product

Well not it shows the image in produt info OK

PROMLEM:
Problem is how do I set image on many product with easy populate.
I can set the price field OK but then the product shows the Price list name but not the IMAGE?

Is it possible to do with esay populate or must I use Zen Cart feature to copy the attribute instead?

marksu

Going nuts here :censored:

I have been trying to get my records to import using EZ Populate without success.

Here's the scenario:

I have the Tab delimited file ready for import. I have even stripped it down to just the Model Number, Image and EOREOR. I browse for the file, upload it with "New Product" messages as to be expected.

When you view the products.....nothing!

I then tried importing it while specifying a category. The good news is that the category appears as it should have. The bad news is that there were no products in it.

I am not new to EZ Populate, but this is crazy.

I really need to get my products imported into my new store, so any help would be appreciated.

Sincerely,

Marty

martbost,

I have had trouble (ie the updates don't show up) using "Upload EP File" -- the first option under Tools/Easy Populate-- but when I FTP my file up to the temp folder and then use the "Import from Temp Dir" option, it does the update. I don't know if this is a glitch on my side but you might try this if you haven't already.

Quote:

---

Originally Posted by marksu

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu

---

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA

Hi,

I'm really trying my best to understand easy populate but I'm not doing to well. After 1 month of messing around with it I have to ask you guys for help on it.

I have zencart version 1.3.7. because that's supported by the dutchlanguage pack. I have created categories in the dutch language but have no products added. The products I want to add come from another site made with shop2date (by databecker) and are made in xml. files

Now the first thing I run into is that I can not get it installed. Not from zencart admin and not by directly typing the mysql thing. I read something about turning the dutch of? But I don't know how to do it. Also would that make me loose my categories (I have over 75 of them!).

Also do I install the files from easy populate right if I put them in c:\xampp\htdocs\zen ? And the register globals in which php.ini should I turn them on (because there are several when running it on pc)

Thank you in advance for helping... sorry being such a noob

Juliet van Ree