Easy Populate 1.2.5.4 support

[schoolboy]

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

[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

[schoolboy]

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.

[lkzone]

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

[marksu]

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

marksu

[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

[martbost]

Going nuts here

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

[lkzone]

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.

[heavenlynights]

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

marksu

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA

[jvanree]

Hi,

I'm really trying my best to understand easy populate but I'm not doing to well. After 1 month of messing around with it I have to ask you guys for help on it.

I have zencart version 1.3.7. because that's supported by the dutchlanguage pack. I have created categories in the dutch language but have no products added. The products I want to add come from another site made with shop2date (by databecker) and are made in xml. files

Now the first thing I run into is that I can not get it installed. Not from zencart admin and not by directly typing the mysql thing. I read something about turning the dutch of? But I don't know how to do it. Also would that make me loose my categories (I have over 75 of them!).

Also do I install the files from easy populate right if I put them in c:\xampp\htdocs\zen ? And the register globals in which php.ini should I turn them on (because there are several when running it on pc)

Thank you in advance for helping... sorry being such a noob

Juliet van Ree