You have no items in your shopping cart.

Friday, May 20, 2022 7:37:09 PM

Product Specification Attribute import - Attribute types?

Avatar

Posted: 9 months ago

#11497 Quote

progettazione.web

Posted: 9 months ago

#11497 Quote

Hello,
I'm trying to import a set of Specification attributes for products already in catalog, using the sku as key; these attribute are of the of the custom HTML type, but I don't think I'm setting the attribute type correctly. I've tried using , in the "Attribute type" column, both "Custom HTML text" and "10" (MultilineTextbox, as in here https://www.foxnetsoft.com/the-list-of-possible-values-for-import-manager ) but it updates 0 columns.

Here is my column mapping :
Column source  Column destination
sku  Key (Product Key)  
Type  Attribute type  
Attribute  SpecificationAttribute  
Value  Value

and then in my excel I have something like this for the first try:
sku  Name  Type  Attribute  Value
XYZ  FARINA   Custom HTML text  Ingredienti  <p>Lorem ipsum</p>

and for the second try:
sku  Name  Type  Attribute  Value
XYZ  FARINA   10  Ingredienti  <p>Lorem ipsum</p>

What am I doing wrong? I will also need to import a localized version of the same attributes
Avatar

Posted: 9 months ago

#11498 Quote

Support

Posted: 9 months ago

#11498 Quote

/// <summary>
    /// Represents a specification attribute type
    /// </summary>
    public enum SpecificationAttributeType
    {
        /// <summary>
        /// Option
        /// </summary>
        Option = 0,

        /// <summary>
        /// Custom text
        /// </summary>
        CustomText = 10,

        /// <summary>
        /// Custom HTML text
        /// </summary>
        CustomHtmlText = 20,

        /// <summary>
        /// Hyperlink
        /// </summary>
        Hyperlink = 30
    }


You forget about option value. Each specification attribute must have option and nopcommerce uses this option for mapping specification attributes.
Try it
sku  Name  Type  Attribute  Value Option
XYZ  FARINA   20 Ingredienti  <p>Lorem ipsum</p>  OptionName

and remember about separator.
You want to add HTML custom value in the specification attribute but you need to add option for mapping.
Avatar

Posted: 9 months ago

#11499 Quote

progettazione.web

Posted: 9 months ago

#11499 Quote

Hi, it worked! Thank you very much.
I'm having difficulties with the attribute value localization though.

I've created a new template "Localized values - Product Attribute Value", and mapped it as follows:

Sku  Key (Product Key)  
Attribute  ProductAttribute  (I've tried using both the italian and the english value)
Value  ProductAttributeValue  
Lingua  LanguageId

I've only left out "name" because I guess it refers to the product name

My XLSX is composed like this:

Sku  Attribute  Value  Lingua
FAR001001  Ingredients  <p>EN ingredients for FAR001001</p>  1
FAR001002  Ingredienti  <p>EN ingredients for FAR001002</p>  1
FAR001001  Did you know?...  <p>EN did you know for FAR001001</p>  1
FAR001002  Curiosità  <p>EN did you know for FAR001002</p>  1


The result is Success but with 0 rows updated. In this template, there no Attribute Option to map. Other localization templates don't allow to localize the attribute value, which is the only thing I need to localize

Thank you in advance,
V
Avatar

Posted: 9 months ago

#11500 Quote

Support

Posted: 9 months ago

#11500 Quote

Attribute
Do you use the primary attribute name?
Avatar

Posted: 9 months ago

#11501 Quote

progettazione.web

Posted: 9 months ago

#11501 Quote

yes, for example "Ingredienti" is the Standard specification attr. name
Avatar

Posted: 9 months ago

#11502 Quote

Support

Posted: 9 months ago

#11502 Quote

One moment.
Do you want to add localized values for
Product Attribute Value
or
Product Attribute?
Avatar

Posted: 9 months ago

#11503 Quote

progettazione.web

Posted: 9 months ago

#11503 Quote

Support wrote:
Attribute
Do you use the primary attribute name?


I want to localize the value, on the previous post I was answering this question
Avatar

Posted: 9 months ago

#11504 Quote

Support

Posted: 9 months ago

#11504 Quote

"Localized values - Product Attribute Value"

You need to set
Key,
ProductAttribute   - the plugin will sue this parameter for looking for product attribute
ProductAttributeValue   - the plugin will sue this parameter for looking for product attribute value
LocalizedValue  
LanguageID
Avatar

Posted: 9 months ago

#11505 Quote

progettazione.web

Posted: 9 months ago

#11505 Quote

Support wrote:
"Localized values - Product Attribute Value"

You need to set
Key,
ProductAttribute   - the plugin will sue this parameter for looking for product attribute
ProductAttributeValue   - the plugin will sue this parameter for looking for product attribute value
LocalizedValue  
LanguageID


I did set all these, except for LocalizedValue, which is not available in the "column destination" select
Avatar

Posted: 9 months ago

#11506 Quote

progettazione.web

Posted: 9 months ago

#11506 Quote

Any updates?
Avatar

Posted: 9 months ago

#11507 Quote

Support

Posted: 9 months ago

#11507 Quote

Key;ProductAtribute;ProductAttributeValue;Language;Name
COMP_CUST;Processor;2.2 GHz Intel Pentium Dual-Core E2200;1;Russian

Product Attribute Value has only one localized value. It name "Name". You need to add this "Name"  in mapping.
Avatar

Posted: 8 months ago

#11519 Quote

progettazione.web

Posted: 8 months ago

#11519 Quote

Hi, unfortunately still 0 rows updated. My excel is this, with the last column mapped on "Name" as you suggested:

Sku  Attribute  Value  Lingua  NomeLingua
FAR001001  Ingredients  <p>EN ingredients for FAR001001</p>  1  English
FAR001002  Ingredienti  <p>EN ingredients for FAR001002</p>  1  English
FAR001001  Did you know?...  <p>EN did you know for FAR001001</p>  1  English
FAR001002  Curiosità  <p>EN did you know for FAR001002</p>  1  English
Avatar

Posted: 8 months ago

#11520 Quote

Support

Posted: 8 months ago

#11520 Quote

Can you give me access to your nopcommerce instance?
Avatar

Posted: 8 months ago

#11521 Quote

progettazione.web

Posted: 8 months ago

#11521 Quote

Sure! At what email should I write you for the credentials and my import excel?
Avatar

Posted: 8 months ago

#11522 Quote

Support

Posted: 8 months ago

#11522 Quote

support@foxnetsoft.com

and upgrade please plugin, I want to be sure that you use the last release.
Avatar

Posted: 8 months ago

#11526 Quote

progettazione.web

Posted: 8 months ago

#11526 Quote

Hello, just checking in, have you received my email from last monday "RE: localized attribute import" to support@foxnetsoft.com?
Avatar

Posted: 8 months ago

#11529 Quote

Support

Posted: 8 months ago

#11529 Quote

Can you send me email again?
I can't find it
Avatar

Posted: 8 months ago

#11530 Quote

progettazione.web

Posted: 8 months ago

#11530 Quote

Email sent, from progettazione.web@node.coop
Avatar

Posted: 8 months ago

#11531 Quote

Support

Posted: 8 months ago

#11531 Quote

Please resend it
I found very old email at Jun 16.
Avatar

Posted: 8 months ago

#11532 Quote

progettazione.web

Posted: 8 months ago

#11532 Quote

I have already re-sent it, could it be the spam filter?

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved