comment supprimer automatiquement les produits quand il atteint 0 en quantité prestashop 1.7


Recherchez la table ps_stock_available. Nous allons créer un déclencheur sur cette table, nous devons donc l’ouvrir. Lorsque vous le trouvez sur la liste, cliquez sur le nom de la table. vous verrez quelque chose comme:



Cliquez sur le bouton des déclencheurs dans le menu horizontal supérieur. Vous verrez tous les déclencheurs définis pour cette table (bien sûr si vous avez créé). Sinon, la liste sera vide:



Cliquez sur le bouton “Ajouter un déclencheur”. Vous verrez la forme, où vous devez spécifier les paramètres de déclenchement. Remplissez-le exactement comme indiqué ci-dessous:

UPDATE ps_product_shop SET active=0 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity=0);
UPDATE ps_product_shop SET active=1 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity>0);



Voici le formulaire des paramètres de déclenchement:


Lorsque vous êtes convaincu que vous avez rempli le formulaire exactement comme indiqué, puis cliquez sur le bouton “Exécuter”.
voila!! vous pouvez tester en mettant un produit à 0 il se désactiveras automatiquement

ce n’est pas moi qui as donner cette solution, j’ai simplement traduit pour vous.

voici le lien de l’original (en anglais):



Have you ever wondered why skin care is important? Well, we will explain: The skin is the largest organ of the body. It serves as a protective barrier between the inside and the rest of the world, helps regulate body temperature and acts as a filter. The skin exists in a constant state of growth, with old cells dying as new ones are formed. This is affected by all aspects of your life, from what you eat to where you live. Healthy skin is better able to fight the signs of aging, heals much faster and better prevent any potential disease than unhealthy skin. You see? It is not only a question of beauty, but of health. It is important that you consider all aspects to have a healthy and radiant skin.
For starters, a balanced diet is essential to achieve a healthy complexion and without imperfections. Otherwise, the excess of toxins will show in the form of dull complexion and granites.


The skin is a reflection of our health. If the body is overloaded with toxins, these will come out through the pores of our skin and our skin will suffer and it will show off and with impurities. Therefore it is essential to feed ourselves in a balanced way, providing sufficient amounts of carbohydrates and protein. In our daily diet should not miss:

  • Fruits and vegetables, raw and cooked, of all colors
  • Integral cereal
  •  Vegetables
  •  Fruits and dried fruits
  •  Seeds (sunflower, pumpkin, flax, chia) and first-pressing cold-pressed seed oils
  •  Superfoods: brewer’s yeast, wheat germ, spirulina
  •  Ecological animal protein

Proper skin care is vital if you care about your physical appearance. Unhealthy skin tends to look pale and dull, while healthy looks full and vigorous. Wrinkles develop more easily and are deeper if your skin is dehydrated and unhealthy, and can cause irregular patches of mottled color. When the skin is diseased, it loses elasticity, which can make it yield and appear thin.
Proper skin care is not just about looking good, it’s about staying healthy. Bad habits in skin care can cause rashes, sores, acne and wrinkles. Sick skin is more susceptible to disease, infection and is more likely to heal after a wound. Proper care is especially important for people who suffer from skin problems, such as psoriasis, or who have skin allergies.

The skin is constantly growing and changing, so you have to stay alert with the care of it. Keep the skin hydrated by drinking plenty of water throughout the day, and followed a balanced diet to provide the vitamins and minerals you need. I continued with fresh fruits and vegetables, whole grains and lean proteins to get the best results. Always make sure to use sunscreen if you are going to spend time outdoors.


Daily we will clean our skin, especially if we have used makeup. The best way to do it is to simply use almond oil, and in this way we will leave our skin well hydrated all night.


The exfoliation is the cleaning of the dead skin cells to regenerate and keep it clean and smooth, but it is something that we will only do once every week or fortnight. The most natural way to do it is using baking soda or sugar, or, if you do not have time, we recommend this bamboo mask. It will help you to clean your skin of impurities, and the best thing, is at a super price.

This slideshow requires JavaScript.

OUPEI Bamboo Black Mask Acne Treatment Blackhead Remover Peel Off Black Head Anti Acne Charcoal Face Mask Skin Care Oil-control


Hydration is essential, especially if we have dry skin. For this we will use any of the following products:

  • For dry skin: olive oil, argan oil and / or rosehip
  • For mixed skin: coconut or sesame oil
  • For oily skin: aloe vera gel or coconut oil

Remember that it is essential to take care of our entire body, not just the face.
Have you ever spoiled yourself with a relaxing massage?
We will begin by telling you that without doubt, they can be the solution to all your stress problems. Massages have benefits that work wonders in our body. Know them.

To begin with, they improve the appearance of the skin. By stimulating blood circulation through the body, massages are perfect for the beauty of our skin: it becomes firmer, softer and more attractive.
Relax your muscles Either by stress or by a simple bad posture, we all suffer from muscle aches. These occur as a result of the tension in the muscles and poor blood circulation in that area of ​​the body. Massages are excellent for relieving muscles, as they stimulate the flow of blood and oxygen throughout the body.


They reduce the pains in the body. Do you feel pain in the abdomen or in different parts of the body? Are you a woman suffering from premenstrual pain? Massages are a good solution to all these problems. According to experts, stimulating painful areas with a massage helps activate a nerve that sends signals to the brain to block pain.


They reduce stress. What better than download stress with a good massage session right? The massages “release” the pressure points of the whole body, relaxing all the senses.
Give yourself the perfect gift, if you do not want to leave the house, you can use this comfortable article “Body Massage Helper Anti Cellulite”

1pc Family Body Massage Helper Anti Cellulite Vacuum Silicone Cupping Cups Brand new and High quality

Dogs are not just pets… But friends for life

Nowadays dogs have gone from being someone who guards the house, to being a faithful companion, no matter what else. For these beloved animals, the human being can be everything. There are people who learn every day of their dog, these faithful pets have taught them the value of commitment and reciprocity. Human beings can learn the value of loyalty, which is immense. And of course, unconditional love, because for a dog, you will always be his inseparable friend. Do you know what it is? Well, here we tell you.

New research explains why you love your dog so much: researchers at Azabu University in Japan discovered that as dogs look at the eyes of their human owners, the hormone oxytocin is released, which strengthens emotional ties and bonds with maternal attachment .
That is, the also known as “hormone of love” is released both in dogs and in people. “Dogs successfully coexist with humans because they have adapted to the binding mechanism used in human relationships,” says author Miho Nagasawa in a video statement, according to the Smithsonian magazine.
Humans and dogs become closer when they share long glances. And mutually increase these levels of oxytocin. And the more you look at your dog, the stronger the bond, which probably explains why some people love their dogs more than they love people.
But Nagasawa and his team discovered that this does not necessarily work with all canines, specifically with wolves, since they perceive eye contact as a threat, and not as a mental embrace. In short, the feeling you have when you stare at your dog’s eyes does not come from nowhere: It’s simple science.

Although … not everything is love. Human beings can be impulsive and acquire more without knowing what care they need, for example, what kind of climate favors them, if we have the adequate space to have it at home, if our rhythm of life allows us to give it the attention it deserves, how to exercise it and every when and how much we exercise it.
There are more than 400 breeds of dogs around the world, but some estimates even say that this number could rise to 800 breeds, if we include those not officially recognized. This makes the dog the mammal with the largest number of sub-varieties of our planet.
The giant races, of enormous size, weigh more than 50 kilos and can reach up to 90 kilos. At the other extreme, there are the miniature races, which weigh less than 5 kilos, and whose smallest example is the Chihuahua, which weighs only between 1.5 and 3 kilos in adulthood. That is why you should pay attention to what dog breed you acquire, because they are all loving, but, not everyone could adapt to your lifestyle, therefore, before acquiring or adopting, make sure that you will give him everything he will need .
Dogs live with us in our homes, however they need some specific care that is important to know, especially everything related to their diet, their hygiene, the vaccines they need, how much exercise we should provide, or how we should educate them to be respectful and quiet at home.
An article that would be very helpful for the hygiene of your dog is this glove to easily remove the dead hair of your pet.

PipiFren Dogs Cats Glove Pets Brush Glove Grooming Accessories Cats Comb Hair Cleaning Remover gants pour chien cepillo perro

Also, do not forget that it is necessary to bathe them at least every 3 weeks, this article will facilitate the bath time. It is easy to use and in amocoza you can buy it.

Pet shower cleaning shower 360 degree multi function folding bathtub circular water gun washing spray bath dog and cat supplies

This slideshow requires JavaScript.

The most important thing is to understand that dogs suffer a lot in solitude, so before we have one we must ask ourselves if we will have enough time to take care of them every day. Think that to be healthy and relaxed a dog should walk at least 3 times each day, being one of the walks at least half an hour.
If you are someone who likes to explore new places, take your dog with you; A good walk or hiking route through the mountain is a wonderful way to interact with your dog in summer. Exercise, open air and the possibility that the dogs can run what they want, discover new smells, etc…

[TAILUP] Pet Running Leash For Large Dog Hands Free Leash Leads Dog-Collar Pet accessories Dog Running Leash For Animals PY0024

This comfortable article will facilitate the walks with your dog, since you will have your hands free and your dog will go to your side, for sure.

Connect with nature, one of the best ways to relax and find peace

Turn your opinion of sport and practice hiking.
There are many good reasons to do so, but, you must know what is needed to practice it.
If your pace of life generates stress, it is a very good reason to practice hiking, because it is a sport that can be practiced by almost everyone, since there are routes for all levels: from beginners with little physical preparation to experts with routes sinuous, of great length and by terrains that present certain difficulties. But, also takes into account that although it is an exercise with little impact at its simplest levels, it is important to consult a medical specialist in the case of suffering from any important pathology so that, by means of a stress test, determine at what intensity It can be practiced. Remember that we do not all have the same physical resistance, so it is important to have a previous check.
Now, the good news is that the health benefits of hiking are also present for the initiates. Burning calories, increasing muscle tone or maintaining bone mass are some of the properties it has for the body; Doctors comment that this sport helps control hypertension, improves mood and reduces anxiety and stress. What else do you need? Make up your mind and start a healthier life.
Another good reason to do so is that you will be in touch with nature, studies by Professor Terry Hartig at the University of Upsala (Sweden) have shown that after a 40-minute nature excursion, intellectual skills are sharpened. Also, a walk around the city or resting at home does not achieve the same results. The longer and more natural and isolated the environment, the better the results. Being in a natural environment, far from noise, consumerism … has a great healthy effect.


And to all this, what do you need?
You do not need such specialized material, what you should not overlook is the footwear, choose good boots for your journey. The most important thing is that the sole of the boot is a little stiff and avoids slipping; the ideal material is the skin, because it transpires better and its height must grip the ankle well, since one of the most common injuries in hiking is the sprained ankle (also knee) when crossing unstable terrain. It is also important to choose models that have a good degree of impermeability, especially if you will make routes on trails with streams or on rainy days. The rest of the clothes should also be comfortable and breathable. Logically, depending on the time of year, it must be thicker or not.

Hiking Climbing Shoes DELTA Professional Waterproof Hiking Boots Tactical Boots Outdoor Mountain Climbing Sports Sneakers


Another very important thing that you should not forget, is a backpack.

70L Tactical Backpack Waterproof Outdoor Sports Bag Military Climbing Bags Hiking Large Camping Backpack Travel Bag Large WX115

40L Waterproof Travel Hiking Backpack Outdoor Sports Bag Camping Climbing Bag Men Women Trekking Mountaineering Cycling Dayback

1000D Nylon Colors 28L Waterproof Tactical Backpack Outdoor Military Backpack Tactical Bag Sport Camping Hiking Fishing Hunting

This slideshow requires JavaScript.

In the backpack you can not miss a basic kit (scissors, anti-inflammatories, analgesics, sunscreen, gauze), a mobile with a fully charged battery, a map with the route and a compass.

