[Skip to main content](#vessel-content) Board Categories Mass Actions ## # [Mass Actions](/forum/44-mass-actions "View Category 'Mass Actions'") 346 topics | Everything about the powerful Hikashop mass action tool | |---| ## | [ ](#forumbottom) | Subject | Replies / Views | Last Post | |---|---|---|---| | [](/forum/44-mass-actions/100000077-order-sorting-disfunctional) | [Order sorting disfunctional](/forum/44-mass-actions/100000077-order-sorting-disfunctional "-- HikaShop version -- : 6.7.1 -- Joomla version -- : 6.2.0 -- Browser(s) name and version -- :  Firefox 157.0 Below is how I've got the sorting order to meet AustPost default label. Looks 100% to me What the CSV received contains which doesn't match What am I stuffing up this time? :wink:") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 week 1 day ago, by [yerg55](/forum/user/60833-yerg55 "View yerg55's Profile") [Last Post](/forum/44-mass-actions/100000077-order-sorting-disfunctional#100000385 "Hi, You set it up correctly: this is a bug in HikaShop. In the order export, the address columns are split into shipping_address_... and billing_address_... columns, and the "Column order and labels" list did not recognise them. They were added after your other columns in their default order, which is why the email comes first, and the labels you type for them were ignored. We fixed it on our end. Download the install package of HikaShop on our website and install it on yours in order to get the patch. No need to change your mass action: run it again. The file will then start with the shipping first name, last name, street, city, post code, state and telephone, then the email, in the order you set, with your labels. The billing address columns still come at the end of each line, in the same order. Your AustPost import should be able to ignore them.") 1 week 19 hours ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:61 | [Last Post](/forum/44-mass-actions/100000077-order-sorting-disfunctional#100000385 "Hi, You set it up correctly: this is a bug in HikaShop. In the order export, the address columns are split into shipping_address_... and billing_address_... columns, and the "Column order and labels" list did not recognise them. They were added after your other columns in their default order, which is why the email comes first, and the labels you type for them were ignored. We fixed it on our end. Download the install package of HikaShop on our website and install it on yours in order to get the patch. No need to change your mass action: run it again. The file will then start with the shipping first name, last name, street, city, post code, state and telephone, then the email, in the order you set, with your labels. The billing address columns still come at the end of each line, in the same order. Your AustPost import should be able to ignore them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 week 19 hours ago | | [](/forum/44-mass-actions/910797-colonne-de-la-massaction) | [colonne de la massAction](/forum/44-mass-actions/910797-colonne-de-la-massaction "-- HikaShop version -- : 6.6.0 -- Joomla version -- : 6.1.3 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Brave Bonjour, avant la mise à jour pour hikaShop 6.6.0, quand je faisais une massAction j'avais ces trois colonnes : item1_order_product_price item1_order_product_quantity item1_order_product_tax maintenant elles n'y sont plus... mais dans ma massAction j'ai bien coché: order_product_price order_product_quantity order_product_tax est-ce que je dois changer un réglage quelque part ? Cordialement, Nicolas") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 month 4 weeks ago, by [sl1200mk2](/forum/user/44915-sl1200mk2 "View sl1200mk2's Profile") [Last Post](/forum/44-mass-actions/910797-colonne-de-la-massaction#373283 "ça fonctionne bcp mieux, merci ++") 1 month 4 weeks ago by [sl1200mk2](/forum/user/44915-sl1200mk2 "View sl1200mk2's Profile") | Replies:2 Views:272 | [Last Post](/forum/44-mass-actions/910797-colonne-de-la-massaction#373283 "ça fonctionne bcp mieux, merci ++") by [sl1200mk2](/forum/user/44915-sl1200mk2 "View sl1200mk2's Profile") 1 month 4 weeks ago | | [](/forum/44-mass-actions/910775-declencheur-webhook-de-mass-action) | [Déclencheur webhook de mass action](/forum/44-mass-actions/910775-declencheur-webhook-de-mass-action "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.3 -- PHP version -- : 8.3 Bonjour, tout d'abord je tiens à préciser que ce retour à été écrit à l'aide de Claude IA. HikaShop 6.5.2, Joomla 6.1.3, PHP 8.3, LiteSpeed. Le déclencheur « On HTTP request (webhook) » d'une mass action sur la table order rencontre trois problèmes. hikashopmassaction.php ligne 357 compare l'endpoint à $_SERVER. Avec la réécriture d'URL SEF standard, PATH_INFO est vide et l'endpoint renvoie un 404 Joomla. Il faut appeler /index.php/mon-endpoint au lieu de /mon-endpoint, ce que l'aide à l'écran ne laisse pas deviner. Ligne 366, la vérification fait $headers sur le retour de getallheaders(), sans repli sur $_SERVER ni sur $_GET — contrairement à la branche MCP lignes 236-238 qui, elle, les prévoit. Sous LiteSpeed, la clé n'est jamais reconnue. Une fois l'authentification passée et « Load element data » coché, l'exécution échoue sur SQL 1146 : Table 'xxx_hikashop_' doesn't exist — le suffixe de table est vide, le contexte n'est pas transmis dans cette branche. Cordialement, Nicolas") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 2 months 1 week ago, by [sl1200mk2](/forum/user/44915-sl1200mk2 "View sl1200mk2's Profile") [Last Post](/forum/44-mass-actions/910775-declencheur-webhook-de-mass-action#373157 "Bonjour, Merci pour ce rapport, les trois points sont confirmés, reproduits ici et corrigés. Ils partaient tous du même bout de code et se cumulaient. Pour le chemin : c'est bien PATH_INFO qui était lu, et il est vide dès que la réécriture d'URL de Joomla est active. L'aide à l'écran annonce pourtant l'adresse sans index.php, donc c'est le code qui avait tort, pas l'aide. Les deux adresses fonctionnent maintenant, avec ou sans réécriture, et cela vaut aussi pour l'adresse du point d'entrée MCP qui avait exactement la même limite. Pour la clé : au delà de l'absence de repli, le tableau rendu par getallheaders() garde la casse envoyée par le client, et la lecture était faite sur la casse exacte "X-API-KEY". Un client envoyant "X-Api-Key" était donc refusé, ce que nous avons reproduit sur Apache, ce n'est donc pas propre à LiteSpeed. Toute casse est acceptée désormais, avec un repli sur $_SERVER quand getallheaders() n'existe pas. La comparaison se fait aussi à temps constant, et la clé n'est plus recopiée dans le journal. Pour le SQL 1146 : la variable qui porte le nom de la table n'était affectée qu'à l'intérieur du bloc qui traite le paramètre de tri, et elle était utilisée en dehors. Sans paramètre "order" dans la requête, le nom de table partait vide. En passant ?order=une_colonne la requête aboutissait. C'est maintenant corrigé. Un point sur votre chemin d'endpoint : il doit commencer par une barre oblique, /mon-endpoint et non mon-endpoint, sinon la comparaison échoue et vous obtenez un 404 même une fois le reste corrigé. Téléchargez le paquet d'installation d'HikaShop sur notre site et installez-le sur le votre pour avoir les différents patchs.") 2 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:246 | [Last Post](/forum/44-mass-actions/910775-declencheur-webhook-de-mass-action#373157 "Bonjour, Merci pour ce rapport, les trois points sont confirmés, reproduits ici et corrigés. Ils partaient tous du même bout de code et se cumulaient. Pour le chemin : c'est bien PATH_INFO qui était lu, et il est vide dès que la réécriture d'URL de Joomla est active. L'aide à l'écran annonce pourtant l'adresse sans index.php, donc c'est le code qui avait tort, pas l'aide. Les deux adresses fonctionnent maintenant, avec ou sans réécriture, et cela vaut aussi pour l'adresse du point d'entrée MCP qui avait exactement la même limite. Pour la clé : au delà de l'absence de repli, le tableau rendu par getallheaders() garde la casse envoyée par le client, et la lecture était faite sur la casse exacte "X-API-KEY". Un client envoyant "X-Api-Key" était donc refusé, ce que nous avons reproduit sur Apache, ce n'est donc pas propre à LiteSpeed. Toute casse est acceptée désormais, avec un repli sur $_SERVER quand getallheaders() n'existe pas. La comparaison se fait aussi à temps constant, et la clé n'est plus recopiée dans le journal. Pour le SQL 1146 : la variable qui porte le nom de la table n'était affectée qu'à l'intérieur du bloc qui traite le paramètre de tri, et elle était utilisée en dehors. Sans paramètre "order" dans la requête, le nom de table partait vide. En passant ?order=une_colonne la requête aboutissait. C'est maintenant corrigé. Un point sur votre chemin d'endpoint : il doit commencer par une barre oblique, /mon-endpoint et non mon-endpoint, sinon la comparaison échoue et vous obtenez un 404 même une fois le reste corrigé. Téléchargez le paquet d'installation d'HikaShop sur notre site et installez-le sur le votre pour avoir les différents patchs.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 1 week ago | | [](/forum/44-mass-actions/910203-mass-action-products-access-level) | [Mass Action Products Access Level](/forum/44-mass-actions/910203-mass-action-products-access-level "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.14 -- PHP version -- : 8.2.30 Hi, i need to remove the access level "Public" privilege on all products while keeping privilege to all other profiles. I'm turning around for quite a while now but can't find the way how so far. Thanks in advance for your help") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 7 months 1 week ago, by [Pgva](/forum/user/34261-pgva "View Pgva's Profile") [Last Post](/forum/44-mass-actions/910203-mass-action-products-access-level#371472 "Works perfectly for me. Thanks for your support and sorry for late feedback, i was away from the office for couple of weeks.") 6 months 3 weeks ago by [Pgva](/forum/user/34261-pgva "View Pgva's Profile") | Replies:2 Views:439 | [Last Post](/forum/44-mass-actions/910203-mass-action-products-access-level#371472 "Works perfectly for me. Thanks for your support and sorry for late feedback, i was away from the office for couple of weeks.") by [Pgva](/forum/user/34261-pgva "View Pgva's Profile") 6 months 3 weeks ago | | [](/forum/44-mass-actions/910226-actionsbutton-permission-error) | [Actions’button -> permission error](/forum/44-mass-actions/910226-actionsbutton-permission-error "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 5.4.4 -- PHP version -- : 8.3 Hi, A customer with admin status (not Super Admin) can no longer perform any action in administrator/index.php?option=com_hikashop&ctrl=product. Although they can select a few products, click the ‘Actions’ button in the toolbar, enter the parameters in the popup, and click ‘Process,’ the following error message appears: 'Warning You don't have permission to access this. Please contact a website administrator if this is incorrect.' With Super Admin rights, I can perform this function myself. In administrator/index.php?option=com_hikashop&ctrl=config#config_acl, the ‘Administrator’ group has all permissions for products and mass actions. Is this a bug in the current version, or is there a setting that could prevent this action from occurring? Regards Stefan") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 7 months 1 day ago, by [smart web](/forum/user/52782-smart-web "View smart web's Profile") [Last Post](/forum/44-mass-actions/910226-actionsbutton-permission-error#371187 "Thank you for your detailed and clear explanation. After adjusting the permissions in administrator/index.php?option=com_config&view=component&component=com_hikashop, the permission settings in...") 7 months 18 hours ago by [smart web](/forum/user/52782-smart-web "View smart web's Profile") | Replies:2 Views:361 | [Last Post](/forum/44-mass-actions/910226-actionsbutton-permission-error#371187 "Thank you for your detailed and clear explanation. After adjusting the permissions in administrator/index.php?option=com_config&view=component&component=com_hikashop, the permission settings in...") by [smart web](/forum/user/52782-smart-web "View smart web's Profile") 7 months 18 hours ago | | [](/forum/44-mass-actions/910172-mass-action-timing-out) | [Mass action timing out](/forum/44-mass-actions/910172-mass-action-timing-out "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 6.0.3 -- PHP version -- : 8.3.30 -- Browser(s) name and version -- : Opera One(version: 112.0.5197.30) -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 3699 Timeout exceeded in regular expression match. Hi, we're running a simple regex to find a short string in our product description and add 'True'/'False' to a custom field (see attached). We need this to filter out certain products before submitting our product list to google. This has always worked in the past and no major changes have been made to the site (php version was updated recently). It has an 8000 upper limit but we have tested '1000' as an upper limit with the same result (below). Further, the timeout happens very quickly. Any suggestion on how to investigate or fix this. An error has occurred. 3699 Timeout exceeded in regular expression match. Thanks, Ian and Stu") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 7 months 3 weeks ago, by [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") [Last Post](/forum/44-mass-actions/910172-mass-action-timing-out#370751 "Hi, The issue comes from your regex pattern .*s3.*. In MySQL, REGEXP already matches anywhere in the string, so the .* on both sides is redundant. It forces the regex engine to consume the entire description text and then backtrack through it, which on long HTML descriptions triggers MySQL's regex timeout. That's why changing the limitation from 8000 to 1000 didn't help because the timeout happens on individual product descriptions, not on the total number of products processed. Your workaround of switching to a non-regex search method was the right call. The CONTAINS operator translates to a SQL LIKE query which is much more efficient for simple text searches like this. If you ever need REGEXP specifically, just use s3 as the pattern instead of .*s3.* It does the same thing without the backtracking issue.") 7 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:418 | [Last Post](/forum/44-mass-actions/910172-mass-action-timing-out#370751 "Hi, The issue comes from your regex pattern .*s3.*. In MySQL, REGEXP already matches anywhere in the string, so the .* on both sides is redundant. It forces the regex engine to consume the entire description text and then backtrack through it, which on long HTML descriptions triggers MySQL's regex timeout. That's why changing the limitation from 8000 to 1000 didn't help because the timeout happens on individual product descriptions, not on the total number of products processed. Your workaround of switching to a non-regex search method was the right call. The CONTAINS operator translates to a SQL LIKE query which is much more efficient for simple text searches like this. If you ever need REGEXP specifically, just use s3 as the pattern instead of .*s3.* It does the same thing without the backtracking issue.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 months 3 weeks ago | | [](/forum/44-mass-actions/909988-null-values-in-mass-actions) | [Null values ​​in Mass Actions](/forum/44-mass-actions/909988-null-values-in-mass-actions "I want to increase the price by 40% on the price column. To do this, I used the tutorial in this link: This method works well on products that do not have variants, but if you have a product that has variants, it sets the price of the variant product to zero. That is, it writes the number 0 in the price column. Therefore, variant products cannot inherit the price from the main product. As far as I know, in the backend product management of Hikashop, we cannot give a product a zero price, but an empty price column means that it is zero. (Although it would be nice if we could have a zero value and a null value for variant products so that those that are zero are free and those that are null inherit the price from the main product). Therefore, the correct value 0 should not be written there. I think this is implemented incorrectly. How can I change the price of variant products that are not null and also the price of the main products by 40%, but leave the variant products whose price is null unchanged and the zero value in their price column not calculated?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 10 months 1 week ago, by [levelup](/forum/user/61801-levelup "View levelup's Profile") [Last Post](/forum/44-mass-actions/909988-null-values-in-mass-actions#369823 "Hi, Oh, then that's probably why. If you can't update, then try with the > 0 as I said in my message. It should work properly.") 10 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:556 | [Last Post](/forum/44-mass-actions/909988-null-values-in-mass-actions#369823 "Hi, Oh, then that's probably why. If you can't update, then try with the > 0 as I said in my message. It should work properly.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 months 1 week ago | | [](/forum/44-mass-actions/909734-recuperation-de-variables-des-commande-dans-mass-action) | [Récupération de variables des commande dans Mass action](/forum/44-mass-actions/909734-recuperation-de-variables-des-commande-dans-mass-action "-- HikaShop version -- : 6.1.0 Bonjour, Je souhaite envoyer un mail avec dans le contenu de celui-ci le nom du client qui a passé commande. Quelle est la variable à utiliser pour récupérer le champ? Car {order_name} ou {customer_name} ne fonctionne pas (même proble pour récuperer le mail du client) Le order_number lui fonctionne correctement et m'affiche bien le numéro de commande dans le mail contrairement aux deux variables précédentes. Cordialement") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 1 month ago, by [NathanJ](/forum/user/83450-nathanj "View NathanJ's Profile") [Last Post](/forum/44-mass-actions/909734-recuperation-de-variables-des-commande-dans-mass-action#368668 "Bonjour, Notez que nous proposons deux plugins qui permettent de contacter le client suite à une commande: - Le plugin cart reminder ( www.hikashop.com/marketplace/product/241-reminder-plugin.html ) qui peut envoyer un email lorsqu'une commande est créée sans être payée et que le client ne passe pas d'autres commandes après. Vous pouvez configurer le délai avant de l'envoi de l'email. - Le plugin review ( www.hikashop.com/marketplace/product/121-review-plugin.html ) qui peut envoyer un email suite à une commande avec un délai configurable pour demander à l'utilisateur de faire un retour sur les produits achetés. Ces emails sont assez facilement configurable dans le menu Système>Emails, comme les emails par défaut d'HikaShop, avec l'édition Business. Et puis vous pouvez également faire des overrides de traduction pour changer le texte pour vos besoins. Je vous recommande de voir si l'un des deux ne pourrait pas convenir à votre situation. Ce sera plus adapter que de passer par une action de masse.") 1 year 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:992 | [Last Post](/forum/44-mass-actions/909734-recuperation-de-variables-des-commande-dans-mass-action#368668 "Bonjour, Notez que nous proposons deux plugins qui permettent de contacter le client suite à une commande: - Le plugin cart reminder ( www.hikashop.com/marketplace/product/241-reminder-plugin.html ) qui peut envoyer un email lorsqu'une commande est créée sans être payée et que le client ne passe pas d'autres commandes après. Vous pouvez configurer le délai avant de l'envoi de l'email. - Le plugin review ( www.hikashop.com/marketplace/product/121-review-plugin.html ) qui peut envoyer un email suite à une commande avec un délai configurable pour demander à l'utilisateur de faire un retour sur les produits achetés. Ces emails sont assez facilement configurable dans le menu Système>Emails, comme les emails par défaut d'HikaShop, avec l'édition Business. Et puis vous pouvez également faire des overrides de traduction pour changer le texte pour vos besoins. Je vous recommande de voir si l'un des deux ne pourrait pas convenir à votre situation. Ce sera plus adapter que de passer par une action de masse.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 1 month ago | | [](/forum/44-mass-actions/909530-mass-actions-with-related-and-option-products) | [Mass Actions with Related and Option Products](/forum/44-mass-actions/909530-mass-actions-with-related-and-option-products "-- HikaShop version -- : 6 -- Joomla version -- : 5 Hi, When you perform bulk exports using "mass actions" and include the "related" and "options" columns, we encounter duplicated data that doesn't accurately match the information in the original product sheets. However, when exporting products without using "mass actions," the data in these columns is correct. Mass actions Data; Product Filter; category_id, product_published Thank you Javier") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 4 months ago, by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") [Last Post](/forum/44-mass-actions/909530-mass-actions-with-related-and-option-products#368005 "Hi, Thank you for the accesses. I was able to reproduce the issue and debug it. I've added a patch to fix the problem and successfully tested the patch on your website. So it is now working fine on your website. For anyone with the same issue, I've also included the patch on our end. So if you have an older version than HikaShop 6.0.0, update it and you'll get the fix. If you have HikaShop 6.0.0, download again the install package on our website and install it on your and it will add the patch. If you have a newer version than 6.0.0, then you already have the patch.") 1 year 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1376 | [Last Post](/forum/44-mass-actions/909530-mass-actions-with-related-and-option-products#368005 "Hi, Thank you for the accesses. I was able to reproduce the issue and debug it. I've added a patch to fix the problem and successfully tested the patch on your website. So it is now working fine on your website. For anyone with the same issue, I've also included the patch on our end. So if you have an older version than HikaShop 6.0.0, update it and you'll get the fix. If you have HikaShop 6.0.0, download again the install package on our website and install it on your and it will add the patch. If you have a newer version than 6.0.0, then you already have the patch.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 3 months ago | | [](/forum/44-mass-actions/909392-round-price-in-mass-action-operation) | [Round Price in Mass Action Operation](/forum/44-mass-actions/909392-round-price-in-mass-action-operation "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.0 -- PHP version -- : 8.1.32 -- Browser(s) name and version -- : Firefox 138.0.1 (64-bit) Hello, due to a percentage based increase in our prices, our price fields in the database have a lot of decimal points. This has not been an issue for now, but now that we want to display the retail price, it is displayed as such: "Price: 2,65 € (2,65 €)" When I manually get rid of the excess decimal points we have the behavior we want: "Price: 2,65 €" How can I specify in a Mass Action to cut the decimal points off so only the first two remain? Thanks in advance") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 5 months ago, by [NTV](/forum/user/69623-ntv "View NTV's Profile") [Last Post](/forum/44-mass-actions/909392-round-price-in-mass-action-operation#367044 "So I guess we're getting AI spam then? :unsure: EDIT: Thanks for deleting.") 1 year 5 months ago by [NTV](/forum/user/69623-ntv "View NTV's Profile") | Replies:4 Views:1400 | [Last Post](/forum/44-mass-actions/909392-round-price-in-mass-action-operation#367044 "So I guess we're getting AI spam then? :unsure: EDIT: Thanks for deleting.") by [NTV](/forum/user/69623-ntv "View NTV's Profile") 1 year 5 months ago | | [](/forum/44-mass-actions/909337-error-on-cron-activation) | [Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation "-- HikaShop version -- : 5.1.5 -- Joomla version -- : 4 -- PHP version -- : 8.2 I have several problems with cron and mass actions. I gues it is conected. 1. When I manualy trigger cron job in hika, I get You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id > 0 LIMIT 5' at line 1 2. Trying to set mass action, no file is exported.") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 6 months ago, by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") [Last Post](/forum/44-mass-actions/909337-error-on-cron-activation#366759 "By some miracle it's working again now. Maybe some cache? The sql error is gone too.") 1 year 6 months ago by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") | Replies:10 Views:1260 | [Last Post](/forum/44-mass-actions/909337-error-on-cron-activation#366759 "By some miracle it's working again now. Maybe some cache? The sql error is gone too.") by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") 1 year 6 months ago | | [](/forum/44-mass-actions/909274-mass-action-for-multiple-languages) | [Mass action for multiple languages](/forum/44-mass-actions/909274-mass-action-for-multiple-languages "Hello, is there a mass action for multiple languages ​​that I can use to quickly enter information into different columns? If not, can you add such a feature?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 7 months ago, by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") [Last Post](/forum/44-mass-actions/909274-mass-action-for-multiple-languages#366332 "Hi, Mass actions do not support multiple languages. However, the import system do supports it: www.hikashop.com/support/documentation/7...op-import.html#trans If you want to quickly add translations for many products, that's what I would recommend doing.") 1 year 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1422 | [Last Post](/forum/44-mass-actions/909274-mass-action-for-multiple-languages#366332 "Hi, Mass actions do not support multiple languages. However, the import system do supports it: www.hikashop.com/support/documentation/7...op-import.html#trans If you want to quickly add translations for many products, that's what I would recommend doing.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 7 months ago | | [](/forum/44-mass-actions/909259-mass-action-filter-error) | [Mass Action Filter Error](/forum/44-mass-actions/909259-mass-action-filter-error "-- HikaShop version -- : 5.1.5 -- Joomla version -- : 4.4.12 -- PHP version -- : 8.2.27 -- Browser(s) name and version -- : Firefox 136.0.1 -- Error-message(debug-mod must be tuned on) -- : None I have written a Mass Action to display the price_values of products that have a product_name containing the string boot. Name: Display Selected Product Prices Description: Show the prices of selected products with certain text in the product name. Data: Product Product: no triggers Filters: Product columns > product_name Contains boot (35 results before Save) Limitations > Start: 0 Value: 10000 Actions: Display the results (product_id, product_name, price_value) Back in the Products section, I select all products and then select the Display Selected Product Prices button. The table displayed shows 35 lines with the word boot. Unfortunately there are an additional 58 lines with product_names that do not contain that word. Examples: F80 E Brake Handle, Z4 E85 Manual Shift Knob, E82 DCT Thick M Sport Steering Wheel. If I switch to the CSV output, the results are the same. If I switch the product_name filter to LIKE %boot%, the result is the same. If I switch the product_name filter to REGEXP, .*boot.*, the result is still wrong. If I try other strings in the product_name, the output still has more matches than it should. What can I do to fix this problem?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 7 months ago, by [cmb](/forum/user/9805-cmb "View cmb's Profile") [Last Post](/forum/44-mass-actions/909259-mass-action-filter-error#366277 "That's a good idea. Thanks for the feedback.") 1 year 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1389 | [Last Post](/forum/44-mass-actions/909259-mass-action-filter-error#366277 "That's a good idea. Thanks for the feedback.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 7 months ago | | [](/forum/44-mass-actions/908574-best-way-to-collect-all-emails) | [Best way to collect all emails](/forum/44-mass-actions/908574-best-way-to-collect-all-emails "Hi, I want to push first of all my old customers to go review the products. What is the best way to collect all customers emails, and if possible separate by country and sort by newest on top. ( so i can filter newer purchases for the next question: What is after this process the best way to get customer email and name into a list for after sales funnel? Like mailchimp or whatever these are all called thanks fot the help") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 2 years 1 month ago, by [NicoW](/forum/user/58228-nicow "View NicoW's Profile") [Last Post](/forum/44-mass-actions/908574-best-way-to-collect-all-emails#366169 "Hello, This message is just to inform you in case this is still a topic for you, HikaShop now has an integration plugin with MailChimp: . Regards") 1 year 7 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:4 Views:1747 | [Last Post](/forum/44-mass-actions/908574-best-way-to-collect-all-emails#366169 "Hello, This message is just to inform you in case this is still a topic for you, HikaShop now has an integration plugin with MailChimp: . Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 1 year 7 months ago | | [](/forum/44-mass-actions/908544-changing-the-price-of-variant-products-with-mass-actions) | [Changing the price of variant products with Mass Actions](/forum/44-mass-actions/908544-changing-the-price-of-variant-products-with-mass-actions "hi How can I change the price of the variant products based on the variant name using mass actions?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 2 years 2 months ago, by [levelup](/forum/user/61801-levelup "View levelup's Profile") [Last Post](/forum/44-mass-actions/908544-changing-the-price-of-variant-products-with-mass-actions#365635 "Actualy you need to focus on product_code column, that column is populated with data for main product and varians, if you target only the product_name column, the variants are not affected.") 1 year 8 months ago by [oxido](/forum/user/29793-oxido "View oxido's Profile") | Replies:2 Views:1605 | [Last Post](/forum/44-mass-actions/908544-changing-the-price-of-variant-products-with-mass-actions#365635 "Actualy you need to focus on product_code column, that column is populated with data for main product and varians, if you target only the product_name column, the variants are not affected.") by [oxido](/forum/user/29793-oxido "View oxido's Profile") 1 year 8 months ago | | [](/forum/44-mass-actions/909024-how-to-update-variant-products-price-in-mass-action) | [How to update variant products price in mass action?](/forum/44-mass-actions/909024-how-to-update-variant-products-price-in-mass-action "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 4.1.3 Hi I intended to update product prices using mass action. The products have variants. The main product's price was updated, but the prices of the variant products did not change.") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 9 months ago, by [levelup](/forum/user/61801-levelup "View levelup's Profile") [Last Post](/forum/44-mass-actions/909024-how-to-update-variant-products-price-in-mass-action#365228 "Hi, Yes. You would have to change the operator from "=" to "regex" and then you could use a regex in the input field, like: where 123, 456 and 789 are three product ids. And you can add as many ids as you want in the regex.") 1 year 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1538 | [Last Post](/forum/44-mass-actions/909024-how-to-update-variant-products-price-in-mass-action#365228 "Hi, Yes. You would have to change the operator from "=" to "regex" and then you could use a regex in the input field, like: where 123, 456 and 789 are three product ids. And you can add as many ids as you want in the regex.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 9 months ago | | [](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing) | [Showing All Products in an Easy-to-Scan Listing](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing "-- HikaShop version -- : 5.1.2 -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Firefox 133.0.3 -- Error-message(debug-mod must be tuned on) -- : none I'm working on a website with over 1,000 products. The business owner should be provided a full listing of all products in the database along with their characteristics, variants and prices. It would be an onerous task to proofread the entire catalog by visiting individual web pages; a summary listing can be perused more easily. My attempts at a Mass Action solution have been unsuccessful. (The HikaShop Export function works well for other purposes but doesn't render the suitable output for a quick scan by a human.) One solution suggested was the use of the plugin. Unfortunately a demonstration page for the plugin doesn't exist and I haven't been able to find a comprehensive demonstration of its features. What I am hoping for in the output are lines in a spreadsheet or PDF file that list the details of each product. An example: product_name Characteristic Variant price_value E36 M Technic Steering Wheel Black Alcantara fabric with black stitching White Alcantara $290.00 E36 M Technic Steering Wheel Black Alcantara fabric with black stitching No Stripe $265.00 E36 M Technic Steering Wheel Two-Tone Option White Alcantara $320.00 Is it possible to construct such a report using a Mass Action? If not, will the HikaSerial Massaction Display & Export plugin work as desired?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 10 months ago, by [cmb](/forum/user/9805-cmb "View cmb's Profile") [Last Post](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing#365088 "Hi, I don't see a way to output something exactly like this with any tools available in or around HikaShop. Supposing that products can have 0, 1 or several characteristics linked to them, it makes outputting a table like in your message impractical. For example, for a variant, the "product_name" of the variant is usually empty in the database, since HikaShop actually displays the "product_name" of the main product on the frontend. And if the product of the variant has 2 characteristics attached to it ( like color and shoe size in this example: demo.hikashop.com/index.php/en/hikashop/...with-characteristics ), then you can't have just one "characteristic" column with one "variant" column. Also, the price of a variant might not be provided in the variant. In that case, the variant will inherit from the price of the main product on the frontend. And products and variants can each have several prices for different currencies or zones or user groups. All of this needs to be taken care of to output a clean table with relevant information. Not everything might apply to your situation, but that means that having a generic system to output exactly what you want is difficult. The best would be to develop a small plugin to output the data the way you need it. With the mass actions system: You could create a mass action with an action "display the results" with the columns "product_name", "price_value", and the characteristics you want to take into account: i.imgur.com/lZVEcxm.png And that will output something like this once you press on the "process" button : i.imgur.com/nC6uZjG.png You have first the product_name column, which contains the product_name of the product or variant of the row. So this can be empty if a variant doesn't have a product_name (which is usually the case). Then, you have the "price_value" column with the prices linked to the product / variant. This can also be empty if the variant inherits from the price of the main product. Then, you have one column for each characteristic. So, if you have many characteristics, you will have many columns there. The "HikaSerial Massaction Display & Export plugin" has nothing to do with what you want to do.") 1 year 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1564 | [Last Post](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing#365088 "Hi, I don't see a way to output something exactly like this with any tools available in or around HikaShop. Supposing that products can have 0, 1 or several characteristics linked to them, it makes outputting a table like in your message impractical. For example, for a variant, the "product_name" of the variant is usually empty in the database, since HikaShop actually displays the "product_name" of the main product on the frontend. And if the product of the variant has 2 characteristics attached to it ( like color and shoe size in this example: demo.hikashop.com/index.php/en/hikashop/...with-characteristics ), then you can't have just one "characteristic" column with one "variant" column. Also, the price of a variant might not be provided in the variant. In that case, the variant will inherit from the price of the main product on the frontend. And products and variants can each have several prices for different currencies or zones or user groups. All of this needs to be taken care of to output a clean table with relevant information. Not everything might apply to your situation, but that means that having a generic system to output exactly what you want is difficult. The best would be to develop a small plugin to output the data the way you need it. With the mass actions system: You could create a mass action with an action "display the results" with the columns "product_name", "price_value", and the characteristics you want to take into account: i.imgur.com/lZVEcxm.png And that will output something like this once you press on the "process" button : i.imgur.com/nC6uZjG.png You have first the product_name column, which contains the product_name of the product or variant of the row. So this can be empty if a variant doesn't have a product_name (which is usually the case). Then, you have the "price_value" column with the prices linked to the product / variant. This can also be empty if the variant inherits from the price of the main product. Then, you have one column for each characteristic. So, if you have many characteristics, you will have many columns there. The "HikaSerial Massaction Display & Export plugin" has nothing to do with what you want to do.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 10 months ago | | [](/forum/44-mass-actions/908933-accessing-customer-details-onafterordercreate) | [Accessing customer details onAfterOrderCreate](/forum/44-mass-actions/908933-accessing-customer-details-onafterordercreate "I'm writing a php script to add a customer's details to a MailerLite list after an order is created. How do I call the customers email address and name into variables?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 11 months ago, by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") [Last Post](/forum/44-mass-actions/908933-accessing-customer-details-onafterordercreate#364840 "Sorry for the misunderstanding. I presumed incorrectly that Mass Actions used the same event trigger. Your solution works perfectly and customers purchasing my intro product now get added to the...") 1 year 10 months ago by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") | Replies:4 Views:1592 | [Last Post](/forum/44-mass-actions/908933-accessing-customer-details-onafterordercreate#364840 "Sorry for the misunderstanding. I presumed incorrectly that Mass Actions used the same event trigger. Your solution works perfectly and customers purchasing my intro product now get added to the...") by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") 1 year 10 months ago | | [](/forum/44-mass-actions/908909-massaction-on-predefined-fields) | [massaction on predefined fields](/forum/44-mass-actions/908909-massaction-on-predefined-fields "-- url of the page with the problem -- : www.aroma-massage.it I created some default fields in the product management page to assign extra categories to the products to work with the filter. since I forgot to insert these default fields for some product categories, I wanted to understand if it is possible to perform a massaction to assign some of these default fields to the products. I was trying to set the massaction as follows but I got stuck and I don't want to mess it up. any suggestions please?") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 11 months ago, by [aromamassage](/forum/user/64297-aromamassage "View aromamassage's Profile") [Last Post](/forum/44-mass-actions/908909-massaction-on-predefined-fields#364630 "Hi, In your action, you want to use the "string" mode, not the "operation" mode. And in the input field on the right, you want to copy / paste the value to be used for all the products filtered. Note that in a custom field, you have two columns for values, the "value" and the "title". You need to provide the "value" in the input field, not the "title". Also, I would recommend adding an extra filter on the custom field column with the mode "=" and the input field empty. That way, it will only fill the custom field of the products where that field is empty.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1557 | [Last Post](/forum/44-mass-actions/908909-massaction-on-predefined-fields#364630 "Hi, In your action, you want to use the "string" mode, not the "operation" mode. And in the input field on the right, you want to copy / paste the value to be used for all the products filtered. Note that in a custom field, you have two columns for values, the "value" and the "title". You need to provide the "value" in the input field, not the "title". Also, I would recommend adding an extra filter on the custom field column with the mode "=" and the input field empty. That way, it will only fill the custom field of the products where that field is empty.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago | | [](/forum/44-mass-actions/908862-mass-action-doesnt-work-as-expected-after-using-process) | [mass action doesn't work as expected after using "process"](/forum/44-mass-actions/908862-mass-action-doesnt-work-as-expected-after-using-process "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 5.1.1 -- Joomla version -- : 5.2.1 -- PHP version -- : 8.2.25 Hello, I have a mass action set up to delete unpublished products each month. I recently discovered that it's not working. Please see attached screenshot to see the settings. This is the same mass action that was discussed in this thread: www.hikashop.com/forum/orders-management...s-automatically.html Is this no longer set up correctly? Can you point me in a direction to determine a fix, please? Thanks, Karen") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 1 year 11 months ago, by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile") [Last Post](/forum/44-mass-actions/908862-mass-action-doesnt-work-as-expected-after-using-process#364448 "Hi, No, this code targets the products filtered by the mass action. So, you still want to have your filter on the product_published column in your mass action.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1629 | [Last Post](/forum/44-mass-actions/908862-mass-action-doesnt-work-as-expected-after-using-process#364448 "Hi, No, this code targets the products filtered by the mass action. So, you still want to have your filter on the product_published column in your mass action.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)