Easy Populate 1.2.5.4 support

Help I just installed dual pricing and now my easy populate comes up with this error
Fatal error: Call to a member function on a non-object in /home/luke/public_html/1310/includes/functions/extra_functions/easypopulate_functions.php on line **587

I hope one of you zen cart pros out there will be able to help**

Ok I"ve installed easy populate on my cart I've found easy populate under my Admin/tool. But I get these error.

Warning: dir(/home/mdr/public_html/test/temp/) [function.dir]: failed to open dir: No such file or directory in /home/mdr/public_html/test/admin/easypopulate.php on line 695

Fatal error: Call to a member function on a non-object in /home/mdr/public_html/test/admin/easypopulate.php on line 697

Also where do you get the excel file to load your stuff?

Dave:D

daver1510:

Also where do you get the excel file to load your stuff?

Dave:D

Dave - the way I did it was to use the feature called "Download Complete tab-delimited .txt file to edit". Then I used this as a template to reconfigure my source database ( used Micro$oft Excel). Once I had all the fields properly populated into the template, I used "Upload EP File", found the .txt file I had saved on my hard drive, uploaded it, and all the data was populated into the SQL database.

This worked fine for me until I got to the quantity discount problem I'm currently facing. I need to find a way to invert my pricing data.

I haven't seen anything where the column order has been customized so much. I believe in the last 10 posts or so someone has mentioned that the product number has to come first, and I would not be surprised by that.

The other thing is you need EOREOR (End Of Row/End Of Record) at the end of each product/item. Because a product description could be up to 64K in size (or larger with things set correctly), not that I would suggest including a whole book in the description, EP looks for the EOREOR on the end of a record/row. Adding EOREOR would be the first thing to try. It is kind of like a run-on sentence/paragraph, without the proper indication you don't know when to breath. It helps let the program know when to stop with one item and begin with another.

That seems to have worked, the products are showing up now, but the pictures still don't show up. The product name is displayed twice instead of the picture... you can see the problem here: http://www.doctorsmedicalsupplies.com/catalog/ . Also, I think the prices are not displaying either.

HELP... I have been reding the 107 pages but am confused. I have EP and cant work out how to add new products with this. Can anyone help please ????

this is what i get on the page after inserting file into database

File uploaded.
Temporary filename: /tmp/phpfeCd3y
User filename: EP2007Oct30-1705.txt
Size: 940
| img104.jpg | ALAN JACKS | TRACKLISTI | | 19.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Country | | | | --none-- | 1 | !New Product!

| 1460 | | AUSTRALIAN | | | 9.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Pop / Rock | | | | --none-- | 1 !New Product!

| | | | | | | | | | | | | | | | | | |

No products_id field in record. This line was not imported

Do the products show up in the Catalog?

The problem I am having is that the product appears to upload just fine. The category is created, but the product is empty. Using PHPMyAdmin I find that the products table is empty, products_description and products_to_categories have their data. :unsure:

No the products dont show up at all. i am thinking it is something to do with this.

No products_id field in record. This line was not imported

When i add a new products manually it gives it a number. There is no field in the download that references to this number. i cant get any new products to add in this way ?

dynamica:

The product name is displayed twice instead of the picture

your database entries for the image location on the server are incorrect. each entry should be /listings/13974.jpg, not the complete url. This is because the default location for images is:

http://doctorsmedicalsupplies.com/catalog/images/

Thus, it's adding your complete url again, whereas all you need in each data entry is /listings/13974.jpg.

Does this make sense?

anyway, I'm still trying to solve this issue:

My question is about quantity discounts.

In my source database I have a database field that shows 3 quantity discount prices.

example:

1 or more = .76
3 or more = .46
6 or more = .34

the data entry in my source file for this example appears like this:

0.76:1:0.46:3:0.34:6

am I correct in understanding that these need to be inverted to

1:0.76:3:0.46:6:0.34 ?
if so, what's the easiest way to do this inversion?