Mulitifunctional Eyeskey Survival Military Compass Camping Hiking Compass Geological Compass Digital Compass Camping Equipment

Emergency Survival Gear multi tool Survive First Aid Kit Outdoor Camping equipment Survival Whistle Flashlight Tactical pen

Xinpuguang 5.5V 10W Foldable Solar Charger system solar panel battery charging cell with USB for outdoor camp Mountaineer phone


In amocoza, we have the equipment you need Empty Bag for Emergency Kits First Aid Kit Military Waist Camouflage Fanny Pack Outdoor Camping Travel Tactical Molle Pouch Mini It will be ideal to store the material you need in your journey, without risk of losing or falling

Inspire yourself, another activity that you will also enjoy will be to go camping; Besides being very fun, camping is very economical, but it’s not just going out with a tent and installing it anywhere. You must take into account some important aspects if you want to go camping and have a great time. If you have never gone camping it is easy to forget something essential. For example, utensils for cooking and eating, are essential that you have at hand and that you do not have trouble cooking in your stay camping.

These items will be of great help because it is equipped with everything you need, plus you can carry it easily without forgetting anything.

Do not run out of fun, buy this product in amocoza and let yourself be pampered, you’ll be comfortable enjoying nature.

If you go camping the most important thing for you to have a good time is that you have a camping equipment with those necessary and essential elements, especially things that you can not get where you are camping.
So, what should you take to your adventure? The answer is not fixed, since it largely depends on things like: in which geographical setting you will camp, what kind of camping, if you are near an urban area or not, the time of year, how many days you plan to camp, among other things. But, do not worry here you can find everything you need to have a good time.

If you run out of drinking water on your trip, do not worry. Take it from nature. With this filter you can drink it without problems.
Finding drinking water is not always easy depending on the country or the type of activity we do.
Or, if you travel backpacking, you can not trust the running water of many countries. It is possible to get parasites, bacteria and other organisms by drinking tap water. In addition, dirty water can contain heavy metals, excess minerals and chemicals that are best avoided.
Make your trip easier, buy it in amocoza at a super accessible price.

Miniwell water filter system with 2000 Liters filtration capacity for outdoor sport camping emergency survival tool




8 Good and simple meals for a healthy living.

1. Hot oatmeal on a cold morning is a must for winter survival. It’s also a good way to stay satisfied until lunch and an excellent source of soluble fiber, the kind that helps keep your cholesterol levels low. You can do it on the stove, in the microwave or in a slow cooker. In warm weather, you can make oatmeal in the fridge overnight without moving a finger.



2. Green salad: Use fresh vegetables and consider that anything canned should be a complement and not the main ingredient so you do not end up with a wilted and sad salad. If you want it to be a complete meal, add a little protein such as meat, eggs, beans and nuts. Make sure you make a good mix of crunchy ingredients such as raw cabbage, cucumber or nuts, and some soft ones like tomatoes, cooked vegetables or beans.
The most important step is to make your own delicious homemade dressing (and healthier). A simple Dijon mustard vinaigrette always works, but also feel free to try something more risky. If you’re looking for a complete recipe that inspires you, try this salad with kale and Brussels sprouts.



3. Crispy Roasted VEGETABLES: Roasting vegetables is one of the easiest and safest ways to cook them. Turn your oven to 450 ° F (232 ° C). Chop your vegetables, the hardest ones (like carrots and potatoes) cut them into smaller pieces than soft vegetables (like broccoli and pumpkin). Place them all with a little olive oil and kosher salt. Spread them on one or two baking trays. Do not pile them up! Serve between 30 and 40 minutes, or until they look good and taste good.



4. A healthy bowl of PASTA: Do not believe anyone who tells you that pasta can not be healthy. Of course it can be. And those who deny themselves the pleasure of eating pasta, do not live their lives to the fullest. First, it uses whole wheat pasta because, like brown rice, it has more nutrients and fiber. Second, add lots of vegetables and some healthy protein. Third, limit your sources of saturated fats such as cream, butter, cheese and fatty meat. Try the whole rigatoni with roasted vegetables and pine nuts, or linguine with shrimp, olives and dehydrated tomatoes. You can also modify your favorite recipes to make them healthier. Try to prepare fusilli with broccoli roast and cauliflower with whole noodles with half of pasta and cheese and twice as many vegetables.



