Catalog entry ATP inventory

Use the CatalogEntryATPInventory keyword to load catalog entry inventory (ATP store) into your WebSphere Commerce database.

Previously, you could load this data only in CSV formatted files. You can now load information in a CSV or XML formatted input file. Your input file must contain CSV column or XML element names and definitions that specify the characteristics of the business object type you are loading into your database.

CSV column and XML element definitions

PartNumber
(String) The unique part number of the catalog entry. This field cannot be null in Insert or Replace. In Delete, either this field or the CatalogEntryUniqueId is required. The part number for a catalog entry displays in Management Center as the value for the catalog entry Code property.
CatalogEntryUniqueId
(Integer) The internal unique reference number of the catalog entry. In Delete, either this field or the PartNumber is required.
ParentPartNumber
(String) The part number of the parent product if the catalog entry is a SKU.
ParentUniqueId
(Integer) The internal unique reference number of the parent catalog entry.
Type
(String) This field defines the type of catalog entry you want to load. The values for Type are "Item, "Product", "Bundle", "Package" and "DynamicKit".
INVQuantityMeasure
(String) The unit of measurement for the NominalQuantity and QuantityMultiple of the catalog entry.
INVQuantityMultiple
(Decimal) The catalog entry can be sold in quantities that are multiples of this quantity.
TrackingInventory
(String) Indicates whether the inventory is tracked. The value can be:
  • N = Inventory is not tracked.
  • Y = Inventory is tracked.
  • E = Inventory is tracked externally.
If you do not specify this value, the default value is Y.
BackOrderable
(String) Indicates whether the item can be back ordered. The value can be:
  • N = Items cannot be backordered.
  • Y = Items can be backordered.
If you do not specify this value, the default value is Y.
ReleaseSeparately
(String) Indicates whether the order item can be released separately. The value can be:
  • N = Order Items can be released along with other Order Items.
  • Y = Order Items must be released separately (in their own boxes).
If you do not specify this value, the default value is N.
Creditable
(String) Indicates whether the merchant, without an override, can issue a credit for this item. This value can be:
  • N = Sold as-is.
  • Y = Creditable.
The requirement for the return of merchandise is evaluated separately. If you do not specify this value, the default value is Y.
ForceBackorder
(String) Indicates whether the inventory can be allocated. Can be used to temporarily suspend allocation of specified items for this Base Item. The value can be:
  • N = Inventory can be allocated (typical behavior).
  • Y = Inventory cannot be allocated, even if there is enough inventory.
If you do not specify this value, the default value is N.
ReturnNotDesired
(String) Indicates whether the return of the item is wanted, even if the customer is willing or able to return the item. For example, perishable food items. The value can be:
  • N = Request for credit is evaluated based on the intention of the customer to return the item. The customer is required to return the merchandise.
  • Y = Request for credit is evaluated as if a return is expected. The customer is not required to return the merchandise.
If you do not specify this value, the default value is N.
MinQTYForSplit
(Integer) The minimum deallocated quantity that must remain for splitting order items in inventory allocation. If you do not specify this value, the default value is 0.
PickingMethod
(String) Determines the method in which inventory is picked under this arrangement. The value can be:
  • F = FIFO (First In First Out) - the least recently received inventory.
  • L = LIFO (Last in First Out) - the most recently received inventory.
Discontinued
(String) Indicates whether the item specified is discontinued. The value can be:
  • Y = The item is discontinued. It can be ordered if there is sufficient inventory but it cannot be backordered.
  • N = The item is active and can be backordered if out of stock.
Delete
(String) Indicates whether to delete. If you are performing a delete operation, specify this column. A value of "1" indicates that the row is to be deleted.