How to speedup migration for products ?

Hi there,
How many products in your working now?
Did you do data migration in local machine or VPS server?
You can run data migration by CLI command to up speed:
Ex: To migrate data in the step #5. You can run CLI command:
php -f bin/ubdatamigration run --step=5 --limit=500
Also, you should follow our guide in the readme.txt to enable php memcache to up speed of migration too.
And you should run data migration with SSD hard disk.
Please have a look and contact me if your need further assistance.
Regards,
Mall.

Hi there,
Yeah, let’s do it and contact me if you need further assistance.
Regards,
Mall.

Hi there,

For the first 1000 records, it took 60 minutes

What type of your Hard Disk in your local machine? If it does not a SSD hard disk. You should do data migration in a VPS.
With high speed of read/write in SSD hard disk. It will helps you save time in data migration.

Also is there a way to limit the migration process of orders based on the period i.e. order placed date like between two dates.

Yes, but we have to added more tweak code for step #7 to do that. 
Regards,
Mall.

Hi there,
Let’s open the file at: pub/ub-tool/protected/controllers/Step7Controller.php
And find to the code line:

//build condition
$condition = [];
if (!UBMigrate::getSetting(2, 'select_all_store')) {
    //get migrated store ids
    $strMigratedStoreIds = implode(',', array_keys($mappingStores));
    $condition[] = "(store_id IN ({$strMigratedStoreIds}) OR store_id IS NULL)";
}
if (!UBMigrate::getSetting(6, 'select_all_customer')) {
    $mappingCustomers = UBMigrate::getMappingData('customer_entity', 6);
    $strMigratedCustomerIds = implode(',', array_keys($mappingCustomers));
    $condition[] = "(customer_id IN ({$strMigratedCustomerIds}) OR customer_id IS NULL)";
}
$condition = implode(" AND ", $condition);

And replace it by code lines:

//build condition
$condition = [];
$startDate = '01/01/2016';
$endDate = '31/12/2016';
$condition[] = "(created_at >= '{$startDate}' AND created_at <= '{$endDate}')";
if (!UBMigrate::getSetting(2, 'select_all_store')) {
    //get migrated store ids
    $strMigratedStoreIds = implode(',', array_keys($mappingStores));
    $condition[] = "(store_id IN ({$strMigratedStoreIds}) OR store_id IS NULL)";
}
if (!UBMigrate::getSetting(6, 'select_all_customer')) {
    $mappingCustomers = UBMigrate::getMappingData('customer_entity', 6);
    $strMigratedCustomerIds = implode(',', array_keys($mappingCustomers));
    $condition[] = "(customer_id IN ({$strMigratedCustomerIds}) OR customer_id IS NULL)";
}
$condition = implode(" AND ", $condition);

And then you can do migration your orders as you want.
Regards,
Mall.