Easy Populate 1.2.5.4 support

rolo550:

Thanks for pasting in the link, but what are you trying to tell me? I was told column order didn't matter...is that what my issue is and you are trying to tell me?

I'm grateful for your taking the time to read my post but a little more specific pointer could be helpful

I can't teach you how to read... but your error says:

"No category provided for this product"

Seriously... you can't get a more simple report than that...

My tutorial illustrates how category issues are handled.

MrsDusty:

Hi

I normally find the answer to any problems I have in this forum, but this time I haven't had any luck.

I use Zent Cart v1.3.9d + Easy Populate 1.2.5.4
I haven't made any changes between Easy Populate working and it playing up. My site has been running for over a year.

I thought EP was not working at all at first, but after investigating I realized it will amend existing products but will not add new ones.

UPDATED! - Model: 100001 | Saa_og.gif | Skill at A | Skill at A | | | | | 1.75 | 0.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
UPDATED! - Model: 100002 | Saa_og.gif | Skill at A | Skill at A | | | | | 2.75 | 1.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
ADD NEW PRODUCT FAILED! - Model: ma073 - SQL error. Check Easy Populate error log in uploads directory

If anyone can suggest what I should try to fix this I would be very grateful.

Again... simple READING tells you:

Check Easy Populate error log in uploads directory

I have pasted the error log below, but I have no idea what it's telling me.

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
products_quantity,
manufacturers_id)
VALUES (
'' at line 11
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_order_min'
products_quantity,
manufacturers_id)
VALUES (
'MA073.jpg','MA072',
'1.8333',
'1',
CURRENT_TIMESTAMP,
"2010-07-15 19:30:00",
NULL,
'1',
'0.001',
'2',
'1000',
'17')

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_products_quantity v_manufacturers_name **v_categories_name_1 **v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
ma073 MA073.jpg ITW Grimloc GhillieTEX IR signature reduction technology. Corrosion resistant stainless steel spring. Self purging ports to prevent sand blockages. Attaches to 1 inch webbing. Textured grip for use with wet/gloved hands. Lightweight: 0.01 kg 3.75 1 1 Garrison PRI Qualification Patches Taxable Goods 2 EOREOR

It might be that the insert statements lack a final delimiter...

Line ELEVEN is the final line:-

'17')

The last line should have a semi-colon as the delimiter

'17';)

Just why it is not inserting the delimiter is not something that can be answered without knowing a lot more about your setup.

Perhaps DrByte will chance on this thread and offer us possible reasons. It could be that your EP files have become corrupted.

You might be able to rectify the issue by loading fresh EP 1.2.5.4 files via FTP.

Thank you. I will try a new upload of EP and see if that helps.

schoolboy:

It could be that your EP files have become corrupted.

You might be able to rectify the issue by loading fresh EP 1.2.5.4 files via FTP.

You were spot on. A new install and it's behaving like a dream.

100asa:

I apologize if the question has already been done, but I can not find it.
My site2 is the mirror of site1; some products on site1 was deleted, and when I import data on site2, the products deleted on site1 still remain alive on site2. Is there a way to delete (or mark as red) the products that not imperted from site1? I hope I'm clear

No one suggestion for my trouble? Must I full delete my sql products table and then import by easy populate?

100asa:

No one suggestion for my trouble? Must I full delete my sql products table and then import by easy populate?

Product information is put in MANY places in the database.

You should use Easy Populate to create a DOWNLOAD of all your product data.

Then, to DELETE product data, you edit the spreadsheet to change v_status to 9 for all products you want to delete. Then you "run" that file through easy populate.

Hello I am using easy populate but for some reason when you load the file prices that have a value example $2,520.99 will load on my site as $2.00. It seems to me that easy populate sees the Comma (,) in larger numbers as a decimal point.

Any suggestions Please,

Thanks

Lexxie

schoolboy:

I can't teach you how to read... but your error says:

"No category provided for this product"

Seriously... you can't get a more simple report than that...

My tutorial illustrates how category issues are handled.

I don't understand why everyone has to be such a smartass in this forum. I looked over your tutorial searching for category and categories and its just general info with "fix it" if you get errors...

If one looks at the file i pasted in, one will see that I have clearly defined a category column...so that leaves us with why is it not being pulled in...I realize its says "no category" in the error, but why? I have the categories name column in my file and every single product has a category assigned...

rolo550:

I don't understand why everyone has to be such a smartass in this forum. I looked over your tutorial searching for category and categories and its just general info with "fix it" if you get errors...

If one looks at the file i pasted in, one will see that I have clearly defined a category column...so that leaves us with why is it not being pulled in...I realize its says "no category" in the error, but why? I have the categories name column in my file and every single product has a category assigned...

Rolo, your problem is quite elementary: You have NO v_products_model column. This column is mandatory in order for EP to work as it is the main key the script uses for either adding or updating product information. This is clearly stated in the wiki.

If you do not want to use products_models, then you cannot use ep 1.2.5.4... you will have to look for Langers' Easy Populate Advanced 3.0.3 PAID module who has unfortunately fallen off the scene for years now... but his site still seems to be up... (!?!?!?) just be aware that you MAY NOT get what you pay for!

NOW....

