Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Attribute Export: Missing "Facet internal logic" in CSV #2978

Closed
FadedOut opened this issue Jun 21, 2023 · 6 comments
Closed

Attribute Export: Missing "Facet internal logic" in CSV #2978

FadedOut opened this issue Jun 21, 2023 · 6 comments
Assignees

Comments

@FadedOut
Copy link

Preconditions

Magento Version : CE 2.4.6-p1
ElasticSuite Version : 2.11.2 (latest)
Environment : Developer mode
Third party modules :
The only module that "might" have an effect on this could be: Bss_CustomProductAttributeExport, but all other fields show properly when exporting the smile attribute values - so I don't believe this should be an issue.

Steps to reproduce

  1. Set up attributes along with smile values for said attributes
  2. Export to CSV
  3. Check CSV

Expected result

  1. The column named "facet_boolean_logic" should [I believe] have the logic chosen, OR/AND, showing. Unless that column/field does not relate to the option named "Facet internal logic"?

Actual result

  1. The column named "facet_boolean_logic" has nothing in it, all fields/values are empty.
  2. magento-smile-boolean-logic-missing

I attempted to place the following into the column fields but it didn't change the value to what I wanted (from OR to AND, vice versa).
or
and
_or
_and

@vahonc
Copy link
Collaborator

vahonc commented Jun 22, 2023

Hello @FadedOut,

Provide output or screenshot of what you have in the specified column in your DB by running this query:
SELECT * FROM catalog_eav_attribute;

BTW, normally this column should have 0 or 1 values, where 0 => OR, 1 => AND.

BR,
Vadym

@FadedOut
Copy link
Author

Hi Vadym,

I have the SQL file and turned it into CSV as well so you can decipher using both. It appears that column is missing entirely in the DB, I think.

@FadedOut
Copy link
Author

@vahonc
Copy link
Collaborator

vahonc commented Jun 23, 2023

@FadedOut,

Yeap, I don't see facet_boolean_logic column in your files. It's very strange and probably this is where you problem.

BR,
Vadym

@FadedOut
Copy link
Author

Hm well this was a fresh install of 2.4.6-p1 that I added smile elasticsuite to. So possibly something up with the install scripts?

Is there a way I can add the column so it that will function properly? Or is there a more in-depth process involved than simply adding the column.

TIA

@vahonc
Copy link
Collaborator

vahonc commented Jun 23, 2023

I will try to reproduce this on a fresh 2.4.6-p1 and elasticsuite.

BR,
Vadym

romainruaud added a commit that referenced this issue Jul 4, 2023
…-db_schema-xml-2.11-fix

Fix #2978, update db_schema.xml
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants