Price batch update workspace

Development Project Status: Seeking Funding

Total cost estimate: 
$4150
Current Percentage Funded: 
0.00%

Forum: http://www.openvpms.org/forum/new-forum-topic-created-user-meeting-price-update-workspace

Jira: http://jira.openvpms.org/jira/browse/OVPMS-1092

This project would create a new workspace where users could perform "batch" operations on multiple products at once.

o       Unit price updates by fixed or percentage amounts.

o       Fixed price updates by fixed or percentage amounts.

o       Filtering of the product set for batch operations by;

§         Name

§         Group

§         Type

§         Active/Deactive

§         PriceRange

o       Price updates may be entered as “Versions” so that the old prices remain visible and a price history can be seen.

Project funding: 

Public pledges can be made to this forum topic or email me directly by clicking here (link only works in the forum).
Development will not commence until fully funded.

Matt C
 

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Price batch update workspace

How do you want this to work?
I imagine it would work something like the following:

  1. The filters would be used to select the products to update.
  2. Matching products would be displayed in a table.
  3. This table would be pageable if there are too many matching products.
  4. Fixed and unit prices would be directly editable in the table.
  5. Changing a price creates a new price version, if the price existing price has been saved.
  6. Modified prices would be highlighted (e.g. cell background colour change), until saved
  7. Historical prices would be visible in dropdowns made visible by clicking the corresponding fixed/unit price cell
  8. Changing a price back to its original value (either by direct entry, selecting a historical price from a dropdown etc) would remove the 'modified' highlight.
  9. Beneath the table, would be the fields to enter batch fixed and unit price modifiers.
  10. An Apply button would apply the batch fixed/unit price changes to all products matching the filter
  11. Pressing Apply would update the prices displayed in the table
  12. Applying more than once without saving would not add create multiple price versions
  13. A Save button would save the changes
  14. A Revert button would revert all unsaved changes
  15. A Print button would print the current products being updated
  16. If other users are editing products while price changes are being performed, versioning issues may arise. Rather than aborting the edit, those products that can't be saved will be displayed in a dialog with the current version displayed. The user will be given the option to apply their price update, or skip it, for each conflict.

-Tim

Re: Price batch update workspace

Hi Tim,

Reminds me of MySQL browser and I think that would provide a very professional solution.

Love the specification personally.

Matt

Re: Price batch update workspace

I estimate there's  approximately 48 hours work there.

-Tim

Syndicate content