Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Configurable products (magento attribute_id issue)
David Robb

Not so New
January 5, 2015 - 9:27 am
Member Since: January 4, 2015
Forum Posts: 4
sp_UserOfflineSmall Offline

Hi Matt and Dave,
I am trying to load multiple variation products.
simple products are loaded successfully but configureable products are not loading.
I would be grateful if you help me in this.
I have uploaded my csv file here.
I am uploading 3 colors & 12 sizes with each

Error detail is:
error 1:SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – INSERT INTO `catalog_product_super_attribute` (`product_id`,`attribute_id`,`position`) VALUES (?,?,?)
error 2:SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – ERROR ON RECORD #37
warning:Skus imported KO:1/37

Warning:

error:1:SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – INSERT INTO `catalog_product_super_attribute` (`product_id`,`attribute_id`,`position`) VALUES (?,?,?)
error:2:SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – ERROR ON RECORD #37
warning:Skus imported KO:1/37

Kindly help me to sort this issue.

Avatar
Matthew Ogborne

Founder
January 5, 2015 - 9:38 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi David,

Just taken look, hmmmm…… that looks good on first glance, will dig deeper and be back to you.

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

Avatar
Matthew Ogborne

Founder
January 5, 2015 - 9:51 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi David,

I’ve been through the headers and they appear to be correct.

Some daft questions:

1. Do the attributes “config_shirt_newcolor” and “config_newsize” actually exist? (note this is their internal codes at the top)
Catalog > Attributes > Manage Attributes

2. Are these attributes setup to be used for configurable products?
Catalog > Attributes > Manage Attributes > Select the attribute > Is the checkbox set for this?

3. In the attribute set “multivariation”, do you have the attributes “config_shirt_newcolor” & “config_newsize” assigned?
Catalog > Attributes > Manage Attribute Sets > Select the “multivariation” set and confirm that they are in in the middle pane

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

David Robb

Not so New
January 5, 2015 - 10:04 am
Member Since: January 4, 2015
Forum Posts: 4
sp_UserOfflineSmall Offline

Hi matt,
Answers are as follows

I’ve been through the headers and they appear to be correct.

Some daft questions:

1. Do the attributes “config_shirt_newcolor” and “config_newsize” actually exist? (note this is their internal codes at the top)

[internal codes are newcolor and newsize] by mistake in the csv file I sent you _shirt is extra please ignore this. Actual header is “config_newcolor” and “config_newsize” and in the internal code config_ is not there in magento….

Catalog > Attributes > Manage Attributes

2. Are these attributes setup to be used for configurable products?

Yes

Catalog > Attributes > Manage Attributes > Select the attribute > Is the checkbox set for this?

3. In the attribute set “multivariation”, do you have the attributes “config_shirt_newcolor” & “config_newsize” assigned?

Catalog > Attributes > Manage Attribute Sets > Select the “multivariation” set and confirm that they are in in the middle pane

Yes they are assigned to multivariation

Another thing if I use the default import export tool for configurable products it works fine but I like your guide and want to use the same way through miagmi….

David Robb

Not so New
January 5, 2015 - 10:44 am
Member Since: January 4, 2015
Forum Posts: 4
sp_UserOfflineSmall Offline

Hi matt,
I got the thing sorted with the help of your previous reply.

issue was config_newcolor…… and my internal attribute was just “newcolor”
I just removed config_ and it worked for me…..

but now I am getting another issue….
as you can see I have different prices for some specific sizes like XX-Large, then XXX-Large and XXXX-Large in the csv file, they are loaded as I need (in admin panel prices are visible properly like parent product price is 24 and xx-large shows 26 then xxx-large shows 28 and xxxx-large shows 30.

but at front end when we select the size it is not changing the price.

If we add the products manually it shows the prices according to the size.

Please advise.

BigBlack

Not so New
August 23, 2015 - 4:55 pm
Member Since: August 7, 2015
Forum Posts: 5
sp_UserOfflineSmall Offline

Hi guys,
I’ve the same problem here. I’ve tryed too many change searching all forums but still have the attribute_id error for all my configurable products:
SKU 3415-sr2pobsve – 1 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null –
SKU 3415-sr2pobsve – 2 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – ERROR ON RECORD #3
SKU 3412-sr1pobsvesucocsepobsinin – 3 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null –
SKU 3412-sr1pobsvesucocsepobsinin – 4 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – ERROR ON RECORD #6
SKU 3409-sr1pobsvesupobsinin – 5 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null –
SKU 3409-sr1pobsvesupobsinin – 6 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null – ERROR ON RECORD #9
etc….

I attache my csv, hoping that you can help me to understand where I’m wrong.
Thank you guys!

BigBlack

Not so New
August 23, 2015 - 7:38 pm
Member Since: August 7, 2015
Forum Posts: 5
sp_UserOfflineSmall Offline

Ok I found the problem… were the ” in the configurable_attributes and super_attributes_pricing columns. Now sku are well associated.
Thank you!

Avatar
Dave Furness

Founder
August 24, 2015 - 10:41 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Glad you got it sorted :)

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:
18 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: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606