Easy Populate 1.2.5.4 support

I managed to upload a bunch of prices in the v_specials_price field that I didn't actually want to keep there. I've successfully altered that column to a zero value and re-uploaded the file, but there does not appear to be a way for EasyPopulate to upload a null field and erase a value already in the database to be replaced with no entry. I don't want ANY values in this field. What do I enter into this field to overwrite what is in the database with a blank entry?

Help please. My cart has all these red lines through it, and it's a hassle. I have 2,000 products so removing the "specials" price manually from each one isn't happening.

Thanks!

Okay, solved. I formatted the column as a number with two decimal places, and then it worked. Didn't think that would have been relevant in a tab-delimited text file.

thank you for your help . I change 60 instead of 30 it is works now .

I have been using Easy Populate to load prices to 2 decimal places with no problems.
I have now started uploading prices to 4 decimal places successfully.
My problem is that when I download the products using EP, the created file rounds the price off to 2 decimal places.
eg upload price as 0.3043.
Check price in ZenCart Catalog and it shows 0.3043
Download list using EP and it is shown as 0.3
Can this be overcome to download as whatever price is stored?

glad to hear that it is working... how is your utf-8 encoding working?
I have had problems with it in the past....

I added the 'product_sort_order' field to my easy populate v1.2.5.4. It works fine on existing products. But I tried the 'dipstick' test where I removed products and then tried re-adding them.

I'm getting the MySQL error 1136. I noticed my debug log says:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (

					products_image,

					products_model,

					products_price,

					products_status,

					products_last_modified,

					products_date_added,

					products_date_available,

					products_tax_class_id,

					products_weight,

					products_quantity,

					master_categories_id,

					manufacturers_id)

However I already updated my easypopulate.php to include 'products_sort_order'. It still doesn't seem to work though. I believe this is what is causing my Error, because it's not counting my sort_order column while updating new products.

(In my easypopulate.php)
$query = "INSERT INTO ".TABLE_PRODUCTS." (
products_image,
products_model,
products_price,
products_sort_order,<-------
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)

Thanks for the help!!

Please scratch the above post.

Below that 'Insert Into Table Products' code, the Values were out of order.

Still getting used to looking at code! :D

I manually entered test products (by copying and pasting existing orders with new model numbers) and uploaded via EasyPopulate v1.2.5.4.

The test product shows in phpmyAdmin under the products table, but it doesn't flow through to my Catalogue- Catagories/Products on the site.

I uninstalled and reinstalled EP, but the same issue occurs. What could be causing this?

hitz310:

I manually entered test products (by copying and pasting existing orders with new model numbers) and uploaded via EasyPopulate v1.2.5.4.

The test product shows in phpmyAdmin under the products table, but it doesn't flow through to my Catalogue- Catagories/Products on the site.

I uninstalled and reinstalled EP, but the same issue occurs. What could be causing this?

Please anyone? This issue has been stressing me out to no end. I've read almost every page of this thread. I've tried other versions of EP and reinstalled EP a few times.

What would cause EP to upload to the Products table in PHPMyAdmin but NOT Categories.php on the site? If it's in PHPMyAdmin database, shouldn't it show on my site?

So confused...

hitz310:

Please anyone? This issue has been stressing me out to no end. I've read almost every page of this thread. I've tried other versions of EP and reinstalled EP a few times.
What would cause EP to upload to the Products table in PHPMyAdmin but NOT Categories.php on the site? If it's in PHPMyAdmin database, shouldn't it show on my site?

Hitz,

Have you tried to "Reset ALL Products Master Categories ID" under Tools -> Store Manager?

Also, have you installed Dr. Bytes MySQL Backup? If you use the backup mod, you can backup/restore all your data quite easily. This will save you a lot of grief should you ever have an EP update fail or mess something up, your you make some other mistake.

Also, Read Schoolboy's wiki on EP. He put a lot of effort into that and it is quite helpful.

chadderuski:

Hitz,

Have you tried to "Reset ALL Products Master Categories ID" under Tools -> Store Manager?

Also, have you installed Dr. Bytes MySQL Backup? If you use the backup mod, you can backup/restore all your data quite easily. This will save you a lot of grief should you ever have an EP update fail or mess something up, your you make some other mistake.

Also, Read Schoolboy's wiki on EP. He put a lot of effort into that and it is quite helpful.

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!

hitz310:

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.

chadderuski:

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!

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.

chadderuski:

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

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?

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)

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?

Excel Tab Delimited file.

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?

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.