Products can be assigned multiple prices (per quantity and/or customer groups)
Is it (or will it be) possible to import products with those prices set? (I surely hope so) If so, how to specify the rules in the export/import?
Update - This seemed to be working after one import but upon updating this table: “catalog_product_entity_tier_price”, I started to get some strange results:
Whenever I update this table I truncate it and start fresh
So after truncating the table and importing my prices, I started to get unpredictable results on the front end GUI(Notice the front end pictures below - one of the products is missing 2 price tiers : 2 and 20), even though the values in the table “catalog_product_entity_tier_price” (See table rows below) are correct. As you can see I am still missing front end information from data I can see in the table.
The other very strange behvoir is that there used to be a note that comes up next t to the price on tier priced items that said “As low as $xx.xx” that never shows up anymore? What tables are influenced by tiered pricing? Something very strange is going on here......
We manage over 30,000 products and I need to understand how pricing is handled and how we are expected to import new pricing schemas (with tier prices). It also appears that the “price” field in the front end cannot be driven off of the tier pricing table - thus making it so I would have to import new pricing twice?? or import the 1-10 category to a different table?
I know that there is a lot of work being done on the dataflow modules, but will the work address any of these pricing and product import issues?
I have put a lot of stock and time into this product but I am getting concerned about some of the workflows around importing and updating products and prices as there appears to be major problems here. Could someone at Magento please comment on the present and near-future workflow for importing and updating products and prices either with the backend or with a SQL query?
I would be happy to use SQL queries to do this............ but I do not understand the magento database structure well enough to do this yet.
UPDATE: After reading through MYTECHFACTORY’s database documentation (thank you again MYTECH FACTORY!!) , I am wondering if I need to clear out indexes in order to get more predictable results. I found these lines in the DB Schema SQL:
CREATE INDEX fk_catalog_product_entity_tier_price_group ON catalog_product_entity_tier_price (`customer_group_id`);
CREATE INDEX fk_catalog_product_entity_tier_price_product_entity ON catalog_product_entity_tier_price (`entity_id`);
CREATE INDEX fk_catalog_product_tier_website ON catalog_product_entity_tier_price (`website_id`);
Are these indexes filled with rows related to tier pricing that I need to clear in order to get predictable GUI behavoir? Is there facility to clear out an index in the Admin interfaces? Or is there a SQL statement to clear these indexes? Am I on the right path? Is this all going to be a mute point with the new release this month?
I am really struggling with this. I need to be able to update pricing and do not know how to do it for a product catalog (10,000 products with tier pricing). Could someone comment on a best practice for this?
For the moment I use the tip of mytechfactory (many thanks to him for his nice video). But I agree that the possibility to import tier prices using System > Import/Export > Profiles > Import all products would be really perfect. Hope somebody will figure it out soon ! (I tried but not strong enough in programming...).
I am blown away by how many posts I’ve found on this site posted since the beginning of this year (08) requesting the ability to import tiered pricing. Has someone figured out a way / hack to get this done? Does anyone know if Magento will be adding this very powerful feature? I am completely stuck and without this seemingly obvious feature I cannot use Magento but may need to settle for a pretty crappy Peachtree - web trader approach. I do not want to go this route. Even if I have to do this myself or work with others as a team to get this done I will by all means I will! Please, anyone, if it seems like I’m begging I am. That’s how great this product is. What can we all do as a team to make this happen?