Easy Populate 1.2.5.4 support

[misty]

What did I do wrong?

EVERY product must have UNIQUE MODEL NUMBER
in column A

[Comtrad]

EVERY product must have UNIQUE MODEL NUMBER
in column A

OK.

I added the categories manually. Not sure why categories would need a model #.




HOWEVER, when I tried to add products to those categories, only the first line is getting inserted into it. Each has it's own unique model #, and trying to insert it into a sub of a sub of a sub category. What might be the cause of this?

I was testing out adding products. I have a sub category I want them inserted into. I tried with 7 products to start out, and only the very first one is being inserted.

[Scrat]

Comtrad -

Not sure why categories would need a model #.

I think you are getting A LITTLE confused how EP works, EP sets out the product values, not your cart values, as you use a Model id for each product, so you set the Model id and the categories to that model, and for each individual model separately.

[Comtrad]

Comtrad -

I think you are getting A LITTLE confused how EP works, EP sets out the product values, not your cart values, as you use a Model id for each product, so you set the Model id and the categories to that model, and for each individual model separately.

Ok, so when I want to upload products, instead of typing out the category names, I want to put the id #'s?

I already added the categories manually, so I don't need to bother with that part anymore with EP. I just am having trouble figuring out this mod.

This thread is great, however it would be nice if there was some how to use manual that came with the download

[Scrat]

Comtrad - The best way to see how EP works download each file and open it in OO or Excel and you will begin to see how it works.

For example:

v_prod_mod,v_cat_name_1,v_cat_name_2,etc,etc
5 metre,Cat5E PatchCable,Blue Cate5
1 metre,Cat5E PatchCable,Blue Cate5

this would put
5m cable in Cat => Cate5 Patch Cable =>Blue Cate5 and also 1 metre in the same,

but if you do this:-

v_prod_mod,v_cat_name_1,v_cat_name_2,,,
5 metre,Cat5E PatchCable,Blue Cate5,,,
1 metre,Cat5E PatchCable,Black Cate5,,,

this would put:
5m cable in Cat => Cate5 Patch Cable =>Blue Cate5
1m cable in Cat => Cate5 Patch Cable =>Black Cate5

The categories can already be set up you are just moving the product from one to another, but the categories have to be present as well as the Model id

[Comtrad]

Comtrad - The best way to see how EP works download each file and open it in OO or Excel and you will begin to see how it works.

For example:

v_prod_mod,v_cat_name_1,v_cat_name_2,etc,etc
5 metre,Cat5E PatchCable,Blue Cate5
1 metre,Cat5E PatchCable,Blue Cate5

this would put
5m cable in Cat => Cate5 Patch Cable =>Blue Cate5 and also 1 metre in the same,

but if you do this:-

v_prod_mod,v_cat_name_1,v_cat_name_2,,,
5 metre,Cat5E PatchCable,Blue Cate5,,,
1 metre,Cat5E PatchCable,Black Cate5,,,

this would put:
5m cable in Cat => Cate5 Patch Cable =>Blue Cate5
1m cable in Cat => Cate5 Patch Cable =>Black Cate5

The categories can already be set up you are just moving the product from one to another, but the categories have to be present as well as the Model id

So the 2nd example is the correct way then? I was doing what you are showing on the first example and that is when it was it was only inputing the first line.

I need to not have different products in the same category on the same upload?

[monkeytown]

Originally Posted by monkeytown View Post
When I run Easy Populate, the results page never loads. It just spins until it either 1) displays a blank page or 2) asks me to open or save the file easypopulate.php (similar to if you have clicked a download file link). Everything works as in the products get inserted/updated as they should, but I like to see the summary page to easily check that the items were handled right (i.e. my data file was formatted correctly)

Anything I can do to fix this or anyone know what the problem may be. I'm not sure when this started or why. Not a huge deal if I can't resolve it I guess.
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.

This is back on page 124 of this thread (assuming you can't change the amount of replies on a page).

Anyway, my host recently had to upgrade our server to include the FreeType library for a CAPTCHA image. The IT guy said he had to do some other updates as well (he didn't specify what these were) but now my EP does display the results of the insert. It still takes a long time to display the page, but it gives the results as it did originally. Not sure what prompted this, I think he upgraded from PHP 4.x to 5.2.5 so I don't know if that had anything to do with it or not. Anyway, glad it is 'working' properly again.

[realizingthedream]

Help Me Please....I am a newbie and so frustrated! Everyone assumes that you have some level of programming...I do not.

I'm finally starting to see some progress with zen cart, but I need to install Easy Populate. I'm having difficulty understanding the instructions. It states to change the admin name to suit your zen cart installation...hugh???? It also states to place the temp file in store directory...where is that? What???? When I installed zen it said that mysql database and mysql user is iicreate_zc1 ..... Is that the directory where i place the temp folder???? Please help me....I can follow directions if they are made clear to a novice...I have posted but no one has responded...and I have spent too many days reading posts that aren't apecific to my needs.....please.....HELP!!!!!!

[Ben-B]

Realizingthedream- I did the same thing and it didn't work for either the first time I tried it. I did it again from scratch and it worked- forget changing the name, just copy the files so the admin folder contents just joins everything in the current admin folder and the temp folder just sits at the top level of your zen cart installation. Then do the installation code bits. Simple as.

I've got a bit of a question myself, most of the database fields are self-explanatory, the special from and to dates are a nifty feature, I love the way it works out the discount % and displays it! And obviously the prices, categories etc. BUT I don't understand what v_status is, and v_tax_class_title. Can anyone explain?

Also- any ideas why my database file turned itself to double-spaced?

Do items in the database join the ones currently in the shop? Or is the database the definitive list?

[monkeytown]

the v_status is the status of the product. 1=active 0=inactive. The v_tax_class_title is the name of a tax class. Leave it blank if the item in non-taxable, or enter the name of the tax class if it needs to have tax applied such as Taxable Goods (or whatever your taxable items tax class named Admin > Location / Taxes > Tax Classes)