Easy Populate 1.2.5.4 support

JimmyV:

I have never used that build and it certainly looks pretty darn old like 3 years old... plus its a pay service so ask them...

I'd go to the free downloads section and get a more recent EZ Pop that does the things you need and this specials issue would be irrelevant as none of the current builds in that area would pose any issue for your problem.

No, not pay. It is downloaded from Zen Cart downloads here (Easy Populate From osc):
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=460

We (nlfallat and I) began using this osc version because it has the ability to download by category and includes a "sort" column to resort products, and those functions work. Only thing is the specials does not work.

Were using 1.2.5.4 until recently, but now see an update (1.2.5.5) here?
http://www.zen-cart.com/index.php?main_page=index&cPath=40_41&sort=20a&page=2

Is 1.2.5.5 the latest version of what you (this thread) recommends? I no longer see 1.2.5.4 at Zen Cart downloads (but may have it on my computer, an earlier version.)

SPH,

Looks like the one you are using is dated June 28th 2008.

Here is EP 1.2.5.4 Mod.
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=1633

You can add the sort order by modifying the weight info in Easy Populate .php. There are some instruction in this forum, but I did not look for them.

I'll see if I can find them. It works as I have used it.

elkbow:

SPH,

Looks like the one you are using is dated June 28th 2008.

Here is EP 1.2.5.4 Mod.
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=1633

You can add the sort order by modifying the weight info in Easy Populate .php. There are some instruction in this forum, but I did not look for them.

I'll see if I can find them. It works as I have used it.

SPH,

Use version 1.2.5.4 and follow this from lankeeyankee.

http://www.zen-cart.com/forum/showthread.php?t=116061

shadowcast:

please take a look at www.sgshoppy.com

i dun know how to say it, but its appearing 2 times for some reason, anyone can help? i thought it was model problem but it does not seem like it.

Shadowcast,

What's appearing twice?

Are you talking about EP or something else?

the product naming is appearing twice, sometimes it get replace by the image, the product names are invisible, they only appear when you hover over it.

Also, how can one add sort to the list in excel? and must it be specifily between some of the commands?

shadowcast I do not see the duplicates and you may just have some kind of admin setting wrong for your needs. If positive it is an EZ Pop problem provide more detailed information.

If a general sitewide problem post a thread in general questions area

We (nlfallat and I) began using this osc version because it has the ability to download by category and includes a "sort" column to resort products, and those functions work. Only thing is the specials does not work.

I will take a look at the file and see if I can do what you need to most recent EZ Pop version. If it takes me ten minutes or less I will shoot you a PM so you can retrieve the file.

I'll take a look Monday

JimmyV:

You do not need to do anything with files except load images in your images file. You need to do a db drop and copy. The related tables in your zencart db are categories and categories_descriptions.

You need to use a db admin panel your host provides to alter/edit this area to mass import the data you want imported.

Its a catch 22 you can't ez pop data that has not been configured someplace. At some point we all have to do the mindless data entry to get our initial setup done. This may be the case in your situation.

Also try this thread. I have not really read it but it does cover your possible need. Looks somewhat dubious so I don't know that I'd go this route myself as nothing is as easy as it appears.

http://www.zen-cart.com/forum/showthread.php?t=116061

Thanks for the help, Jimmy, and sorry to have taken so long to get back to you.

I haven't yet had time to do this, but if I can't manage, you'll hear back from me again :D

so has anyone tried adding a sort column?

shadowcast:

so has anyone tried adding a sort column?

As the field products_sort_order is in the PRODUCTS table in the database, it is possible to incorporate this into easy populate. (I have successfully added many additional fields in the products tables to my copy of EP.)

The technique for adding fields is described here:-
http://www.zen-cart.com/forum/showpost.php?p=659172&postcount=1

schoolboy:

As the field products_sort_order is in the PRODUCTS table in the database, it is possible to incorporate this into easy populate. (I have successfully added many additional fields in the products tables to my copy of EP.)

The technique for adding fields is described here:-
http://www.zen-cart.com/forum/showpost.php?p=659172&postcount=1

In fact, I have zipped up my copy of easypopulate.php (just the FILE that goes into the admin folder) and my copy will put in both the products sort order AND the master categories ID.

The two new columns in your spreadsheet will be:

v_products_sort_order | v_master_categories_id

You can either unzip and use my file as-is, or use it to compare with the original (following the tutorial by lankeeyankee).

Naturally, if you use my file (in place of the ORIGINAL in the admin folder), then you will backup your original file first.

elkbow:

SPH,

Use version 1.2.5.4 and follow this from lankeeyankee.

http://www.zen-cart.com/forum/showthread.php?t=116061

Thanks, I'll take a look.

schoolboy:

As the field products_sort_order is in the PRODUCTS table in the database, it is possible to incorporate this into easy populate. (I have successfully added many additional fields in the products tables to my copy of EP.)

The technique for adding fields is described here:-
http://www.zen-cart.com/forum/showpost.php?p=659172&postcount=1

hi bro, i tried doing it.:oops:
i added sort to the list. but it does not work

shadowcast et al...

I have a reworked file that should be ready before end of week after testing. Shoot me your email if you need it then or

I will also update that old one in the downloads section so future folks can have it since it is obviously popular

shadowcast:

hi bro, i tried doing it.:oops:
i added sort to the list. but it does not work

It worked perfectly for me... I followed LankeeYankee's instructions carefully... and had no problems at all.

So the problem cannot be with the method LankeeYankee advocates.

I think you may find the problem by looking in a mirror :D

OK... that's a bit cruel... no offence meant.

Have you tried my ZIPPED file, loaded in the previous post?

Have searched without success for an answer to this one so......
I am trying to use easy populate to conduct a stocktake of our inventory. I have a multiple price add-on which I use to record the cost price on each product. When I download the complete inventory using easy populate into excell it only gives me the retail price but I want it to give me the 'Price A' price which is where we record our cost price on items. What needs to be changed in the code to make it download the 'A' price as well or instead of the retail price?

schoolboy:

It worked perfectly for me... I followed LankeeYankee's instructions carefully... and had no problems at all.

So the problem cannot be with the method LankeeYankee advocates.

I think you may find the problem by looking in a mirror :D

OK... that's a bit cruel... no offence meant.

Have you tried my ZIPPED file, loaded in the previous post?

no offence , cause i am realy bad at this kind of stuff. i will most probably be missing something.

Shadowcast,

I don't know if this helps you, but I use Dreamweaver. Open the admin/easypopulate.php file and use the "Find and Replace".

Type in v_products_weight then hit the "find all".

If it shows any found, you may have missed one that needs to be changed to sort order.

That file by schoolbow really works great...

elkbow:

Shadowcast,

I don't know if this helps you, but I use Dreamweaver. Open the admin/easypopulate.php file and use the "Find and Replace".

Type in v_products_weight then hit the "find all".

If it shows any found, you may have missed one that needs to be changed to sort order.

That file by schoolbow really works great...

The procedure is sound enough... but I would not advise novices to use DreamWeaver to do file edits.

The same SEARCH function is available in plain text editors (mcuh better to use these) such as EMERALD editor and NOTEPAD ++ .

i just tried using schoolboy file and hit a problem.

First, the old easy populate will show the files in the tempEp from your admin,but it no longer shows, after uploading, all i get was a white screen.

new, i save it under csv and it can now upload, but my products are not able to upload. even thought it says that it is successful.