Gitter got replaced by Slack. Please use following invite link https://slack.shopware.com to rejoin the awesome Shopware community! https://www.shopware.com/en/news/an-introduction-to-the-shopware-community-slack/
composer run-script test after installing the git version of the FroshProfiler but I still get Fatal error: Uncaught RuntimeException: No autoloader found in /develop/frosh-profiler/FroshProfiler/vendor/frosh/shopware-classic-phpunit-bridge/src/Bootstrap/Functional/bootstrap.php on line 12
hello guys, for shopware6 I need to make listing order like
- article inStock(not order by MAX(product.availableStock), just if product has inStock)
- date of creation
So at the end of the show order by should looks like
Order by IF(MAX(product.availableStock)>0,1,0) desc,product.createdAt DESC
But I'm stock how to add IF(MAX(product.availableStock)>0,1,0), maybe anyone can advice how to do it?
```SELECT
od.articleordernumber
, cc.countryname
, SUM(od.quantity)
FROM s_order_details AS od
JOIN s_order AS o
ON o.id = od.orderID
JOIN s_order_shippingaddress AS os
ON os.orderID = od.orderID
JOIN s_core_countries AS cc
ON cc.id = os.countryID
WHERE DATE(o.ordertime) BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01') AND LAST_DAY(NOW() - INTERVAL 1 MONTH)
GROUP BY od.articleordernumber, cc.id; ```
https://store.de/api/v3/search/state-machine-state
I am trying to fetch products by categories using the ../store-api/product-listing/ endpoint. The header is complete with values for sw-access-key, Content-Type and Accept. Running the request as is, results in the desired response. But when I try to set a page number other than 1 in the request body including a limit number, I always receive the products for page 1. If I change the limit number, I weirdly receive the correct amount of desired products (but still only for page 1). I am out of ideas. Any help is much appreciated.
Hello. when trying to update shopware to the latest version it gives this error when calling the update page. I logged out and in again to ensure i am logged in. What might be wrong? "{"errors":[{"code":"401","status":"500","title":"Internal Server Error","detail":"Client error: POST https:\/\/api.shopware.com\/swplatform\/autoupdate?shopwareVersion=6.4.5.1\u0026language=de-DE\u0026domain=www.my.shop resulted in a 401 Unauthorized response:\n{\u0022success\u0022:false,\u0022code\u0022:\u0022ShopwarePlatformException-1\u0022,\u0022title\u0022:\u0022Nicht authorisiert\u0022,\u0022description\u0022:\u0022Die durchgef\u00fchrte (truncated...)\n"}]}" on .
Can still press update, but what is the reason for the alert?
{"success":false,"data":[{"result":[{"entities":[],"errors":[{"code":"FRAMEWORK__WRITE_CONSTRAINT_VIOLATION","status":"400","detail":"This field is write-protected.","template":"This field is write-protected.","meta":{"parameters":["crud",""]},"source":{"pointer":"\/0\/categoryTreecategoryTree"}}]}],"extensions":[]}],"deleted":[],"notFound":[],"extensions":[]}
I have created a new service for this (extends EventSubscriberInterface) and would like to know which event or events I have to subscribe to?
I've already tried:
app.loaded, kernel.request and a few others, but nothing happens at all.I registered the service in the services.xml - also with the tag:
<tag name="kernel.event_subscriber" /> ... but unfortunately I don't really know how to test it in a meaningful way, where the error is? Because nothing happens at all. No error message at all.
If customer registered with 'AT' shop (austria) , zipcode must be validated with 4 digits and validated with 5 digits for 'DE' shop (german).
I used BackendSubscriber but I can't detect current address is 'AT' or 'DE' to validate.
Can everyone help me?