5. GRILLED CHICKEN: Grilled chicken is easy to make and is also a low-fat and healthy meat, although it has a bad reputation because it is tasteless. The key is to combine the chicken with strong and interesting flavors. If you have the time (and so you have foreseen), decide on a marinade.



6. SMOOTHIE: Smoothies are an easy and delicious way to condense many nutrients at once. Whether it’s a green detox smoothie, a seasonal fruit smoothie or a very simple three-ingredient smoothie, the key is making sure you have a combination of fruits, vegetables and protein, so it’s well-balanced AND tasty.
Water is ideal but also normal milk or its substitutes. But do not pay attention to the recipes that ask you to add sugar, be careful with the juices that are usually high in sugar and with the protein powder, since high levels of toxins such as arsenic, cadmium and lead have sometimes been found in it.



7. GRILLED FISH or GRILL: You’ve probably heard it a hundred times: fish is really good for you. It is high in protein but also low in fat, which makes it an excellent alternative to pork or red meat. White meat fish such as tilapia are especially low in fat, while fatty fish such as salmon have a high concentration of Omega-3. However, some fish have higher concentrations of mercury than others and many species are endangered due to overfishing. The Council for the Defense of National Resources has information here to help you make the best choice in your purchases. Even when choosing fish is not easy, cooking it can always be super simple. One of the easiest and healthiest ways is to bake it on parchment paper, but roasting it on the grill is another easy option for when you want something quick and crispy. To make a quick and easy marinade, try mixing oil, soy sauce, garlic, Dijon mustard and chives in proportions according to your taste. (The more mustard, more spicy, the more soy sauce, more salty, etc.) This will basically work with everything.


8. CHOCOLATE PUDDING low in sugar: Chocolate … is … amazing. Do not deprive yourself, just learn to enjoy it in healthier ways than with a chocolate bar “Snickers”. Chocolate pudding is the perfect solution because there are many ways for you to do it (secretly) and make it good for you. Try making this pudding of chocolate and avocado when you do not have much time, these rates of sparkling chocolate if you want to fool someone (or yourself) to eat tofu or a chocolate pudding with chia seeds and dates.



4 natural homemade face masks for a perfect skin

Natural face masks

The homemade and natural masks are an effective way to save money and have a good time, while taking care of the face with products that do not harm the environment.
Facials done at home are not just for relaxation, in fact, they can remove some of the most common skin problems. Ingredients such as honey or oatmeal can work wonders on your skin.

They are fast and help save money too. Usually you have all the necessary ingredients in the kitchen cupboard and therefore you can make these masks in just 10 minutes or less.


Oat hydrating mask


  • Cold chamomile
  • 1 teaspoon of honey
  • 2 tablespoons of oatmeal.

Mix the oatmeal, honey and two tablespoons of chamomile. If your skin is very sensitive you can change the honey by lanolin. Spread the mixture through the skin using a brush, always avoiding contact with the eyes (you can protect them with a cotton makeup remover disk) and let it act for 20 minutes. Wash your face with the remaining chamomile.

Mask for oily skin


  • 1 egg white
  • 1 ripe tomato
  • 1 tablespoon of brewer’s yeast
  • 1 cup of water
  • 3 dry bay leaves.

Prepare a tea with the water and the laurel and let it rest until it cools. Prepare the clear at the point of snow and add the peeled and crushed tomato. Add the yeast and two tablespoons of the tea that you prepared before and stir everything well. Now you can apply it on the most greasy areas of the face with a brush. Let the mask work for 15 minutes, and then wash your face with the rest of the tea.

Mask for dry skin

Prepare the mask by mashing an entire avocado. Add a little milk and stir until the texture is pasty enough. Apply the mask to the face and neck and let it act for 20 minutes. Wash your face with warm water.

Mask to clean, close pores and firm skin

