Tutorials > Customize > Use an ATP catalog
Examine the results of testing ATP catalog assets for an order
This section examines the result of the testing done in previous steps.
Continue the checkout to the Product Availability page:
Product Availability The products referred to as "Minimal ATP Item 2 Short" and "Minimal ATP Item 3 Short" will prevent you from continuing your checkout. You must first remove these items from the cart. Even though these items are buyable, they cannot be fulfilled for the order, because you have exceeded inventory (by setting quantity to 20 for each) and the backorderable function is flagged to No (storeitem.backorderable = No). Most interesting is that the order item holding "Minimal ATP Item 2 Short" has actually split to allocate 10 quantities to one entry and 10 quantities to a separate order item which now must be removed from the cart.
Continue to remove these items which have an 'availability unknown' estimated shipping date and click Next to refresh the Checkout page.
The Product Availability page now shows actual estimated shipping dates for the remaining items. The estimated shipping offset value has been set for each of these products (storitmffc.shippingoffset). The summary of data shows that these values vary in seconds.
Click Next (ship entire order) and continue to order confirmation. Make a note of the Order Confirmation number that appears on your page.
Order ResultsThe results of this order will give you an idea of how changing different ATP fields can affect your shopping flow. Here is an example of a query for a tested order result:
Query
select ORDERITEMS_ID,PARTNUM,INVENTORYSTATUS,NEEDEDQUANTITY ALLOCQUANTITY from orderitems where orders_id = 13001
ORDERITEMS_ID PARTNUM INVENTORYSTATUS ALLOCQUANTITY 65001 'ATP-0101' 'ALLC' 1000 65002 'ATP-0201' 'ALLC' 10 65004 'ATP-0401' 'BO ' 20 65005 'ATP-0501' 'BO ' 20 65006 'ATP-0601' 'ALLC' 10 65007 'ATP-0701' 'BO ' 20 65008 'ATP-0901' 'BO ' 20 65009 'ATP-1201' 'BO ' 20 65013 'ATP-0101' 'BO ' 1000 65014 'ATP-0601' 'BO ' 10
Some of the products were split into two separate order items, to represent two types of inventory status: allocated inventory (which affected the inventory tables) and unallocated inventory or back-ordered inventory. These two products, ATP-0601 and ATP-0101, each had their data set to storitmffc.releaseseparately = Yes or storitmffc.releaseseparately = null.
All other items that were added to the cart had equal results for NEEDEDQUANTITY and ALLOCQUANTITY. A more advanced inspection of the ATP system would result in unbalanced values for these two fields, which would require more investigation. However, for this tutorial, you are shown only a simple order transaction which includes different types of ATP products.
This test cannot be replicated after you have executed it once, because inventory is allocated for this product to satisfy the order request, and data is added to the orders table.
To further test these ATP products, you could update the XML and reload for more creative investigations.