Chandra

@dosbiner Thanks. But I would like the catalog and search to have the products available. I just want to highlight the in stock ones, so it is easier for the customer to order.

How easy would it be to create a 'In Stock' tab similar to 'Best Sellers' and 'New Products' (that shows up if there are some actually)? I would love to move such a tab to be the first - that way a user sees only the in stock ones by default and can move to other tabs to see all products. I guess it is safe from a google indexing perspective as well. Thoughts please?

I completely agree with @RaptorX Managing products is still the more difficult areas of PS/TB day to day, and each step to improve it is going to be very productive. I have my workarounds like everyone else - google sheets with formulas to generate sql that I then execute in phpmyadmin, but they are still workarounds. For example, I can not have my employee handle it given the complexity involved. Is PS1.7 a good starting point where it is somewhat easy to update multiple products on a single screen? The solution is definitely to be discussed but my view is that this should but stop us from acknowledging the area for improvement. Thanks.

@datakick Very happy to see this shaping up. For email follow ups on recent orders, how do you plan to capture product wise ratings for multiple attributes like taste and quality?

@wakabayashi Thanks, that explains it.

Installed the module and enabled for one of the shops in multistore. Created a list in mailchimp and tried syncing to the list. It shows exporting 0/0: 100% complete and none of the users is exported. Anyone faced this issue? Thanks.

Thanks @alwayspaws @SLiCK_303 I did have custom payment methods installed and set up. It also worked correctly from the front office when a customer places an order. I now had to add a translation for 'custom payment methods' to read 'COD' and it works correctly from backoffice and in invoice. All good now. Thanks for your support.

Hi, I am using the Custom Payment Methods module and have created COD as a payment method. COD is available to customers at order time, correctly. I notice the following issue: When creating an order from backoffice by admin, COD does not appear. Instead, 'Custom Payment Methods' appears.

The first line below is the offending line 725 of referralprogram.php Is there anything obvious here? I am reading that the current versions of mysql have bigint/unsigned related changes. $friends = ReferralProgramModule::getSponsorFriend((int) $customer->id); if ($idReferralprogram = ReferralProgramModule::isSponsorised((int) $customer->id, true)) { $referralprogram = new ReferralProgramModule((int) $idReferralprogram); $sponsor = new Customer((int) $referralprogram->id_sponsor); }

Hi, I have just migrated from PS1.6 and default bootstrap that I used before works just fine. However, I would like to switch to the TB default theme to stay updated with future changes. When I switch to the community theme, the header and footer simply become too wide and the body remains in fixed width - in summary messing up the look. Is there an easy way to completely reset the site to the community theme? Thanks.

Yes Field name Type Allow nulls? Key Default value Extras id_referralprogram int(10) unsigned No Primary NULL auto_increment id_sponsor int(10) unsigned No None NULL email varchar(255) No None NULL lastname varchar(128) No None NULL firstname varchar(128) No None NULL id_customer int(10) unsigned Yes None NULL id_cart_rule int(10) unsigned Yes None NULL id_cart_rule_sponsor int(10) unsigned Yes None NULL date_add datetime No None NULL date_upd datetime No None NULL

Hi, Just migrated to TB and am getting this error when a new user account is created. Kindly give me a hand. ``` [ThirtyBeesDatabaseException] BIGINT UNSIGNED value is out of range in '(xxc_tdb.s.id_sponsor - 361)' SELECT s.* FROM ps_referralprogram s WHERE (s.id_sponsor - 361) at line 808 in file classes/db/Db.php 803. if ($webserviceCall && $errno) { 804. $dbg = debugbacktrace(); 805. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 806. } elseif (PSDEBUGSQL_ && $errno && !defined('TBINSTALLATIONIN_PROGRESS')) { 807. if ($sql) { 808. throw new PrestaShopDatabaseException($this->getMsgError().' '.$sql.''); 809. } 810. 811. throw new PrestaShopDatabaseException($this->getMsgError()); 812. } 813. } DbCore->displayError - [line 460 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 673 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 91 - modules/referralprogram/ReferralProgramModule.php] - [1 Arguments] ReferralProgramModule::getSponsorFriend - [line 725 - modules/referralprogram/referralprogram.php] - [1 Arguments] ReferralProgram->hookAdminCustomers - [line 771 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 489 - classes/Hook.php] - [3 Arguments] HookCore::execWithoutCache - [line 280 - classes/Hook.php] - [7 Arguments] HookCore::exec - [line 211 - config/smarty.config.inc.php] - [3 Arguments] smartyHook - [line 274 - config/smarty.config.inc.php] - [2 Arguments] SmartyLazyRegister->__call - [line 856 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [2 Arguments] content_5a033ff55220a7_84235799 - [line 188 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php] - [1 Arguments] Smarty_Internal_TemplateBase->fetch - [line 424 - classes/SmartyCustom.php] - [7 Arguments] Smarty_Custom_Template->fetch - [line 378 - classes/helper/Helper.php] HelperCore->generate - [line 83 - classes/helper/HelperView.php] HelperViewCore->generateView - [line 3054 - classes/controller/AdminController.php] AdminControllerCore->renderView - [line 997 - controllers/admin/AdminCustomersController.php] AdminCustomersControllerCore->renderView - [line 2420 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 244 - controllers/admin/AdminCustomersController.php] AdminCustomersControllerCore->initContent - [line 366 - classes/controller/Controller.php] ControllerCore->run - [line 743 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - admin/index.php] ```

@baarssen Thanks, I am looking to not use a module for this. This is possibly a php7.1 issue. I now successfully migrated on a php5.6 VPS and then copied over the files and db to a php7.1 VPS.

Hi, I have three shops in multistore mode (under one default group set to share stock) and I have advanced stock management enabled. The first shop is associated with one warehouse. The second shop is associated with two warehouses. The third shop is associated with three warehouses. For a given item, is it correct to expect: The first shop displays stock from the one warehouse. The second shop displays the sum of the two associated warehouses. The third shop displays the sum of the three associated warehouses. It doesn't look like it is working that way though. Any thoughts please?

Thanks @alwayspaws and hello community! Looking to have a good time with ThirtyBees.

I have made a decision to move to TB and got stuck here. Any ideas, team? I am happy to dig deeper if i have some pointers, but clicking the migrate button gives no feedback at all. Thanks.

Hi, I am trying to migrate to TB using the migration module/tool on PS 1.6.1.17 and all pre-requisites are green. However clicking the migrate button does nothing. I have tried this on a couple of different browsers and it is the same behaviour. Also tried downgrading from PHP 7.1.11 to 5.6.30, no luck either. A fresh composer install on the same server works fine, but I need to migrate an existing PS site. Is there anywhere to look for logs and trouble shoot? Apache or system logs have absolutely nothing. Thanks.