EasyPopulate 4.0 Support Thread

[chadderuski]

I've been trying to find a way to 'escape' the comma - and have had no luck. So I just deleted all of the contents in the description.
There are now no comma's anywhere in the csv file.
When I try to import I get "No model field in record. This line was not imported" over and over - no records import.
But I have no idea why...
What now?
Thanks!
Amber

If you are using OpenOffice to export your file, you do NOT have to worry about commas, quotes, etc. in your descriptions. But you do need to make sure you are exporting your file correctly from OpenOffice. This has been explain in detail in the first couple posts of this thread.

Also, please read the README docs that come with the mod. I always recommend that you enter a product manually first through the admin, then do an EXPORT to get your file header and column mapping. This goes a long way to explain how to use the mod. Most things are very self-explanatory.

-chadd

[chadderuski]

Easy Populate 4 seems to be working great but I'm having a vexing problem. I've successfully imported my products but when I go to edit an individual product, I make a change click on preview, and then don't have the Back, Update, or Cancel buttons on the preview page. I do have the option with products I've uploaded individually; otherwise I would think the problem is elsewhere.

I've compared the query strings from a manually-added product and one from Easy Populate, and there is no difference other than the category and ID of the product.

I've turned on strict debugging and looked in my logs but there are no errors to give me a clue. It seems as if not allowing me to edit the product is set somewhere and I don't know where to fix it.

I'm running on a cPanel VPS with Zen Cart 1.5.1, upgraded from 1.3.9h. Everything else is working just fine.

The only thing that I can think of without seeing your data / install is that you have not set v_product_type to 1 which is a normal/standard product.

I'm going to simplify this is the next update so that the column doesn't export unless you have enable "music" columns.

-chadd

[chadderuski]

Just to recap:

When first learning to use EP4, first manually create a product within your category tree, i.e.

products_model: widget_101

in it's proper category:

Widgets > My 101 Widgets

So you now have a widget within it's Top level category, and sub-level category.

When you export your data, you'll see the category column as this: "Widgets^My 101 Widgets"

Now, before you do anything else, you should be able to Export your data, and WITHOUT DOWNLOADING OR EDITING, import that SAME file. You should get NO errors, and a notice that says the products was "Updated".

Go look at the product and ensure the the "round-robin" Export -> Import worked without error. If you have not error, you're ready to download your CSV file and begin working on it.

If you have not experience with data import/export, easypopulate (any versions!), it is best to go slow and only work with a couple products until you are confident about what you are doing.

All I can say is that EP4 has been tested by numerous users, some with sku's numbering the hundreds of thousands (one store has 980,000 sku's!!!) without error (server permitting!).

I hope this clarifies some things for new users...

-chadd

[hermes369]

Hmmmm. v_products_type is set to 1 for all items. There must be some kind of way to see what's different between whatever is generating the product preview for products I may edit and the ones I can't. I guess I'm looking for something like a Console, or Event Viewer for mysql. Obviously there is some difference somewhere. I appreciate the advice to go slow. I will try that again presently.

Thanks for the response!

[Serious]

veery frustrated over here.

Spent a few days going through all of my products via a downloaded .csv file to remove all of the HTML tags in the MetaTag descriptions.

Divided the spreadsheet int 3 separate sheets of approx. 2000 parts each.

made sure that all " were removed from the text in the description fields.

Uploaded and imported the files only to find that ALL of the product descriptions are being cut-off.

So now what?

The descriptions were correct (with regards to length) in downloaded spreadsheet.

[Serious]

I went back through the descriptions and noted that all text after the ® was dropping off.

Could be happening with trademark and copyright symbols too, haven't looked yet.

Anyway around this?

[chadderuski]

I went back through the descriptions and noted that all text after the ® was dropping off.

Could be happening with trademark and copyright symbols too, haven't looked yet.

Anyway around this?

Serious,
I sent you a PM. Please contact me off line so I can help you better.
-chadd

[Dashizna]

how do you import items and have easy populate 4 make the categories for them. it trys to import them and it says
SKIPPED! - Model: 18200 - No category provided for this new product
SKIPPED! - Model: 18201 - No category provided for this new product
SKIPPED! - Model: 18202 - No category provided for this new product
SKIPPED! - Model: 18203 - No category provided for this new product
SKIPPED! - Model: 18204 - No category provided for this new product
SKIPPED! - Model: 18205 - No category provided for this new product
SKIPPED! - Model: 18240 - No category provided for this new product
SKIPPED! - Model: 18241 - No category provided for this new product
SKIPPED! - Model: 18242 - No category provided for this new product
SKIPPED! - Model: 18243 - No category provided for this new product
SKIPPED! - Model: 18244 - No category provided for this new product
SKIPPED! - Model: 18245 - No category provided for this new product
SKIPPED! - Model: 18248 - No category provided for this new product
SKIPPED! - Model: 18249 - No category provided for this new product

please let me know what im doing wrong thanks

[chadderuski]

how do you import items and have easy populate 4 make the categories for them. it trys to import them and it says

SKIPPED! - Model: 18249 - No category provided for this new product

please let me know what im doing wrong thanks

Hi Dashizna,

You should read the first posts in this thread for more detailed info, but you must provide a category name in the v_categories_name_1 column.

This error means you left it blank.

[Dashizna]

Hi Dashizna,

You should read the first posts in this thread for more detailed info, but you must provide a category name in the v_categories_name_1 column.

This error means you left it blank.

haha my bad helps when you have the head line there when you upload the file.