After Migration From M1 to M2, Default Migrated Attribute Set Product Tier Pricing Not UpdatingData migration...
What is the industry term for house wiring diagrams?
Microtypography protrusion with Polish quotation marks
Coworker asking me to not bring cakes due to self control issue. What should I do?
Translation needed for 130 years old church document
How vim overwrites readonly mode?
Lava breathing lizard creature (for cult worshipping)
Why do neural networks need so many training examples to perform?
Is there any risk in sharing info about technologies and products we use with a supplier?
How to not let the Identify spell spoil everything?
How do you voice extended chords?
Removing whitespace between consecutive numbers
Sprint is 2 week and 40-stories
What happens when a Shield of Missile Attraction wearer is behind total cover?
How do I prevent a homebrew Grappling Hook feature from trivializing Tomb of Annihilation?
Can 5 Aarakocra PC summon an Air Elemental?
What will happen if I transfer large sums of money into my bank account from a pre-paid debit card or gift card?
Is there a file that always exists and a 'normal' user can't lstat it?
Why avoid shared user accounts?
I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."
Why did the villain in the first Men in Black movie care about Earth's Cockroaches?
How to politely refuse in-office gym instructor for steroids and protein
Count repetitions of an array
Plausible reason for gold-digging ant
Existence of Riemann surface, holomorphic maps
After Migration From M1 to M2, Default Migrated Attribute Set Product Tier Pricing Not Updating
Data migration problems 1.9.2.2 to 2.0Migration from 1.6 to 2.1 successfull but no settings migratedMagento2 Blank category list page after migrationSpecial prices not showing in product pagesMagento 2: Why my products aren't showing in Catalog Search?After Migration from Magento 1.9.1.0 to Magento 2.2.4, Customer Creation IssueMagento 2 After Migration Configurable Product Price blankMigrating from Shopify: Manual or Migration Tools?Data migration done partially Magento2Tier Price doesn't work after combining two or more custom options
I've migrated M1 to M2.1.8 by using "UB Data Migration tool", but when I tried to update tier price for a product having "Default Migrated" attribute set it doesn't
updated(not getting any error just getting product saved message), others things are updating properly e.g-product name, special price, cost etc.
While for the attribute set "Default" everything working fine.
magento2 magento2-migration-tool tiered-pricing
add a comment |
I've migrated M1 to M2.1.8 by using "UB Data Migration tool", but when I tried to update tier price for a product having "Default Migrated" attribute set it doesn't
updated(not getting any error just getting product saved message), others things are updating properly e.g-product name, special price, cost etc.
While for the attribute set "Default" everything working fine.
magento2 magento2-migration-tool tiered-pricing
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40
add a comment |
I've migrated M1 to M2.1.8 by using "UB Data Migration tool", but when I tried to update tier price for a product having "Default Migrated" attribute set it doesn't
updated(not getting any error just getting product saved message), others things are updating properly e.g-product name, special price, cost etc.
While for the attribute set "Default" everything working fine.
magento2 magento2-migration-tool tiered-pricing
I've migrated M1 to M2.1.8 by using "UB Data Migration tool", but when I tried to update tier price for a product having "Default Migrated" attribute set it doesn't
updated(not getting any error just getting product saved message), others things are updating properly e.g-product name, special price, cost etc.
While for the attribute set "Default" everything working fine.
magento2 magento2-migration-tool tiered-pricing
magento2 magento2-migration-tool tiered-pricing
edited Jun 15 '18 at 8:59
Teja Bhagavan Kollepara
2,96341847
2,96341847
asked May 24 '18 at 6:56
wakar Ahamadwakar Ahamad
302113
302113
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40
add a comment |
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40
add a comment |
3 Answers
3
active
oldest
votes
After lots of debugging, finally, I fixed it via event-observer.
So just created a separated custom module & used "catalog_product_save_before" event.
FilePath:- Namespace/Module/Observer/Tierpriceupdate.php
Here is the observer code:-
public function execute(MagentoFrameworkEventObserver $observer)
{
$_product = $observer->getProduct();
//Get Migrated attribute set id
$att_set_id=$_product->getAttributeSetId() ;
// Only fot "Default Migrated" attribute set
if($att_set_id==11){
$product_id=$_product->getId() ;
// Sql Connection :-
$objectManager = MagentoFrameworkAppObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tier_prices=$_product->getData('tier_price') ;
// echo "<pre>" ; print_r($tier_prices) ; exit;
foreach($tier_prices as $tier_price){
$price_qty = $tier_price['price_qty'];
$price = $tier_price['price'];
$website_id = $tier_price['website_id'];
$all_groups=0;
// When Customer Group As All group
if($tier_price['cust_group']==32000){
$tier_price['cust_group']=0;
$all_groups=1;
}
$cust_group =$tier_price['cust_group'];
if(isset($tier_price['price_id']) && !empty($tier_price['price_id'])){
$price_id =$tier_price['price_id'];
if(empty($tier_price['delete']) && !isset($tier_price['delete'])){
// Update table catalog_product_entity_tier_price
$update_table = "UPDATE `catalog_product_entity_tier_price` SET `all_groups`='$all_groups', `customer_group_id`='$cust_group', `qty`='$price_qty', `value`='$price', `website_id`='$website_id' WHERE `value_id`='$price_id'" ;
// echo $update_table ; exit;
$connection->query($update_table);
} else{
// Delete table row catalog_product_entity_tier_price
$delete_table="DELETE FROM `catalog_product_entity_tier_price` WHERE `value_id` = '$price_id'" ;
// echo $delete_table ; exit;
$connection->query($delete_table);
}
} else{
// Insert INto catalog_product_entity_tier_price
$insert_table="INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `website_id`) VALUES ('$product_id', '$all_groups', '$cust_group', '$price_qty', '$price', '$website_id')";
$connection->query($insert_table);
}
}
}
}
add a comment |
We wonder if you're using our old script on Github or our latest UB Data Migration Pro package? We no longer maintain the Github version as its codebase was outdated.
If you use our Pro version, you can submit a ticket via our helpdesk, we will work closely with you then.
PS. From your initial question, there's a high chance that it relates to the special case of your data only, not the issue of the migration tool. We will get back to you in more details, if you can provide further info via our helpdesk.
add a comment |
After Migration Must Execute SQL Query For Remove "_Migrated" Postfix From Attribute Set Name
UPDATE eav_attribute_set SET attribute_set_name =
replace(attribute_set_name, 'Default_Migrated', 'Default') WHERE
attribute_set_name = 'Default_Migrated';
New contributor
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%2f227306%2fafter-migration-from-m1-to-m2-default-migrated-attribute-set-product-tier-prici%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
After lots of debugging, finally, I fixed it via event-observer.
So just created a separated custom module & used "catalog_product_save_before" event.
FilePath:- Namespace/Module/Observer/Tierpriceupdate.php
Here is the observer code:-
public function execute(MagentoFrameworkEventObserver $observer)
{
$_product = $observer->getProduct();
//Get Migrated attribute set id
$att_set_id=$_product->getAttributeSetId() ;
// Only fot "Default Migrated" attribute set
if($att_set_id==11){
$product_id=$_product->getId() ;
// Sql Connection :-
$objectManager = MagentoFrameworkAppObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tier_prices=$_product->getData('tier_price') ;
// echo "<pre>" ; print_r($tier_prices) ; exit;
foreach($tier_prices as $tier_price){
$price_qty = $tier_price['price_qty'];
$price = $tier_price['price'];
$website_id = $tier_price['website_id'];
$all_groups=0;
// When Customer Group As All group
if($tier_price['cust_group']==32000){
$tier_price['cust_group']=0;
$all_groups=1;
}
$cust_group =$tier_price['cust_group'];
if(isset($tier_price['price_id']) && !empty($tier_price['price_id'])){
$price_id =$tier_price['price_id'];
if(empty($tier_price['delete']) && !isset($tier_price['delete'])){
// Update table catalog_product_entity_tier_price
$update_table = "UPDATE `catalog_product_entity_tier_price` SET `all_groups`='$all_groups', `customer_group_id`='$cust_group', `qty`='$price_qty', `value`='$price', `website_id`='$website_id' WHERE `value_id`='$price_id'" ;
// echo $update_table ; exit;
$connection->query($update_table);
} else{
// Delete table row catalog_product_entity_tier_price
$delete_table="DELETE FROM `catalog_product_entity_tier_price` WHERE `value_id` = '$price_id'" ;
// echo $delete_table ; exit;
$connection->query($delete_table);
}
} else{
// Insert INto catalog_product_entity_tier_price
$insert_table="INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `website_id`) VALUES ('$product_id', '$all_groups', '$cust_group', '$price_qty', '$price', '$website_id')";
$connection->query($insert_table);
}
}
}
}
add a comment |
After lots of debugging, finally, I fixed it via event-observer.
So just created a separated custom module & used "catalog_product_save_before" event.
FilePath:- Namespace/Module/Observer/Tierpriceupdate.php
Here is the observer code:-
public function execute(MagentoFrameworkEventObserver $observer)
{
$_product = $observer->getProduct();
//Get Migrated attribute set id
$att_set_id=$_product->getAttributeSetId() ;
// Only fot "Default Migrated" attribute set
if($att_set_id==11){
$product_id=$_product->getId() ;
// Sql Connection :-
$objectManager = MagentoFrameworkAppObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tier_prices=$_product->getData('tier_price') ;
// echo "<pre>" ; print_r($tier_prices) ; exit;
foreach($tier_prices as $tier_price){
$price_qty = $tier_price['price_qty'];
$price = $tier_price['price'];
$website_id = $tier_price['website_id'];
$all_groups=0;
// When Customer Group As All group
if($tier_price['cust_group']==32000){
$tier_price['cust_group']=0;
$all_groups=1;
}
$cust_group =$tier_price['cust_group'];
if(isset($tier_price['price_id']) && !empty($tier_price['price_id'])){
$price_id =$tier_price['price_id'];
if(empty($tier_price['delete']) && !isset($tier_price['delete'])){
// Update table catalog_product_entity_tier_price
$update_table = "UPDATE `catalog_product_entity_tier_price` SET `all_groups`='$all_groups', `customer_group_id`='$cust_group', `qty`='$price_qty', `value`='$price', `website_id`='$website_id' WHERE `value_id`='$price_id'" ;
// echo $update_table ; exit;
$connection->query($update_table);
} else{
// Delete table row catalog_product_entity_tier_price
$delete_table="DELETE FROM `catalog_product_entity_tier_price` WHERE `value_id` = '$price_id'" ;
// echo $delete_table ; exit;
$connection->query($delete_table);
}
} else{
// Insert INto catalog_product_entity_tier_price
$insert_table="INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `website_id`) VALUES ('$product_id', '$all_groups', '$cust_group', '$price_qty', '$price', '$website_id')";
$connection->query($insert_table);
}
}
}
}
add a comment |
After lots of debugging, finally, I fixed it via event-observer.
So just created a separated custom module & used "catalog_product_save_before" event.
FilePath:- Namespace/Module/Observer/Tierpriceupdate.php
Here is the observer code:-
public function execute(MagentoFrameworkEventObserver $observer)
{
$_product = $observer->getProduct();
//Get Migrated attribute set id
$att_set_id=$_product->getAttributeSetId() ;
// Only fot "Default Migrated" attribute set
if($att_set_id==11){
$product_id=$_product->getId() ;
// Sql Connection :-
$objectManager = MagentoFrameworkAppObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tier_prices=$_product->getData('tier_price') ;
// echo "<pre>" ; print_r($tier_prices) ; exit;
foreach($tier_prices as $tier_price){
$price_qty = $tier_price['price_qty'];
$price = $tier_price['price'];
$website_id = $tier_price['website_id'];
$all_groups=0;
// When Customer Group As All group
if($tier_price['cust_group']==32000){
$tier_price['cust_group']=0;
$all_groups=1;
}
$cust_group =$tier_price['cust_group'];
if(isset($tier_price['price_id']) && !empty($tier_price['price_id'])){
$price_id =$tier_price['price_id'];
if(empty($tier_price['delete']) && !isset($tier_price['delete'])){
// Update table catalog_product_entity_tier_price
$update_table = "UPDATE `catalog_product_entity_tier_price` SET `all_groups`='$all_groups', `customer_group_id`='$cust_group', `qty`='$price_qty', `value`='$price', `website_id`='$website_id' WHERE `value_id`='$price_id'" ;
// echo $update_table ; exit;
$connection->query($update_table);
} else{
// Delete table row catalog_product_entity_tier_price
$delete_table="DELETE FROM `catalog_product_entity_tier_price` WHERE `value_id` = '$price_id'" ;
// echo $delete_table ; exit;
$connection->query($delete_table);
}
} else{
// Insert INto catalog_product_entity_tier_price
$insert_table="INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `website_id`) VALUES ('$product_id', '$all_groups', '$cust_group', '$price_qty', '$price', '$website_id')";
$connection->query($insert_table);
}
}
}
}
After lots of debugging, finally, I fixed it via event-observer.
So just created a separated custom module & used "catalog_product_save_before" event.
FilePath:- Namespace/Module/Observer/Tierpriceupdate.php
Here is the observer code:-
public function execute(MagentoFrameworkEventObserver $observer)
{
$_product = $observer->getProduct();
//Get Migrated attribute set id
$att_set_id=$_product->getAttributeSetId() ;
// Only fot "Default Migrated" attribute set
if($att_set_id==11){
$product_id=$_product->getId() ;
// Sql Connection :-
$objectManager = MagentoFrameworkAppObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tier_prices=$_product->getData('tier_price') ;
// echo "<pre>" ; print_r($tier_prices) ; exit;
foreach($tier_prices as $tier_price){
$price_qty = $tier_price['price_qty'];
$price = $tier_price['price'];
$website_id = $tier_price['website_id'];
$all_groups=0;
// When Customer Group As All group
if($tier_price['cust_group']==32000){
$tier_price['cust_group']=0;
$all_groups=1;
}
$cust_group =$tier_price['cust_group'];
if(isset($tier_price['price_id']) && !empty($tier_price['price_id'])){
$price_id =$tier_price['price_id'];
if(empty($tier_price['delete']) && !isset($tier_price['delete'])){
// Update table catalog_product_entity_tier_price
$update_table = "UPDATE `catalog_product_entity_tier_price` SET `all_groups`='$all_groups', `customer_group_id`='$cust_group', `qty`='$price_qty', `value`='$price', `website_id`='$website_id' WHERE `value_id`='$price_id'" ;
// echo $update_table ; exit;
$connection->query($update_table);
} else{
// Delete table row catalog_product_entity_tier_price
$delete_table="DELETE FROM `catalog_product_entity_tier_price` WHERE `value_id` = '$price_id'" ;
// echo $delete_table ; exit;
$connection->query($delete_table);
}
} else{
// Insert INto catalog_product_entity_tier_price
$insert_table="INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `website_id`) VALUES ('$product_id', '$all_groups', '$cust_group', '$price_qty', '$price', '$website_id')";
$connection->query($insert_table);
}
}
}
}
answered Jun 1 '18 at 4:49
wakar Ahamadwakar Ahamad
302113
302113
add a comment |
add a comment |
We wonder if you're using our old script on Github or our latest UB Data Migration Pro package? We no longer maintain the Github version as its codebase was outdated.
If you use our Pro version, you can submit a ticket via our helpdesk, we will work closely with you then.
PS. From your initial question, there's a high chance that it relates to the special case of your data only, not the issue of the migration tool. We will get back to you in more details, if you can provide further info via our helpdesk.
add a comment |
We wonder if you're using our old script on Github or our latest UB Data Migration Pro package? We no longer maintain the Github version as its codebase was outdated.
If you use our Pro version, you can submit a ticket via our helpdesk, we will work closely with you then.
PS. From your initial question, there's a high chance that it relates to the special case of your data only, not the issue of the migration tool. We will get back to you in more details, if you can provide further info via our helpdesk.
add a comment |
We wonder if you're using our old script on Github or our latest UB Data Migration Pro package? We no longer maintain the Github version as its codebase was outdated.
If you use our Pro version, you can submit a ticket via our helpdesk, we will work closely with you then.
PS. From your initial question, there's a high chance that it relates to the special case of your data only, not the issue of the migration tool. We will get back to you in more details, if you can provide further info via our helpdesk.
We wonder if you're using our old script on Github or our latest UB Data Migration Pro package? We no longer maintain the Github version as its codebase was outdated.
If you use our Pro version, you can submit a ticket via our helpdesk, we will work closely with you then.
PS. From your initial question, there's a high chance that it relates to the special case of your data only, not the issue of the migration tool. We will get back to you in more details, if you can provide further info via our helpdesk.
answered Jun 15 '18 at 8:44
UberthemeUbertheme
664
664
add a comment |
add a comment |
After Migration Must Execute SQL Query For Remove "_Migrated" Postfix From Attribute Set Name
UPDATE eav_attribute_set SET attribute_set_name =
replace(attribute_set_name, 'Default_Migrated', 'Default') WHERE
attribute_set_name = 'Default_Migrated';
New contributor
add a comment |
After Migration Must Execute SQL Query For Remove "_Migrated" Postfix From Attribute Set Name
UPDATE eav_attribute_set SET attribute_set_name =
replace(attribute_set_name, 'Default_Migrated', 'Default') WHERE
attribute_set_name = 'Default_Migrated';
New contributor
add a comment |
After Migration Must Execute SQL Query For Remove "_Migrated" Postfix From Attribute Set Name
UPDATE eav_attribute_set SET attribute_set_name =
replace(attribute_set_name, 'Default_Migrated', 'Default') WHERE
attribute_set_name = 'Default_Migrated';
New contributor
After Migration Must Execute SQL Query For Remove "_Migrated" Postfix From Attribute Set Name
UPDATE eav_attribute_set SET attribute_set_name =
replace(attribute_set_name, 'Default_Migrated', 'Default') WHERE
attribute_set_name = 'Default_Migrated';
New contributor
New contributor
answered 3 hours ago
Ronak RathodRonak Rathod
111
111
New contributor
New contributor
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%2f227306%2fafter-migration-from-m1-to-m2-default-migrated-attribute-set-product-tier-prici%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
My suggestion to use Magento own Data Migration tool and also don't use 2.1.8. Lastest Magento 2 version 2.2.4
– Amit Bera♦
May 24 '18 at 7:51
I've already migrated & made lots of changes,lots of products,orders etc here so for now i can't do this.
– wakar Ahamad
May 24 '18 at 8:40