catalog-price-rulesimportprice
Our customer is looking to supply only costs prices and markup percentage for products on Magento. For example if the product cost price is £100 and markup is 20%. He would like to import £100 and 20% into Magento rather than £120.
Is it possible? If yes, how do we import markup in Magento import CSV?
I don't think Magento has an inbuilt function to specifically exclude products already on sale through a catalog rule.
When setting up your coupon code rule use this to exclude your Product A (and other on sale products)
One other approach is to create a new category (On Sale), which you can easily keep out of the navigation menu if you do not want to display it.
Then place your product A into the category.
When setting up the coupon code rule use this to exclude the on sale category
The problem is that Magento assumes that discounts are always decreasing the price and to change this behaviour you would have to make modifications to several core files (or use proper overrides).
A practical solution to your situation would be to set the highest possible price (i.e. 120 €) as product price and use price rules to make it cheaper for everybody except those in your 120% group.
Best Answer
I'm not sure if this would fit your case but as far as I know the only way to do this with default Magento functionality is to add a product
custom optionwhich price is set to 20%.Add a custom option called markup and make it a required checkbox, add one option only or two if markup is not required and give it a percentage price of 20%.
On how to do this with your type of import I'm not sure. Not very experienced with that.