Mryntu

I'm trying to port over tens of thousands of coupons from a custom e-commerce website into Magento 2.0.8 and I'm having a hard time getting it to work. These are simple coupons either fixed $ or % off of the carts subtotal. I have been unable to get it to save from the command line.

I have a command called coupons:migrate that I'm running this code in. This is what I have so far in my createCoupon method that accepts the current coupons row (looping over a CSV file):

protected function createCoupon($coupon) 
 $shoppingCartPriceRule = $this->objectManager->create('MagentoSalesRuleModelRule');

 $shoppingCartPriceRule->setName($coupon['name'])
 ->setDescription($coupon['name'])
 ->setFromDate($coupon['start'])
 ->setToDate($coupon['end'])
 ->setUsesPerCustomer($coupon['max_redemptions'])
 ->setCustomerGroupIds(array('0','1','2','3',))
 ->setIsActive('1')
 ->setSimpleAction($coupon['discount_type'])
 ->setDiscountAmount($coupon['discount_amount'])
 ->setDiscountQty(1)
 ->setApplyToShipping($coupon['flag_is_free_shipping'])
 ->setTimesUsed($coupon['redemptions'])
 ->setWebsiteIds(array('1',))
 ->setCouponType('2')
 ->setCouponCode($coupon['code'])
 ->setUsesPerCoupon(NULL);

 return $shoppingCartPriceRule->save();

I'm currently getting this error from my database:

[Zend_Db_Statement_Exception]
 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: INSERT INTO `magento_reward_salesrule` (`rule_id`,`points_delta`) VALUES (?, ?) ON DUPLICATE KEY UPDATE `points_delta` = VALUES
 (`points_delta`)

 [PDOException]
 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Any help would be greatly appreciated. I'm basically stuck now.

I don't try to test your code, however, seem that your code lines need to improve the performance. After saving the object model, we need to unset the data object:

$shoppingCartPriceRule->save()
$shoppingCartPriceRule->unsetData(); 

You can try below code:

protected $ruleFactory

public function __construct(MagentoSalesRuleModelRuleFactory $ruleFactory) 
 $this->rulesFactory = $ruleFactory 


$ruleData = [
 "name" => "Buy 3 tee shirts and get the 4th free",
 "description" => "Buy 3 tee shirts and get the 4th free",
 "from_date" => null,
 "to_date" => null,
 "uses_per_customer" => "0",
 "is_active" => "1",
 "stop_rules_processing" => "0",
 "is_advanced" => "1",
 "product_ids" => null,
 "sort_order" => "0",
 "simple_action" => "buy_x_get_y",
 "discount_amount" => "1.0000",
 "discount_qty" => null,
 "discount_step" => "3",
 "apply_to_shipping" => "0",
 "times_used" => "0",
 "is_rss" => "1",
 "coupon_type" => "NO_COUPON",
 "use_auto_generation" => "0",
 "uses_per_coupon" => "0",
 "simple_free_shipping" => "0",
 "customer_group_ids" => [0, 1, 2, 3],
 "website_ids" => [1],
 "coupon_code" => null,
 "store_labels" => [],
 "conditions_serialized" => '',
 "actions_serialized" => ''
 ];

$ruleModel = $this->ruleFactory->create();
$ruleModel->setData($ruleData);
$ruleModel->save();

Try code below

$objectManager = MagentoFrameworkAppObjectManager::getInstance(); 
$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('adminhtml'); 

$coupon['name'] = 'test';
$coupon['desc'] = 'Discount for Test';
$coupon['start'] = date('Y-m-d');
$coupon['end'] = '';
$coupon['max_redemptions'] = 1;
$coupon['discount_type'] = 'by_percent';
$coupon['discount_amount'] = 15;
$coupon['flag_is_free_shipping'] = 'no';
$coupon['redemptions'] = 1;
$coupon['code'] = 'test-1234'; //this code will normally be autogenetated but i am hard coding for testing purposes

$shoppingCartPriceRule = $objectManager->create('MagentoSalesRuleModelRule');
$shoppingCartPriceRule->setName($coupon['name'])
 ->setDescription($coupon['desc'])
 ->setFromDate($coupon['start'])
 ->setToDate($coupon['end'])
 ->setUsesPerCustomer($coupon['max_redemptions'])
 ->setCustomerGroupIds(array('0','1','2','3',))
 ->setIsActive(1)
 ->setSimpleAction($coupon['discount_type'])
 ->setDiscountAmount($coupon['discount_amount'])
 ->setDiscountQty(1)
 ->setApplyToShipping($coupon['flag_is_free_shipping'])
 ->setTimesUsed($coupon['redemptions'])
 ->setWebsiteIds(array('1'))
 ->setCouponType(2)
 ->setCouponCode($coupon['code'])
 ->setUsesPerCoupon(NULL);
$shoppingCartPriceRule->save();