Getting the order product Id and order quantity

[john booth]

In uPlan, how do you get the @orderproductid and order qty?

[James Ridge]

Hi John,

I think it may depend on how you plan to use OrderProductID and the order quantity.

Here is how we get OrderProductID from uStore to then use in uPlan and output in an email or PURL web page:

• In the plan file, create a Text ADOR called OrderProductID and set it as a Campaign Dial.
• Set up a product on uStore which uses this plan file.
• In the product's Customization Wizard settings, move the OrderProductID ADOR across to the be a Campaign Dial and click 'Edit'.
• It doesn't need to be visible to the customer (in terms of being able to edit its value) so make sure 'Visible to Customer' is unchecked.
• Select 'Get Order Properties' as the Input Control type.
• Make sure 'Take Values from Predefined Value/s:' is checked.
• Select 'Order Item ID' (which is OrderProductID) as the Property type.This link has further details: https://help.xmpie.com/uStore/Latest/Help/en/index.htm#t=Product_Profiles%2FGet_Order_Properties.htm
• Save the dial.
• You should now be able to use the OrderProductID ADOR from the plan file in documents, emails, web pages etc to display the OrderProductID value when an order has been placed.

Sorry, I don't have an example for order quantity so hopefully someone can help here.

Thanks,

James

[west-digital.fr]

The order quantity is certainly stored in the [TotalQuantity] field of the [OrderProduct] table in the uStore SQL DB.

I would try creating a Dial Variable in uPlan, then a related hidden Dial in uStore, bound to a SQL query (with the "Override existing value (may override a value selected by the shopper and in reordering)" and "Take Values from Data Source" options). 

Now, I do not know, what you want to do with this information, but as the "Quantity" will certainly be specified by the uStore User in the OrderFinalStep page only, I would not hope that the value in uPlan is accurate, until the User reaches this step.

In other words: the value should be the wrong one in the Customization Wizard, as it is located *before* the OrderFinalStep in the user journey.

west-digital.fr