Plugin module bid request, utilizing product_cost & 6 level admin setup.

['Mike']

I would like to help a plugin coder build a new plugin... the only help I can offer is financial support and plugin concept.

I would like to donate for plugin that utilizes "product cost" in product table. Setup admin page for setting the name and percentage of markup times the "product cost"... for 6 levels of markup. Plugin does not require all 6 levels to be setup... ZenCart owner has option to utilize the levels as needed.

The markup level "name" can ? be utilized for "customer markup level"... customer will require a field for "price level" 1 thru 6.

A 10.00 product_cost marked up by 130% would equal 13.00 selling price, or markup @ 300% equal 30.00 sell price.

Settings should be on the Product setup page. We set the product_cost and we set the 6 level percentage for markup.

Another method would be "admin settings page" that would utilize either the cost price or the MSRP price... and utilize the product_cost for different markup percentages.. or not produce a "cost plus markup" result if price is higher or above the MSRP discounted price.

Below query (not complete) produces such results: example below:
Can submit all of query if needed.

products_price * .90 AS `'Level 1 10 off'`,     -- COMMENT: produces a 10% off the MSRP
products_price * .85 AS `'Level 2 15 off'`,     -- COMMENT: produces a 15% off the MSRP
products_price * .80 AS `'Level 3 20 off'`,     -- COMMENT: produces a 20% off the MSRP


-- COMMENT level 4 below checks the product_cost level and markup is based on cost level, and no markup is produced if higher then level 1 thru 3
CASE 
WHEN products_cost >=0.01 && products_cost <=2.00 && (products_cost * 400 / 100) <= products_price && (products_cost * 400 / 100) <= 
(products_price * .80) && 
(products_cost * 600 / 100) <= (products_price * .80)
THEN products_cost * 600 / 100
WHEN products_cost >=2.01 && products_cost <=10.00  && (products_cost * 400 / 100) <= products_price && (products_cost * 400 / 100) <= 
(products_cost * .80) 
THEN products_cost * 400 / 100
WHEN products_cost >=10.01 && products_cost <=50.00 && (products_cost * 200 / 100) <= products_price && (products_cost * 200 / 100) <= 
(products_price * .80) 
THEN products_cost * 200 / 100 
WHEN products_cost >=50.01 && products_cost <=100.00 && (products_cost * 220 / 100) <= products_price && (products_cost * 220 / 100) <= 
(products_cost * .80) 
THEN products_cost * 220 / 100 
WHEN products_cost >=100.01 && (products_cost * 180 / 100) <= products_price && (products_cost * 180 / 100) <= (products_price * .80) 
THEN products_cost * 180 / 100 
END AS `'Level 4'`,

-- COMMENT level 5 below checks the product_cost level and markup is based on cost level, and no markup is produced if higher then level 1 thru 4

CASE 
WHEN products_cost >=0.01 && products_cost <=2.00 && (products_cost * 400 / 100) <= products_price && (products_cost * 400 / 100) <= 

(products_price * .80) &&
(products_cost * 500 / 100) <= (products_price * .80)
THEN products_cost * 500 / 100
WHEN products_cost >=2.01 && products_cost <=10.00 && (products_cost * 300 / 100) <= products_price && (products_cost * 300 / 100) <= 

(products_price * .80) 
THEN products_cost * 300 / 100
WHEN products_cost >=10.01 && products_cost <=50.00 && (products_cost * 190 / 100) <= products_price && (products_cost * 190 / 100) <= 

(products_price * .80) 
THEN products_cost * 190 / 100
WHEN products_cost >=50.01 && products_cost <=100.00 && (products_cost * 180 / 100) <= products_price && (products_cost * 180 / 100) <= 

(products_price * .80) 
THEN products_cost * 180 / 100
WHEN products_cost >=100.01 && (products_cost * 150 / 100) <= products_price && (products_cost * 150 / 100) <= (products_price * .80) 
THEN products_cost * 150 / 100
END AS `'Level 5'`,


-- COMMENT level 6 below checks the product_cost level and markup is based on cost level, and no markup is produced if higher then level 1 thru 5

CASE 
WHEN products_cost >=0.01 && products_cost <=2.00 && (products_cost * 400 / 100) <= products_price && (products_cost * 400 / 100) <= 

(products_price * .80) &&
(products_cost * 400 / 100) <= (products_price * .80)
THEN products_cost * 400 / 100
WHEN products_cost >=2.01 && products_cost <=10.00 && (products_cost * 200 / 100) <= products_price && (products_cost * 200 / 100) <= 

(products_price * .80) 
THEN products_cost * 200 / 100
WHEN products_cost >=10.01 && products_cost <=50.00 && (products_cost * 150 / 100) <= products_price && (products_cost * 150 / 100) <= 

(products_price * .80) 
THEN products_cost * 150 / 100
WHEN products_cost >=50.01 && products_cost <=100.00 && (products_cost * 140 / 100) <= products_price && (products_cost * 140 / 100) <= 

(products_price * .80) 
THEN products_cost * 140 / 100
WHEN products_cost >=100.01 && (products_cost * 130 / 100) <= products_price && (products_cost * 130 / 100) <= (products_price * .80) 
THEN products_cost * 130 / 100
END AS `'Level 6'`,

All feedback welcomed... I was not sure of where this post would go... I thought plugin forum would be best. Thank you for all feedback.

[philip937]

What's the benefit? Why don't you just have a spreadsheet with all your cost prices and calculate what price you want to assign to products?

['Mike']

What's the benefit? Why don't you just have a spreadsheet with all your cost prices and calculate what price you want to assign to products?

Need a plugin method to sell at "Cost Plus" instead of "MSRP" or "MSRP Discounted". MSRP discount percentages could sometimes be less then product_cost.

I must be missing Zencart Insight... I don't understand how Zencart Owners keep their product prices updated in less then 15 minutes of worktime.

It's too time consuming to adjust MSRP and cost basis... now we must add spreadsheet time and additional calcs.????? We need a smart Zencart.....

We place a new product in Catalog/products with price, and then we update the product when additional products arrive... however, vendors will sometimes have a price increase across their complete inventory line in specific categories 2-3 times in one year, sometimes more.

And all Zencart owners need a method to automatically adjust "all product" prices by a simple admin page that will adjust prices in specific categories by percentage.

With all the Zencart owners and "Totally Zenned" users we have available... we should be "Totally Smart Zenned".

[lankeeyankee]

I do this in a matter of minutes already with easy populate. You can add new fields like msrp, map, cost price, profit percentage, etc. I then sort the sheet either by categories or manufacturer and paste in the columns of new prices. In less than 5 minutes it's done. And in my industry, rarely does a vendor/manufacturer do blanket cost increases, it's almost always individual price increases so taking their spreadsheets I can quickly and accurately change the prices.

What you are describing would be cool, but probably relatively costly to implement. I get custom coding done now that I am too busy to do it myself and I would estimate the cost by a proficient, knowledgeable coder to run $2 - 3K although it could easily be more or less.

[DivaVocals]

or you could use Quick Updates..
https://github.com/DivaVocals/zen_QuickUpdates