I have over 5,000 of these (of varying prices), how do I get them into the SQL database using Easy Populate? Is this the correct format for multiple discounts, and what field do I need to add these to?

Press Play Music:

HELP... I have been reding the 107 pages but am confused. I have EP and cant work out how to add new products with this. Can anyone help please ????

this is what i get on the page after inserting file into database

File uploaded.
Temporary filename: /tmp/phpfeCd3y
User filename: EP2007Oct30-1705.txt
Size: 940
| img104.jpg | ALAN JACKS | TRACKLISTI | | 19.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Country | | | | --none-- | 1 | !New Product!

| 1460 | | AUSTRALIAN | | | 9.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Pop / Rock | | | | --none-- | 1 !New Product!

| | | | | | | | | | | | | | | | | | |

No products_id field in record. This line was not imported

Can anyone help with this or give me some idea who i could contact to help ?

I opened the PHP file and had it print the SQL error message. I do not know the maintainer of EP, or the bug reporting procedure, but this is what I found.

I downloaded easy_populate_from_osc_2.76dmod3a.zip. In catalog/admin/easypopulate.php at line 2203, the INSERT statement's list of database fields does not match the data fields. I added products_priced_by_attribute and all is well.

I do not know what version of EP you have, so I do not know if you are impacted.

When trying to:

Download Complete tab-delimited .txt file to edit (Attributes Not Included)

I get the below error but when I use any of the other links, they work with no problem.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 706

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1074

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1075

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1079

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1083
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_products_cost v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

Please help,

I have uploaded one product via admin and then uploaded 19 products more using EP.

They all show on the store but when you click on any of the pictures, it says "Sorry, the product was not found."

It only works with the one product I have uploaded not using EP.

you can check at https://www.butterflieshome.com/store

Thank you for your reply

cbar126:

Please help,

I have uploaded one product via admin and then uploaded 19 products more using EP.

They all show on the store but when you click on any of the pictures, it says "Sorry, the product was not found."

It only works with the one product I have uploaded not using EP.

you can check at https://www.butterflieshome.com/store

Thank you for your reply

Hi,

I tried to find your other products, but could only see the one. (ie: no other products at all, although strangely, the catagory says "20".

Best practice for Easy Populate is to create a couple of products manually, then download the the full products list. Then, copy the format with your new products and upload them.

With respect to images, I always upload them first, not sure if this is actually required, but that's what I do. I have had plenty of problems, but few with EP.

Good luck! :)

I install Easy Populaten and works fine.

But i need one more field, the "id_product" how can i add this field?

i have a few issues. i guess start at the top:

when i first go to the EP module i have a error banner stating "1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here."

clicking 'here' tells me it failed and i should read the error logs.

when i read the logs, it tells me:

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
8:91627b10f753ee314dbb959b0511ee2c
It is recommended that you delete this corrupted data using phpMyAdmin.

what do i do with this information. i tried searching for that string in phpMyAdmin and drew a blank.

cudaboy71 - known issue search this thread for fix...

Scrat:

cudaboy71 - known issue search this thread for fix...

ooi...the problem may be known. but, the solution is evasive. i've been reading for 1/2 hour and find nothing.

if anyone who makes following this thread a habit cares to throw me a bone, i'd be appreciative.

rge:

When trying to:

Download Complete tab-delimited .txt file to edit (Attributes Not Included)

I get the below error but when I use any of the other links, they work with no problem.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 706

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1074

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1075

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1079

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1083
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_products_cost v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

Does anyone have any info on this problem?

bifficus:

Hi,

I tried to find your other products, but could only see the one. (ie: no other products at all, although strangely, the catagory says "20".

Best practice for Easy Populate is to create a couple of products manually, then download the the full products list. Then, copy the format with your new products and upload them.

With respect to images, I always upload them first, not sure if this is actually required, but that's what I do. I have had plenty of problems, but few with EP.

Good luck! :)

Have you checked the length of the product_name. I found if I exceeded the field length of 64, I would experience similar behaviors for all the products that followed.