How to schedule price changes in WCS?

UPDATE: This become obsolete with FEP 6, commerce now have the date fields in the price list! =)

Here’s a regular picture of a Price List in WCS, as you can see, we have the fields:

  • Name
  • Description
  • Type (Product / Item)
  • Code
  • Minimum Quantity
  • Maximum Quantity
  • Value ( in the possible currencies of the e-commerce site)

pl

We can also add three more fields by right clicking on the Price List header, and choosing configure columns, we can add:

  • Thumbnail
  • Qualifier
  • Unique ID

lp2

Then, how should we be able to schedule offers with these fields?

The answer is: We can’t.

In the most recent version of WCS 7, Fix Pack 6 FEP 5, we can only do that through CSV upload, which allows us access to more fields. (Without customization)

Using the CSV file upload (which is the best way to manage price list data), we can set the StartDate and EndDate fields to achieve the following effect:

At 10:30

pricefromlistprice epl

 

Note that the offer Price List is empty,  the Price Rule brings the value of $50 from the List Price.

At 10:35

newprice vlpNote that the offer Price List now have a value, and  the Price Rule brings the value of $60 from the Offer Price List.

For this to happen automatically,I used the following CSV template.

Download Link: PriceList

Info Center CSV Format page

Follow the description of each field in the CSV Price List upload template:

  • PriceListUniqueId – (Optional, String) The identifier of the price list. When there is a data mapping for price list UniqueID in the price list data load configuration file, then the uniqueID is mandatory in the CSV file.
  • PriceListName – (Optional, String) The name of the price list that contains this offer. When loading an offer, you can provide either the PriceListName or the PriceListUniqueId, or both. If both of them are provided in the CSV file, the PriceListUniqueId is used to load. If neither of them are provided in the CSV file, the store’s default price list name is used to load.
  • CatentryUniqueId – (Optional, String) The unique identifier of the catalog entry that this offer is for. When loading an offer, you must provide either the CatentryPartNumber or CatentryUniqueID. If both of them are provided in CSV file, the CatentryUniqueID is used to load. If neither of them are provided in the CSV file, the offer will not load.
  • CatentryPartNumber – (Optional, String) The part number of the catalog entry that this offer is for. When loading an offer, you must provide either the CatentryPartNumber or CatentryUniqueID. If both of them are provided in CSV file, the CatentryUniqueID is used to load. If neither of them are provided in the CSV file, the offer will not load.
  • Identifier – (Optional, String) The identifier of the offer. If the identifier is not provided in the CSV file, a random identifier is generated for the offer.
  • Precedence – (Optional, Double) When more than one offer is effective at a particular time, the one with the highest precedence is used. If the precedence value is not provided in the CSV file, the default value of 0.0 is used.
  • StartDate – (Optional, Timestamp) The start of the time range during which this offer is effective. Use this format: yyyy-mm-dd hh:mm:ss.millis
  • EndDate – (Optional, Timestamp) The end of the time range during which this offer is effective. Use this format: yyyy-mm-dd hh:mm:ss.millis
  • QuantityUnitIdentifier – (Optional, String) The unit of measure for Minimum Quantity and Maximum Quantity.
  • MinimumQuantity – (Optional, Double) The minimum quantity that can be purchased in a single order under this offer.
  • MaximumQuantity – (Optional, Double) The maximum quantity that can be purchased in a single order under this offer.
  • LastUpdate – (Optional, Timestamp) The last time that the offer is updated. Use the format yyyy-mm-dd hh:mm:ss.millis
  • Description – (Optional, String) The description for this offer.
  • PriceIn*** – (Optional, Decimal) The price in each of your e-commerce currency.
  • Delete – (String) Indicates whether to delete this offer. The value 0 means do not delete. The value 1 means delete.

If you have any question about price list, please, fell free to ask in the comments.

 

7 thoughts on “How to schedule price changes in WCS?

  1. Hi Sergio, really nice article. I have to do a lot of price loads, and have never come across an article outside of the InfoCenter on it.

    One tip for if you need to update a lot of prices in one go, is to Export the Price List through the Catalog Filter and Pricing tool in Management Center –
    http://bit.ly/YSocSL;
    The main drawback I find with this though is that it doesn’t export every currency set up for a product, only certain WCS default currencies – am still looking for a way to resolve this without resorting to SQL.

  2. Hi
    I am using “IBM® Management Center for WebSphere® Commerce” to control products on our website. I have a question regarding price lists. we deal with USD/EURO/GBP and on the exported price list from the Management Centre their is no GBP option (column).

    Is there a way I can add this to the export so that I can update GBP along with USD and EUR via the csv please?

    Kindest Regards
    Ste Hyatt

    • Hello Stephen, sorry for the delay.

      Can you confirm if into your extended e-site, GBP is a valid currency?

      Dos GBP appear in product setup in catalog option?

      • Hi

        Apologies also for the delay in responding to you. It does appear to show. On the Extended Sites Catalog Asset Store the order is as follows:
        GBP|BRL|CAD|CNY|EUR|JPY|KRW|PLN|RON|RUB|TWD|USD
        Only 3 of those are in use GBP, USD, EUR.

        On the export it only exports the following columns:
        PriceInUSD|PriceInBRL|PriceInCAD|PriceInCNY|PriceInEUR|PriceInJPY|PriceInKRW|PriceInTWD

        Hope this helps.

        Kind Regards
        Ste Hyatt

Leave a Reply