-
Posts
1,152 -
Joined
-
Last visited
-
Days Won
98
Content Type
Profiles
Forums
Gallery
Downloads
Articles
Store
Blogs
Everything posted by the.rampage.rado
-
Who is the sender? Sender is not same as SMTP authenticate username
the.rampage.rado replied to Havouza's topic in English
Did you implement the code modification datakick made for your case in the other thread? -
Who is the sender? Sender is not same as SMTP authenticate username
the.rampage.rado replied to Havouza's topic in English
Preferences->Store Contacts The email should match the email account you use to send email. This setting is multistore aware so if you have multistore you have to edit this per shop. -
Warning: cloudflare enabled Speculation rules API
the.rampage.rado replied to datakick's topic in English
One more place where you forget to clean the cache from when troubleshooting. 😄 😄 😄 Just joking. Of course if your site has thousands of visitors a day it will help, also it is useful as a first measure if somebody is trying to bring your site down. If your host is fast and your cache is working you might not see a big improvement in speed but for big sites it's a must. -
So check your thirty bees settings then. Be sure that the app is working, yes, there are unfortunately many ways you can misconfigure it (I had similar issues a while back and it was totally my fault).
-
Misconfiguration of your app or your server is not thirty bees' fault. I would strongly suggest triple checking your setup and settings and if you can't find the issue search for paid support.
-
Where set the email address orders are sent to?
the.rampage.rado replied to Havouza's topic in English
If Mail alerts was not installed you never received one admin email as this is the only transport method for those emails since the PS days. -
I was going to purchase a CGPT module but then I tried generating the descriptions myself - OK, English is 90% human, there are some quirks (it likes to use 'crafted' A LOT!, like I'm selling a diablo 2 potions or something...). But when you give it a small list of forbidden words it's OK, at times it stops using the memory and you have to give the instructions again, but it's decent. Things don't sit that well for Bulgarian, my main website language - where nearly every sentence has to be touched by human, it uses a metric ton of foreign words, that simply are not used in Bulgarian, bit it's easier to substitute 1:1 than to invert the whole sentence so it sounds humanly written. Yes, I'm using CGPT as a tool now but I read every result and if I'm not happy I touch up. If I do this with 500 products at once I will get mad fixing everything. The tool saves me time in another way - I have products from a catalog, it contains some bullet points for every product but not enough, I give the bot instructions to format this input text as I want, modify it, give me a html code in two languages, add text that is not present on every product or play according to additional input per product. Something that could not be done easily in bulk description generation.
-
thirty bees is not compatible with 1.7 modules but is compatible with the vast majority of PS 1.6 modules.
-
Is there a Deployment Best Practices Document?
the.rampage.rado replied to Obi's question in Technical help
I would not mix WP with other websites on the same hosting or subfolder. If they hack your WP they will infect your thirty bees too. Not saying that thirty bees is 100% secure but it's exposure is much much smaller so less bad-actors play with it. Otherwise you can run it in subdomain, subfolder, any way you like. SEO-wise I don't think the juice will flow differently between both cases. -
And it is supported. Regular (as much as possible) updates are made and bugs are fixed. But if we expect that this slider will be released for free and will have the functionality of a paid module with 300 kb of main php files and 500 kb of js derived from WP and many other systems.... I don't think this is realistic and should not be.
-
This is basic slider. Not everything can be implemented and come free with support, etc. Revolution was good but it does not work under php 7.4 and later (lots of warnings and notices) and for 8 it will be a nightmare. The developer is not interested in supporting thirty bees. 😕
-
Update 1.5.1 from php 7.4 to 8
the.rampage.rado replied to Derbai's question in Updating thirty bees
1. Have your shop working properly on 7.4 and make a backup (both DB and filesystem). 2. Go to Core Updater and select Target PHP version: 8.x version you want to switch to. Save. 3. Update your store at this state. It will probably break it when you refresh, don't worry. 4. Switch php versions on your server (use the version you specified in Core updater, if you don't your shop will not work as some dependencies have custom versions). 5. Open your backoffice and front office. BO should work right away. FO might have some issues (3rd party theme and modules). 6. Clear cache. 7. Fix any issues present in Collect logs module. 8. Once your shop is working on php 8.x you can once again switch Target PHP version to 'Server PHP version'. In order to revert to 7.4 simply do the opposite: 1. In Core updater - switch the target version to 7.4. Shop is again broken until you switch php versions on the server. 2. Switch php to 7.4. 3. Open BO and FO and continue (you should not see any issues if your shop worked OK before that). 4. Clear cache. 5. Again revert back to Target PHP version to 'Server PHP version' if you don't plan to play again soon and you don't want to forget about this setting. -
I think tariff will be quite a useful addition for shops selling cross-border. And If we don't want it we can simply turn it off by a switch in Preferences. Regarding BBD - yes, this might be quite a niche thing for food/medicine/pet shops, etc.
-
BBD = Best Before Date. Basically batching system when you enter stock in the shop it first draws from the quantities with the soonest expiration date and of course shows this in FO.
-
Pseudo-automation of data import (product combinations).
the.rampage.rado posted a question in Technical help
Currently I have many products that are on preorder with my shop. All of them are 0 stock for all combinations (of size and color) and I order them if from my supplier if an order comes in. The issue is that my supplier does not provide me with machine readable stock information that I can use. A workaround I tried yesterday was with CHATGPT to parse the pages and visually scan them - not good results, 20% errors. But the bot recommended a Python script - I add a bunch of pages, the code gives me a list (currently) formatted as: "REF_Nummber": [42, 42.5, 43, 44, 44.5, 46.5], with sizes. And the quality is above 98%. There are still some errors here and there but I don't care if the percentage is that high. Every product I have for this selection is only 1 color so the combinations per product are 1x N (N = number of sizes available for purchase). I want the color in the combinations so the customer can filter by it. The bad thing is that I was unable to find how I can manipulate thirty bees to sync the combinations to those values. Every combination has its own id. Even if I manage to delete unneeded combinations I still end up with the situation that one of them was default and the front end breaks (a message is thrown to the customer to select another combination). At this point I gave up on attempts to add combinations via sql as I think it will be quite hard to implement by myself. A module that can create combinations based on a list of values and save them also would be helpful! Does anybody have any clues how something similar can be achieved? Currently I have the following routine. 1. pull the available sizes in the same format as above from my install 2. pull the available sizes with my supplier 3. compare both arrays and spit out movement changes - add or delete sizes and I regenerate the combinations via the Comb. generator. This saves me 80% or more of my time but I still want to implement further automation if possible. -
Uninstall HTML Block v1.2.1 - by thirty bees if you don't plan on using it for another information in this place (the fourth column).
-
All front facing translations are in Front office translations and Installed Modules translations sections. The errors a customer can see are in Error message translations. Keep in mind that due to potential server configuration limitations thirty bees is coded that you have to click Save (or Save and Stay) on every section - so if you want to translate 2 modules - you will have to translate the first, save, then the second, etc. Same with the Front, BO and other main sections.
-
(this post will be shorter as I once wrote it to the end and mis-clicked, exiting the page and I don't have the nerves to write it once again... 😄 ) In general despite using PS for over 10 years and thirty bees since the start of the project I only discovered how powerful the SQL manager is couple months back. Using it you can make very custom queries for almost every part of your shop. Currently I use it mostly for data normalization for my products catalog but you can think of many other useful queries to load and use on daily basis. Keep in mind that those queries should be read only (I believe). Or could they be writing to the table also? 🙂 I use the following examples almost daily to speed up my manual work with the catalog. The queries could be very powerful for small/medium shops that don't do automatic import of items and all data is entered by hand to normalize the data and improve your shop appearance. Please, keep in mind that every query should be adjusted with your table prefix (in this case tb_, it's not the real one in my case, don't try to hack me! 😛) and your personal parameters - id_lang, id_category, etc. 1. Pull out all products without WHS price - if you started your shop not populating this field and later discovered that Stats module relies on it to calculate profit use this query to sift through all your products. SELECT p.id_product, pl.name FROM tb_product p LEFT JOIN tb_product_lang pl ON p.id_product = pl.id_product WHERE (p.wholesale_price IS NULL OR p.wholesale_price = 0) AND pl.id_lang = 2 -- change language here GROUP BY p.id_product; 2. Pull products associated with Home - if you don't use Featured products module to display set of products in your homepage you don't need to associate products with home category (id 2 by default). If home is the default category for products this messes up the navigation of customers and does not display the proper breadcrumbs. Better remove the association. SELECT p.id_product, p.reference, pl.name FROM tb_product p JOIN tb_category_product cp ON p.id_product = cp.id_product JOIN tb_category c ON cp.id_category = c.id_category JOIN tb_product_lang pl ON p.id_product = pl.id_product JOIN tb_product_shop ps ON p.id_product = ps.id_product WHERE c.id_category = 2 -- by default id.category for Home is 2 AND pl.id_lang = 2 -- change according to your preferred language GROUP BY p.id_product; 3. Cyrillic letters in EN language - when your default lang is Cyrillic and you forget to enter EN (or other non-Cyrillic) title of the product it is written with the same value in both languages in title/meta/images, which is not good. SELECT p.id_product, pl.name, pl.description, pl.description_short, pl.meta_title, pl.meta_description, pl.meta_keywords, pl.link_rewrite AS friendly_url, il.legend AS image_description FROM tb_product p JOIN tb_product_lang pl ON p.id_product = pl.id_product LEFT JOIN tb_image i ON p.id_product = i.id_product LEFT JOIN tb_image_lang il ON i.id_image = il.id_image AND il.id_lang = pl.id_lang WHERE pl.id_lang = 4 -- adjust to your id_lang AND (pl.name REGEXP '[А-Яа-яЁё]' OR pl.description REGEXP '[А-Яа-яЁё]' OR pl.description_short REGEXP '[А-Яа-яЁё]' OR pl.meta_title REGEXP '[А-Яа-яЁё]' OR pl.meta_description REGEXP '[А-Яа-яЁё]' OR pl.meta_keywords REGEXP '[А-Яа-яЁё]' OR il.legend REGEXP '[А-Яа-яЁё]') GROUP BY p.id_product; 4. < 50 characters in description SELECT pl.id_product, pl.id_lang, pl.description, LENGTH(pl.description) as description_length FROM tb_product_lang pl WHERE LENGTH(pl.description) < 50 -- adjust to your liking 5. < 50 characters in short description SELECT pl.id_product, pl.id_lang, pl.description_short, LENGTH(pl.description_short) as short_description_length FROM tb_product_lang pl WHERE LENGTH(pl.description_short) < 50 -- adjust to your liking 6. Products associated with a category - useful when you want to move products from one category SELECT p.id_product, p.reference, pl.name FROM tb_product p JOIN tb_category_product cp ON p.id_product = cp.id_product JOIN tb_category c ON cp.id_category = c.id_category JOIN tb_product_lang pl ON p.id_product = pl.id_product JOIN tb_product_shop ps ON p.id_product = ps.id_product WHERE c.id_category = 35 AND pl.id_lang = 2 -- adjust id_category and id_lang GROUP BY p.id_product; 7. Products without attachment files - your product must have attachment files (catalog, data sheet, some other stuff) but you forget to associate it on time? SELECT pl.id_product, pl.name FROM tb_product_lang pl LEFT JOIN tb_product_attachment pa ON pl.id_product = pa.id_product WHERE pl.id_lang = 4 -- adjust display id lang AND pa.id_attachment IS NULL GROUP BY pl.id_product; 8. Custom modules queries - in this case products that don't have associated size chart from the Warehouse size chart module: SELECT pl.id_product, pl.name FROM tb_product_lang pl LEFT JOIN tb_iqitsizeguide_product sg ON pl.id_product = sg.id_product WHERE pl.id_lang = 4 -- adjust id_lang AND sg.id_guide IS NULL GROUP BY pl.id_product; 9. Description contains XYZ string - I used it to change some table formatting that was applicable to only few products SELECT pl.id_product, pl.id_lang, pl.description, pl.description_short FROM tb_product_lang pl WHERE pl.id_lang IN (2, 4) -- change id_lang to search in the lang you need AND pl.description LIKE '%XYZ%' -- change XYZ to the string you are searching for; ...But what does the military have?! 🙂 Can you think of other useful queries? Write them down as a comment!
-
- 1
-
-
Unsupported Module Version - plus 500 Server Error
the.rampage.rado replied to Fizzwizz's topic in English
The error is due to that you currently use php 8.2 but your thirty bees is build for 7.4. If you changed the server php version - roll it back to 7.4. Update your Core updater, go to Settings and select target PHP version to 8.2, update your store, then switch back your server to 8.2. Keep in mind that if you don't know what is going on it's better to stick to 7.4 as it's more forgiving than any 8.x version as they introduce MANY changes and you will most definitely have issues with theme/non-native modules. If you have not switched the server php version - ask your hosting and tell them that your site is crashing because of the update that they probably did and ask for them to revert this or show you how to change it yourself. Regarding module updates: Go to Modules. Click "Check for update" All available updates from thirty bee's native modules will show up. Update -
If you sell different types of those (different sizes, different bases, etc.) I would configure it as follows: Attributes: Wood/base color: wood1; wood2; wood3; wood4 Mane: mane1; mane 2 Unicorn: yes, please; just normal horse Create a normal product, put base price (the lowest of all combinations if you have differences in those). Go to Combinations - use Product Combination generator Select and add all applicable attributes from all applicable attribute groups If you have some price increases for certain attribute put in the respective field to the right. Click 'Generate these combinations'. You have 16 combinations for this product. If you have sizes of this product you can make another product or add it here and also put the differences in prices for it (you will have to adjust the price increases and balance them if the different woods also have price differences).
-
Updating from 1.5.1 to Bleeding Edge Breaks Product Images
the.rampage.rado replied to Rhapsody's question in Updating thirty bees
He's now using them so it's installed, yes. Officially out of ideas! 😄 -
Updating from 1.5.1 to Bleeding Edge Breaks Product Images
the.rampage.rado replied to Rhapsody's question in Updating thirty bees
Check if mod_rewrite is on. -
Updating from 1.5.1 to Bleeding Edge Breaks Product Images
the.rampage.rado replied to Rhapsody's question in Updating thirty bees
The code looks proper. In any case there is some local issue as the regeneration and the rewrite as a whole works with at least few installations (including mine 3 production installs and 2 test installs). -
Nearly everything is possible - matter of manpower and money. 😞