Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

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

The default position is missing on the category page. #3179

Closed
mahesh-makwana-web-vision opened this issue Feb 13, 2024 · 7 comments
Closed

Comments

@mahesh-makwana-web-vision
Copy link

mahesh-makwana-web-vision commented Feb 13, 2024

The default sorting option is 'Position,' and we can change the default sorting option from the category page. Here, we can assign different position numbers to products, as shown below:

Gear-ID-3-Categories-Inventory-Catalog-Magento-Admin (2)

After installing the Smile module, we enabled default position sorting from the store view, but we cannot see the position column in the category grid.

Gear-ID-3-Categories-Inventory-Catalog-Magento-Admin (3)

Am I missing something, or is it a bug? Can you please help me solve this problem?

@romainruaud

@mahesh-makwana-web-vision
Copy link
Author

Hello @romainruaud

I updated the category position in the catalog_category_product table and performed reindexing and cache cleaning, but the position is still not working.
database-local-localhost-mz-catalog_category_product-phpMyAdmin-5-2-1

We have more than 10,000 products in one category, so it's not possible to update them manually for position. We have an order number for each product. I checked this link : https://github.com/Smile-SA/elasticsuite/wiki/ProductSorting#manual-product-sorting-in-categories but it didn't work.

Can you please help me?

@romainruaud
Copy link
Collaborator

Hi @mahesh-makwana-web-vision

If you want to import positions in Elasticsuite, you'll want to target the "smile_virtualcategory_catalog_category_product_position" table.

There is no column to change the position of product in admin, you should drag and drop them in the listing, by switching them from "Automatic sort" to "Manual Sort".

The "Use Default position" for a specific store view is just a mechanism to determine if you want to use the same positions at the "Default" level and at the "Store" level. It's not a way to get back the old fashioned grid.

We do not recommend setting a huge amount of products to a pinned position, that's barely unusable for the endusers, it's better to use boosts (optimizers) to create ranking rules.

Where does your positions come from ? Is this something computed from another tool ?

Regards

@borishinzer
Copy link

Sorry, but the drag'n'drop might be useful for 20-100 products, but not for thousand of products.

@romainruaud
Copy link
Collaborator

HI @borishinzer that's my point, pinning thounsands of products to fixed positions is not a proper way to do merchandising. Because you'll have permanently to come and change the positions.

We do not recommend setting a huge amount of products to a pinned position, that's barely unusable for the endusers, it's better to use boosts (optimizers) to create ranking rules.

@mahesh-makwana-web-vision
Copy link
Author

Hello @romainruaud

We use MHSI to import products with positions in category pages. You can find MHSI here: MHSI GitHub Repository.

Customers decide the positions of their products in category listings, so they import products with positions set.

To enable manual sorting for all products because we cannot change every category manually, we have two options: either modify MHSI or the Smile module.

Is there any possible way to resolve the above issue?

Thanks.

@romainruaud
Copy link
Collaborator

@mahesh-makwana-web-vision modify your import so that you push the positions into "smile_virtualcategory_catalog_category_product_position" table.

Regards

@mahesh-makwana-web-vision
Copy link
Author

Gear-ID-3-Categories-Inventory-Catalog-Magento-Admin (4)

Is there any global setting to update sorting in all categories without manual work?

@Smile-SA Smile-SA locked and limited conversation to collaborators Feb 16, 2024
@romainruaud romainruaud converted this issue into discussion #3186 Feb 16, 2024

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants