Service - Cart: Difference between revisions

From Izara Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Tag: Manual revert
 
(15 intermediate revisions by the same user not shown)
Line 71: Line 71:
},
},
totalQuantity: {},
totalQuantity: {},
totalValue: {}, // will be in the currency of the paymentMethod selected (when changes need to re-calculate)
totalValue: {}, // will be in the currency of the deliveryMethod selected (sellOffer/sellOfferPlans must match deliveryMethod currency or are invalid)
name: {},
status: {}, // validating|valid|invalid|partiallyValid
timeValidated: {}, // date last time validated
},
},
}
}
Line 88: Line 91:
identifier: true, // create unique id from request params and uniqueMessageId
identifier: true, // create unique id from request params and uniqueMessageId
},
},
quantity: {},
},
},
}
}
Line 95: Line 99:
<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
nodeLabel: "{SellOfferPlanLib.SELLOFFERPLAN_PAYMENTMETHODLINK_GRAPH_NODE_LABEL}", // "sellOfferPlanPaymentMethodLink"
nodeLabel: "{CartPlanLib.CARTORDER_GRAPH_NODE_LABEL}", // "cartOrder"
schema: {
schema: {
identifier: true,
identifier: true,
Line 101: Line 105:
restrictRelationships: true,
restrictRelationships: true,
properties: {
properties: {
sellOfferPlanPaymentMethodLinkId: {
cartOrderId: {
identifier: true, // create unique id from request params and uniqueMessageId
identifier: true, // create unique id from request params and uniqueMessageId
},
},
status: {}, // processing|complete|error
errors: {}, // array of errors found
totalQuantity: {},
totalValue: {}, // will be in the currency of the deliveryMethod selected (when change deliveryMethod need to re-calculate cart)
},
},
}
}
Line 109: Line 117:
</syntaxhighlight>
</syntaxhighlight>


=== Versioned data ===
=== Relationships ===
 
==== sellOfferPlanDeliveryMethodLinkSettings ====


<syntaxhighlight lang="JavaScript">
{
{
properties: {
relationshipType: "{CartPlanLib.createHasCompletedCartGraphRelationshipType()}", // "hasWorking_cart"
oneTimeAmountSetting: {}, // "value"|"rate", do we add one time cost to the value before calculating, or is it a straight rate added after calculating
schema: {
oneTimeAmount: {}, // value of the one time amount
elementCanBeRemoved: true,
oneTimeAmountAccumulate: {}, // boolean true|false, if TRUE for combined orders then add oneTimeAmount for each included Sell Offer, if FALSE only gets added once
allPropertiesImmutable: true,
valueType: "xx", // quantity|productValue|productAttribute|sellOfferTerm, if set overwrites deliveryMethod defaultValueType
restrictProperties: true,
valueId: "xx", // if set overwrites deliveryMethod defaultValueId
properties: {
},
originTimestamp: //timestamp the request to create/change this relationship was sent
},
}
}
}
 
</syntaxhighlight><syntaxhighlight lang="JavaScript">
 
==== sellOfferPlanPaymentMethodLinkSettings ====
 
{
{
properties: {
relationshipType: "{CartPlanLib.createHasCompletedCartGraphRelationshipType()}", // "hasCompleted_cart"
oneTimeAmountSetting: {}, // "cost"|"percentage", do we add a one time cost, or add a % to the order total
schema: {
oneTimeAmount: {}, // value of the one time amount
elementCanBeRemoved: true,
},
allPropertiesImmutable: true,
restrictProperties: true,
properties: {
originTimestamp: //timestamp the request to create/change this relationship was sent
},
}
}
}
 
</syntaxhighlight>
==== sellOfferPlanSettings ====
<syntaxhighlight lang="JavaScript">
 
{
{
properties: {
relationshipType: "{CartPlanLib.createHasDeletedCartGraphRelationshipType()}", // "hasDeleted_cart"
combineWins: {}, // true|false
schema: {
},
elementCanBeRemoved: true,
allPropertiesImmutable: true,
restrictProperties: true,
properties: {
originTimestamp: //timestamp the request to create/change this relationship was sent
},
}
}
}
 
</syntaxhighlight>
=== Relationships ===
* links a user to a cart
* a cart can either be working, completed, or deleted


<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createOwnsSellOfferPlanGraphRelationshipType()}", // "owns_sellOfferPlan"
relationshipType: "{CartPlanLib.createHasActiveCartGraphRelationshipType()}", // "hasActive_cart"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 156: Line 173:
}
}
</syntaxhighlight>
</syntaxhighlight>
* links a sell offer to a sell offer plan
* all users should have one cart that is active
* a sell offer has only one sell offer plan


<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createHasSellOfferPlanGraphRelationshipType()}", // "has_sellOfferPlan"
relationshipType: "{CartPlanLib.cartPaymentMethodGraphRelationshipType()}", // "cart_paymentMethod"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 172: Line 188:
}
}
</syntaxhighlight>
</syntaxhighlight>
* links a user to one of their sell offer plans
* links a cart to it's current paymentMethod setting


<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createHasDeliveryMethodLinkGraphRelationshipType()}", // "has_deliveryMethodLink"
relationshipType: "{CartPlanLib.cartDeliveryMethodGraphRelationshipType()}", // "cart_deliveryMethod"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 187: Line 203:
}
}
</syntaxhighlight>
</syntaxhighlight>
* links a cart to it's current deliveryMethod setting
<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createDisabledDeliveryMethodLinkGraphRelationshipType()}", // "disabled_deliveryMethodLink"
relationshipType: "{CartPlanLib.cartShipToAddressGraphRelationshipType()}", // "cart_shipToAddress"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 200: Line 218:
}
}
</syntaxhighlight>
</syntaxhighlight>
* links a cart to it's current ship to address setting


<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createHasPaymentMethodLinkGraphRelationshipType()}", // "has_paymentMethodLink"
relationshipType: "{CartPlanLib.createHasCartSellOfferLinkGraphRelationshipType()}", // "has_cartSellOfferLink"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 216: Line 235:
<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createDisabledPaymentMethodLinkGraphRelationshipType()}", // "disabled_paymentMethodLink"
relationshipType: "{CartPlanLib.createCartSellOfferLinkIsSellOfferGraphRelationshipType()}", // "cartSellOfferLinkIs_sellOffer"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 227: Line 246:
}
}
</syntaxhighlight>
</syntaxhighlight>
* Links cartSellOfferLink to one sellOffer


