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.