Hi guys, I think I posted these questions in the wrong section, so I"ll move them here…
I would like to add custom options to Product Availability such as “Please call” and “On order” .
Also, I would like to know how to use a % percent value for the product price instead of a set number..
Because lets say for example I have a cost price of $30.00 and my markup rate is 35% for that specific item, i want the product price to be automatically calculated. I am going to have approximately 7200+ items in the database, and I only want to import my products cost price from my suppliers price list. I would take me forever to update the selling prices of all those items.
it could i guess, but all of my prices are sent to me by my suppliers in excel format.. I’m selling computer products. So for many different categories of items, I have different percent values for the markup price. Lets say for example Hard drives is 25% markup…
I have 5 suppliers.. It will take a lot of work to go through all of the price lists to add a new column for “price” and have it calculate all the prices over to the net column.
In the pricelist that I get from my supplier, it contains many columns.. One for sku, cost price, description, manufacturer, stock, etc…
What i’m going to do is delete all of the extra fields so I only have 2 columns.. Sku and Cost Price. I will then do the same with the price lists that I get from my other suppliers, delete all the extra columns, then copy and paste their product list in the same list from my first supplier.. I’ll keep doing the same with all my prices lists.
So in the end, I’ll just have 1 excel file with 2 columns, Sku and Price, and all the items from all suppliers will be in this file.
Then I"ll just take the script that I have to use this file, and update the cost price fields in the database. That’s all I want to do.
I don’t want to have to go into my price list file, add another column called “price” then put in the formulas to calculate the proper percentage markups. There’s too many categories of items that all have different markup rates.
These rates will not change. The price list i get from my suppllier has EVERYTHING in one spreadsheet.. So it might have like 3000 rows.. . I don’t want to have to go and filter through those rows and manually add my percentage markups and have it calculate that into a new column. It will take too much time.
In order to do this you will have to add an Attribute to each Category called “markup” and and then right a script to apply that to each item in that Category.... I think that would be the way to do it if you can not just to in in excel with would be the best way.
The one problem, I do not think that you can add an Attribute to a Category (cant work out why not....) so, if you would that one out please let us know.
hi nafnaf, I wasn’t looking to add this to a category, but rather to each product. I did try making a new attribute for the product itself, but when I enter in a percent value, with the percent sign, nothing gets saved. It won’t except the stupid % symbol.
I guess I could try and figure out how to write a peice of code that would calculate the numbers I need, and then display that amount instead of the “price” amount, but I would have to change that in all of the pages that display the item price in the front end, and in the admin area as I’m going to be using this script to bill out customers manually..
So when I’m billing them out, and adding products to their orders, I need to see the real selling price.
not the best ting you want to do.......miss one ref somewhere and you could have problems..
I still dont get why you dont want to do it in excel, it shound not take long with the power of copy, past, drag and drop...
I’m doing it in excel because my supplier send me my price lists in excel. All together I will have about 7000+ products.. I don’t get what you mean by copy and paste.... I’m not going to copy and paste the new cost price for every single item once a week after I have the products in the database.
Does nobody know how to program the small change to the product price . I just want the product price box to be able to accept percent values (35%) and to display the selling price on the page, I just wan it to have some code that will do this ---> cost price * product price = _________
I don’t even know the basics when it comes to php, so that’s why I"m asking for help on this..
And nothing can go wrong when i’m going to be importing the new product costs once a week because the script I have matches the sku numbers and only updates the prices for those specifc sku’s.. jI’m not updating anything else for the products except for that one field.