org.torweg.pulse.component.shop.util
Class PriceUpdateController

java.lang.Object
  org.torweg.pulse.bundle.Controller
      org.torweg.pulse.component.shop.util.PriceUpdateController

public class PriceUpdateController
extends Controller

contains utilities to update the prices of ShopContents.

Editing a price list

All editing of the price list must only be made on the first sheet ("products"). The sheets "price groups" and "info" must not be modified!

The "products" sheet

Please do not change the ordering of the columns or the price list cannot be re-imported.

The columns A ("Type"), B ("ID") must not be edited. They are used to identify affected products and prices. The columns C ("Order code") and E ("Name") contain the EAN code and the product names and are included for your convenience. They are ignored during the import.

Column D ("Keywords") is used for updating the keywords of ShopContents, i.e. if the "Type" column contains a class which is ShopContent or a sub class of ShopContent.

The editable price information of the product sheet starts with column F. The information for individual prices is located in groups of two columns:

• the first column contains the prices as numeric values. The column is labelled with the name of the price group (e.g. PG 1 to PG n)
• the second column (labelled "price-id") with either the internal identifier for an existing price or the text "inherited" for variant prices which are determined by the parent product. The numeric identifiers in these columns must not be changed.

Prices which are followed by the "inherited" keyword in the next column are ignored during import. If you want to change such a price, you will have to clear the cell containing the "inherited" keyword.

Price amounts have to be numeric cells or the import will fail.

Version:

$Revision: 2026 $

Author:

Thomas Weber

Nested Class Summary

Nested classes/interfaces inherited from class org.torweg.pulse.bundle.Controller

Controller.AlwaysRun

Constructor Summary

PriceUpdateController()

Method Summary

void	getPriceList(ServiceRequest request) produces an Excel workbook with all products using the bundle and locale of the current request.
PriceUpdateResult	updatePrices(ServiceRequest request) updates prices based on a given price-list.

Methods inherited from class org.torweg.pulse.bundle.Controller

getAlwaysRun, isAlwaysRun, setAlwaysRun

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PriceUpdateController

public PriceUpdateController()

Method Detail

updatePrices

@Action(value="updateFromPriceList", generate=true, uploadAllowed=true)
@Permission(value="updateFromPriceList")
@Groups(values="ShopAdministrator")
public final PriceUpdateResult updatePrices(ServiceRequest request)

updates prices based on a given price-list.

Parameters:

request - the request

Returns:

the price update result

getPriceList

@Action(value="getPriceList", generate=true)
@Permission(value="getPriceList")
@Groups(values="ShopAdministrator")
public final void getPriceList(ServiceRequest request)

produces an Excel workbook with all products using the bundle and locale of the current request. Both Locale (parameter locale) and Bundle (parameter bundle) can be overridden. If passed as parameter shopSettingsId, it overrides bundle and locale settings.

Parameters:

request - the request