Quick Updates plugin [support]

[paulm]

Waiting...

Ok since you were waiting for it.....

Attached v1.4 to this post.

This version enables you to enter the products price including tax, and the price ex tax will be calculated and filled in (using js).

I also made preparations to add a purchase price and calculate margin (profit in %) for each product (and store these values to the database). But this part is not functional yet. I commented these additions with "// add for products_purchase_price and margin". I think it is almost complete, but I am sure some more changes will have to be made and typos need to be corrected to make it really work.

For now those preparations are all disabled so they will not intefere with the normal operation of the script.

Please test extensively and backup your database before using it on a live shop! ;-)

[a_berezin]

Thanks, paulm!

[paulm]

Your welcome Andrew :-)

About the profit/margin feature:

I was taking a look at the Profit Markup/Margin calculator by Farukh, and was wondering if it would be handy to add the same column names to the Quick Updates contribution. But unfortunately products_margin_gross_percent and products_margin_gross_dollar both are not column names I would like to use (product_cost is no problem).

So I guess it might be best to use constants to define the column names. Or even make the column names adjustable and add the definitions to the Quick Updates admin settings?

[paulm]

New version: quick_updates-v1.5

1.) Added purchase price and margin (commented with "// added for products_purchase_price and margin")
To make this products_purchase_price feature work "products_purchase_price" (i.e. DECIMAL 15,4) and "products_margin" (i.e. DECIMAL 15,2) need to be added to your products tabel.

The margin is calculated by js, and stored to the database (enables sorting on margin).

2.) Moved several inline styles and depricated styling to in document CSS

3.) Several minor corrections

[tiger]

Hi

I was just checking out this contribution and noticed that the file in admin/includes/extra_datafiles is called qucik_updates_filenames.php.

I assume this is a typo and should be quick_updates_filenames.php. Hope that's helpful...

[paulm]

Not bad though, if that's the only qurik eeh.... I mean quirk

[tiger]

- Most true!!! Just one of the few woopsies i can actually spot!

[a_berezin]

Hi paulm,
I also make some modifications. Select image from server, run html-editor to products description. May be we "left join" our work?

[paulm]

Hi Andrew,

I also make some modifications. Select image from server, run html-editor to products description. May be we "left join" our work?

Sounds like a good idea :-) I do hope however that it is possible to add your edits to "my" last version, because I did lots of edits (most of which were minor edits, but still would be quite some work to repeat).

You think that is possible/doable?

[
I had no plans to make any other major changes soon myself. Only some extra cleanup maybe and styling (coloring "important" columns and such), but there is no real need to do that now.

One feature that I would like, is the ability to insert multiple new products in one click, but it's not likely I will get to that soon.
]

So I will not do any updates to this module soon.

[paulm]

Just for the fun, I attached a screenshot of some experimental styling I was working on tonight

Note that the name input field is enlarged on ":hover" (using CSS) which makes viewing and editting easier (without the need of it taking up too much space when not hover).

Bus as I said: no plans to update soon here.