Magento 2 get all customizable options
How long is it safe to leave marker on a Chessex battle map?
2019 gold coins to share
Math cases align being colored as a table
What are the implications when matrix's lowest eigenvalue is equal to 0?
Is Lambda Calculus purely syntactic?
Possible runaway argument using circuitikz
tabular: caption and align problem
Arduino wrap or Subclass print() to work with multiple Serial
Does the new finding on "reversing a quantum jump mid-flight" rule out any interpretations of QM?
What is the color of artificial intelligence?
Proving that a Russian cryptographic standard is too structured
Live action TV show where High school Kids go into the virtual world and have to clear levels
Why did Intel abandon unified CPU cache?
Do you have to have figures when playing D&D?
Are polynomials with the same roots identical?
60s or 70s novel about Empire of Man making 1st contact with 1st discovered alien race
Why was this person allowed to become Grand Maester?
Why the output signal of my amplifier is heavily distorted
What is the Leave No Trace way to dispose of coffee grounds?
How can I remove material from this wood beam?
Why Does Mama Coco Look Old After Going to the Other World?
Is it safe to change the harddrive power feature so that it never turns off?
Does a bank have to tell me if a check made out to me was cashed there?
Can the removal of a duty-free sales trolley result in a measurable reduction in emissions?
Magento 2 get all customizable options
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Is there a way I could retrieve all the custom options and their values? (not from a specific product, but just all of the options)
custom customizable-options
asked Jun 3 at 15:04
kolozzkolozz
435
add a comment |
Is there a way I could retrieve all the custom options and their values? (not from a specific product, but just all of the options)
custom customizable-options
asked Jun 3 at 15:04
kolozzkolozz
435
add a comment |
Is there a way I could retrieve all the custom options and their values? (not from a specific product, but just all of the options)
custom customizable-options
asked Jun 3 at 15:04
kolozzkolozz
435
Is there a way I could retrieve all the custom options and their values? (not from a specific product, but just all of the options)
custom customizable-options
custom customizable-options
asked Jun 3 at 15:04
kolozzkolozz
435
asked Jun 3 at 15:04
kolozzkolozz
435
asked Jun 3 at 15:04
kolozzkolozz
435
asked Jun 3 at 15:04
kolozzkolozz
435
asked Jun 3 at 15:04
kolozzkolozz
435
435
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I found this solution:
$tableName = $this->_resourceConnection->getTableName('catalog_product_option_type_title');
$connection = $this->_resourceConnection->getConnection();
$query = "SELECT * FROM " . $tableName;
$resultOptions = $connection->fetchAll($query);
answered Jun 3 at 17:40
kolozzkolozz
435
add a comment |
If you are trying to retrieve custom options and their values for one time you can use mysql query else you can have your own kind of implementations based on the below sql.
mysql> select t4.title as 'Custom Option', t3.Custom_Option_Values from (select t2.option_id, t1.option_type_id,t1.title as 'Custom_Option_Values' from catalog_product_option_type_title t1 left join catalog_product_option_type_value t2 on t1.option_type_id = t2.option_type_id) t3 left join catalog_product_option_title t4 on t3.option_id = t4.option_id;
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277101%2fmagento-2-get-all-customizable-options%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I found this solution:
$tableName = $this->_resourceConnection->getTableName('catalog_product_option_type_title');
$connection = $this->_resourceConnection->getConnection();
$query = "SELECT * FROM " . $tableName;
$resultOptions = $connection->fetchAll($query);
answered Jun 3 at 17:40
kolozzkolozz
435
add a comment |
I found this solution:
$tableName = $this->_resourceConnection->getTableName('catalog_product_option_type_title');
$connection = $this->_resourceConnection->getConnection();
$query = "SELECT * FROM " . $tableName;
$resultOptions = $connection->fetchAll($query);
answered Jun 3 at 17:40
kolozzkolozz
435
add a comment |
I found this solution:
$tableName = $this->_resourceConnection->getTableName('catalog_product_option_type_title');
$connection = $this->_resourceConnection->getConnection();
$query = "SELECT * FROM " . $tableName;
$resultOptions = $connection->fetchAll($query);
answered Jun 3 at 17:40
kolozzkolozz
435
I found this solution:
$tableName = $this->_resourceConnection->getTableName('catalog_product_option_type_title');
$connection = $this->_resourceConnection->getConnection();
$query = "SELECT * FROM " . $tableName;
$resultOptions = $connection->fetchAll($query);
answered Jun 3 at 17:40
kolozzkolozz
435
answered Jun 3 at 17:40
kolozzkolozz
435
answered Jun 3 at 17:40
kolozzkolozz
435
answered Jun 3 at 17:40
kolozzkolozz
435
435
add a comment |
add a comment |
If you are trying to retrieve custom options and their values for one time you can use mysql query else you can have your own kind of implementations based on the below sql.
mysql> select t4.title as 'Custom Option', t3.Custom_Option_Values from (select t2.option_id, t1.option_type_id,t1.title as 'Custom_Option_Values' from catalog_product_option_type_title t1 left join catalog_product_option_type_value t2 on t1.option_type_id = t2.option_type_id) t3 left join catalog_product_option_title t4 on t3.option_id = t4.option_id;
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
add a comment |
If you are trying to retrieve custom options and their values for one time you can use mysql query else you can have your own kind of implementations based on the below sql.
mysql> select t4.title as 'Custom Option', t3.Custom_Option_Values from (select t2.option_id, t1.option_type_id,t1.title as 'Custom_Option_Values' from catalog_product_option_type_title t1 left join catalog_product_option_type_value t2 on t1.option_type_id = t2.option_type_id) t3 left join catalog_product_option_title t4 on t3.option_id = t4.option_id;
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
add a comment |
If you are trying to retrieve custom options and their values for one time you can use mysql query else you can have your own kind of implementations based on the below sql.
mysql> select t4.title as 'Custom Option', t3.Custom_Option_Values from (select t2.option_id, t1.option_type_id,t1.title as 'Custom_Option_Values' from catalog_product_option_type_title t1 left join catalog_product_option_type_value t2 on t1.option_type_id = t2.option_type_id) t3 left join catalog_product_option_title t4 on t3.option_id = t4.option_id;
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
If you are trying to retrieve custom options and their values for one time you can use mysql query else you can have your own kind of implementations based on the below sql.
mysql> select t4.title as 'Custom Option', t3.Custom_Option_Values from (select t2.option_id, t1.option_type_id,t1.title as 'Custom_Option_Values' from catalog_product_option_type_title t1 left join catalog_product_option_type_value t2 on t1.option_type_id = t2.option_type_id) t3 left join catalog_product_option_title t4 on t3.option_id = t4.option_id;
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
answered Jun 3 at 19:28
Prashiddha Raj JoshiPrashiddha Raj Joshi
213
213
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277101%2fmagento-2-get-all-customizable-options%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
