Easy Populate 1.2.5.4 support

[ams30gts]

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')

[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

[ams30gts]

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

[ams30gts]

this is the one i downloaded and am using

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

[ams30gts]

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?

[ams30gts]

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

[acutouch]

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?
Thanks a lot

[ams30gts]

fixed it.

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

all works now

[Outloudvinyl]

I'm having problems when I load attributes. I exported the current attributes changed them and re-uploaded them. All works great except when a attribute has a negative value (That attribute should subtract from the price) When I put in a negative value it adds another negative sign in the attributes controller and so it because positive. I can't figure out how to get around that. Has anyone else had this issue?

[esugrue]

Hi!

I have a query in regards to EasyPopulate and the updating of stock!

I have about 200 items, about 100 of which have attributes - I have gone through and added stock to each of the size attributes for the items that have attributes.

I now just need to add stock to those items that do not have attributes - just the product and stock.

If I use EP and add stock quantity to only the products that have no attributes will the items that have attributes retain the stock I have already added.

eg:
Currently:
Item 1 (Size 1) - I have qty 2
Item 1 (Size 2) - I have qty 2

(Added these manually as they have stock attributes Size 1 and 2)

If I use EP and change stock levels for say Item 2 which has no attributes, will Item 1 retain the stock I have already entered, or do I have to remove those items from the EP upload altogether.