Is there anything on this? I would imagine that the Magento guys could add a way that the import function could all a user to select an option that says tier 1, tier 2, tier 3 and so forth. If the import could simply have this in the list of possible database fields I would and others should be able to import tier pricing. If people are managing product lines in external systems like MAS or peachtree, but need to publish these products online using Magento (Truly great product! Thank you open source and Magento team), it quickly becomes cumbersome and almost impossible to use Magento if people need to import major pricing changes into Magento. Please Magento team, could you find it in your hearts to add some functionality to make this possible? Thank you
After many hours spent on Magento, this is REALLY needed for many kind of store.
The one i\’m working on at the moment needs to import prices for customers and resellers… imagine to to this manually for 11.000 products (a medium DVD store!!!)
Without this feature i will stop to use Magento.
Good news! I’ve made a free extension for importing tier prices in a normal xml/csv.
I sent to magento connect, but still pending at the moment (probably tomorrow?). The extension name is “TierPriceImport” ;o)
With this extension you can create tier prices adding column like this
“price_wholesale” -> price for “wholesale” when quantity >= 1
“price_othergroup” -> price for “othergroup” when quantity >= 1
“price_othergroup_5” -> price for “othergroup” when quantity >= 5
“price_wholesale_10” -> the price for wholesale when quantity >= 10
and so on.
You can use any quantity you like and any group you have in the customer groups.
To remove a tier price just import the column with empty values.
this is really one of the most sought after features.
I was literally on this forum for like 10hrs.
i have seen various threads on api, cron jobs and of course some extensions that are overpriced.
i gave up and worked on my own script.
Of course with the help of API.
I have created a script.
And, it allows tier prices to imported extremely easily.
all you will need to do is upload my script and the csv.
csv would be simplified.
just sku, customer group, quantity and price.