Hi all-sizes,

I had to delete completely Sellacious and make a complete reinstallation after a lot of trouble with table "doesn't exist".

After that, table #__sellacious_seller_timings was missing with this error in sellacious backend edit profile and I posted a bug report here: https://www.sellacious.com/community-support/4909-sellacious-beta3-warning-__sellacious_seller_timings-doesn-t-exist

In phpmyadmin I had to write a command sql: (replace "#_ " with your "prefix table"

CREATE TABLE IF NOT EXISTS `#__sellacious_seller_timings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seller_uid` int(11) NOT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`week_day` int(11) NOT NULL,
`from_time` time NOT NULL DEFAULT '00:00:00',
`to_time` time NOT NULL DEFAULT '00:00:00',
`full_day` tinyint(1) DEFAULT NULL,
`slot_window` int(11) NOT NULL,
`slot_window_unit` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`today_availability` time NOT NULL DEFAULT '00:00:00',
`state` tinyint(1) NOT NULL DEFAULT 1,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL,
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL,
`params` text COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__sellacious_product_seller_slot_limits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seller_uid` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`slot_from_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`slot_to_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`full_day` tinyint(1) NOT NULL,
`slot_limit` int(11) NOT NULL,
`slot_count` int(11) NOT NULL,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

and all works.

Hope this help.

I get the following error when attempting to upgrade Sellacious. I am currently on 2.0 Beta 1

Thanks

However, I would like to point out a problem: when I search for the categories to be matched on the product page, it only works by looking for the main language. It would be right that if I am looking at the backend in Italian, it would make me search in Italian (as the preview of the results shows me)

In order to improve process for assign the categories to the products, needs to add some indexes on database:

ALTER TABLE `%_sellacious_categories` ADD INDEX(`title`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`alias`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`parent_id`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`level`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`path`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`state`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`lft`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`rgt`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`mfr_id`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`type`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`is_default`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`compare`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`usergroups`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`ledgergroup`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`seller_commission`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`ledgergroup`);
ALTER TABLE `%_sellacious_categories` ADD INDEX(`commission`);

it is possible that someone is superfluous but better too many than few!

thank you

Hello All,

Sellacious latest version beta3 is released. Please download from here https://www.sellacious.com/download and update.

Thank You

By next weekend we will be releasing next beta. Which has this fixed.

Great

Thank you for your reply.

By next weekend we will be releasing next beta. Which has this fixed.

-Abhishek

Hey Abhishek,

Thank you for your reply and for your work about it.

Do you have any idea when the upcoming release will be available? In weeks or months?

Hey Tony,

Thanks for your Patience. We completed this feature. and its in our upcoming release. we added auto-complete, which will not load all thousands of categories at once, crashing the browser. Hope this helps. do get back to us if you need any further assistance.


-Abhishek

Up!!!

I made a new post title, maybe a chance to get a reply?

We are changing the UI of that commissions and changing it to load in the additional right drawer.

It is already in the top priority list.

-Abhishek
Team sellacious

Hellooooo!!!

After 2 months and a half, where are you now about it?

Thank you to make a reply!!!!

Hello Abhishek,

After 2 months and a half that I have reported it, do you have some news about it?

A reply would be appreciate...

No answer means to me that you do not care and that you are not serious at all.

Up!

It could be very interesting and very important to get a reply, and particularly about the schedule to fix this big problem

Hi Abhishek,
I guess you upgraded sellacious to more beta versions ...
is it possible to have more information on how to install these updates?
Thank you!

Hello Abhishek,

After 1 months that I have reported it, do you have some news about it?

Thank you fr your reply

Hi Abhishek,
I just became your premium user and I trusted you ...
when will the fix be ready?
I would need it urgently
Thanks

Thank you Abhishek!

We are changing the UI of that commissions and changing it to load in the additional right drawer.

It is already in the top priority list.

-Abhishek
Team sellacious

Hi Sellaciouas Team,
I analyzed the reason for the slowness and I'm almost sure it depends on the drop-down menu that allows you to filter the products by category.

Today that drop-down menu is always populated with all the records in the categories table.

The solution could be that filter should be transformed into an auto-complete field.

The 2 marketplaces that I am developing with Sellacious have few categories, so I hadn't noticed the problem, but I have 2 other marketplaces in negotiation (with high probability of leaving), with many categories, so it is important for me that this problem is solved quickly.

Thank you
Paolo