Easy Populate 1.2.5.4 support

[chadderuski]

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!

-cj

[rolo550]

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...

[chadderuski]

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

[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!!

[rolo550]

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

[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?

[schoolboy]

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

[Alexiss]

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

[giftmeister]

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

[schoolboy]

I'm posting this here to let visitors to this thread know about my recent experiences with APSONA.

I have (and may remain) an advocate for Easy Populate (1.2.5.4 and the commercial Ver 3.)

When Apsona introduced their Store Manager some years ago, I was invited to trial it. At the time, I was cautiously in favour of it.

This week, we were presented with a mammoth project, uploading over 3,000 products to a database, and with most having between 50 and 100 separate attributes. The data came from the supplier in a simple linear format (Excel), with every product variation allocated a product code.

That's a dbase with over 150,000 product options!

After examining a range of data-loading alternatives, including, bespoke SQL queries, EP 3, and even hiring an army of temp workers, I decided to load Apsona.

Wow... it has matured and improved since I tried it a few years ago.

The good news is that (using pivot table functions in Excel and a variety of other formulae), we will be able to load ALL products and ALL attributes in probably a couple of hours.

I think I might just abandon EP completely now, in favour of Apsona.