Hi. I uploaded by FTP my test cart developed on my WAMP server for Zen Cart version 1.3.9f. Easy Populate 1.2.5.4 was in the cart, and some test products were in the cart. However, the products disappeared, and when I first tried to use Easy Populate to import products, it prompted me to install. I pressed the install link it offered and a message stated it installed successfully.

I tried to import products but was unsuccessful. However, after a period of time, the product categories showed up in my Zen Cart online, but with no products. At time of the failed install, Easy Populate had stated:

New Product Failed. SQL error. Check Easy Populate error log in uploads directory.
First, after checking for hours for the location of the uploads directory and what it actually meant to check that directory, I found that under Admin>Configuration>Easy Populate, there is a menu that names the Uploads Directory as "temp"; the admin screen gave the option to edit the name of the uploads directory.

I went to my online temp directory by going by FTP to my www/temp directory, and downloading the file called "ep_debug_log.txt" to my computer and opening the file in my wordprocessing program.

Now, I have the following error message repeated for days and days of uploads:

[QUOTE]
MySQL error 1054: Unknown column 'p.products_UPS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_UPS as v_products_UPC,
p.products_ISBN as v_products_ISBN,
p.products_weight as v_products_weight,
p.products_date_added as v_date_added,
p.products_date_available as v_date_avail,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id
FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
p.products_model = 'CDASK101' AND
ptoc.categories_id = subc.categories_id
</QUOTE>

There is one of these messages for each of the 6 products in my test upload, with the second to last line changing for the product number for each product.

The heading on my spreadsheet correctly states v_products_UPC, not UPS.

1. Where could this "UPS" be coming from?

2. In trying to make Easy Populate work, I installed the .sql patch for Easy Populate, and it created a duplicate "Easy Populate" in my Admin>Configuration>list, although it then recognized it would be a duplicate entry and stopped itself from installing.

How may I remove the empty Easy Populate listing in Configuration? I find no extra line in the configuration table in PHPMyAdmin to delete.

3. Thank you to Dr. Byte who pointed out to someone in this forum the $ in the price column, which keeps reappearing in my tables. Also, thanks to Dr. Byte for pointing out that the numerals 0, 1, and 9 are used for inactive, active, and delete status. I find my product source uses the word Active, and am changing that as a precaution for making Easy Populate work, although it worked in my test server.

Notageek