Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Extra Fields not displaying on existing products


Recommended Posts

I installed the products extra fields add-on (https://apps.oscommerce.com/wFnge) and it works great for new products and search, but on existing products I cannot get the custom field to display.  It's skipping over it and not displaying it. In the first screenshot you can see where it shows the UPC (it should display below weight but I moved it up intentionally just in case it was a CSS issue).  In the second screenshot, that product has a UPC (I manually entered it) and can search for it, but it doesn't prompt for the field.

Screen Shot 2019-05-04 at 12.24.43 PM.png

Screen Shot 2019-05-04 at 12.25.04 PM.png

Link to comment
Share on other sites

20 hours ago, duckydan said:

it should display below weight but I moved it up intentionally just in case it was a CSS issue)

Silly question but have you made sure both products are in the same category? I think I remember that to use this you have to assign a category id to the new fields.

 

Link to comment
Share on other sites

Sorry I didn't reply sooner... I never received a notification I received a reply and just logged in today to bump this :(

So I did not know I had to add them to a category and thought I could leave category blank and it would be universal... we have several hundred "categories" based on how the store is laid out.  Is there a way to make it global?

Link to comment
Share on other sites

Son of a... thanks for the help all.  I read the SQL and apparently there is a hidden command you can use called "all"

pef
                        WHERE category_id like '% " . $current_category_id .  ",%' 
                        OR category_id=" . $current_category_id . "  
                        OR category_id='all'
                        OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id = " . $current_category_id . ") 

I changed category to "all" and it worked

 

Edited by duckydan
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...