Page 1 of 1

Errors with Recurring Subscription Orders R9

Posted: Thu Oct 30, 2014 9:54 am
by SuperMindConsulting
Errors with Recurring Subscription Orders (CIM)R9

I have run into some issues with this specific scenario.
Has anyone else ran into this?
Is there a fix in the pipeline or a better way to address this scenario?

Scenario:
* 6- month Subscription Based Non-Shippable Product with Options
Price
  • $20 initial fee
  • $20/mo for 5 months
Optional Features
  • $5 initial fee
  • $5/mo for 5 months
Product SETTINGS
Base Product Price
  • $20 price
  • Enable Shipping = false
Subscription Settings
  • Billing Option: "Initial charge of $20.00 with recurring charge"
  • Recurring Charge: "Modify Override Subscription Base Price ($20.00) With (0.00)
  • Payment Frequency: Fixed
Attempt #1 using KITTING
1 Kit Config with 2 Checkboxes Components (tried both Fixed and Modify pricing)

RESULT: Exception is logged and future orders for this subscription are NOT created. Exception thrown from RecurringOrderService on "Next Order Due"

Code: Select all

Exception: Cannot insert duplicate key row in object 'dbo.ac_Orders' with unique index 'ac_Orders_IXOrderNumber'. 
settings
  • 1 Kit Component List
  • 2 Checkbox SKUs
*I tried both itemized and bundled

Attempt #2 using OPTIONS
RESULT: Incorrect Order Amount for Future Orders. Orders do not have the correct Price set if OPTIONS are selected.
* Order #1 : $20 + $5 feature = $25
* Order #2 : $20 (item description shows the Optional Feature, but price modifier is not reflected.

RESULT: Incorrect OrderStatus for Recurring Orders: Future orders marked as "Shipment Pending" even though product is marked as not-shippable

settings
  • 1 OPTION with 2 choices (each with $5 price modifier)
*I tried both itemized and bundled