Catalog Upload - Tiered Pricing
    • Dark
      Light
    • PDF

    Catalog Upload - Tiered Pricing

    • Dark
      Light
    • PDF

    Article Summary

    Tiered pricing data for catalog upload is described in this topic, which also includes a sample template.

    Catalog Upload - Tiered Pricing

    Full or Delta Load Accommodated

    Tiered Pricing may be a full or delta load.

    Tiered Pricing Delta Upload Behavior

    Suppliers may provide a Tiered Pricing upload file consisting of only the items that need to be updated. The behavior of a delta upload is as follows: 

    • If the sku does not exist in the system or is empty a warning should be generated and the line should be skipped
    • If the sku does exist, the tiered pricing data is added for the item. 
    • For each valid sku in the file:

      • if the product has existing tiered pricing
        • replace the existing tiered pricing with the pricing in the upload file
        • For example, if  a SKU A has 4-tiered pricing associated to it and the file has 2 tiers,  the 2 tiers in the file will now be associated to the item, replacing the 4. 
      • if the product does not have existing tiered pricing, the tiered pricing in the file is added to the product
    • A change report and an error report file is generated for Tiered Pricing Upload.

    Tiered Pricing Upload Template

    TieredPricingSample8.10.csv

    Tiered Pricing Support for Catalog-Based Pricing

    The Tiered Pricing Catalog file supports multiple prices for the same SKU. Different prices may be associated with different catalogs.  

    Each unique price/catalog combination will have its own line in the Tiered Pricing Catalog Upload file. 

    Users are shown the pricing for the catalog mapped to their Content Group. When a User has access to multiple catalogs, the lowest price is displayed. 

    The following use cases illustrate scenarios for catalog-based pricing. 

    Use Case
    SKU
    pricecatalogResult
    1 SKU, 1 catalog1231.00 USSKU "123" will be uploaded to catalog "US". If the product was tied to different catalogsit will be removed from those catalogs and will be associated to the catalog "US"
    1 SKU, Multiple catalogs1231.00EU|NASKU "123" will be uploaded to catalog "EU" and "NA". If the product was tied to different catalogsit will be removed from those catalogs and will be associated to the catalog "EU" and "NA"
    1 SKU, No catalog1231.00NULLIf no value is specified for 'catalogs', SKU "123" will be uploaded to the lowest Catalog ID. If the product was tied to different catalogsit will be removed from those catalogs and will be associated to the the lowest Catalog ID.
     
    1 SKU, 2 prices, Multiple catalogs
    requires multiple rows in the Common Fields file, one for each unique price/catalog combination 
    1231.50USSKU "123" will be uploaded to catalog  US with the price of $1.00"EU" and "NA". If the product was tied to different catalogsit will be removed from those other catalogs.
     1232.00HI|AKSKU "123" will be uploaded to catalog "HI" and "AK" with the price of 2.00.
     1233.00NYSKU "123" will be uploaded to catalog "NY" with the price of 3.00.

    Tiered Pricing Fields Details

    Column NameDescriptionRequiredSample Value
    part_numberProduct SKUYes

    A22055FC1

    from_qtyThe lowest quantity for tiered priceYes5
    priceThe tiered price valueYes12.99
    catalogThe catalog id for the price NoHI

    Tiered Pricing Validation and Change Reports

    The table below provides details on the validation and change reports generated based on file status. 

    File StatusReason (If Status is Failed)Validation Report is CreatedChange Report is Created 
    FailedA file of the same type is being processed by the system  
    Failed File failed validationY 
    FailedFile failed to be updated due to system issuesY 
    Processed Successfully YY

    Was this article helpful?