Get Customer Details by Wishlist Product Id in Magento 2
A list of products was added to wish-list by the number of customers and I need to know that which customer was added a particular product to the wish-list, based on the product id.
I need to get the customer details or at-least a customer id based on the product id.
magento2 customer wishlist
add a comment |
A list of products was added to wish-list by the number of customers and I need to know that which customer was added a particular product to the wish-list, based on the product id.
I need to get the customer details or at-least a customer id based on the product id.
magento2 customer wishlist
1
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago
add a comment |
A list of products was added to wish-list by the number of customers and I need to know that which customer was added a particular product to the wish-list, based on the product id.
I need to get the customer details or at-least a customer id based on the product id.
magento2 customer wishlist
A list of products was added to wish-list by the number of customers and I need to know that which customer was added a particular product to the wish-list, based on the product id.
I need to get the customer details or at-least a customer id based on the product id.
magento2 customer wishlist
magento2 customer wishlist
edited yesterday
Yann Martel
2715
2715
asked yesterday
kiran kumar
247
247
1
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago
add a comment |
1
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago
1
1
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago
add a comment |
2 Answers
2
active
oldest
votes
Get data by Item ID
private $wishlist;
public function __construct(
...
MagentoWishlistModelWishlist $wishlist
) {
$this->wishlist = $wishlist;
...
}
...
$item_id= 1;
$wishlistItem_collection = $this->wishlist->getItem($item_id);
This will return Item data collection including customer ID.
Wishlist Model
add a comment |
The worked code for me as below:
First iam getting the collection from the wishlist_item table and filter with my product id.
$wishlistItemCollection = $objectManager->get('MagentoWishlistModelResourceModelItemCollection')->addFieldToFilter('product_id', ['eq' => $productId]);
Then joined the wishlist_item and wishlist table using the common field name wishlist_id and gets the customer_id into the wishlistItemCollection
$joinConditions = 'main_table.wishlist_id = wishlist.wishlist_id';
$wishlistItemCollection->getSelect('*')->join(
['wishlist'],
$joinConditions,
)->columns("wishlist.customer_id");
Using the customer_id we can get all the customer details as below:
foreach($wishlistItemCollection as $wishlistData){
$customerId = $wishlistData->getCustomerId();
$customer = $this->_customer->load($customerId);
$customerData = $customer->getData();
$customerName = $customer->getFirstname();
$customerEmail = $customer->getEmail();
}
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%2f256833%2fget-customer-details-by-wishlist-product-id-in-magento-2%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
Get data by Item ID
private $wishlist;
public function __construct(
...
MagentoWishlistModelWishlist $wishlist
) {
$this->wishlist = $wishlist;
...
}
...
$item_id= 1;
$wishlistItem_collection = $this->wishlist->getItem($item_id);
This will return Item data collection including customer ID.
Wishlist Model
add a comment |
Get data by Item ID
private $wishlist;
public function __construct(
...
MagentoWishlistModelWishlist $wishlist
) {
$this->wishlist = $wishlist;
...
}
...
$item_id= 1;
$wishlistItem_collection = $this->wishlist->getItem($item_id);
This will return Item data collection including customer ID.
Wishlist Model
add a comment |
Get data by Item ID
private $wishlist;
public function __construct(
...
MagentoWishlistModelWishlist $wishlist
) {
$this->wishlist = $wishlist;
...
}
...
$item_id= 1;
$wishlistItem_collection = $this->wishlist->getItem($item_id);
This will return Item data collection including customer ID.
Wishlist Model
Get data by Item ID
private $wishlist;
public function __construct(
...
MagentoWishlistModelWishlist $wishlist
) {
$this->wishlist = $wishlist;
...
}
...
$item_id= 1;
$wishlistItem_collection = $this->wishlist->getItem($item_id);
This will return Item data collection including customer ID.
Wishlist Model
answered yesterday
Aditya Shah
3,5932834
3,5932834
add a comment |
add a comment |
The worked code for me as below:
First iam getting the collection from the wishlist_item table and filter with my product id.
$wishlistItemCollection = $objectManager->get('MagentoWishlistModelResourceModelItemCollection')->addFieldToFilter('product_id', ['eq' => $productId]);
Then joined the wishlist_item and wishlist table using the common field name wishlist_id and gets the customer_id into the wishlistItemCollection
$joinConditions = 'main_table.wishlist_id = wishlist.wishlist_id';
$wishlistItemCollection->getSelect('*')->join(
['wishlist'],
$joinConditions,
)->columns("wishlist.customer_id");
Using the customer_id we can get all the customer details as below:
foreach($wishlistItemCollection as $wishlistData){
$customerId = $wishlistData->getCustomerId();
$customer = $this->_customer->load($customerId);
$customerData = $customer->getData();
$customerName = $customer->getFirstname();
$customerEmail = $customer->getEmail();
}
add a comment |
The worked code for me as below:
First iam getting the collection from the wishlist_item table and filter with my product id.
$wishlistItemCollection = $objectManager->get('MagentoWishlistModelResourceModelItemCollection')->addFieldToFilter('product_id', ['eq' => $productId]);
Then joined the wishlist_item and wishlist table using the common field name wishlist_id and gets the customer_id into the wishlistItemCollection
$joinConditions = 'main_table.wishlist_id = wishlist.wishlist_id';
$wishlistItemCollection->getSelect('*')->join(
['wishlist'],
$joinConditions,
)->columns("wishlist.customer_id");
Using the customer_id we can get all the customer details as below:
foreach($wishlistItemCollection as $wishlistData){
$customerId = $wishlistData->getCustomerId();
$customer = $this->_customer->load($customerId);
$customerData = $customer->getData();
$customerName = $customer->getFirstname();
$customerEmail = $customer->getEmail();
}
add a comment |
The worked code for me as below:
First iam getting the collection from the wishlist_item table and filter with my product id.
$wishlistItemCollection = $objectManager->get('MagentoWishlistModelResourceModelItemCollection')->addFieldToFilter('product_id', ['eq' => $productId]);
Then joined the wishlist_item and wishlist table using the common field name wishlist_id and gets the customer_id into the wishlistItemCollection
$joinConditions = 'main_table.wishlist_id = wishlist.wishlist_id';
$wishlistItemCollection->getSelect('*')->join(
['wishlist'],
$joinConditions,
)->columns("wishlist.customer_id");
Using the customer_id we can get all the customer details as below:
foreach($wishlistItemCollection as $wishlistData){
$customerId = $wishlistData->getCustomerId();
$customer = $this->_customer->load($customerId);
$customerData = $customer->getData();
$customerName = $customer->getFirstname();
$customerEmail = $customer->getEmail();
}
The worked code for me as below:
First iam getting the collection from the wishlist_item table and filter with my product id.
$wishlistItemCollection = $objectManager->get('MagentoWishlistModelResourceModelItemCollection')->addFieldToFilter('product_id', ['eq' => $productId]);
Then joined the wishlist_item and wishlist table using the common field name wishlist_id and gets the customer_id into the wishlistItemCollection
$joinConditions = 'main_table.wishlist_id = wishlist.wishlist_id';
$wishlistItemCollection->getSelect('*')->join(
['wishlist'],
$joinConditions,
)->columns("wishlist.customer_id");
Using the customer_id we can get all the customer details as below:
foreach($wishlistItemCollection as $wishlistData){
$customerId = $wishlistData->getCustomerId();
$customer = $this->_customer->load($customerId);
$customerData = $customer->getData();
$customerName = $customer->getFirstname();
$customerEmail = $customer->getEmail();
}
answered 9 hours ago
kiran kumar
247
247
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f256833%2fget-customer-details-by-wishlist-product-id-in-magento-2%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
1
This's your custom function or core magento. In module-wishlist, you can get customer id based on the product id by join 2 tables wishlist and wishlist_item
– rocky
yesterday
[community.magento.com/t5/Magento-2-x-Programming/…
– kiran kumar
yesterday
Hi @AdityaShah the below example code wishlist->getItem doesn't work for me.
– kiran kumar
9 hours ago