Here's a quick tutorial on how to add fields to easypopulate v1.2.5.4 or 1.2.5.5

[artmuns]

Hi,

Getting the below when trying to import after modifying the various lines per your instruction. The first record will update correctly but the others will not (the subsequent records were new items). I have triple checked the mods and they are correct. Downloading the file gives me the correct columns I want.
They are "products_sort_order" and "default_subcontractor" (from another mod). Tried it also with just "products_sort_order"
and same problem. Below is the error log.

Thanks for any help!

Art

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO zen_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,
manufacturers_id)
VALUES (
'no_picture.gif','3R1919-14B-CW',
'349.99',
'1',
CURRENT_TIMESTAMP,
"2009-01-09 13:59",
NULL,
'1',
'28',
'20',
'',
'0',
'13')

[artmuns]

One more thing: This is the message after trying to update:

UPDATED! - Model: 3R1919-14B-EW | | Roto Mil-S | Empty - Pu | | | | | 279.99 | 23 | 10 | | | 1/9/2009 1 | 0 | SKB | Shockmount | SKB - Mil | Roto Cases | 3R Series | | | | Taxable Go | 1 |
ADD NEW PRODUCT FAILED! - Model: 3R1919-14B-CW - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: 3R2216-15B-E - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: 3R2217-10B-EW - SQL error. Check Easy Populate error log in uploads directory

Thanks again.

Art

[lankeeyankee]

Art,

It looks like, in your first post, that there are more VALUES being added than there are rows in the table, thus the error message you received:

MySQL error 1136: Column count doesn't match value count

In your second post, it looks like you don't have EOREOR at the end of your row which is why the only one added is the first record, or since the column count and value count don't match it is throwing it off.

This often happens with a quote ending up throwing things off. If you look at the VALUES you were trying to insert you will see after the weight and quantity values there is a '', followed by '0', '13'. I'd look at the spreadsheet file to make sure all values are in their correct columns and that you have EOREOR at the end of each row.

Please let me know if you are still having trouble. You can post your spreadsheet file and your easypopulate file so I can see what's going on.

[artmuns]

Thanks for the reply lankeeyankee. Everything imports correctly if the product already exists. It only throws the error if it is a new product in the import file. I can take an existing product code that imports properly, change it by one character and when I try to import it again it throws that error.

Thanks for the help!

Art

[swamyg1]

I assume this would work for adding meta tags for products?

[lankeeyankee]

I assume this would work for adding meta tags for products?

most likely, yes. but I haven't tried it so I can't say for sure. You might have to insert new db queries for other db tables, but again I'm not sure. sorry that I can't help further!

[Mike_Dean]

I assume this would work for adding meta tags for products?

I'm trying to find this out myself as well.

From what Lanky suggested, just check the products structure in your database and whatever fields are in there, can be added to the EP table.

Problem I see there is that whilst the metatags status fields are in the products structure, the actual metatags titile, keywords and descriptions are not.

They have their own field in the database called meta_tags_product_description and in that structure, resides the metatags_title, metatags_keywords and metatags_description.

I'm trying to find a clean way to add meta tags and status at the same time as an upload of upto 1000 parts at a time..

1.2.5.7 does this, and although the process works, there are some code issues and you get warnings on the admin site, which to me is never a good thing.

I'm using 1.2.5.4 on my live site, so this thread interested me, and I'm cautious to upgrade it to 1.2.5.7 whilst there are code issues...

I think what I will do is do a clean install on my test site, dump 1.2.5.4 on that and see if I can amend the EP as per this tutorial...

[jackie.taferner]

Mike, yes you should definitely try upgrading. What kind of errors are you getting when you upgrade EP?

[lankeeyankee]

Thanks for the reply lankeeyankee. Everything imports correctly if the product already exists. It only throws the error if it is a new product in the import file. I can take an existing product code that imports properly, change it by one character and when I try to import it again it throws that error.

Thanks for the help!

Art

was this working correctly with the default EP install? Or just since you made the changes that I outlined?

[CoolCarPartsOnline]

Are you familiar with the Advanced Easy Populate???
I have an added mod to my site that creates new table to the database they are called maker_name and maker_model. How can I display the values of these 2 tables in my exported file. I managed to add the auction attributes and the MSRP Price table to the Easy Populate since they are tables inside the product_table. But the 2 new tables are separate from the product table.