Easy Populate 1.2.5.4 support

[Tanith]

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.

[sunriseimports]

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

[RalphSmith]

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?

[eranariel]

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

[hitz310]

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

[hitz310]

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!

[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?

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

[chadderuski]

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.

[hitz310]

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!