Printable View
So I found out a way to add attributes to the SBA data by utilizing the "Add Quantity for product variant" If I enter a number in the quantity for all it will add the attributes for me. I had not noticed that link before and after trying a couple of options it worked. I think this will work just fine for my purpose.
@MC12345678. Can you please send me a link where I can buy you a coffee or lunch for your efforts? Thank you..
So, I went back to review the modification I applied. There was an issue with the query I created, it had an extra semi-colon from when I copied and pasted it from within phpMyAdmin.Quote:
Originally Posted by chuckrey
The issues about the missing constant, well that is something that would be seen with the code in place, visitors navigating the site until the database install was completed. I've made generated a change to the code to prevent logging that issue; however, in a way the fix is unnecessary once the appropriate constant has been set either in a file or the database.
But, the other above issues? I have no idea how the other issues exist in your file. I do not see github history of the problem content like:
1) I don't see what the issue is with the option list, the three options appear to have the same format with just differences in associated/necessary data. So i'm not sure what issue is/was created there.
2) semi-colons as a part of case statements, these specifically are supposed to be colons, there is nothing that I found having semi-colons in that spot.
I have created and force pushed an update for the original issue for the query to do what was requested: Adds all new product/attribute pairs for single attribute not yet in SBA · mc12345678/Stock_By_Attributes_Combined@064350f (github.com)
https://github.com/mc12345678/Stock_...326c26a8192f01
I have just uploaded on a squeaky clean install of V2.0.1 and while there were no error during installation I do get an error when clicking on the All Attribute Stock link.
I am assuming this is the link used access the SBA functions/features.
The link launches a new browser tab as indicated and displays the following error message on the new page "WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."
[31-May-2024 01:53:24 ------] Request URI: /********/index.php?cmd=products_with_attributes_stock, IP address: *******, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /*****/includes/classes/db/mysql/query_factory.php(714): trigger_error()
#2 /*****/includes/classes/db/mysql/query_factory.php(659): queryFactory->show_error()
#3 /*****/includes/classes/db/mysql/query_factory.php(299): queryFactory->set_error()
#4 /*****/products_with_attributes_stock.php(912): queryFactory->Execute()
#5 /*****/index.php(16): require('/******* ..')
--> PHP Fatal error: MySQL error 1146: Table '******.products_with_attributes_stock' doesn't exist :: SELECT DISTINCT pwas.products_id FROM products_with_attributes_stock pwas
LEFT JOIN (SELECT DISTINCT
pa.products_id, pd.products_name
FROM products_attributes pa
LEFT JOIN products_description pd ON (pa.products_id = pd.products_id)
WHERE pd.language_id= 1
ORDER BY pd.products_name) att ON (att.products_id = pwas.products_id)
WHERE
att.products_id IS NULL ==> (as called by) /**********/products_with_attributes_stock.php on line 912 <== in /*******/includes/classes/db/mysql/query_factory.php on line 714.
--> PHP Fatal error: MySQL error 1146: Table '*******.products_with_attributes_stock' doesn't exist :: SELECT DISTINCT pwas.products_id FROM products_with_attributes_stock pwas
LEFT JOIN (SELECT DISTINCT
pa.products_id, pd.products_name
FROM products_attributes pa
LEFT JOIN products_description pd ON (pa.products_id = pd.products_id)
WHERE pd.language_id= 1
ORDER BY pd.products_name) att ON (att.products_id = pwas.products_id)
WHERE
att.products_id IS NULL ==> (as called by) *******/products_with_attributes_stock.php on line 912 <== in /******/includes/classes/db/mysql/query_factory.php on line 714.
(Directories and original ZC DB tables are correct but have been ****** out.)
Issue resolved: SBA links and screens were added once I manually ran the SBA install script from the browser address bar. Sorry to be a bother. :)
No problem at all. Would help if I had a central set of instructions to at least get through the start of things. Glad you worked it out though. While the time between posts was only 15 minutes, I hope you didn't lose too much up to that point.Quote:
Originally Posted by webmanstudios
Has anyone had any luck with styling the drop down "Qty" and "Custom Id's"? Been searching w/ no luck. Using 1.5.8 Responsive Classic.
Thanks all.
Referring to changing the look of the catalog side drop-down for qty, or some sort of admin side modification?Quote:
Originally Posted by chuckrey
What is the desired modification or issue attempting to address?
I would like to bold the Qty with the count and/or change it's color to make it stand out a bit more. I am near completion and asked for some input from the users in the office and this was something that came up. You can view it at pfcfurnitureindustries.com If that isn't possible, I was thinking of removing the custom id from displaying so there is less information on that line. Thanks for your response.
The dropdown is not a jQuery/javascript driven item. It is a standard option type list which means that there is little to no html modifications possible.Quote:
Originally Posted by chuckrey
The custom_id was chosen to be attached to that area; however, can be modified/reworked to act/respond/report differently or elsewhere. But, alas, bolding parts, alternate coloring, etc within the dropdown list would require implementing some other dropdown list "tool". I've been wanting to do so, but haven't made the time. I believe it will require a complete rework of the product attributes display code or at least the final output. Currently it is more of a create for the output instead of a create for posing to an html tag. (E.g. not as javascript like as it should be).
Good that the team had some ideas, unfortunately, not easily implemented as requested. I suggest at least capturing the information that is made available, whether it is by alternate javascript output or page location. But basically, by incorporating the data where I did allowed reducing the overall file edits and ways for things to possibly go wrong. :)
Apologize for the delay in response, been busy.
Makes total sense. I understand and I think the way it currently sits will work as needed. Thanks very much for your response.Quote:
Originally Posted by mc12345678