Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Importing Tiered Pricing
 
bobbrodie
Sr. Member
 
Avatar
Total Posts:  132
Joined:  2008-04-02
Philadelphia, PA
 

I believe it would help a tremendous amount of people to import tiered pricing via Import/Export profiles.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mejim707
Jr. Member
 
Total Posts:  16
Joined:  2008-09-21
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
_Lobo_
Member
 
Total Posts:  35
Joined:  2008-04-10
 

This would be great! smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
chanchel
Member
 
Total Posts:  43
Joined:  2008-09-04
 

I would like this same feature.

 
Magento Community Magento Community
Magento Community
Magento Community
 
LockWire
Jr. Member
 
Total Posts:  25
Joined:  2008-04-21
 

Just a bump as I think this is a very important feature. Please have a look into it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
LAMASE
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2009-02-20
Italy
 

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.

A-B-S-O-L-U-T-E-L-Y I-M-P-O-R-T-A-N-T!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
LAMASE
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2009-02-20
Italy
 

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
“price_wholesale_100”
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.

Only for import, but is enough for the moment.

Hope this helps!

 
Magento Community Magento Community
Magento Community
Magento Community
 
shapsp
Jr. Member
 
Total Posts:  11
Joined:  2009-03-02
 

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.

I am charging $15 for this script
and more information can be found at my thread,
http://www.magentocommerce.com/boards/viewthread/195132/

Mail me at

Thank You

 
Magento Community Magento Community
Magento Community
Magento Community
 
LAMASE
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2009-02-20
Italy
 

Check it out! Completely free!

http://www.magentocommerce.com/magento-connect/LAMASE/extension/3728/tierpriceimport

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.zhan
Member
 
Total Posts:  35
Joined:  2010-10-19
 
LAMASE - 08 June 2010 12:19 AM

Check it out! Completely free!

http://www.magentocommerce.com/magento-connect/LAMASE/extension/3728/tierpriceimport

hi,LAMASE:
thanks for your good work!
would u please tell me how to use it?
thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
salik ahmed
Jr. Member
 
Total Posts:  15
Joined:  2008-08-11
Karachi
 

Hi ..

how can i shift wholesale columns in a rows coz
i have 100 of wholesalers and i need to import in a row formate ..

any help really appreciated

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top