Before accusing Schoolboy of being a "smartass" please note his 7,248 postings since 2005. He is one of a very few number of people that come into this forum, and also this thread to offer FREE unpaid support for people on a nearly DAILY basis... Quite a few people contribute from time to time, but very few are hear daily. Also, this thread is nearly 3500 entries long... with MANY of the exact same issues being repeated over and over. I think you can understand how one can become exasperated - which I've seen happen to the point that an avid supporter drops off the boards.

Schoolboy wrote his WIKI to help stem the flood of questions until someone writes a better module. (which BTW I've partly done... EP4 beta is posted at GITHUB)

So, be kind, and rewind on that statement! :P

-cj

No I get it, I mean, I feel how people repeat questios and all, but literally every time I have posted anything, the responses have been caustic...I'm on dozens of forums and this one is by far the nastiest...i get it, I'm a noob and <insert poster> is the all knowing God of this small little world - yes I don't know ########, and no i cant find this answer anywhere else, and yes maybe it is posted and I missed it - but I have looked sorry..there is no excuse for all the snottiness tho...I respect what people are doing here, totally, and I appreciate it and am grateful, but its just unnecessary is all I'm saying, I appreciate much schoolboy and his ilk...

Now that that is aside, I do in fact have a vproducts model column as well...I'm sorry if my file is confusing, maybe you didn't see because its out of order? I read order matters not, but maybe it does? I haven't had time truthfully in like a week or two to mess with it...I need to just paste it in the order of the sample...my error is category based though, and again, I did put categories, so that is where I'm getting confused... Thanks a million for the response...

Rolo,

I think your best bet is to do an export of your products after you have entered some manually through the admin.
This will give you the layout of the file. Maybe this will help you identify the problem.
You should be able to do an Export, then turn right around and Import that same file (without ever opening it!),
and it should import just fine. Do this, and let me know what the outcome it. If this file Uploads without
error, then you definitely have something wrong in your posted file.

Also, better to work with just a couple lines at first until you get the hang of it.

Okay, I looked at your posted file again and I see you did include v_products_model. I usually keep them in order, but that's just me. Sorry. It does come up though!

However, I see that you have two empty columns. Don't know how EP 1.2.5.4 is going to react to that. You have no column heading for the column after v_products_quanty, and the
column after v_products_model.

ANOTHER potential problem is that you have "data" in the empty columns AFTER the EOREOR column. Yes, nothing there but spaces, but these spaces will break EP 1.2.5.4. Open your spreadsheet and hi-light a dozen or so columns AFTER your EOREOR column and delete them. Do the same thing at the bottom of your spreadsheet for any blank rows. This is more than
likely your issues.

The parser langer wrote uses EOREOR to mark the end-of-record,end-of-row. It's doesn't really respect the end of line or carriage return characters because these can be different on different
operating systems. But what happens is that next empty data after EOREOR becomes the first element for your column 1 entry. It shifts everything out of order and breaks the script.

Fix these two issues and post back the results.

-cj

GADZOOKS!

On thirds look, you have several dozen empty columns you are importing. You may be better off hi-lighting your data columns and pasting them into an new empty sheet.

Must be 30 or 40 empty columns there!!

chadderuski:

GADZOOKS!

On thirds look, you have several dozen empty columns you are importing. You may be better off hi-lighting your data columns and pasting them into an new empty sheet.

Must be 30 or 40 empty columns there!!

Lol @ gadzooks...don't hear that exclamation often...

Ok I think im goind to not try to take my data file and paste in the headings, but instead take the EP headings and paste in my data...

I need to just start form the start again...I should have done that already...

I was kinda hoping to avoid the big pain in the ###### of having to paste column by column, instead just opening my data, which changes almost daily, and pasting in the headings, but it appears i need to just do it the long way...

Thanks for the response, much appreciated...ill follow up

I'm planning on attempting to use just the Model/Category text file generated in EP to move products between categories. Does it work like I hope - on an upload of the modified file, EP will look up each model# and change the master category ID for each?

fakeDecoy:

I'm planning on attempting to use just the Model/Category text file generated in EP to move products between categories. Does it work like I hope - on an upload of the modified file, EP will look up each model# and change the master category ID for each?

This is unlikely to work... At best, you will just find that EP DUPLICATES the products - possibly turning them into a LINKED product.

It is possible to add the MASTER CATEGORIES ID field to EasyPop, and this may be the better option.

Search for "Add Fields To Easy Populate" by LANKEEYANKEE

Quote:
Originally Posted by Alexiss View Post

I got it. UPC/ ISBN now works. Question is can I do this for manufacture image? Is there any extra step i would have to make.

Thanks

Lexxie
I really need some help with this. How can I make it to also import images for manufactures? Do I do the same thing? How do I tell easy populate how to import the image and where to import it? I really need to be able to do this cause I have over 1000 venders that have manufacture logo. Please any one who can help. I am not a programer but I am learning all that I can.

Thanks,

Lexxie

I have posted a few post with no luck getting help yet. Maybe I am posting in the wrong place.

My question is I was able to add additional fields to my easy populate. I need to add one for importing manufacture images. But I am not sure if it works the same by just adding p.manufacture_image in the same way as adding p.url. How do I tell it where to import the image and what file it is pulling from.

Thanks

Lexxie

Hi,

I've never used this mod and am about to install ZC 1.5 on a test directory in the hopes of moving it to my main site. I see there is yet no version of this mod for 1.5, but assuming one will soon come out, can I create the spreadsheet in the meantime? I figure that part wouldn't change, right?

Cheers,

R