Jump to content
Sign in to follow this  
frafac

Products Extra Fields

Recommended Posts

Hi all,

 

I've just installed "product extra fields" contribution on my fresh installation of oscommerce 2.2...but I have a problem... in admin panel I can add new fields... but I cannot insert fields value in the add product page... and naturally I can see nothing in diplay product page.

 

my osc is 2.2rc2a and the contribution is extra_fields_v2_0i.zip, available in http://addons.oscommerce.com/info/2202

 

Any ideas will be appreciates...

 

Regards

 

Francesco

Share this post


Link to post
Share on other sites

Have you defined the extra product field using

 

Product Maintenance >> Product Extra Fields

 

in your admin area?

 

If you have check you have updated admin/categories.php as per the installation instructions


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Your contrib installation is incomplete.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

Read the installation instructions and follow all of them


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

logic:

when You add product fields thru admin then these details go in data base.

 

Now a code uses this detail and creates additional field related boxes in admin product cretae page.

 

Also the details for these products then are used in user side to display.

 

So see that all steps are taken care.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

I forgot some code in categories.php.. and now when I create a new product I can finally see the field I created... and Insert it...

But I have now another problem.. in the product_info.php..

when I see product info page I cannot see field I created... so I change product_info.php with that in the contribution...and than I0ve this error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languag' at line 5

 

SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value ,pef.products_extra_fields_status as status FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id= and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order

 

What's wrong?

 

Thanks in advance...

 

 

logic:

when You add product fields thru admin then these details go in data base.

 

Now a code uses this detail and creates additional field related boxes in admin product cretae page.

 

Also the details for these products then are used in user side to display.

 

So see that all steps are taken care.

 

Satish

Share this post


Link to post
Share on other sites

ptf.products_extra_fields_value<>''

 

<> should not be a blank.

You need to analyse Your code.

It appears You added some additioal code not following exactly what the contribution wants.

 

saSatish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites
ptf.products_extra_fields_value<>''

 

<> should not be a blank.

You need to analyse Your code.

It appears You added some additioal code not following exactly what the contribution wants.

 

saSatish

 

Thanks for your patience... now I replace the file... and no error become... but I cannot see in product info page the fields I added..

can you tell me a contrib that is ok 100%?

Share this post


Link to post
Share on other sites

product extra fields

 

The problem occurs when you do not follow all the instructions exactly.

 

I have installed it and it works fine.

 

Have another go and follow the instructions very carefully


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites
Thanks for your patience... now I replace the file... and no error become... but I cannot see in product info page the fields I added..

can you tell me a contrib that is ok 100%?

 

Now I istalled "bug fix of bugfix from majidmx" and I can see extra fields in product page...

but.. laste question :)

 

I want to see extra fields below product name... but I see instead product name below extra fields... :(

 

Any ideas?

Share this post


Link to post
Share on other sites

Move the code you installed in product_info.php to wherever you want it.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites
Move the code you installed in product_info.php to wherever you want it.

 

Ok..

 

do you know if I can put a photo as value of one field?

Share this post


Link to post
Share on other sites

Extra fields is used to display additional data about the product.

 

If you want to display images you will need a different contribution or to do some coding.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

The contribution is ok.

You are not placing the code as needed.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

I have successful installed the contribution but the "Product Listing" does not display the Product Name instead it display only the product extra field. Is this a norm or do i have to enable the product name display?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×