To create a support ticket, start a search

Setting up a discount


Store Commander allows you to setup sales on products very quickly wether you use the interface or the CSV import tool.

 

Using the interface

The quickest way to create a discount is to use the Specific Prices panel accessible from the Properties column.

 Select a product and open the Specific Prices panel

 If multiple products will benefit from the same discount, then select them all and refresh the Specific Prices panel

 Then click on the  icon

 A line will be created for the product IDs selected

 Enter the discount amount or percentage in the Reduction column - use % for a percentage

 Select the start and end dates (select the minute before the day in the calendar)

 Finally, refresh  the panel


This is it, the discount is now setup on all the products you selected.

Check the procedure in this video

 

 

You also have the possibility to setup a promotion from the Discount view, and using the copy/paste option. Find the detailed procedure on this article as well as on this video.

 Note that scheduled discount, non active, will not be displayed in the Discount view. Only active ones will be. Refer to this article for more detailed information. 

 

The last thing to do will be to enable the 'on sale' logo on discounted products (during sales periods).

Because this field is not linked to the Specific Prices nor Discounts, it cannot be enabled automatically. So you will need to do so manually in the interface. 

The quickest way is to display all your discounts in the Specific Prices interface (accessible from Catalog menu) and use the copy/paste option.
 

 First modify the 'on sale' to Yes on the first discount price

 Right click on the 'yes' you have just chosen and selec Copy

 Then select all the other discounted prices, or use the mass selection icon application_lightning.png

 Right click again in the same column and select Paste

 
Here you go, the 'On sale' logo is now enabled.

 

Using the CSV import

If you have hundreds of products you need to setup a discount onto, the CSV import tool will be more appropriate.

Your CSV file will include the following information:

- the product unique identifier (id_product, reference for example)

- specific price: minimum quantity

- specific price: price (for a fixed price)

- specific price: reduction (amount or percentage to apply)

- specific price: reduction type (if using a percentage) - value will be percent

- specific price: date - from date (format has to be YYYY-MM-DD hh:mm:ss)

- specific price: date - to date (format has to be YYYY-MM-DD hh:mm:ss)

 

Once the file is present in the Import interface, configure the mapping by matching your file headers with the database fields as shown on this screenshot:
 

The identification options will be (change the identifier is need be):

 

 

 

 Note that if you are working in multistore mode, id_shop_list will be required in your import.

 Also note that importing specific prices do not replace existing ones but add new ones onto the concerned products.

 


Download our dedicated Guides to learn how to manage your shop at lightning speed with Store Commander.



Related articles