RAJEEV K TOMY

Music | Magento | Malayalee

Magento 1: Attention! Keep All of Your Select Attributes as INT

Yes, You heard it right. It is better to be keep all backend types of your select attributes in INT type. This is so important because that will avoid lot of headaches in future. If you want to know more details, please keep on reading.

Possible Issues if we keep select attributes backend type other than INT

  • Suppose you have a select attribute which backend type is varchar. Everything is fine. You can assign this attribute to an attribute set and all products are saving all it’s values as we need. Now you came to a situation in which you want to update this attribute via backend. Of course, you can do this via admin side, Catalog > Attributes > Manage Attributes > [Select Your Attribute] > [Do all changes] > SAVE. Bingo attribute is updated, but if you check your database an important hack is done without your knowledge which is backend type of your attribute is now INT and not VARCHAR. This is definitely going to make problems in future.

Why Magento changes backend type of attribute while save via backend. I really don’t know and I feel it’s as serious bug.

  • Suppose you have a configurable product attribute which backend type is varchar. You did a massive product import to your system. Now configurable product won’t show in category and even in search page. There is no problem with other simple products which uses same attribute, but configurable product won’t show in the assigned category pages. I don’t know the real reason behind this. But most probably this is an indexing issue. Instead if all of your configurable attributes are using backend type as INT, then there is no problem at all.

Solution For this Problem

Please keep all of your select attributes backend model as INT. I am sure you will thank me for this tip later 🙂

Prev post Magento 1: Most Important Things While You Merge Js
Next post Magento 1: Get Final Price of Configurable Associated Product

Rajeev K Tomy

Related Posts

3,812 thoughts on “Magento 1: Attention! Keep All of Your Select Attributes as INT”

  144. Everything about medicine. Everything information about medication.
    cure ed
    Read now. Comprehensive side effect and adverse reaction information.

    Reply

  225. Do you mind if I quote a couple of your articles as long asI provide credit and sources back to your website?My blog site is in the very same niche as yours and my users would certainly benefit from some of the information you present here.Please let me know if this okay with you. Thanks!

    Reply

  229. Reading your article helped me a lot and I agree with you. But I still have some doubts, can you clarify for me? I’ll keep an eye out for your answers.

    Reply

  250. Genuinely no matter if someone doesn’t know then its up to other users that they will help, so here it occurs. “오피스북” I so much undoubtedly will make sure to do not overlook this web site and provides it a glance regularly.

    Reply

  270. Hello, Neat post. There’s a problem with your web site in internet explorer, might check this?
    IE still is the market leader and a large part
    of folks will pass over your magnificent writing because of this problem.

    Reply

  274. It¦s actually a great and useful piece of information. I am satisfied that you shared this helpful info with us. Please stay us informed like this. Thank you for sharing.

    Reply

  326. Does your site have a contact page? I’m having
    a tough time locating it but, I’d like to send you an e-mail.
    I’ve got some ideas for your blog you might be interested in hearing.

    Either way, great site and I look forward to seeing it develop over time.

    Reply

  336. An interesting discussion is definitely worth comment.
    There’s no doubt that that you ought to publish more on this subject, it may not be a taboo matter but generally
    folks don’t talk about these issues. To the next! All the best!!

    Reply

  343. I’m extremely impressed with your writing skills as well as with the layout on your blog.
    Is this a paid theme or did you customize it yourself? Anyway keep up the excellent quality writing,
    it is rare to see a nice blog like this one these days.

    Reply

  421. I’m always looking for web sites that sell real bags. I’ve purchased several bags over the last year. or perhaps a the bags are always perfect, the shipping time is very prompt, and the communication is excellent. including the I highly recommend this site to anyone who’s looking for real bags. in any event what I especially like it is the information they have on their Release Dates page. This really helps me stay in tune with what’s going on in the world of bags.
    https://www.louisvuittonsoutlet.com https://www.louisvuittonsoutlet.com/

    Reply

  446. I received my jordans yesterday. This is the first time ordering shoes from this website and I am definitely satisfied with them. or sometimes I would give this website a 20 on a scale from 1-10 and would certainly recommend this site to all. such I will definitely be purchasing more items in the future. regardless It has been a pleasure.
    cheap retro jordans https://www.cheapjordanssneakers.com/

    Reply

  450. I received my jordans yesterday. This is the first time ordering shoes from this website and I am definitely satisfied with them. in addition I would give this website a 20 on a scale from 1-10 and would certainly recommend this site to all. choose to I will definitely be purchasing more items in the future. you ultimately choose It has been a pleasure.
    http://www.cheapauthenticjordans.com https://www.cheapauthenticjordans.com/

    Reply

  451. I received my jordans yesterday. This is the first time ordering shoes from this website and I am definitely satisfied with them. or even a I would give this website a 20 on a scale from 1-10 and would certainly recommend this site to all. exactly like the I will definitely be purchasing more items in the future. regardless It has been a pleasure.
    cheap jordans https://www.bestretro-jordans.com/

    Reply

  453. I received my jordans yesterday. This is the first time ordering shoes from this website and I am definitely satisfied with them. to I would give this website a 20 on a scale from 1-10 and would certainly recommend this site to all. most notably the I will definitely be purchasing more items in the future. anyway It has been a pleasure.
    cheap jordans for men https://www.cheapretrojordan.com/

    Reply
  454. Pingback: seo services los angeles inc

  461. Also Check : 18 Outfits for Women Over 60- Fashion Tips For 60 Plus Women Whether you’re heading back into the office after a post-pandemic hiatus, are just starting your professional career, or are just looking for a wardrobe revamp, this collection of Amazon work clothes is for you. We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information. This does not include trusted third parties who assist us in operating our website, conducting our business, or servicing you, so long as those parties agree to keep this information confidential. We may also release your information when we believe release is appropriate to comply with the law, enforce our site policies, or protect ours or others rights, property, or safety. However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.
    https://wiki-burner.win/index.php?title=New_pakistani_dresses_for_eid
    This sophisticated plum cocktail dress epitomizes evening chic with a sparkling sequined cape that drapes elegantly to one side. There seems to be a problem serving the request at this time The “Dolly Girl” was another archetype for young females in the 1960s. She emerged in the mid-1960s, and her defining characteristic is the iconic miniskirt. “Dolly Girls” also sported long hair, slightly teased, of course, and childish-looking clothing. Clothes were worn tight fitting, sometimes even purchased from a children’s section. Dresses were often embellished with lace, ribbons, and other frills; the look was topped off with light colored tights. Crocheted clothing also took off within this specific style. Chic Coverups to Wear With Your Maillot

    Reply