Easy Populate 1.2.5.4 support

Scrat:

samgdaniel: Did you have a product already in Zen Cart before you did a EP import?
As with EP 1.2.5.4 if you had no products in the DB and no category/ies and you imported with EP your products would not show, but if you have a one category and one product in ZC - EP would import and show!

Scrat, thanks for the reply. I had one product in Zen Cart which I added in manually. I also set up categories as well. What I did was download the complete CSV file without attributes and used this as a template for my test file. I added a new product with a unique model number and EP says no errors but nothing is added to the database.

Should I go to EP 1.2.5.4?

samgdaniel:
What messages do you get when you import ? (ie Updated,New Product etc)
Are your products set to active?

As far as I can tell (I have only tested 1.2.5.5 myself) and it seems to work OK

samgdaniel:

There seems to be a bug in EP when adding products to an empty store. I have not been able to completely nail this bug as to the cause myself, but to fix it do this:

After running your update go to: Tools > Store Manager

Now run:

Update ALL Products Price Sorter

and

Reset ALL Products Master Categories ID

This should fix your problem. If you are to look at the databases from within phpMyAdmin you should see the products there, just not showing up in your store.

-cj

Scrat:

samgdaniel:
What messages do you get when you import ? (ie Updated,New Product etc)
Are your products set to active?

As far as I can tell (I have only tested 1.2.5.5 myself) and it seems to work OK

Scrat, no error messages I even have the EP debugging set to True. My product is active.

chadderuski:

samgdaniel:

There seems to be a bug in EP when adding products to an empty store. I have not been able to completely nail this bug as to the cause myself, but to fix it do this:

After running your update go to: Tools > Store Manager

Now run:

Update ALL Products Price Sorter

and

Reset ALL Products Master Categories ID

This should fix your problem. If you are to look at the databases from within phpMyAdmin you should see the products there, just not showing up in your store.

-cj

Chadderuski

I ran the Update All Products Price Sorter and Reset All Products Master Categories ID.

I ran the importer and it says it upload complete. But when I look at the product table through PHPAdmin and also through Zen Cart, I only see my original product that I've entered manually.

I am using 1.3.8

I just updated my easy populate support and now it has multiple listing (repeated) on the configuration tab. Any ideas as to what I did? How do I get the multiple (repeat) listings off?

samgdaniel:

Chadderuski

I ran the Update All Products Price Sorter and Reset All Products Master Categories ID.

I ran the importer and it says it upload complete. But when I look at the product table through PHPAdmin and also through Zen Cart, I only see my original product that I've entered manually.

Sam,

What is your default language id? I think I remember seeing an issue if you use something other than english as your default language...

Ah! Wait. You are using the CSV version or the 1.2.5.4 TAB version? You will need to find the CSV support thread. My comments are for the 1.2.5.4 TAB version. Nor can I speak on the workability of 1.2.5.5 ... seems some people have problems with that.

I am having problem to load my items using easy populate. Currently I am using
easy populate 1.2.4
zen cart 1.3.8

My php configuration is:
max_execution_time = 45 ;
max_input_time = 60 ;
memory_limit = 96M ;

Server timeout = 10 seconds.

I constantly get HTTP Error 502 - Bad gateway error, even just load one item. I don't have problem to download from database.

It used to work before, but suddenly it's not working. I'm not sure if any server configure changed which affects on this.

Appreiate any help on this.

Anybody can help?

Thanks.

Having some problems adding new products via Easy Populate 1.2.5.4. and zc 1.3.8a

Everything works fine when i update my current products already in the DB.

Problem is when i try and add a new product.

Here are my steps on how i was doing it.

1: Download Complete tab-delimited .txt file to edit (Attributes Not Included)

2. open with Open Office

3. in the correct fields i add my v_products_model, v_products_image, v_products_name_1, v_manufacturers_name, v_categories_name_1, v_categories_name_2, v_categories_name_3, v_tax_class_title, v_status, EOREOR

4. save and upload back to easy populate.

Easy Populate gives me this error:
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

my log file says this

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
						products_image,
						products_model,
						products_price,
						products_status,
						products_last_modified,
						products_date_added,
						products_date_available,
						products_tax_class_id,
						products_weight,
						products_quantity,
						master_categories_id,
						manufacturers_id)
							VALUES (
								'products/KLA161_1.jpg','KLA161',
									'',
									'1',
									CURRENT_TIMESTAMP,
									CURRENT_TIMESTAMP,
									NULL,
									'1',
									'',
									'',
									'',
									'0',
									'140',
									'65')

any suggestions on what is wrong?

Do you have any completely empty columns in your tab-delimited text file ? (That is, a column WITHOUT a header and WITHOUT any further content).

If you "remove" unwanted content (on occasions where it need not be updated by EP) then it's no good to just delete the data in your spreadsheet. The entire column must go... no "blank" columns.

fairestcape:

Do you have any completely empty columns in your tab-delimited text file ? (That is, a column WITHOUT a header and WITHOUT any further content).

If you "remove" unwanted content (on occasions where it need not be updated by EP) then it's no good to just delete the data in your spreadsheet. The entire column must go... no "blank" columns.

there arnt any that are completely empty. i use the one i DL from EZ Populate and just add a product# and catagory. everything else that was originally in the file uploads fine, just the new item

i tried doing this as well:

deleted all colums and only put an item number and a test catagory along with eoreor

i got 2 errors

Warning: explode() [function.explode]: Empty delimiter in /home/XXXXXX/public_html/XXXXX/includes/functions/extra_functions/easypopulate_functions.php on line 241

and

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

in easypopulate_functions.php line 241 reads:

	```

$date_bits = explode($separator, $excel_date[1]);

on the bottom of the page where it shows the updates it reads:

ADD NEW PRODUCT FAILED! - Model: abdef - SQL error. Check Easy Populate error log in uploads directory
No model field in record. This line was not imported |


and the error log reads this

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
VALUES (
'no_picture.gif','abdef',
'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'',
'',
'',
'',
'0',
'171',
'NULL')

Are you sure you are using EP 1.2.5.4 ?

See my WIKI article:
http://www.zen-cart.com/wiki/index.php/Easy_Populate

schoolboy:

Are you sure you are using EP 1.2.5.4 ?

See my WIKI article:
http://www.zen-cart.com/wiki/index.php/Easy_Populate

hmm interesting. my admin page shows 1.2.5.4, but the file i downloaded and installed says 1.2.5.5

this is the one i downloaded and am using

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=395

it has something to do with the values

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,				
products_model				
products_price,				
products_status,				
products_last_modified,			
products_date_added,		
products_date_available,			
products_tax_class_id,			
products_weight,			
products_quantity,			
master_categories_id,			
manufacturers_id)
							
VALUES (
'products/KLA160_1.jpg',
'KLA160',
'5',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',
'',
'',
'0.1',
'20',
'140',
'67')

12 colums and 14 vlaues

everything it finds is between '. so i am assuming where it says CURRENT_TIMESTAMP, is where the error it is coming from.

what do i do from here?

ok just found out that the 2 values with nothing in them are the msrp and cost fields.

how do i make it so that it does look for them when adding new products?

sure wish i could delete my older posts so people dont get confused. dont know why i can even edit them after a few minutes

Langer,

When I try insert EP file in "Easypopulate",
It says:

No model field in record. This line was not importedMeradian2. | One Treatm | It is not | | | | | 60 | 0 | | 4/27/2009 | 2 | | Treatment | | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |

What I do wrong?:frusty:
Thanks a lot

fixed it.

needed to add msrp and cost around line 1921 in admin/easypopulate.php

all works now