Easy Populate 1.2.5.4 support

[chadderuski]

Chadderuski- thank you for your response. I've tried the "Reset all products master categories ID" from seeing it mentioned in this thread but it doesn't solve this weird issue I'm having.

I checked the Wiki, but it doesn't mention my issue.

I know EP is working because I see it in my Products table with a new product ID and all of the information I put in. But that last step of flowing through to my Categories.php is not working. Working in the other direction- creating a product manually on the site it appears fine in my database & spreadsheet.

How is EP -> Products -> Categories linked?

Thanks!

You could also try to run the Price Sorter...

You didn't mix products and categories did you? THAT will definitely mess things up. How many TOTAL products do you have in your store? Best I can suggest is that you do a full export via EP and either post it here, or send me a PM with a link and I'll take a look at your data.

You could also do a "reload" ... BACKUP -> Export all products via EP -> Delete all Categories & Products -> Optimize DB (from Under Tools) -> Reload All Products via EP.

Make sure you are not Mixing Products and Categories. This can really mess things up, and I don't think 1.2.5.4 dealt with it well.

[hitz310]

You could also try to run the Price Sorter...

You didn't mix products and categories did you? THAT will definitely mess things up. How many TOTAL products do you have in your store? Best I can suggest is that you do a full export via EP and either post it here, or send me a PM with a link and I'll take a look at your data.

You could also do a "reload" ... BACKUP -> Export all products via EP -> Delete all Categories & Products -> Optimize DB (from Under Tools) -> Reload All Products via EP.

Make sure you are not Mixing Products and Categories. This can really mess things up, and I don't think 1.2.5.4 dealt with it well.

I did what you suggested above. When I tried to reload all products via EP, what happened was 1. the categories were created just fine, but 2. the categories were empty- none of the products uploaded. But they were just fine in phpMyAdmin products table.

So I uploaded my backup directly via phpMyAdmin and it uploaded fine into my Categories.php. All of the products/categories are there.

So somehow, the link between just EP -> Categories.php seems to be off in my case. Is this action of uploading products defined in "admin/products_to_categories.php"? To my knowledge, I've never touched this file...

Chadderuski, if you don't mind I'll send you my txt file to take a look at.

Thank you SO much for the help!

[chadderuski]

hitz310:

I took a look at your data. I believe that you need to put info in v_products_name_1 and v_products_description_1 ... there is something in the script that is done when handling these columns that zencart needs.

Here's a test for you. Trim your file down to 4 items, assign the name and description. Do your upload. I'll bet this fixes your problem. I discovered that my EP4 also has a bit of a bug in regards to v_products_name_1 and v_products_description_1 not being filled in ... one or the other is required or the script doesn't work correctly.

let me know how that works.

[chadderuski]

hitz310:

I took a look at your data. I believe that you need to put info in v_products_name_1 and v_products_description_1 ... there is something in the script that is done when handling these columns that zencart needs.

Here's a test for you. Trim your file down to 4 items, assign the name and description. Do your upload. I'll bet this fixes your problem. I discovered that my EP4 also has a bit of a bug in regards to v_products_name_1 and v_products_description_1 not being filled in ... one or the other is required or the script doesn't work correctly.

let me know how that works.

LOL. Sorry for the poor english. Not much sleep last night. Someone firebombed a car outside our apartment complex late last night!

It looks like the EP 1.2.5.4 needs the name and description to properly import your data and get things indexed/linked properly. Zencart WILL let you add a product without a name/description, the for now this is probably a must for EP.

[hitz310]

LOL. Sorry for the poor english. Not much sleep last night. Someone firebombed a car outside our apartment complex late last night!

It looks like the EP 1.2.5.4 needs the name and description to properly import your data and get things indexed/linked properly. Zencart WILL let you add a product without a name/description, the for now this is probably a must for EP.

Wow, you're the best. I didn't think it was something as simple as that. I was blinded by the idea that there was something horribly wrong with the code somewhere in my site and I was going nuts!

Just to upload via EP I need to fill in something under Name and Description. After that I can delete the added text on the site and re-download my txt file and I can make changes to the product via EP just fine!

Thank you thank you!!

[Serious]

ZC v1.39

I've got a really head scratcher for you folks.

I've been saving my works regularly while editing product data so my info isn't getting lost but the format is a mess.

Example:
I need to enter a lengthy description in v_products_description_1 so I make the entire column wider. (either manually or using the Format Cells pull-down).

After entering all of the info I save the document, upload to my site and close the workbook.

When I reopen the workbook to add more products the cells have all reverted back to their former narrow state and my data is now a jumbled mess.

So how do I keep my cells wide enough on the EasyPopulate spread sheets?

[DivaVocals]

If the file format is CSV, the short answer is you can't using Excel or Open Office. Neither of these programs retain columns widths in CSV files.. (they only display them when you have the file open)

ZC v1.39

I've got a really head scratcher for you folks.

I've been saving my works regularly while editing product data so my info isn't getting lost but the format is a mess.

Example:
I need to enter a lengthy description in v_products_description_1 so I make the entire column wider. (either manually or using the Format Cells pull-down).

After entering all of the info I save the document, upload to my site and close the workbook.

When I reopen the workbook to add more products the cells have all reverted back to their former narrow state and my data is now a jumbled mess.

So how do I keep my cells wide enough on the EasyPopulate spread sheets?

[Serious]

Excel Tab Delimited file.

[chadderuski]

ZC v1.39

I've got a really head scratcher for you folks.

I've been saving my works regularly while editing product data so my info isn't getting lost but the format is a mess.

Example:
I need to enter a lengthy description in v_products_description_1 so I make the entire column wider. (either manually or using the Format Cells pull-down).

After entering all of the info I save the document, upload to my site and close the workbook.

When I reopen the workbook to add more products the cells have all reverted back to their former narrow state and my data is now a jumbled mess.

So how do I keep my cells wide enough on the EasyPopulate spread sheets?

Serious,
If you need descriptions longer than 255 character, then you will need to use OpenOffice to edit and save your tab-delimited files. Excel will truncate to 255 characters.
Also, the column width is a feature of excel/OO, and not CSV or tab-delimited TXT files. Each time you open or edit them you will have to adjust column width.

[Serious]

Sigh......

Guess I need to learn how to use OO now.


I hate my life.....