search

tradefurniturecompany / site

tradefurniturecompany.co.uk (Magento 2)
https://upwork.com/fl/mage2pro
2 stars 1 forks source link

`Amasty_Feed`: «The Product with the "H32D&4B1DRW" SKU doesn't exist» #232

Closed dmitrii-fediuk closed 3 years ago

dmitrii-fediuk commented 3 years ago

Related to https://github.com/tradefurniturecompany/site/issues/227

{
    "channel": "main",
    "context": {
        "exception": {}
    },
    "datetime": {
        "date": "2021-08-15 05:34:41.303817",
        "timezone_type": 3,
        "timezone": "UTC"
    },
    "level": 500,
    "level_name": "CRITICAL",
    "Mage2.PRO": [
        {
            "IP Address": "92.243.166.8",
            "mage2pro/core": "7.6.6",
            "Magento": "2.3.2",
            "PHP": "7.2.34",
            "Post": {
                "compress": "",
                "delivery_enabled": "0",
                "exclude_disabled": "0",
                "exclude_not_visible": "0",
                "exclude_out_of_stock": "0",
                "execute_mode": "manual",
                "feed_entity_id": "12",
                "feed_type": "xml",
                "filename": "google-shopping.xml",
                "form_key": "cg4EHCne9Xuh5x2Y",
                "format_date": "Y-m-d",
                "format_price_currency": "GBP",
                "format_price_currency_show": "1",
                "format_price_decimal_point": "dot",
                "format_price_decimals": "two",
                "format_price_thousands_separator": "comma",
                "is_active": "1",
                "name": "Google Shopping",
                "page": "4",
                "rule": {
                    "conditions": {
                        "1": {
                            "aggregator": "all",
                            "new_child": "",
                            "type": "Amasty\\Feed\\Model\\Rule\\Condition\\Combine",
                            "value": "1"
                        }
                    }
                },
                "store_id": "1",
                "utm_campaign": "",
                "utm_content": "",
                "utm_medium": "",
                "utm_source": "",
                "utm_term": "",
                "xml_content": "<g:id>{attribute=\"basic|sku\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape\"}</g:id>\n<title>{attribute=\"product|name\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape|length:150\"}</title>\n<description>{attribute=\"product|description\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape|length:500\"}</description>\n<link>{attribute=\"url|short\" format=\"as_is\" parent=\"yes\" optional=\"yes\" modify=\"html_escape\"}</link>\n<g:image_link>{attribute=\"image|thumbnail\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"\"}</g:image_link>\n<g:condition>new</g:condition>\n<g:price>{attribute=\"price|final_price\" format=\"price\" parent=\"no\" optional=\"yes\" modify=\"\"}</g:price>\n<g:tax>\n    <g:country>GB</g:country>\n    <g:rate>{attribute=\"other|tax_percents\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"\"}</g:rate>\n    <g:tax_ship>y</g:tax_ship>\n</g:tax>\n<g:shipping>\n    <g:country>GB</g:country>\n    <g:price>0 GBP</g:price>\n</g:shipping>\n<g:availability>{attribute=\"inventory|is_in_stock\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"replace:1^In Stock|replace:0^Out of Stock\"}</g:availability>\n<g:google_product_category>{attribute=\"mapped_category|google_category_1\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape|length:150\"}</g:google_product_category>\n<g:identifier_exists>FALSE</g:identifier_exists>\n<g:product_type>{attribute=\"category|category\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape\"}</g:product_type>\n<g:sale_price>{attribute=\"product|special_price\" format=\"price\" parent=\"no\" optional=\"yes\" modify=\"\"}</g:sale_price>\n<g:sale_price_effective_date>{attribute=\"other|sale_price_effective_date\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"\"}</g:sale_price_effective_date>\n<g:brand>{attribute=\"product|manufacturer\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\"html_escape\"}</g:brand>\n<g:additional_image_link>{attribute=\"gallery|image_1\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\":gallery|image_1\"}</g:additional_image_link>\n<g:additional_image_link>{attribute=\"gallery|image_2\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\":gallery|image_2\"}</g:additional_image_link>\n<g:additional_image_link>{attribute=\"gallery|image_3\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\":gallery|image_3\"}</g:additional_image_link>\n<g:additional_image_link>{attribute=\"gallery|image_4\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\":gallery|image_4\"}</g:additional_image_link>\n<g:additional_image_link>{attribute=\"gallery|image_5\" format=\"as_is\" parent=\"no\" optional=\"yes\" modify=\":gallery|image_5\"}</g:additional_image_link>\n",
                "xml_footer": "</channel> </rss>",
                "xml_header": "<?xml version=\"1.0\"?> <rss version=\"2.0\" xmlns:g=\"http://base.google.com/ns/1.0\"><channel> <created_at>{{DATE}}</created_at>",
                "xml_item": "item"
            },
            "Referer": "https://localhost.com:2197/admin/amfeed/feed/edit/id/12/",
            "Request Method": "POST",
            "URL": "https://localhost.com:2197/admin/amfeed/feed/ajax/?isAjax=true",
            "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36"
        }
    ],
    "message": "The Product with the \"H32D&4B1DRW\" SKU doesn't exist."
}
Location:    vendor/mage2pro/core/Framework/Logger/Handler.php:55
Callee:      df_log_l
*****************1******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:344
Callee:      Df\Framework\Logger\Handler::handle
*****************2******************
Location:    vendor/magento/framework/Logger/Monolog.php:48
Callee:      Monolog\Logger::addRecord
*****************3******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:740
Callee:      Magento\Framework\Logger\Monolog::addRecord
*****************4******************
Location:    vendor/amasty/feed/Controller/Adminhtml/Feed/Ajax.php:150
Callee:      Monolog\Logger::critical
*****************5******************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::execute
*****************6******************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::___callParent
*****************7******************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::Magento\Framework\Interception\{closure}
*****************8******************
Location:    generated/code/Amasty/Feed/Controller/Adminhtml/Feed/Ajax/Interceptor.php:26
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::___callPlugins
*****************9******************
Location:    vendor/magento/framework/App/Action/Action.php:108
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::execute
*****************10*****************
Location:    vendor/magento/module-backend/App/AbstractAction.php:231
Callee:      Magento\Framework\App\Action\Action::dispatch
*****************11*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Magento\Backend\App\AbstractAction::dispatch
*****************12*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::___callParent
*****************13*****************
Location:    app/code/WeltPixel/Backend/Plugin/Utility.php:76
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::Magento\Framework\Interception\{closure}
*****************14*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:135
Callee:      WeltPixel\Backend\Plugin\Utility::aroundDispatch
*****************15*****************
Location:    vendor/magento/module-backend/App/Action/Plugin/Authentication.php:143
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::Magento\Framework\Interception\{closure}
*****************16*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:135
Callee:      Magento\Backend\App\Action\Plugin\Authentication::aroundDispatch
*****************17*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::Magento\Framework\Interception\{closure}
*****************18*****************
Location:    generated/code/Amasty/Feed/Controller/Adminhtml/Feed/Ajax/Interceptor.php:39
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::___callPlugins
*****************19*****************
Location:    vendor/magento/framework/App/FrontController.php:159
Callee:      Amasty\Feed\Controller\Adminhtml\Feed\Ajax::dispatch
*****************20*****************
Location:    vendor/magento/framework/App/FrontController.php:99
Callee:      Magento\Framework\App\FrontController::processRequest
*****************21*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Magento\Framework\App\FrontController::dispatch
*****************22*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Magento\Framework\App\FrontController::___callParent
*****************23*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Magento\Framework\App\FrontController::Magento\Framework\Interception\{closure}
*****************24*****************
Location:    generated/code/Magento/Framework/App/FrontController/Interceptor.php:26
Callee:      Magento\Framework\App\FrontController::___callPlugins
*****************25*****************
Location:    vendor/magento/framework/App/Http.php:137
Callee:      Magento\Framework\App\FrontController::dispatch
*****************26*****************
Location:    generated/code/Magento/Framework/App/Http/Interceptor.php:24
Callee:      Magento\Framework\App\Http::launch
*****************27*****************
Location:    vendor/magento/framework/App/Bootstrap.php:261
Callee:      Magento\Framework\App\Http::launch
*****************28*****************
Location:    index.php:39
Callee:      Magento\Framework\App\Bootstrap::run
dmitrii-fediuk commented 3 years ago

Actually, the product exists: tradefurniturecompany.co.uk/admin/catalog/product/edit/id/2494

dmitrii-fediuk commented 3 years ago

Fixed by:

UPDATE catalog_product_entity SET sku = REPLACE(sku, '&amp;', '&');