Easy Populate 1.2.5.4 support

[webguygary]

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

Dave

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.

[dynamica]

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.

[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

[dustyshoes]

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.

[Press Play Music]

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 ?

[webguygary]

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?

[webguygary]

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 ?

[dustyshoes]

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.

[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