Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
How to change prices for simple products within a configurable product
Andrew Owen-Price
Member
June 26, 2014 - 9:52 am
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

We hit a knowledge gap in the UE video guides for importing products using Magmi.

We sell clothing and, for some ranges, the retail price of larger sizes is higher than small sizes.

We have created configurable products for the various sizes but could not work out how to give the larger size simple products a different price ; even when the price column in the Magmi import CSV had a different price for larger products.

Finally found this knowledge base article :-

http://www.magentocommerce.com…..le-product

This brings in the concept of Associated Products – which enables the price of simple products within a configurable set to be varied (from the ‘base’ price) by either a fixed amount or a percentage.

It works find both on the Magento website and on Ebay via M2ePro … but I currently have to manually go in and adjust each product where the product price is different from the parent base price.

My question is therefore, … can you help me so that I can just import this adjustment as another column in Magmi ?

Many Thanks !

Avatar
Matthew Ogborne

Founder
June 26, 2014 - 10:06 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Andrew,

See here http://wiki.magmi.org/index.ph….._processor you can override the values on the configurable product, but needs to be in a slightly different format as shown in the examples.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Andrew Owen-Price
Member
June 26, 2014 - 12:10 pm
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

Hi Matt,

Thanks for that … its at times like this – when I read the “official” explanation of a Magento related function – that I entirely realise the real value that you and Dave are bringing to the party.

This article is clearly written in Nerd and, I think, by someone for whom English may not be their first language.

So, it will be a pain in the proverbial but I think I’m going to carry on doing manual edits … until perhaps one day, when you issue the video guide …

… because trying to understand this very clever goobledegook is beyond my meagre intellect … I think it’ll be quicker doing 500 product changes manually than trying to work this out !

Thanks, Andrew.

Avatar
Dave Furness

Founder
June 26, 2014 - 1:55 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Andrew,

You’re certainly not alone on this one, Magmi is a bit of a minefield for us non nerds :) I’m sure we will get round to a video guide on this.

Is it worth giving it a try on a test (clone) system to see if you can get it to work, without having to worry about breaking anything?

Dave

Every expert was once a beginner

Andrew Owen-Price
Member
June 26, 2014 - 2:21 pm
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

Good idea … but I’m up against the clock … so even though its tremendously tedious, its better right now to do the graft and get it done.

As soon as I see your video guide announced on IMDB, I’ll be in the front row to watch with my popcorn at the ready.

SimonY
Member
June 26, 2014 - 4:04 pm
Member Since: May 15, 2014
Forum Posts: 235
sp_UserOfflineSmall Offline

Hi Andrew,

I’ve been looking at this and I should be able to help.

1. You need an extra column in the spreadsheet called “super_attribute_pricing”
2. On the Configurable item line, NOT the simple items, add the options you want for the prices you are changing on that configurable product.

So using the examples in the magmi wiki you would have the following:-

pricing.PNGImage Enlarger

If you are not sure then maybe provide some examples of what changes you want and I can hopefully give you the correct format.

Hope that helps

sp_PlupAttachments Attachments
Andrew Owen-Price
Member
June 26, 2014 - 4:26 pm
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

Thanks for that – I’ll give that a go this evening (there’s nothing worth watching on TV anyway).

Andrew Owen-Price
Member
June 26, 2014 - 5:33 pm
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

Looks like I have probably got a syntax error … see attached ..

… doesn’t produce the desired (any) effect

SimonY
Member
June 27, 2014 - 4:30 am
Member Since: May 15, 2014
Forum Posts: 235
sp_UserOfflineSmall Offline

Hi,

Looks ok doesn’t it. Did the product actually get created?

I assume that you have got the “Configurable Item Processor” enabled in Magmi?

Only other things I can see and try is that your Size values have spaces in them, try quoting them maybe or test them without spaces.

Although it probably defaults to 0, try putting a :0 on the end.

And one other thing is that the pre-requisites state that the item attribute “Values Required” option to be set to Yes. Not sure that would make any difference, but it’s one to check to be safe.

Andrew Owen-Price
Member
June 27, 2014 - 9:09 am
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

Hi,

Before we look at this again, just thought I’d say that I’ve previously used Magmi to import lots of configurable products … but they were all of a type where the variation didn’t change the price – and I have checked Mamgi – it has the Configurable Item processor v1.3.7 box ticked OK.

Tried import again – this time putting single quote around the size in the super attribute pricing (see CSV attached).

When it is imported via Magmi, it creates the product OK but Magmi reports 70 errors and one warning … but I can’t see where to find out what is happening (see screen shot)

Magento Product List shows configurable parent product AND all child products, – the 2XL size is correctly shown as being priced at £25 (as per the CSV import) (see screenshot)MAGMI-Magento-Mass-Importer-by-Dweeves-version-0.7.18.pngImage Enlarger

Magento-Products.pngImage Enlarger

BUT when the product is viewed on Ebay or my web site … the 2XL price is displayed as £20 (see screen shot)

yours in confusion.

Sample-Ebay-Listing.pngImage Enlarger

SimonY
Member
June 27, 2014 - 11:55 am
Member Since: May 15, 2014
Forum Posts: 235
sp_UserOfflineSmall Offline

Hi Andrew,

Seems you have made progress.

It does look like the spaces in the Size were causing an issue. did you also try double quotes (“) ? Or was the single quote the only option that seemed to work?

For the price on eBay, what attribute are you using to sync across in your Price & Qty policy? Not sure why the website would also be an issue.

Simon

Andrew Owen-Price
Member
July 1, 2014 - 9:34 am
Member Since: October 22, 2013
Forum Posts: 297
sp_UserOfflineSmall Offline

I referred this problem to M2ePro support who emailed me to today to advise that its not just a Magento / Magmi problem … there are some settings that have to be set in the M2ePro Price, Quantity and Format policy that are essential to get this to work.

They have referred me to this link where the settings for “Associated Products” are explained :-

http://docs.m2epro.com/display…..-ItemPrice

I haven’t tried it yet … but I live in hope that it will actually work !!

Avatar
Dave Furness

Founder
July 1, 2014 - 5:38 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Oooo do let us know if you get it working Andrew and if that link helped.

Dave

Every expert was once a beginner

 

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:
20 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: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606