Easy Populate 1.2.5.4 support

apogeerockets:

will EP 4 beta solve this problem? i guess i may as well test locally to find out....

I use EP4 in conjunction with another EP. EP4 looks like our best bet for upgrading to 1.5 cart. He is still working on the attributes function, though.

EP4 works flawlessly for me re the products function. And one thing I really like about it: you can download by category. Meaning that when you download your products, you do not have to download them all. Very nice touch.

Is the EP 1.2.5.4 in the works to be upgraded to 1.5? Just wondering, as I have not used this version for years.

sph

https://www.prommart.com

https://www.prom-mart.com
test area

SPH:

Is the EP 1.2.5.4 in the works to be upgraded to 1.5? Just wondering, as I have not used this version for years.

Probably not. EP4 will assume the mantle going forward.

My only issue with EP4 is that it favours CSV over tab-delimited, and that's why I don't use it. When product descriptions are full of commas, and possibly the odd quote mark, it risks throwing the load file into total disarray.

Tab-delimiting is far more robust and error-resistant, and makes for a much easier conversion from spreadsheet to txt format (one of Langer's original reasons for choosing it).

I haven't run into problems yet, knock on wood. But will keep an eye on it.

sph
https://www.prom-mart.com
Ecommerce Cart Test area

fairestcape:

Probably not. EP4 will assume the mantle going forward.

My only issue with EP4 is that it favours CSV over tab-delimited, and that's why I don't use it. When product descriptions are full of commas, and possibly the odd quote mark, it risks throwing the load file into total disarray.

Tab-delimiting is far more robust and error-resistant, and makes for a much easier conversion from spreadsheet to txt format (one of Langer's original reasons for choosing it).

Hi fairestcape!

Actually, there are provisions in the EP4 for using tab-delimited files. If you look at the first few lines of easypopulate_4.php, you'll see this. Note that I am using php's fgetcsv() function to read data from the input file. fgetcsv() is not perfect, but it is so much faster and less convoluted than langer's code. Feel free to experiment!

The main issues with fgetcsv() is that the CSV file must be properly formatted. OpenOffice does this correctly, but Excel is finicky depending on the platform (mac/pc) and version you are using.

-chadd

Let's keep discussion of EP4 in the EP4 thread, please.

I just installed EP4 and manually inputted a single product to copy formatting for other products.

When I downloaded the products file, the product wasn't in the file. I added a few products to the file from memory and then uploaded them.

The new products didn't load into zen cart, but when I download the file again the new products, but tnot the original were int he scv file.

Did I do something wrong in the install?

Also I would like to have my site in multiple languages, is there a possible additional descriptions that I can load with ep?

Thank you.
Andi

chadderuski:

Hi fairestcape!

Actually, there are provisions in the EP4 for using tab-delimited files. If you look at the first few lines of easypopulate_4.php, you'll see this. Note that I am using php's fgetcsv() function to read data from the input file. fgetcsv() is not perfect, but it is so much faster and less convoluted than langer's code. Feel free to experiment!

The main issues with fgetcsv() is that the CSV file must be properly formatted. OpenOffice does this correctly, but Excel is finicky depending on the platform (mac/pc) and version you are using.

-chadd

I'll continue with this on the EP4 thread, but do have a comment on the above, that is relevant to 1,2,5,4

We only discovered this a short while ago, but it is very effective in "by-passing" the fussiness of Excel, and the inststence of Excel in saving .txt formats its own way.

This is what we do...

(We use CRIMSON EDITOR as our PLAIN TEXT EDITOR in matters of code editing, etc. So if you want to use our method of creating the tab-delimited TXT file that EP 1.2.5.4 requires, out of an Excel spreadsheet, then go and get CRIMSON EDITOR and install it.)

STEP ONE
Create your initial spreadsheet in MS Excel, using the columns relevant to your data import needs.

STEP TWO
SAVE this as a MS Excel spreadsheet... NOT as a TXT file.

STEP THREE
OPEN Crimson Editor

STEP FOUR
Toggle back to the MS Excel spreadsheet and HIGHLIGHT all the data. CTRL+C (copy) it to computer clipboard.

STEP FIVE
Toggle to Crimson Editor and CTRL+V (paste) clipboard contents.

You now have a "perfect", tab delimited file, which you just need to save as a .txt file.

its give me seccurity error and got mesage "Please contact administrator "

ludoto93:

its give me seccurity error and got mesage "Please contact administrator "

You need to desribe what you did FIRST... How are we supposed to know what ause it to do this?

What were you doing BEFORE it ame up with this message?

schoolboy:

You need to desribe what you did FIRST... How are we supposed to know what ause it to do this?

What were you doing BEFORE it ame up with this message?

i fix it but i dont know how to add products now ? example my categorie id is 150 then how to add 10 products same time there?

I am am SUPER new to zen cart and easypopulate.

May I know if easypopulate 1.2.5.4 is still working with zen-cart 1.5?
Or I must now use EP 4.0?

Please help me!!! Thank you very much.

hanming:

I am am SUPER new to zen cart and easypopulate.

May I know if easypopulate 1.2.5.4 is still working with zen-cart 1.5?
Or I must now use EP 4.0?

Please help me!!! Thank you very much.

You should use EP ver 4 with ZC 1.5

NO admin > Tools > "Easy Populate" button
None in "admin >configuration" either

Installed zen cart v1.5.0
Installed ez populate easypopulate-shafiqv1-2-5-6
NO button

Installed right over previous install ep_v1.2.5.4
NO Button

Easy Populate works using:
h ttp://mysite.com/admin-directory/easypopulate.php?langer=install
(space added to stop this system from amking it a linkl)

When I run it there is a green message at the top of the screen which says:

Installation Successfull! A full download of you store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.
Success File Full-EP2012May11-1111.txt successfully exported! The file is ready for download in your /temp/ directory.

I have installed Easy Populate on another zen cart before.
Am I doing something wrong?
Is it OK to use it without the button.

larryweiss:

NO admin > Tools > "Easy Populate" button
None in "admin >configuration" either

Installed zen cart v1.5.0
Installed ez populate easypopulate-shafiqv1-2-5-6
NO button

Installed right over previous install ep_v1.2.5.4
NO Button

Easy Populate works using:
h ttp://mysite.com/admin-directory/easypopulate.php?langer=install
(space added to stop this system from amking it a linkl)

When I run it there is a green message at the top of the screen which says:

Installation Successfull! A full download of you store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.
Success File Full-EP2012May11-1111.txt successfully exported! The file is ready for download in your /temp/ directory.

I have installed Easy Populate on another zen cart before.
Am I doing something wrong?
Is it OK to use it without the button.

I have this very same issue. can any1 help?

panelcart:

I have this very same issue. can any1 help?

Use this following query in mysql. you will have the ez-populate under tools.

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES
('ezpopulate', 'BOX_TOOLS_EASYPOPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', 150);****

Balaji:

Use this following query in mysql. you will have the ez-populate under tools.

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES
('ezpopulate', 'BOX_TOOLS_EASYPOPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', 150);

Thanks for the help.!

hanming:

I am am SUPER new to zen cart and easypopulate.

May I know if easypopulate 1.2.5.4 is still working with zen-cart 1.5?
Or I must now use EP 4.0?

Please help me!!! Thank you very much.

I'm not sure if it is fully working with it right now..... Some confirm this!

Almost all the earlier version modules works in zen 1.5 which are not having boxes defined in admin. For box definitions you need to use admin>admin access management>admin page registration. So the easy populate too.

Balaji:

Use this following query in mysql. you will have the ez-populate under tools.

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES
('ezpopulate', 'BOX_TOOLS_EASYPOPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', 150);****

That worked - now how do I add the settings to the configuration menu??

Thanks
Matt

My plan is to upload stock received to admin via EP but ADD to current stock quantity when uploading.

Three columns:

1. v_products_id
2. v_products_model
3. v_products_quantity

At my line 1561 a query selects the current contents...
$sql = "SELECT
p.products_quantity as v_products_quantity,

I see in my line 1980 this...
$query = "UPDATE " . TABLE_PRODUCTS . " SET
products_quantity = '" . zen_db_input($v_products_quantity) . "' ,

In order to do this, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "'