Reference > Data load utility CSV column definitions


Catalog entry calculation code

Use the CatalogEntryCalculationCode keyword to load catalog entry calculation codes into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type. There are calculation codes for different usages; the provided calculation code usages discount, shipping, sales tax, shipping tax, coupon, surcharge, and shipping adjustment


CSV file column definitions

PartNumber

(String) The unique part number of the catalog entry. Either this field or the CatalogEntryUniqueId is required.

CatalogEntryUniqueId

(Integer) The internal unique reference number of the catalog entry. Either this field or the PartNumber is required.

DiscountCalculationCode

(String) The catalog entry discount calculation code.

DiscountCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry discount calculation code.

ShipCalculationCode

(String) The catalog entry shipping calculation code.

ShipCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry shipping calculation code.

SalesTaxCalculationCode

(String) The catalog entry sales tax calculation code.

SalesTaxCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry sales tax calculation code.

ShipTaxCalculationCode

(String) The catalog entry shipping tax calculation code.

ShipTaxCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry shipping tax calculation code.

CouponCalculationCode

(String) The catalog entry coupon calculation code

CouponCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry coupon calculation code.

SurchargeCalculationCode

(String) The catalog entry surcharge calculation code.

SurchargeCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry surcharge calculation code.

ShipAdjustmentCalculationCode

(String) The catalog entry shipping adjustment calculation code.

ShipAdjustmentCalculationCodeUniqueId

(Integer) The unique reference number of the catalog entry shipping adjustment calculation code.

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