The main caveat is to beware:
THE FORM IS CURRENTLY NOT SUBMITTED WHEN YOU CHANGE SORT OPTIONS OR PAGE - you will lose any updates made in the fields.
I intend to add a popup to intervene but it's not there yet.
The admin page is intended to allow bulk updates of products to support receiving deliveries, price list updates as well as reviewing stock when placing orders.
The settings allow you to choose what product data is displayed or updateable on the page. Currently if you want different configurations for different tasks you have to update the settings in the module field by field. I have some ideas about saving alternative configurations and switching them but it's non-trivial so let me know if you're interested.
Specials
- The page only supports one special per product.
- A single option for displaying / modifying specials controls the availability of 4 columns on the page for the special price, expiry, special status and delete special. When they are displayed you can change any of the product price and special fields. When they are not displayed, you can't edit the price of a product with specials either by editing it or using the bulk price update function
- The keep special percent option leads to the special price tracking changes you make to the product price
Bulk Price Updates
The field (+/-) Value or rate is for updating the product and special prices by an amount or a percentage rate. Put in the amount/percentage and then press Preview. This applies it to all applicable price fields and a ticked checkbox appears next to each updated price. If there are any you don't want to apply, uncheck that one. To cancel all, there's a cancel button where the preview was.
- If specials are not displayed, the prices of products with specials are not affected by the bulk update
- When specials are displayed, updates by amount are not permitted, only percentage updates work. Irrespective of the Keep special percent setting, the same percent adjustment is made to the special prices. If you don't want this, uncheck the box next to the special price after pressing preview.
Working With Prices Including Tax
- If you choose to work with this option, all product and special price fields are converted to values including tax for the form and then the tax is deducted again before saving the values to the database.
- If you change the tax rate for a product by changing the class, the price of the product as saved in the database will be unchanged, but on redisplaying the page the price including tax will be different.
- If you change the product price and tax class at the same time, the price without tax saved in the database will be calculated using the OLD tax class, so it's best to avoid changing both at once.
