Quick Updates plugin [support]

/me thinks about buying a ticket to Texas! :P

Thanks for the feedback :-)

I just noticed I forgot to remove some debug lines, and forgot to add two instances of the zen_update_products_price_sorter() as well (which needs to be executed when changing the master category, I think...). These are only minor issues, but of course they need to be fixed, so I will probably upload an updated version soon.

Other than that (and possible other bug fixes) I am taking a break again from this mod, I think ..... ;-)

Attached a new version to this post wich should fix the formentioned issues, and hopefully does not introduce any new issues ;-)

In the last update there is a problem. In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices. When I insert this value the script don't function, crash. I think that the problem is in the field format.

cataland:

In the last update there is a problem. In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices. When I insert this value the script don't function, crash. I think that the problem is in the field format.

It might be that he didn't realize there are possibilities of different levels of wholesale pricing. I don't know how Quick Updates functions though. I use one set of wholesale prices and its been working fine for me.

cataland:

In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices.Are you saying the wholesale prices contribution stores more than one price in one column? :shocking:

paulm:

Are you saying the wholesale prices contribution stores more than one price in one column? :shocking:

Yes. I believe you can choose 4 different levels (?). I'm not completely sure how many levels, but you can assign different levels to different wholesale customers. So you can do 5.00,6.00,7.00,8.00 and if paulm is level two, he would see $6 as his wholesale price when logged in.

I guess we should've mentioned that when we asked for your help!!!!! (i personally only use one level so it didn't occur to me :)

paulm:

Are you saying the wholesale prices contribution stores more than one price in one column? :shocking:

Yes, in the field I can put different prices split by "," and in the customer page I set if the price is the first, second or other.

craftzombie:

I guess we should've mentioned that when we asked for your help!!!!! (i personally only use one level so it didn't occur to me :)No problem, it's just that I did not expect anything like that. If I would have known I would probably not have added the code though.

An advantage is that it revealed something that should have been fixed anyway :-) Some quotes were missing at the database update code part (that is why the script crashed on the multiple wholesale prices input).

I have no plans to really support the multiple wholesale prices stuff (atm), I did add a setting to the configuration (extra_configures/quick_updates.php) file though:

  @define('QUICKUPDATES_MODIFY_WHOLESALE_PRICE_INPUT_SIZE', '6');
```it allows you to change the width of the wholesale input field, and increasing the value *might* help (a *little*) editting multiple wholesale prices.


Quote from the included version-history.txt file
> v-november-27th-2006 by Paul Mathot
> 1) converted all remaining <inputs> to zen_draw_input_field()'s
> 2) added quotes to database input/update fields (script crashed on comma input)
> 3) moved some config settings from admin/quick_updates to config files (to extra_configures/ and extra_datafiles/)
> 
> Note: some configures should actually be moved to the quick_updates admin settings sql in a next version.
> 
> Changed files (since the november-25th version) are:
> 
> admin/quick_updates.php
> admin/includes/extra_configures/quick_updates.php
> admin/includes/extra_datafiles/quick_updates.php
> 
> (so no sql changes again)

**And don't forget to always backup your database before usage! **(even better first try it on a testshop)

And if any messages occur please copy and paste the exact message when reporting it here.

I have just found this contrib, installed the latest one from November 27th, loaded fine. I have the Profit contrib by farukh. How can I turn on the functionality for margin/profit??

Hi NamSingh,

that margin/profit contribution uses column names that are different, I think it uses a column name "......_dollar" for example (if I remember well, and I am not mixing up with other contributions now ;-) ). So the column names would have to be changed to make it work.

I recently added one "dynamic" column. It's name is defined and thus can be changed easily. I might convert the margin and purchase price columns to work the same, and then it's probably easy to make it compatible with that profit/margin contribution.

Do you happen to know what the exact column names are that it uses?

ALTER TABLE products ADD products_cost DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER products_price ;
ALTER TABLE products ADD products_markup DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER products_cost ;
ALTER TABLE products ADD products_margin_gross_dollar DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER products_markup ;
ALTER TABLE products ADD products_margin_gross_percent DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER products_margin_gross_dollar ;
ALTER TABLE orders_products ADD products_cost DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER products_price ;

That is the SQL file, so:

PRODUCTS TABLE
products_cost, products_markup, products_margin_gross_dollar, products_margin_gross_percent

ORDERS PRODUCTS TABLE
products_cost

I can confirm tha above is correct as i've checked my columns and they match!

products_cost, products_markup, products_margin_gross_dollar, products_margin_gross_percentThnx, currently I am using products_purchase_price and products_margin (and thus so is quick_updates). In which products_margin is the profit percentage.

Now I assume products_margin_gross_dollar is the absolute profit (still not happy about the _dollar extension though ;-) ). But I am not sure about products_markup? Can you explain what that adds to it?

Anyway, I am willing to convert the existing products_purchase_price and products_margin, so that these are defined i.s.o. hardcoded.

Yeah American's lol. Just leave it as it's in the database. He should have used currency or amount word instead!

I think it will be great if you convert them to match the profit contrib as a lot of people use it! No point duplicating things.

This is how his contrib works:

You input the product cost and press TAB, then enter the Markup Precent and again press TAB, the Gross Margin £: field is then updated with the Gross Margin amount and likewise the Gross Margin %:

The Products Price (Net) is then also updated.

The image i have attached will explain it hopefully! Good luck

I really love this contrib all ready. Makes it so Quick lol!!

One thing i think it would really benefit from is adding the available date drop down box too. Then you can update the stock, when it's next available and done.

Just uploaded Nov 27th version but the table not rendering properly.

Also why ID instead of product name and can we change this. very disappointed so far in the functionality of this module (like it doesn't work).

Hope some one can point me in right direction here.

Cheers

Ian

NamSingh:

I really love this contrib all ready. Makes it so Quick lol!!

One thing i think it would really benefit from is adding the available date drop down box too. Then you can update the stock, when it's next available and done.
I would that too, but I am afraid I won't get to adding it myself (not soon anyway). I did not even get to making the margin and purchase price column configureable yet. Still planning to do it but........

@Ian: I looked at the screenshot and it really looks weird :shocking: I don't know what went wrong, but it looks like the file must be damaged, or maybe only a part of the sql has been loaded? The zip contains a couple of sql files for upgrading olders versions (named accordingly), and one sql file for clean installs, maybe you loaded one of the upgrade sql files?

Yes that is what I did.

So I uploaded the "quick-update" and have a better looking page.

However, if I add an amount to the +- value field, nothing happens.

What have I missed.

BTW when I try to upload the update_1_3_6 it fails (not sure if I need that).

Cheers

Ian

I am glad to hear it works now :-) (and I think I will upload it to the Zen downloads soon, since this version seems quite stable)

The update sql files are only needed if you are having an older version installed and don't want to remove your old settings (so not needed for fresh installs). The version naming is a bit confusing I think, I guess that is why you loaded the wrong one in the first place .

However, if I add an amount to the +- value field, nothing happens.

What have I missed.I must admitt I am not sure about it. It may have worked before but I never tried/tested it very well. Maybe it never worked correctly or maybe I wrecked it (:blush: ), or maybe it works in a way I don't know either. If I get time to update I might take a look at it.

I assume the idea is that you can enter a percentage and/or amount and add it to all listed prices?