<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createIsDeliveryMethodGraphRelationshipType()}", // "is_deliveryMethod"
relationshipType: "{CartPlanLib.createCarthasCartOrderGraphRelationshipType()}", // "has_cartOrder"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 244: Line 264:
<syntaxhighlight lang="JavaScript">
<syntaxhighlight lang="JavaScript">
{
{
relationshipType: "{SellOfferPlanLib.createIsPaymentMethodGraphRelationshipType()}", // "is_paymentMethod"
relationshipType: "{CartPlanLib.createCartOrderHasCartSellOfferLinkGraphRelationshipType()}", // "cartOrderHas_cartSellOfferLink"
schema: {
schema: {
elementCanBeRemoved: true,
elementCanBeRemoved: true,
Line 255: Line 275:
}
}
</syntaxhighlight>
</syntaxhighlight>
* links a cartSellOfferLink to a cartOrder
= Cart Orders =
* One cart can have many sellOffers from many sellers, or sell offers that don't combineWins, that cannot be purchased as a single order
* When validating split out into multiple orders according to what can be combined into a single payment/order
== Grouping into orders ==
* Done when validating cart
* Go through each selloffer:
*# does it offer the cart's paymentMethod? If not is invalid
*# does its offer the cart's deliveryMethod? If not is invalid
*# does the quantity chosen validate sellOffer available qty/minimum quantity? If not is invalid
*# if no sellOffers valid then cart status is invalid. If some sellOffers invalid then cart status is partiallyValid
*# if sellOffer does not combine then it gets put into it's own order
*# do all sellOfferPlans for all sellOffers use the same valueType/valueId (either from deliveryMethod or from sellOfferPlanDeliveryMethodLink), if not must split out
*# split sellOffers by seller and stock location
= Data model notes =
* Consider cart details transient and of low importance, no need to have record of changes
= Ideas =
* cart service could have function for testing multiple prices, find all payment methods and delivery methods offered by all sell offers in cart, then find total price for each combination (maybe also check all delivery methods ship to selected destination?)


= Working documents =
= Working documents =


[[:Category:Working_documents - Sell Offer Plan|Sell Offer Plan]]
[[:Category:Working_documents - Cart|Cart]]


[[Category:Backend services| Sell Offer Plan]]
[[Category:Backend services| Cart]]

Latest revision as of 13:17, 13 April 2023

Overview

Manages a shopping cart of sell offers prior to confirming as order/s.

Repository

https://bitbucket.org/izara-market-orders/izara-market-orders-cart

DynamoDB tables

Standard Config Table Per Service

Configuration tags

{
	configTag: "SellOfferManagerServiceName"
	configKey: "SellOfferManagerServiceName"
	configValue: xxx // eg: "SellOfferManager"
}
{
	configTag: "DeliveryMethodManagerServiceName"
	configKey: "DeliveryMethodManagerServiceName"
	configValue: xxx // eg: "DeliveryMethodManager"
}
{
	configTag: "PaymentMethodManagerServiceName"
	configKey: "PaymentMethodManagerServiceName"
	configValue: xxx // eg: "PaymentMethodManager"
}
{
	configTag: "SellOfferPlanServiceName"
	configKey: "SellOfferPlanServiceName"
	configValue: xxx // eg: "SellOfferPlan"
}
{
	configTag: "OrderGraphServiceName"
	configKey: "OrderGraphServiceName"
	configValue: xxx // eg: "OrderGraph"
}

Graph database

Service - Orders Graph

Nodes

{
	nodeLabel: "{CartPlanLib.CART_GRAPH_NODE_LABEL}", // "cart"
	schema: {
		identifier: true,
		restrictProperties: true,
		restrictRelationships: true,
		properties: {
			cartId: {
				identifier: true, // create unique id from request params and uniqueMessageId
			},
			totalQuantity: {},
			totalValue: {}, // will be in the currency of the deliveryMethod selected (sellOffer/sellOfferPlans must match deliveryMethod currency or are invalid)
			name: {},
			status: {}, // validating|valid|invalid|partiallyValid
			timeValidated: {}, // date last time validated
		},
	}
}
{
	nodeLabel: "{CartPlanLib.CART_SELLOFFERLINK_GRAPH_NODE_LABEL}", // "cartSellOfferLink"
	schema: {
		identifier: true,
		restrictProperties: true,
		restrictRelationships: true,
		properties: {
			cartSellOfferLinkId: {
				identifier: true, // create unique id from request params and uniqueMessageId
			},
			quantity: {},
		},
	}
}
{
	nodeLabel: "{CartPlanLib.CARTORDER_GRAPH_NODE_LABEL}", // "cartOrder"
	schema: {
		identifier: true,
		restrictProperties: true,
		restrictRelationships: true,
		properties: {
			cartOrderId: {
				identifier: true, // create unique id from request params and uniqueMessageId
			},
			status: {}, // processing|complete|error
			errors: {}, // array of errors found
			totalQuantity: {},
			totalValue: {}, // will be in the currency of the deliveryMethod selected (when change deliveryMethod need to re-calculate cart)
		},
	}
}

Relationships

{
	relationshipType: "{CartPlanLib.createHasCompletedCartGraphRelationshipType()}", // "hasWorking_cart"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
{
	relationshipType: "{CartPlanLib.createHasCompletedCartGraphRelationshipType()}", // "hasCompleted_cart"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
{
	relationshipType: "{CartPlanLib.createHasDeletedCartGraphRelationshipType()}", // "hasDeleted_cart"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • links a user to a cart
  • a cart can either be working, completed, or deleted
{
	relationshipType: "{CartPlanLib.createHasActiveCartGraphRelationshipType()}", // "hasActive_cart"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • all users should have one cart that is active
{
	relationshipType: "{CartPlanLib.cartPaymentMethodGraphRelationshipType()}", // "cart_paymentMethod"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • links a cart to it's current paymentMethod setting
{
	relationshipType: "{CartPlanLib.cartDeliveryMethodGraphRelationshipType()}", // "cart_deliveryMethod"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • links a cart to it's current deliveryMethod setting
{
	relationshipType: "{CartPlanLib.cartShipToAddressGraphRelationshipType()}", // "cart_shipToAddress"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • links a cart to it's current ship to address setting
{
	relationshipType: "{CartPlanLib.createHasCartSellOfferLinkGraphRelationshipType()}", // "has_cartSellOfferLink"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
{
	relationshipType: "{CartPlanLib.createCartSellOfferLinkIsSellOfferGraphRelationshipType()}", // "cartSellOfferLinkIs_sellOffer"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • Links cartSellOfferLink to one sellOffer
{
	relationshipType: "{CartPlanLib.createCarthasCartOrderGraphRelationshipType()}", // "has_cartOrder"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
{
	relationshipType: "{CartPlanLib.createCartOrderHasCartSellOfferLinkGraphRelationshipType()}", // "cartOrderHas_cartSellOfferLink"
	schema: {
		elementCanBeRemoved: true,
		allPropertiesImmutable: true,
		restrictProperties: true,
		properties: {
			originTimestamp: //timestamp the request to create/change this relationship was sent
		},
	}
}
  • links a cartSellOfferLink to a cartOrder

Cart Orders

  • One cart can have many sellOffers from many sellers, or sell offers that don't combineWins, that cannot be purchased as a single order
  • When validating split out into multiple orders according to what can be combined into a single payment/order

Grouping into orders

  • Done when validating cart
  • Go through each selloffer:
    1. does it offer the cart's paymentMethod? If not is invalid
    2. does its offer the cart's deliveryMethod? If not is invalid
    3. does the quantity chosen validate sellOffer available qty/minimum quantity? If not is invalid
    4. if no sellOffers valid then cart status is invalid. If some sellOffers invalid then cart status is partiallyValid
    5. if sellOffer does not combine then it gets put into it's own order
    6. do all sellOfferPlans for all sellOffers use the same valueType/valueId (either from deliveryMethod or from sellOfferPlanDeliveryMethodLink), if not must split out
    7. split sellOffers by seller and stock location

Data model notes

  • Consider cart details transient and of low importance, no need to have record of changes

Ideas

  • cart service could have function for testing multiple prices, find all payment methods and delivery methods offered by all sell offers in cart, then find total price for each combination (maybe also check all delivery methods ship to selected destination?)


Working documents

Cart