I need to add group pricing to around 1200 products, so that when my Wholesale customers login to the site they see discounted prices on certain items.
Magmi is importing my CSV, however, it’s not pulling in the group pricing.
What am I missing? What should the column headers be for this data import? And, are there any specific Magmi settings that I need to change.
NOTE: We have added the Group Pricing extension to Magmi, but I believe the group price functionality is already ‘baked into’ our version of Magmi. When I try to import my CSV with the Group Pricing Processor ticked, it prevents my CSV from uploading, presumably because it’s unnecessary and causes a conflict. The text below show what happens when I try to improt the CSV with the Group Pricing Processor ticked
error 1Smiley FrustratedQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”.mage_catalog_product_entity_group_price.’ WHERE entity_id = ‘18896’; AND custo’ at line 1 – DELETE FROM ‘.mage_catalog_product_entity_group_price.’ WHERE entity_id = ?; AND customer_group_id IN (2) AND website_id IN (0)
error 2Smiley FrustratedQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”.mage_catalog_product_entity_group_price.’ WHERE entity_id = ‘18896’; AND custo’ at line 1 – ERROR ON RECORD #1
warningSmiley Frustratedkus imported KO:1/1
Skus imported OK:0/1
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606