Reference > Data load utility CSV column definitions


Catalog entry ATP inventory

Use the CatalogEntryATPInventory keyword to load catalog entry inventory (ATP store) into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.


CSV file column 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.

CatalogEntryUniqueId

(Integer) The internal unique reference number of the catalog entry. In Delete, either this field or the PartNumber is required.

ParentPartNumber

(String) This is 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 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.

TrackInventory

Indicates whether or not the inventory is tracked.

BackOrderable

Indicates whether or not the item can be back ordered.

ReleaseSeparately

Indicates whether or not the item can be released separately.

Creditable

Indicates whether or not the merchant will issue a credit for this item.

ForceBackorder

Indicates whether or not the inventory can be allocated.

ReturnNotDesired

Indicates whether or not the return of item is desired.

MinQTYForSplit

The minimum remaining unallocated quantity for splitting order items in inventory allocation.

PickingMethod

Determines the method in which inventory is picked under this arrangement.

Discontinued

Indicates whether or not the item specification has been discontinued.

Delete

(String) Indicates whether to delete. If you are performing a delete operation, specify this column. A value of "1" indicates that the row should be deleted.


+

Search Tips   |   Advanced Search