1054 Unknown column 'p.product_price_w' in 'field list'

Don't worry about the "p." prefix. That's just an alias to avoid having to write out "products." as the table name.

The thing to be concerned about is the difference between "product**s**_price_w" and "product_price_w".
Looks like sloppy coding in the addon.

The product "preview" page in the admin is handled by the files under /admin/includes/modules/ folder. Whichever files were in that folder in the addon you installed are likely the offending ones.

in the amin/includes/modules i have 3 instances. one in the page
product/collect_info.php

if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
p.products_id, p.products_quantity, p.products_model,
p.products_image, p.products_price, p.products_price_w, p.products_virtual, p.products_weight,
p.products_date_added, p.products_last_modified,
date_format(p.products_date_available, '%Y-%m-%d') as
products_date_available, p.products_status, p.products_tax_class_id,
p.manufacturers_id,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed,
p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
p.products_sort_order,
p.products_discount_type, p.products_discount_type_from,
p.products_price_sorter, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = '" . (int)$_GET['pID'] . "'
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

and 2 instances in category/product_listing.php

$products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_price_w, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id,
p.products_model,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
p.products_quantity_order_max, p.products_sort_order,
p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and (p.products_id = p2c.products_id
and p.master_categories_id = p2c.categories_id)
and (
pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
or p.products_id = '" . zen_db_input($_GET['search']) . "'
or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
$order_by);

$products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_price_w, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p.products_model,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
p.products_quantity_order_max, p.products_sort_order
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = p2c.products_id
and p2c.categories_id = '" . (int)$current_category_id . "'" .
$order_by);

i hope this is helpful

In the Tools ... Developers Tool Kit ... do a search in the bottom input box on:
product_price_w

Select Catalog/Admin and click search ...

How many files use it?

Next, do a search on:
products_price_w

How many files use it?

All files should be using the one method of spelling the fields name ...

I am thinking that the spelling:
products_price_w

is the correct one and where you see:
product_price_w

are errors and need to be corrected ...

thank you... that actually did it. you have been right. there where over 900 for "products" and only ONE for product.
for all that have the same issue. you need to go to
admin/includes/modules/product/preview_info.php around line 19

p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual,

and change that to

p.products_model, p.products_image, p.products_price, p.products_price_w, p.products_virtual,

that solved, off to the next issue :) YAYYYY:frusty:

I am so grateful to all of you helping here and spending time to make this cart what it is...

Thanks for the update and for posting what the solution was that you discovered to fix this ... :smile: