Easy Populate 1.2.5.4 support

Newbird, you wrote>>Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

In the install.txt it said to only run the SQL if the config install fails. It sounds like your config install went fine. And I saw that you had success uploading products, so that's great.

My Issues:

1. Knowing the answer is out there somewhere...Why am I getting
   "No model field in record. This line was not imported | | | | | " after I upload?

2. When I attempt to browse to my txt file, the Upload function doesn't execute but if I load my txt file to the temp folder and use that "form" (Import from Temp Dir (temp/), the upload does execute correctly. Has anyone seen this?

I would LOVE to see this thread/forum split up by the moderator!!

Thanks.

It created duplicate products instead of overwriting the original product. Am I doing something wrong?
No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

misty:

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

So now that I have the model numbers, it will automatically overwrite if I make any more changes?

Thanks for your help!

erika_311:

So now that I have the model numbers, it will automatically overwrite if I make any more changes?

Every product MUST have UNIQUE model number..if you add further
products, using model number used before, EP will overwrite..
use different/unique model number/s for further products, EP will
enter.

misty:

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.

AWESOME! Thank you!

erika_311:

AWESOME! Thank you!
:smile:
Your Welcome..

I was just wondering if we should change the setting in the database table to make the field "product_model" Null=No;

1 - Can this be done without harming other functions?
2 - Would this prevent me (as it should) from adding a product without this important value?
3 - Wouldn't this prevent importing products with a null value - again, as it should?

~Lynne

Ok, I'm sorry if I'm asking really basic stuff here, but this thread is 150 pages long and search isn't paring it down well for me at all.

I'm trying to set up Attributes. Pulling down a model/attributes sheet with Easy Populate is not making any sense to me. I made a couple of attributes and gave them values... and threw them on a category of products, and pulled down the sheet with EP again... and it's still not making a lot of sense to me. It's either really complex, or way simpler than what I thought it'd be and that's why I'm confused.

All it's doing so far is listing EVERY product, EVERY attribute on every row, and putting a 0 in one column of the ones that have it assigned. Is that all it does? And doing that is all it takes?

Does anyone have any SQL scripts they use to assign attributes instead of doing it through EP? Because that doesn't seem to be a very simple way of doing it. You'd have to link that model sheet to some other sheet anyways, and if you're joining tables, might as well just go straight to SQL, right?

The main thing I want to do it outside of the default attribute copy interface for, is I need to assign by category and manufacturer. At the least. Not just category. And even probably a lot of manufacturers will have some colors and options only available to certain product lines, and not all of their items under a certain category.

Any advice or help would be awesome.

Most especially just an explanation of what each column in that models/attributes sheet is. Maybe it's just as simple as I'm thinking and I'm over complicating it on myself.

Thanks in advance.

Can I change the field product_model to "unique" without causing any problems for other functions?

lkzone:

Can I change the field product_model to "unique" without causing any problems for other functions?
EVERY Product entered using Easy Populate, MUST HAVE
UNIQUE MODEL NUMBER, or it wont work.

I have started work on a WIKI entry for Easy Populate that Newbies may find helpful.
**
http://www.zen-cart.com/wiki/index.php/Easy_Populate**

Additionally, there are probably 100,000,000,000 users of Zencart and EP that are more intelligent than me, so I'd appreciate it if EP experts could take a look and alert me to errors, etc. (As it's the WIKI, users can edit at will ! :D )

Misty, thanks. I know the number has to be unique but in my products table the field doesn't have that setting in the table structure. Also, Null isn't set to no. Should I change these in my table/field attributes?

lkzone:

I was just wondering if we should change the setting in the database table to make the field "product_model" Null=No;

1 - Can this be done without harming other functions?
2 - Would this prevent me (as it should) from adding a product without this important value?
3 - Wouldn't this prevent importing products with a null value - again, as it should?

~Lynne

Whatever you do, DON'T try to delete product_model from the database. It is FUNDAMENTAL to the functioning of Easy Populate.

The Model Number (aka Stock Keeping Unit or SKU) is an elementary part of all retail, as it provides the unique identifier for a product. These days, barcodes are used for the same purpose.

If you use Easy Populate, you will need to give each of your products a unique Model Number.

I've just put up the start of a WIKI on Easy Populate. You may find it helpful...:smile:

I am aware that the number has to be unique and cannot be deleted.

In the table structure: should I (we) change the field product_model to be unique?

Secondly, shouldn't the null field be set to no.

I appreciate your responses Misty and love the new Wiki stuff (read it today) but I still haven't gotten an answer as to changing the field attributes in the database.

Regards,
Lynne

lkzone:

I am aware that the number has to be unique and cannot be deleted.

In the table structure: should I (we) change the field product_model to be unique?

Secondly, shouldn't the null field be set to no.

I appreciate your responses Misty and love the new Wiki stuff (read it today) but I still haven't gotten an answer as to changing the field attributes in the database.

Regards,
Lynne

Lynne, Zencart allows DUPLICATE products (either by linking, or by outright duplication). This means de-facto, that DUPLICATE products have the same Model Number.

EP handles this by allowing duplicate model numbers in an EP upload IF the two (duplicate) products are in different categories. (See my WIKI).

So you don't want to force uniqueness in this d-base table.

Additionally, as it is EP that requires a model number (not zencart itself) null should not be set to no.

Okay, I won't change the setting -- thanks for zoning in on my question!

BTW, my experience with relational databases (I'm not a programmer!) shows that primary keys should always be unique. Wouldn't you think that the Products table would have a one-to-many relationship with Product_categories?

This would allow the setting of product_model to be unique. Hmmmmm

Anyway, that's not how it's setup at this point so I guess I'll have to trust my data entry clerk not to double-enter -- hmmm...what if my vendor's inventory update has a duplicate product_model # ... I wonder what will happen...

ya see, I'm only uploading the quantity/pricing for my products so category is never a field being compared. Hmmmm

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu

I tried to do the seach but did not find solution.

I have need to display a image for view only for products.

I did following

1. Added Option name: Price list
2. Added a empty option value

• some reason Attribute controll reuires that

3. Added "Price list" with image defined to a product

Well not it shows the image in produt info OK

PROMLEM:
Problem is how do I set image on many product with easy populate.
I can set the price field OK but then the product shows the Price list name but not the IMAGE?

Is it possible to do with esay populate or must I use Zen Cart feature to copy the attribute instead?

marksu

Going nuts here :censored:

I have been trying to get my records to import using EZ Populate without success.

Here's the scenario:

I have the Tab delimited file ready for import. I have even stripped it down to just the Model Number, Image and EOREOR. I browse for the file, upload it with "New Product" messages as to be expected.

When you view the products.....nothing!

I then tried importing it while specifying a category. The good news is that the category appears as it should have. The bad news is that there were no products in it.

I am not new to EZ Populate, but this is crazy.

I really need to get my products imported into my new store, so any help would be appreciated.

Sincerely,

Marty

martbost,

I have had trouble (ie the updates don't show up) using "Upload EP File" -- the first option under Tools/Easy Populate-- but when I FTP my file up to the temp folder and then use the "Import from Temp Dir" option, it does the update. I don't know if this is a glitch on my side but you might try this if you haven't already.