I have been looking for a way to add a field to my items.
Our store isn't used for just selling, but it's also going to be our inventory as well, so we want to list which distributor the products come from.
I've been looking over Easy Populate's method of using an Extra Field, but it's extremely complicated with so many different versions I have a headache.
I do have Easy Populate, and I'd love to get it to work but I can not find a tutorial on how to do it, that's actually understandable (Grammar / spelling wise)
For example, I turned on the "Extra products" support with Easy Populate, but when I click the new link I get:
1146 - Table 'max_ca.TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS' doesn't exist
SELECT p.products_id as v_products_id, p.products_model as v_products_model, subc.products_extra_fields_id as v_products_extra_fields_id, subc.products_extra_fields_value as v_products_extra_fields_value, ptoc.products_extra_fields_name as v_products_extra_fields_name FROM products as p, TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS as subc, TABLE_PRODUCTS_EXTRA_FIELDS as ptoc WHERE p.products_id = subc.products_id AND ptoc.products_extra_fields_id = subc.products_extra_fields_id
[TEP STOP]
So, basically I'm asking if anyone knows the best way to get an extra field with the products.
Thank-you.
[My settings:
EP vers: 2.76h-MS2
osCommerce Online Merchant v2.2 RC2a
OS: Linux 2.6.21.5
HTTP: Apache/1.3.29 (Unix) PHP/4.4.9 mod_gzip/1.3.19.1a FrontPage/5.0.2.2635 mod_ssl/2.8.16 OpenSSL/0.9.7c
DB: MySQL 4.1.22-log
PHP: 4.4.9 (Zend: 1.3.0)
Temp Directory:
/hdd/2/home/ca/maxelectronics.ca/temp/
Temp Dir is Writable
Magic Quotes is: off
register_globals is: on
Split files on: 300 records
Model Num Size: 24
Price with tax: true
Calc Precision: 2
Replace quotes: false
Field seperator: comma
Excel safe output: true
Preserve tab/cr/lf: false
Category depth: 7
Enable attributes: true
SEF Froogle URLS: false
More Pics: false
Unknown Pics: false
HTC: false
SPPC: false
Extra Fields: true]