Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Magmi group pricing - won't import
annalisa

Excellent
October 11, 2018 - 2:24 pm
Member Since: February 9, 2018
Forum Posts: 15
sp_UserOfflineSmall Offline

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.

I am using Magento ver. 1.9.3.10 and Magmi version: 0.7.18. I have tried various column headers, as per the attached image.

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[42000]: 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[42000]: 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/1GroupPricingSpreadsheetIssues.JPGImage Enlarger

sp_PlupAttachments Attachments

 

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.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
26 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5215

Posts: 27469

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606