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
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
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.