Page 1 of 1

Price calculated by entering percentage off MSRP

Posted: Sun Oct 05, 2008 1:38 pm
by draneb
I have always wanted this feature. I would like to see a field next to the price in the admin where you could enter a number for percentage off and have AbleCommerce dynamically calculate the Price based on the % off the MSRP entered. One would enter a fixed price or % off MSRP like this...

Price:______ or % off MSRP:______

With my previous shopping cart the only way to enter the price was to assign a percentage off the retail price. So after over 10 years of using that cart I have become used to pricing that way.

It would speed up the process of adding new products by so much. I do believe getting the calculator out and calculating the percentage off of the MSRP is the most time consuming part of adding a new product for me.

Certainly others use this method to calculate the Our Price (Sale Price). Is this built in somewhere and I'm just missing it?

Thank you.

Re: Price calculated by entering percentage off MSRP

Posted: Sun Oct 05, 2008 3:17 pm
by jmestep
This isn't built in, but if you enter your products using the dataport .csv , you can put the MSRP in one column of excel, with a formula in the next column to calculate your price, that would do it automatically. Then save the excel file as a .csv file. The dataport doesn't have documentation yet, so be sure you fill out all the necessary fields (there might be a list of them in another dataport post) or you will have to fix your data by hand. On the prices, make sure that you convert the columns in excel to general format if they are currency format. I didn't on one upload and ended up with 1000 products with no price.