Jump to content


  • Posts

  • Joined

  • Last visited

Posts posted by traylor23

  1. I’ll let you know how it goes on my end. So, yes, instead of empty, it was posting 0, making it impossible to add to cart. As you stated, I can manually type a 1 in that field, if I choose, but it’s just another step that interferes with a routine. I appreciate your help, as we all do!

  2. Having an issue with this also, where the minimum_quantity column is not being autofilled at 1, but rather, is taking the 0 for being left blank. This is for all new items added to the store as of the last update. I have since gone back and edited phpmyadmin for those columns to behave correctly, but I'd rather it be automatic, rather than something I have to manually do!

  3. Yep. Already thought of this. The backup for my hosting happened on 11/12, and there have been hundreds of categories and products added/removed since then, and no backup within cubecart. Oh well. Tedious lesson learned. I really appreciate your help, as always. After I get these cats reassigned, I will need to revisit this, as I'm having the same KEY/PRIMARY database errors that led me to this thread. 

  4. That is correct. What happened is, that I was trying to fix an error that was listed here, went to the Structured column under Cubecart_category, and hit DROP. It was a mistake. I didn't catch it before it was gone. And, now, it appears I'm going to have to manually reassign all of these categories. If there's another way, that'd be awesome!

    Reggie Jackson should be under the following Category Tree:

    All Baseball Cards --> Last Names - J --> Jackson, Reggie

  5. I have no clue what I'm doing. When I drop in the code into the SQL section of Cubecart, it tells me that 1 line was affected, but it makes no changes that I can see to the database table. This thing has literally unassociated every category from it's parent category. This happened under the structure tab in phpMyAdmin

  6. 8 hours ago, Dirty Butter said:

    It may b too late now to be of any use to you, but I mentioned this thread to Daren of SFWS, and here's his reply concerning his Search plugin:

    Utilize the custom search field introduced via the AJAX Search plugin to specify the product codes from the options matrix.

    Configure the plugin to only search that field, matching all keywords.


    He suggested another alternative would be to alter the standard search so it looks at the 'product_code' field in the 'CubeCart_option_matrix' table directly.



    That mod looks like it would do exactly what I want it to do. I'm still playing with Brian's edits in a cloned store. Not having any trouble, just haven't had time to mess with it. If that doesn't appear to be a solution, this might.  Thanks for sharing!

    7 hours ago, bsandall said:

    I'm not sure why your category SEO paths are all set to custom=1 (perhaps they are indeed custom paths?), but the naming / display issue for custom paths is a result of this change - I have submitted a fix.

    This worked perfectly, by the way. Thanks!

  7. All cool stuff, and I really appreciate the help. Trying to implement Brian's Custom Search edits, but I have run into an annoyance, at least on the admin side of things, that's different since upgrading to v6.1.3.  Basically, any category that I created, and used a custom seo url for, is now showing up in my add a product pages, where you would select a category, differently than they ever have before, making finding the categories difficult.  Well, I was able to track this back to the database and see that all of these new cats were assigned a custom tag of 1, and when I made all of them 0 again, everything was back to normal. Every time I add a new category, I have to go clear this 1 designation for it to look correct and be in the right order.  I have included a couple of pictures to demonstrate what I'm talking about. Does anyone know of a way I can stop the new categories from gaining this 1 designation?  Also, if I forgo using the Custom URL and then update it later, the update causes the 1 to be designated.




  8. 1 hour ago, Dirty Butter said:

    I was making an assumption that multiple team names could be input on each of the other Codes lines, but only show if there were more than one team on that particular card. Of course I have no idea how complicated that would make Search!

    Since I don't foresee this being a clickable, aggregate linking mechanism, I could just add the 2nd/3rd team to the same field, i.e. Chicago Cubs - Atlanta Braves 

  9. 2 hours ago, Dirty Butter said:

    I just used upc as an example as it was first in the list in admin. We don't have to provide a upc code, because everything we sell is used. But don't you provide UPC codes?

    Don't make the change to Team in definitions.xml. Your change will be lost on upgrade. Find the Language section in admin, click on your flag, and look in Category. You can change it there and it will survive upgrading.

    Ahh...good point. I'll edit there as well.  I actually don't use UPC codes because baseball cards aren't sold individually at the retail store level.

    30 minutes ago, bsmither said:

    Would you be willing to experiment using my project?

    The project makes a change to the content.search.php (Advanced Search) template, and uses two code snippets. And possibly a minor change to the Category class file if necessary enhancements didn't make it into CC612.

    Of course I would, Brian! Just let me know!

  10. 4 minutes ago, Dirty Butter said:

    MY code to show upc is different than what I suggested to you, as Foundation is coded differently than Kurouto. So you still need to test it with your Kurouto skin.

    It worked fine as far as that side of things. Here is a screenshot after I changed the definitions.xml to reflect the new term.


  11. 50 minutes ago, bsandall said:

    Allowing multiple teams for a single product is a more complicated question.

    If you just want to allow users to search for said products using either of those team names, all you have to do is include them in the product description.

    If you want to allow admins to filter products by those team names via the admin search bar, you're going to have to modify the search code to either:

    • Include the product description in the search (assuming you added the team names to the description)
    • OR include the manufacturer(s) column in the search

    Choosing the second option introduces further complications, as by default CubeCart only supports one manufacturer per product; you'd probably need to make an additional table for the product:manufacturer associations in a one-to-many relationship, and then query that in your search as well as modify the admin product interface to allow setting multiple manufacturers.

    If you are or have at your disposal a competent developer, the latter changes could be made in perhaps a few hours, more or less depending on how complicated it actually turns out to be.


    22 minutes ago, bsandall said:

    By that do you mean add an additional column that has all the properties (e.g. searchability) of the original Product Code field? Sure, that's possible, but it boils down to the same amount of work as I was describing above - you still need to add the column, ability to edit it in the admin product panel, and modify all of the search code to include it.

    Besides, how will adding that one additional column help your requirement for multiple team associations?

    In other words, sure you can do it, but it will be just as much work as and less effective than creating a table for multiple associations.

    Yes....Does the "It works in my mind" reason become a sound theory?

    6 minutes ago, Dirty Butter said:

    Getting the additional Codes to show on the store front shouldn't be too difficult. What skin do you use? What version CC are you on?

    Kurouto and 6.1.12

  12. 2 hours ago, Dirty Butter said:

    Do you already make use of ALL the Miscellaneous Codes on the Product listing? It seems like it should be possible to use one of those, rename it, and edit the storefront code to display it where you want it.

    I did try that, but they do not show up on my product pages. Is there a way to make those codes display there. Renaming one of those, and having it show up would be the easier route, I think. Good suggestion!

    7 minutes ago, bsmither said:

    I am approaching this as wanting to associate a category to the product, then showing the category name.

    I have to ask, How many team names will be needed? Will this get out of hand?

    Discerning the name of the category would be easy enough. That is, if an item has a main category and also three associated categories, there would be the need to pick which associated category is to be displayed. (Answer: team categories would have it's parent category named "Team Name".)

    You would then end up with a spot in the Category Navigation menu for "Team Name" (there's your link).

    I'd rather not do it relative to another category. I've though of that, and I didn't like the process all that much (multiple categories for every item).  As far as number of teams, it would literally be ALL professional sports teams, so probably > 120.

  13. Hey Brian,

      Basically what I am trying to do is to have a field in my admin, when I'm adding a product, similar to the product code box, where I can input a team name, and it show up underneath the product code on the storefront side on the product pages, like this:

    Product Code: 89UDKGJ1RC

    Team Name: Seattle Mariners

    Also, it'd be nice if either the team name was a hyperlink to an aggregate page of every item under that team name, or searchable so that I could make one myself.




  14. Hey All,

       I have a baseball card site, ballcardz.com, and I'd like to add a searchable field in the admin, similar to the Product Code field, that I could enter a team name into, and it would show up in the product description right below the product code text. Anyone know what I need to do to accomplish this? Is there a 3rd party solution? I have searched as hard as I could before asking. Thanks in advance!

  • Create New...