Products table dosnt have a column to store product cost?

[jodean]

The products table doesn't have a field to store the product cost.

Is it safe to use the product products_price_w table column to store product cost?

[lat9]

The products table doesn't have a field to store the product cost.

Is it safe to use the product products_price_w table column to store product cost?

it is not; that's a text field where the wholesale price bands are stored. You'll need custom code to (a) add that field and (b) enable its update when editing/adding a product in the admin.

[swguy]

... and adds it to any reports you use, such as Sales Report.

Info on adding a field like cost to the products table:

https://docs.zen-cart.com/dev/code/add_field_products/

[jimmie]

get numinix product fields and you can add that field in, plus any other you need

[dbltoe]

I haven't been able to get Numinix working with 2.1.0, much less 2.2.0a. It states 1.5.8 as the latest compatibility.

[barco57]

I haven't been able to get Numinix working with 2.1.0, much less 2.2.0a. It states 1.5.8 as the latest compatibility.

They supposed to be working on it...

[jimmie]

im running 2.10 havent tried it in a while but it is how i set up some of my fields

[dbltoe]

They supposed to be working on it...

May have to slow their marketing program down to have time.

[barco57]

I got an email this morning - "There's an update for Numinix Product Fields"

[dbltoe]

The only difference between 3.16 and 3.1.7 is the addition of two install.sql files to the catalog directory.

catalog\YOUR_ADMIN\includes\npf_includes\prebuilt_fields\exclude_from_google_fee d\install.sql

ALTER TABLE products ADD exclude_from_google_feed int(1) NULL default 0;

and

catalog\YOUR_ADMIN\includes\npf_includes\prebuilt_fields\products_date_added\ins tall.sql

ALTER TABLE products ADD products_date_added DATETIME DEFAULT CURRENT_TIMESTAMP;

And, the site still says it's for 1.5.8