Blend a medium cucumber that is ripe. Mix it with a spoonful of milk powder and egg white until you get the texture of a consistent paste. Put on the mask and let it act for 30 minutes. To finish, rinse with warm water first and then with cold water.


NATURAL MEDICINE: An alternative

At present there are many scientific advances regarding medicine and even technology to prevent and detect diseases. But in many parts of the world it has been preferred to use natural medicine, this depends on each culture for its use. Natural medicine is a medicine that is based on the prevention of diseases and maintaining health instead of directly treating the symptoms once the body has become ill.


What does the concept of traditional medicine encompass?
Traditional medicine, also known as naturopathy, is an enormously broad concept of techniques. The main ones would be:

  • Nutrition: it is based on changing the diet, correcting bad habits and adding the necessary supplements for health.
  • Phytotherapy: uses plants to promote health and restore balance during illness.
  • Homeopathy: uses agents very similar to those that cause the disease to stimulate the body’s defenses to heal itself
  • Acupuncture: uses very thin needles to stimulate certain points of the body to improve the balance of the body.
  • Digitopuntura: comes from acupuncture but uses the pressure of the fingers on different points of the body to relieve pain.
  • Biomagnetism: uses the application of magnets on body areas that suffer pain.
  • Massages: There are several types of massages, depending on whether you want to heal or, if it is just relaxing.


Why is traditional medicine so fashionable?

In addition to being less aggressive to the body, has no side effects or leaves harmful remains, is preventive and seeks not only physical but also emotional well-being.
Is it really effective?

It is getting more advanced, but it is far from being a panacea because there is still a lot of research to be done in this field.
It is also slower to take effect than conventional medicine and comparatively more expensive, although it is a ray of hope to alleviate symptoms of diseases and for their prevention. It is recommended that it be used in a complementary way to medical treatments of conventional medicine to make it even more effective.

Mario Kart 8 Deluxe receives content from Zelda: Breath of the Wild

Today, Nintendo revealed a big surprise: Mario Kart 8 Deluxe will receive DLC from The Legend of Zelda: Breath of The Wild. The best part? The content is free!

That’s right, thanks to the 1.6 update for Mario Kart 8 Deluxe, which is available right now, players will find the Master Cycle Zero and the champion tunic that Link uses in Breath of the Wild. We must make it clear that the character and his vehicle were already in the game, it is only a new version that surely fans will appreciate.


This announcement comes a few days after Nintendo suggested that Mario Kart 8 Deluxe would have new downloadable content. Last week, the game’s producer, Shinya Takahashi, said that “there will be future updates for Mario Kart 8 Deluxe” and called the players to be on the lookout. This means that the game could receive new DLCs soon.
Mario Kart 8 Deluxe is the 2nd best-selling game of Nintendo Switch, since it has 9.22 million copies, just behind Super Mario Odyssey, title that, until March 31, had 10.41 million units sold in all the world.

The thing does not end here, since Nintendo prepares Mario Kart Tour, a proposal for mobile devices that will arrive sometime in 2019. Taking into account that the franchise is the most popular, it is likely that the game will be a success when you see the light.

Couple of things you must try whilst visiting Germany?

ffm_weihnachtsmarkt_06_panorama.jpgIf you visit Germany during the months of November and December, you can visit its charming Christmas Markets (Christkindlesmarkt).

These markets are characterized by dressing in light and color during the Christmas season and offering visitors local handicrafts, gifts and typical seasonal cuisine such as mulled wine (Glühwein) and a variety of sweets from the region.

Transportation system: Like most European countries, Germany has an excellent transportation system. Once you get there, you can make use of public transport, which allows you to reach any point of the city without complications and at a reasonable price.


Did someone say beer? Well, Germany has this particular charm. Beer is a very important part of your culture and identity as a country. Drinking a beer in Germany is quite an experience, it is very common to see traditional tables where customers (even without knowing each other) sit together to drink a good local beer. In addition, every year the world famous Oktoberfest takes place, this great celebration of approximately 2 weeks where more than 7 million liters of beer are consumed, as well as delighting the palate of the attendees with the delicious local gastronomy. What better reason to visit this country?


Up ↑