papagino

If I go in "Customers" in Backoffice and use "EXPORT TO SQL MANAGER" button, then it is working fine, I am able to see or export in CSV. So the problem seems to be only when you use the "Add new SQL query" inside the SQL Manager in Backoffice to create a new query from the "List of MySQL Tables" that I get the errors. Not sure if it is a bug...

... not sure what you mean with " for a better version." but I basically need these queries: id_customer, id_shop_group, id_lang, firstname, lastname, email, newsletter, date_add

Hello people, today, I tried to use SQL Manager in the Backoffice to do an SQL query for an email campaign, but as soon as I click to view the results, I get this error : "Db::getArrray method can be used for SELECT queries only." If I try to export the query instead, I get a "This site can’t be reached" page with this error: The webpage at https://www.xxxxxxxxxxxxxxx/index.php?controller=AdminRequestSql&token=xxxxxxxxxxxxxxxxxxxxxxxxxx&id_request_sql=2&exportrequest_sql=1 might be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE Errors logs shows this: Stacktrace #0 controllers/admin/AdminRequestSqlController.php(511) #1 classes/db/Db.php(1100): () #2 controllers/admin/AdminRequestSqlController.php(511): DbCore->getArray() #3 controllers/admin/AdminRequestSqlController.php(343): AdminRequestSqlControllerCore->generateExport() #4 classes/controller/Controller.php(209): AdminRequestSqlControllerCore->initContent() #5 classes/Dispatcher.php(858): ControllerCore->run() #6 admin123/index.php(58): DispatcherCore->dispatch() I'm on Thirtybees 1.6.0 Any idea why I get this error? Any help would be appreciated Cheers,

Hello people. Being the sole operator of my online shop, meaning I am the only person having access to Thirtybees Backoffice, what would happen if I became incapacitated from an accident or worse, die from a sudden heart attack??? Visitors would still place orders for months and would never have their products shipped or delivered... This is why I was wondering if Thirtybees developers could make such a module (Dead Man Switch). Basically, it would put the shop in "Catalog mode" (All shopping features disabled) if nobody has logged in to the backoffice for X days. Also a message would show up on a top banner of the shop utilizing the Thirtybees native HTML Block module. A message should also show up on the Backoffice showing the Administrators that the "Dead Man Switch" is enabled. Another example for larger online businesses that would benefit for such module would be for example if all the Thirtybees Backoffice administrators traveled to an event and got in a bad accident/plane crash/Alien invasion (LOL...). Anybody else think that this could be a good thing to implement to Thirtybees? Any comments! Cheers,

Ok, so will Thirtybees fix this in a future release "having the connections table support for both IPv4 and IPv6 ip addresses" ?

I would like to increase traffic to my shop by posting my product catalog on Pinterest or Facebook. Is there a module that can create a catalog data source or any other way to do it with not too much trouble? Here is the formatting needed for Pinterest: Data source formatting options We support the following formats: Tab separated (TSV) Comma separated (CSV) XML (RSS 2.0, ATOM 1.0) Google Sheets Note: We accept compressed files (.zip, .giz, .gz, .bz2 and others), but we currently do not support encrypted, password-protected compressed files, or Dropbox files. Required fields Your retail catalog needs to include the following fields, formatted exactly as you see them. If they’re missing, or formatted incorrectly, your entire retail catalog will fail ingestion. id title description link image_link price availability item_group_id (only required when products have multiple variants) Any help on this would be appreciated... Cheers,

Hello people, I noticed in the last few months that when viewing my Backoffice "Current online visitors" stats, I often (daily) see visitors with IP address 0.0.0.0, why is this? Is my site being hacked? Should I block ip address 0.0.0.0 on my server side? Also, I have Matomo installed on my shop and those visitors are not/can't be tracked... Any light on this would be appreciated. Cheers,

***Beware*** Well, this explains a lot of things about this developer... https://ca.trustpilot.com/review/psitsolution.com I have since uninstalled and deleted the module from my server making sure there is no trace of it anywhere on the server... Cheers,

Update... I contacted the developer of the module and they are not interested in fixing the issues. Also, it is impossible to have the module to only create and send discount vouchers emails to selected customer groups, so in my case, I have resellers and don't want them to get discount vouchers as they already get my products and discounted price. So, I will probably uninstall the module for this reason... Cheers,

I agree on this, however, there are other options the module can create vouchers, like: - For each canceled cart (with no order), - For each validated order - For each customer raising a threshold, - For each customer who has already placed at least one order and with no orders since a given duration You can turn on and off those options in the module, so it is still good for getting back inactive customers or to thank very good customers. I contacted the developer to see if they could set the abandoned carts with your suggested, "simply add this discount voucher only for carts >0.00" Will see what happens... Cheers,

Ho Well, after double checking and deleting all empty shopping carts in the Backoffice, I can confirm that if I go back and login in my test account, Thirtybees DOES create an empty shopping cart under Customers/Shopping Carts in the Backoffice. So, the bug is in fact in Thirtybees. Can anyone replicate this? I am running Thirtybees 1.6.0 by the way...

I just noticed something, what happens in thirtybees if you create a cart, then delete the item(s) in that cart, so you basically have an empty shopping cart, would thirtybees then create an empty cart on your next log in then the "Abandoned Carts module" would create and sent out coupon emails? I just saw this feature in my Backoffice: I could see lots of abandoned carts with $0.00 inside, so I clicked on the "Delete empty carts" and "Delete carts older than 20 days" buttons to delete those empty carts. Would it be possible to create a Cron do to this automatically every so often? Cheers,

Yep, that make sense... Do you know if the "Abandoned Cart Reminder v1.0.0 - by thirty bees" is able to only be applied to selected customer groups? (I don't want my resellers/retailers to get a 10% discount every time they leave a cart open to be completed later to place an order.) Even if I set the "PS IT Thirty Bees Abandoned Carts" to "NO" for a particular group, the module still sent out emails with voucher coupons... No good... Cheers,

Hello wonderful people, I have the "PS IT Thirty Bees Abandoned Carts" module that generates a discount voucher whenever a customer canceled a cart. The problem is that whenever a customer log into their account or give a review on a product, Thirtybees interprets this as an abandoned cart and the customer receive a discount. I contacted the developer of the module and here's what they said: Can anyone confirm that this is a bug in Thirtybees and if yes, how to fix this problem. Cheers, Dan

Hello people, is there a shipping module for Canpar Canada available for Thirtybees, "ClickShip" is listed on Canpar E-Commerce Tools but how to you integrate this to Thirtybees? Any recommendation / Solutions? Cheers