Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Extra Fields


frafac

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

Link to comment
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 ======>>>>>.

Link to comment
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 ======>>>>>.

Link to comment
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.

Link to comment
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

Link to comment
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.

Link to comment
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%?

Link to comment
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 ======>>>>>.

Link to comment
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?

Link to comment
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 ======>>>>>.

Link to comment
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 ======>>>>>.

Link to comment
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.

Link to comment
Share on other sites

  • 1 month later...

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...